Re: issue with C functions using pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cédric Prin-Derre <prinderr(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: issue with C functions using pg_dump
Date: 2017-08-26 21:37:12
Message-ID: 12213.1503783432@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?Q?C=C3=A9dric_Prin-Derre?= <prinderr(at)gmail(dot)com> writes:
> i was hoping to just get the create function code but i do not.

> Here s a sample of code not generated :

> CREATE OR REPLACE FUNCTION public.uuid_nil()

If you're looking for uuid_nil, the reason you're not seeing it
is that it's a member of the uuid-ossp extension. pg_dump
will emit a CREATE EXTENSION command, not commands for all the
individual member objects. You should look into the extension's
script file if you want to see the member objects' creation
commands.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-08-27 18:10:32 Re: [HACKERS] [postgresql 10 beta3] unrecognized node type: 90
Previous Message Cédric Prin-Derre 2017-08-26 21:25:39 Re: issue with C functions using pg_dump