Heikki Linnakangas wrote: > I had a very brief look at the docs, and these extra outputs from > pg_event_trigger_dropped_objects caught my eye: > > >+ <row> > >+ <entry><literal>address_names</literal></entry> > >+ <entry><type>text[]</type></entry> > >+ <entry> > >+ An array that, together with <literal>address_args</literal>, > >+ can be used by the C-language function getObjectAddress() to > >+ recreate the object address in a remote server containing a > >similar object. > >+ </entry> > >+ </row> > >+ <row> > >+ <entry><literal>address_args</literal></entry> > >+ <entry><type>text[]</type></entry> > >+ <entry> > >+ See <literal>address_names</literal> above. > >+ </entry> > >+ </row> > > I couldn't find a function called getObjectAddress anywhere. Typo?
Ah, yeah, it's get_object_address actually. > Also, is providing a C-language function the best we can do? The > rest of the information returned by pg_event_trigger_dropped_objects > is usable from any language. Well, the return value from get_object_address is an ObjectAddress. It's simple enough to create an SQL wrapper that takes the address_names/address_args arrays and return an ObjectAddress; would this be useful? -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers