find functions, triggers, views and rules.

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: find functions, triggers, views and rules.
Date: 2002-05-27 11:58:42
Message-ID: 7DD34E6DF5CD1B4283DDAB96A855DCED2F3391@vodabemail1.vodacom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi all

I drop a table by mistake and managed to get the info back from a backup.

but now i'm getting the following error

ERROR: Relation "personal" with OID 12225548 no longer exists in

Now i read that i should rebuild functions or triggers on this table.(does
this include views and rules?)

thats fine but how do i find out what they are?

I tried select * from pg_triggers and could not see any thing that would
help. i tried pg_dump -s but can't find any thing there.



Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2002-05-27 14:33:22 Re: Full Outer Joins
Previous Message John Taylor 2002-05-27 10:14:55 Full Outer Joins