[GENERAL] How to do auto numbering on INT column

HI I have a simple table created using PGAdmin III. How do i do a auto numbering on a column SYMBOL_ID? My table is CREATE TABLE "SYMBOL" ( "SYMBOL_ID" int4 NOT NULL, "SYMBOL2EXCHANGE" int2 NOT NULL, "SYMBOL_ALIAS" text[], "RELATED_SYMBOLS_OTHER_EXCHANGES" int8[], "SYMBOL_NAME" text, "C

[GENERAL] ruby driver postgresql

HI I am using the C driver and am trying to run this statement irb(main):020:0> a=conn.exec("select * from exchanges where id=$1",4) ArgumentError: wrong number of arguments (2 for 1) from (irb):20:in `exec' from (irb):20 from :0 irb(main):021:0> I get the error. But the ru

[GENERAL] remote duplicate rows

hI i have a bad situation that i did not have primary key. so i have a table like this colname1colname2 1 apple 1 apple 2 orange 2 orange It is a very

Re: [GENERAL] remote duplicate rows

es and stuff on the original table if > you don't want to set them all up again. Me lazy? > > That said, if you've got foriegn keys pointing at it, the truncate ain't > going to work. > > Or if you have your data exported as a tab or csv, the use sort | uniq on

[GENERAL] unique key issue

HI I have a table with a unique key constraint on col1,col2. The dattabase allowed an multiple inserts. here is how col1 col2 'abc' 'abc' I am not sure how this can happen ---(end of broadcast)--- TIP 1: if posting/rea