> Try this query
>
>
> select a.relname as base,a.relkind
> from
> pg_class a
> join pg_depend d on (a.oid = d.refobjid)
> join pg_class c on (d.classid = c.oid)
> join pg_rewrite r on (objid = r.oid)
> join pg_class v on (ev_class = v.oid)
> where a.relkind in('r', 'v')
> and a.relname <> v.relnam
Hello,
I have two tables as follows:
create table vm_message
(
MessageIdvarchar(128) not null,
MessageType integer not null default 1,
UseCount integer not null default 1,
Sender
Run the following:
update pg_class set reltriggers = count(*) from pg_trigger where
pg_class.oid=tgrelid and relname='vm_message';
It should solve the problem
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/28/06, Kashmira Patel (kupatel) <[EMAIL PROTECTED]> wrote:
