Re: replicating DROP commands across servers

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