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