Re: creating languages in the pg_catalog schema? - Mailing list pgsql-general

From Jochem van Dieten
Subject Re: creating languages in the pg_catalog schema?
Date
Msg-id 3E131CAE.20100@oli.tudelft.nl
Whole thread Raw
In response to Re: creating languages in the pg_catalog schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: creating languages in the pg_catalog schema?
List pgsql-general
Tom Lane wrote:
> Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
>
>>Just wondering if there are any downsides to creating a procedural
>>language in the pg_catalog schema instead of some other default schema.
>
> pg_dump will not dump it.  Otherwise I don't think it matters.

Worse. pg_dump will not dump at all. The error is:

Dumping database jochemd...
pg_dump: handler procedure for procedural language plpgsql not found
0 bytes.


Any workarounds?

Best wishes,
Jochem


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: compiling 7.3 on RH7.2
Next
From: Bruce Momjian
Date:
Subject: Re: French date