Re: [GENERAL] installation problem - semaphores

2006-04-02 Thread fufay
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 h

Re: [GENERAL] about partitioning

2006-04-02 Thread fufay
INTO news(title,content,author) 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 "

[GENERAL] about partitioning

2006-03-31 Thread fufay
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.