Primary Key results in endless loop

From: De_Spike(at)Pandora(dot)Be
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Primary Key results in endless loop
Date: 2004-05-26 19:57:13
Message-ID: 40B512B9.20477.2CC0D34@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Sergio Samayoa 2004-05-27 00:45:41 Re: Unable to connect
Previous Message Tom Lane 2004-05-26 16:02:13 Re: Win32 GiST bug - more info