) VALUES('just a test','test
too','fufay')
it stored data both news and news_001 that falls short of my
expectations.
since i did a rule to redirect the INSERT to the child and a trigger on
news
that RETURN NULL when get INSERT action,but they didn't work any way.
if we can't restrict to insert data
u have to su postgres first,just like this:
--
# rehash
# su postgres
postgres$ initdb -D /usr/local1/pgsql/data
good luck!
Yadu [EMAIL PROTECTED]
news:[EMAIL PROTECTED]
Hi,
I have
dear all,
i created a master table and a sub table which inherits the main table.
and then i made a trigger and a function that want to keep the master table
empty.
but the trigger didn't work anyway.when i inserted data into the table
news,both the master table
and the sub table were inserted.