Re: [BUGS] issue with C functions using pg_dump

Hello Tom, thanks for your quick answer,

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()

  RETURNS uuid AS

'$libdir/uuid-ossp', 'uuid_nil'

  LANGUAGE c IMMUTABLE STRICT

  COST 1;

ALTER FUNCTION public.uuid_nil()

  OWNER TO postgres;

Here’s also the sql file generated with my command

(pg_dump --dbname=postgresql://postgres:xxx@127.0.0.1:5432/Adventureworks

--no-owner --format=plain --schema=public  --file="D:\public.sql")

Regards,

Provenance : Courrier pour Windows 10

Cédric Prin-Derre <prinderr@gmail.com> writes:

> i am am doing some test using the Adventureworks sample database (available

> on postgresql wiki) and i have noticed an issue with pgdump

> pg_dump --dbname=postgresql://postgres:xxx@127.0.0.1:5432/Adventureworks

> --no-owner --format=plain --schema=public  --file="D:\public.sql"

> the generated sql file does not contain the code of the LANGUAGE c

> functions stored in this schema

If you're expecting it to contain the C source code, you're mistaken.

It should just be reconstructing the CREATE FUNCTION commands.

Typical output for a C-language function might be something like

CREATE FUNCTION int44in(cstring) RETURNS city_budget

    LANGUAGE c IMMUTABLE STRICT

    AS '$libdir/regress.so', 'int44in';

                                               regards, tom lane