Is this a bug or am I doing something wrong?
От | Joost Kraaijeveld |
---|---|
Тема | Is this a bug or am I doing something wrong? |
Дата | |
Msg-id | 1126249751.8917.91.camel@Panoramix обсуждение исходный текст |
Ответы |
Re: Is this a bug or am I doing something wrong?
Re: Is this a bug or am I doing something wrong? |
Список | pgsql-general |
Hi, I am trying to create a foreign key, followed by creating anindex on the foreign key, using PgAdmin III The command that are generated : ALTER TABLE prototype.orderlines ADD CONSTRAINT fk_orderlines_orders FOREIGN KEY (orderobjectid) REFERENCES prototype.orders (objectid) ON UPDATE RESTRICT ON DELETE RESTRICT; CREATE INDEX fki_orderlines_orders ON prototype.orderlines(orderobjectid); Ont the second command PostgreSQL hangs forever. The prototype.orderlines table is completely empty, the prototype.orders table contains 1.000.000+ records. Is this a known feature and am I doing something wrong or a bug? -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld@Askesis.nl web: www.askesis.nl
В списке pgsql-general по дате отправления: