Re: Detecting functions installed by an extension

2018-06-17 Thread Benjie Gillam
On 17 June 2018 at 10:26, Vik Fearing wrote: > On 17/06/18 10:05, Benjie Gillam wrote: > > Greetings! > > > > How can I tell, using the system catalog or information schema, if a > > function/procedure was created by an extension as opposed to by the user > > (i.e. would be dropped if you perform

Re: Detecting functions installed by an extension

2018-06-17 Thread Vik Fearing
On 17/06/18 10:05, Benjie Gillam wrote: > Greetings! > > How can I tell, using the system catalog or information schema, if a > function/procedure was created by an extension as opposed to by the user > (i.e. would be dropped if you performed "DROP EXTENSION")? So far I've > looked at the `pg_exte

Detecting functions installed by an extension

2018-06-17 Thread Benjie Gillam
Greetings! How can I tell, using the system catalog or information schema, if a function/procedure was created by an extension as opposed to by the user (i.e. would be dropped if you performed "DROP EXTENSION")? So far I've looked at the `pg_extension` table, which lists the class IDs of configura