Postgres Pro
Downloads
Home   >   mailing lists

Re: tsearch consistency trigger on inheritated table - Mailing list pgsql-general

From Tom Lane
Subject Re: tsearch consistency trigger on inheritated table
Date
Msg-id 16913.1037144224@sss.pgh.pa.us
Whole thread Raw
In response to tsearch consistency trigger on inheritated table  ("Bjoern Metzdorf" <bm@turtle-entertainment.de>)
List pgsql-general
Tree view 
"Bjoern Metzdorf" <bm@turtle-entertainment.de> writes:
> When using this trigger on an inheritated table (with "title" being an
> inheritated column), an insert or update on the table fails stating:
> NOTICE:  TSearch: can not find field 'title'
> ERROR:  ExecAppend: Fail to add null value in not null attribute created

Hm, I cannot see how it would matter whether the column is inherited or
not.  Could you provide a self-contained example of what you're doing?

            regards, tom lane

pgsql-general by date:

Previous
From: "Bjoern Metzdorf"
Date:
Subject: tsearch consistency trigger on inheritated table
Next
From: Corey Gibbs
Date:
Subject: Good Job and Kudos to the Postgres Team