Re: [GENERAL] Inheritance and such

2005-04-03 Thread Daniel Schuchardt
Stephane Bortzmeyer schrieb: I have a problem which MAY be in the same category. CREATE TABLE base ( id serial not null primary key, ); CREATE TABLE specialized ( ) INHERITS base; Now, I try to set up a trigger AFTER UPDATE ON base but, when I update "specialized", the trigger is not called. Same

Re: [GENERAL] Inheritance and such

2005-04-03 Thread Stephane Bortzmeyer
On Fri, Apr 01, 2005 at 09:51:25AM -0600, John Hughes <[EMAIL PROTECTED]> wrote a message of 49 lines which said: > I ran into a brick wall when I realized that inheritance in postgres > isnt really there... I have a problem which MAY be in the same category. CREATE TABLE base ( id serial n

[GENERAL] Inheritance and such

2005-04-01 Thread John Hughes
Hi everyone, I ran into a brick wall when I realized that inheritance in postgres isnt really there... Here's a description of the relevant part of my schema. CREATE TABLE base ( id serial not null primary key, ); CREATE TABLE specialized ( ) INHERITS base; CREATE TABLE specialized2 ( ) IN