Re: creating languages in the pg_catalog schema?

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: creating languages in the pg_catalog schema?
Date: 2003-01-01 16:51:58
Message-ID: 3E131CAE.20100@oli.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-01-01 18:48:23 Re: French date
Previous Message Oliver Elphick 2003-01-01 15:58:57 Re: compiling 7.3 on RH7.2