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
Joost Kraaijeveld wrote:
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
On Fri, Sep 09, 2005 at 09:09:11AM +0200, Joost Kraaijeveld wrote:
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
Hi Richard (s),
The problem was reproducable untill I restarted my whole machine. Now it
works. Still have no clue what this was about, but thanks to you, now I
know where to start looking next time.
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063