| From: | j0rd1 adame <jordi(at)jordi(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Serials in where clause |
| Date: | 2004-07-05 18:31:07 |
| Message-ID: | 200407051331.07063.jordi@jordi.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Im having trouble whith a Serial Primary key that i cannot use in a where
clause
here is what i did
ixmati=# create table jordi(
ixmati(# "jordi_idPK" serial NOT NULL,
ixmati(# jordi_nombre varchar);
NOTICE: CREATE TABLE creará una secuencia implícita "jordi_jordi_idPK_seq"
para la columna "serial" "jordi.jordi_idPK"
CREATE TABLE
ixmati=# alter table only jordi
ixmati-# add constraint "jordi_idPK" primary key ( "jordi_idPK");
NOTICE: ALTER TABLE / ADD PRIMARY KEY creará el índice implícito "jordi_idPK"
para la tabla "jordi"
Here is the error
ixmati=# select * from jordi where jordi_idPK = 1;
ERROR: column "jordi_idpk" doesn't exists
Any ideas??
thanx
j0rd1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-07-05 18:33:50 | Re: Do we need more emphasis on backup? |
| Previous Message | Stephen Liu | 2004-07-05 16:41:05 | Re: How to add an userA to login postgresadmin |