Обсуждение: is it postgres issue?

Поиск
Список
Период
Сортировка

is it postgres issue?

От
"Rajesh Kumar Mallah."
Дата:

Hi On updating a table i get following ERROR

tradein_clients=# begin work; UPDATE eyp_listing  set company_id=companies.company_id from companies   where
eyp_listing.amount> 0  and  
eyp_listing.email=companies.email;
BEGIN
ERROR:  heap_mark4update: (am)invalid tid


is it a postgresql issue?
or is it some contrib module i am using tsearch in this table.


regds
mallah.





--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.



Re: is it postgres issue?

От
Tom Lane
Дата:
"Rajesh Kumar Mallah." <mallah@trade-india.com> writes:
> tradein_clients=# begin work; UPDATE eyp_listing  set company_id=companies.company_id from companies   where
eyp_listing.amount> 0  and  
> eyp_listing.email=companies.email;
> BEGIN
> ERROR:  heap_mark4update: (am)invalid tid

> is it a postgresql issue?

Possibly, but we'll need to see more detail.

            regards, tom lane