[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' empty space 'abc' empty space I am not sure how this can happen ---(end of

Re: [GENERAL] remote duplicate rows

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 it and shove it back in... -Original Message- From: Junkone [mailto:[EMAIL PROTECTED] Sent

[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

[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 ruby

[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, COMPANY_NAME