-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;-- Then change column name of your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;
From http://concord-consortium.github.io/developer-notes/automating-gh-pages-integration.html:
How to setup a git repo so gh-pages automatically tracks commits to master and ‘git push origin’ updates the remote master and gh-pages branches.
Setup a test repo:
mkdir pages-test
cd pages-test/
git init .
| ;SMBDIS.ASM - A COMPREHENSIVE SUPER MARIO BROS. DISASSEMBLY | |
| ;by doppelganger (doppelheathen@gmail.com) | |
| ;This file is provided for your own use as-is. It will require the character rom data | |
| ;and an iNES file header to get it to work. | |
| ;There are so many people I have to thank for this, that taking all the credit for | |
| ;myself would be an unforgivable act of arrogance. Without their help this would | |
| ;probably not be possible. So I thank all the peeps in the nesdev scene whose insight into | |
| ;the 6502 and the NES helped me learn how it works (you guys know who you are, there's no |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| .lower_roman+ol, .lower_roman+ul {list-style-type: lower-roman;} | |
| .upper_roman+ol, .upper_roman+ul {list-style-type: upper-roman;} | |
| .lower_alpha+ol, .lower_alpha+ul {list-style-type: lower-alpha;} | |
| .upper_alpha+ol, .upper_alpha+ul {list-style-type: upper-alpha;} | |
| .lower_greek+ol, .lower_greek+ul {list-style-type: lower-greek;} | |
| .lower_latin+ol, .lower_latin+ul {list-style-type: lower-latin;} | |
| .upper_latin+ol, .upper_latin+ul {list-style-type: upper-latin;} | |
| .none+ol, .none+ul {list-style-type:none;} | |
| .disc+ol, .disc+ul {list-style-type:disc;} | |
| .circle+ol, .circle+ul {list-style-type:circle;} |
| # first, fetch the latest refs for all branches. And be sure we have latest master, etc | |
| git checkout master | |
| git fetch | |
| # If any changes from remote, catch our local version up | |
| git rebase origin/master | |
| # could also be done as |
| #include <stdio.h> | |
| #include <stdlib.h> | |
| #include <pthread.h> | |
| #define M 3 | |
| #define K 2 | |
| #define N 3 | |
| #define NUM_THREADS M * N | |
| /* Global variables for threads to share */ |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml"> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> | |
| <title>Styling a poem</title> | |
| <style type="text/css"> | |
| /* Left-aligned text in a centered block (mangles text in Adobe Digital Editions 1.7, so search an alternative if you need to support it) */ | |
| .poem { | |
| display: table; | |
| margin-right: auto; |
| Having received many constructive comments and bug reports about my previous | |
| C implementation of my color quantizer (Graphics Gems vol. II, p. 126-133), | |
| I am posting the following second version of my program (hopefully 100% | |
| healthy) as a reply to all those who are interested in the problem. | |
| /********************************************************************** | |
| C Implementation of Wu's Color Quantizer (v. 2) |
