Re: [SQL] Table inherit & foreign key problem

2007-03-09 Thread Richard Huxton
Moritz Kobel wrote: i would like to reference to the element table, because i have some tables which inherit from element and i would like to add comments to these elements. is this impossible or did i do a silly mistake? i did not find a solution unsing google. Foreign-key limitations with in

[SQL] Table inherit & foreign key problem

2007-03-09 Thread Moritz Kobel
Hi all, i have problems with tables an foreign keys. i created the following tables: (i did not copy all the command, only the important (in my point of view) CREATE TABLE element ( id bigint NOT NULL, site_id bigint, type_id bigint NOT NULL, name character varying(512), des