Re: [GENERAL] Inherited tables, triggers, and schemas...

2005-03-07 Thread Net Virtual Mailing Lists
Hello, Sorry, I forgot the trigger: -- public stuff SET search_path = public, pg_catalog; CREATE TABLE customer( customer_id SERIAL, customer_notification INTEGER, CONSTRAINT customer_notification CHECK notification = 0) OR (notification = 1)) OR (notification = 2))), ); CREATE

[GENERAL] Inherited tables, triggers, and schemas...

2005-03-07 Thread Net Virtual Mailing Lists
Hello, I have a question about inherited tables w/r to triggers... Hopefully this will make some sense... (I'll try to keep the schema example as simple as possible): Given the follow schema/tables: -- public stuff SET search_path = public, pg_catalog; CREATE TABLE customer( customer_id SER