Re: [SQL] how to inherits the references...

2002-07-12 Thread Stephan Szabo
On Fri, 12 Jul 2002, [iso-8859-1] frederik nietzsche wrote: > ok, thanks for the (double: two mails ;) ) help, but > in this way when I insert a record in a child table, > the key must be already present in the "sigles" table, > otherwise it breaks the reference and doesn't insert > anything. >

Re: [SQL] how to inherits the references...

2002-07-12 Thread frederik nietzsche
ok, thanks for the (double: two mails ;) ) help, but in this way when I insert a record in a child table, the key must be already present in the "sigles" table, otherwise it breaks the reference and doesn't insert anything. In order to use this solution I must create a set of function that when I

Re: [SQL] how to inherits the references...

2002-07-11 Thread Stephan Szabo
On Thu, 11 Jul 2002, [iso-8859-1] frederik nietzsche wrote: > as if the sigles where not in the "sigles" table, but > it's there! > it's probably because of the way in which psql threats > the inheritance. > my question is (finally): is there some workaround for > this?? or: am I making some mi

[SQL] how to inherits the references...

2002-07-11 Thread frederik nietzsche
hi all, I've created some table with the inharitance, something like: CREATE TABLE sigles( sigle varchar(255) PRIMARY KEY ); CREATE TABLE cars( UNIQUE (sigle) )INHERITS (sigles); CREATE TABLE used_cars( old_owner text, kmtext, mode