Re: sql_drop Event Trigger

Alvaro Herrera escribió:

> Now, one last thing that comes up is what about objects that don't have
> straight names (such as pg_amop, pg_amproc, pg_default_acl etc etc), the
> only thing you get is a catalog OID and an object OID ... but they are
> pretty useless because by the time you get to the ddl_command_end
> trigger, the objects are gone from the catalog.  Maybe we should report
> *something* about those.

Here's another idea --- have three columns, "type", "schema" (as in the
current patch and as shown above), and a third one for object identity.

For tables and other objects that have simple names, the identity would
be their names.  For columns, it'd be <tablename>.<columnname>.  For
functions, it'd be the complete signature.  And so on.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services