Re: Primary Key results in endless loop

I just tried this with current cvs, and it works fine:
mha=# CREATE TABLE public."Adres"
mha-# ("Id" int8 NOT NULL,
mha(# "Name" varchar(40) NOT NULL,
mha(# "Street" varchar(40) NOT NULL,
mha(# "Nr" int8,
mha(# "CityId" int8,
mha(# CONSTRAINT "Adres_pkey" PRIMARY KEY ("Id")) WITH OIDS;
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"Adres_pkey" for
table "Adres"
CREATE TABLE


The create table first, then add constraint approach also works fine.

Please try latest cvs/snapshot. If you still have the same problem,
there is something specific to your environment that breaks it.

//Magnus


-----Original Message-----
From: De_Spike@Pandora.Be [mailto:De_Spike@Pandora.Be]
Sent: den 26 maj 2004 21:57
To: pgsql-hackers-win32@postgresql.org
Subject: [pgsql-hackers-win32] Primary Key results in endless loop


I tried the nightly build of 25/5: runs smoothly but the following query
results in an endless loop.  Don't have to restart the postmaster
neither he gave an error.


CREATE TABLE public."Adres"
("Id" int8 NOT NULL,
"Name" varchar(40) NOT NULL,
"Street" varchar(40) NOT NULL,
"Nr" int8,
"CityId" int8,
CONSTRAINT "Adres_pkey" PRIMARY KEY ("Id")) WITH OIDS;


I tried it on a Redhat with PostgreSql 7.4.2 and there it works


With some experimenting it seems to be the PRIMARY KEY statement  which
is doing the damage.  Because this one works:


CREATE TABLE public."Adres"
("Id" int8 NOT NULL,
"Name" varchar(40) NOT NULL,
"Street" varchar(40) NOT NULL,
"Nr" int8,
"CityId" int8) WITH OIDS;


And this isn't:


ALTER TABLE public."Adres"
ADD CONSTRAINT "Adres_pkey" PRIMARY KEY ("Id");


If it's allready found, noted or if I'm doing something wrong =>
apologies


Greetings
Deblauwe Gino