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
