[SQL] about Inheritance...

2002-07-18 Thread frederik nietzsche
Hi all, I'm still in trouble with inheritance. Now I've created some triggers and rules for realize something similiar to an inheritance... I MUST do myself all the check for integrity, it seems the only way. But because psql executes a function in a transaction it was not so bad... In practice, i

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

[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