Hi,
The following fails:
create table t (id int, "fk" int);
alter table t add constraint t_t_fk foreign key ("fk") references t
(id);
throwing:
Column FK not found; SQL statement:
SELECT 1 FROM (SELECT "fk" FROM PUBLIC.T WHERE "fk" IS NOT NULL ORDER
BY "fk") C WHERE NOT EXISTS(SELECT 1 FROM PUBLIC.T P WHERE
C."fk"=P.ID) [42122-104] 42S22/42122 (Help)
Please help , I need to correct it quickly.
Regards,
Jacek
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
