Re: NEW + tableOID

Поиск
Список
Период
Сортировка
От Ricardo Bayley
Тема Re: NEW + tableOID
Дата
Msg-id AANLkTi=HjHitHDYAj2oKUgYd_4pJaBsQ+QyQBUBu5aPv@mail.gmail.com
обсуждение исходный текст
Ответ на NEW + tableOID  (Ricardo Bayley <ricardo.bayley@gmail.com>)
Список pgsql-admin
Дерево обсуждения
By the way,

Another option to do this, is to do some table Inheritance. So Full Text Search is perform on each table.

So which scenario is better ? Triggers which insert data into a third table,  or Inheritance ?

Thanks in advanced !


Ricardo.

On Fri, Aug 13, 2010 at 6:08 PM, Ricardo Bayley <ricardo.bayley@gmail.com> wrote:
Hi Fellows,

I have a bunch of tables which I need to perform a Full Text Search. 
The approach I am using is to insert into another table (the searcheable table):  tsvector information, tableOID and the record Id

I do this with triggers. This issue I have is that the tableoid data cannot be used with the NEW keyword. I always get value 0 instead of the actual tableoid.

Insert statement looks something like this:
INSERT INTO fts.fdata(tbl_oid, id, vector_info)
VALUES (NEW.tableoid, NEW.id, NEW.vector_info)

So how can I get the tableoid in a trigger function ?


regards,


Ricardo


В списке pgsql-admin по дате отправления: