Serials in where clause

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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