Re: adminpack and pg_catalog

From: Neil Conway <neilc(at)samurai(dot)com>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: adminpack and pg_catalog
Date: 2006-10-20 20:17:05
Message-ID: 1161375425.13928.40.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2006-10-20 at 11:50 +0200, Andreas Pflug wrote:
> Having pg_dump not saving the function definitions is an intended
> behaviour.

The manual defines the pg_catalog schema as containing "the system
tables and all the built-in data types, functions, and
operators" (section 5.7.5). adminpack is none of the above, so I don't
think it should be located in pg_catalog.

> I'd consider installing contrib modules as an act of installation, not
> something that backup/restore should perform

AFAICS this is inconsistent with how every other contrib module behaves:
installing the contrib module into a database results in DDL for that
contrib module being included in pg_dump's output.

> (finally, pg_restore isn't able to do so, since it can't provide
> the dll/lib module).

This is not related to adminpack per se: pg_dump is never be able to
provide the shared object for any C language UDF. By your logic, pg_dump
shouldn't emit DDL for any such function.

-Neil

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2006-10-20 20:18:56 Re: adminpack and pg_catalog
Previous Message Peter Eisentraut 2006-10-20 20:14:21 Re: Multiple postmaster + RPM + locale issues