Serials in where clause - Mailing list pgsql-general

From j0rd1 adame
Subject Serials in where clause
Date
Msg-id 200407051331.07063.jordi@jordi.net
Whole thread Raw
Responses Re: Serials in where clause  (Josué Maldonado <josue@lamundial.hn>)
Re: Serials in where clause  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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


pgsql-general by date:

Previous
From: Stephen Liu
Date:
Subject: Re: How to add an userA to login postgresadmin
Next
From: Bruce Momjian
Date:
Subject: Re: Do we need more emphasis on backup?