Postgres Pro
Downloads
Home   >   mailing lists

Re: createlang and Schemas - Mailing list pgsql-general

From Jochem van Dieten
Subject Re: createlang and Schemas
Date
Msg-id 3E3160F7.30700@oli.tudelft.nl
Whole thread Raw
In response to Re: createlang and Schemas  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
Peter Eisentraut wrote:
> Ian Harding writes:
>
>> createlang seems not to take a schema argument.  Should it?
>
> Schema of what?  Languages do not live in schemas.

Languages not, but language call handler functions do.

Since languages are global to the database, I think the location for the
call handler functions should be the pg_catalog schema. Currently, that
creates a problem with pg_dump:
http://archives.postgresql.org/pgsql-general/2002-12/msg01098.php
http://archives.postgresql.org/pgsql-general/2003-01/msg00006.php

Jochem

pgsql-general by date:

Previous
From: Ian Barwick
Date:
Subject: OT: cvsweb (was: psql 7.3.1 crash)
Next
From: Tom Lane
Date:
Subject: Re: I was spoiled by the MySQL timestamp field