Re: Extension table data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Keith Fiske <keith(at)omniti(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extension table data
Date: 2012-06-09 12:33:57
Message-ID: 26553.1339245237@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Keith Fiske <keith(at)omniti(dot)com> writes:
> Just found something else rather disturbing. If you try to exclude the
> schema that the extension tables are in, their data is still output.

This is a common misconception: extensions do not live within schemas.
(An extension might own a schema, not the other way around.) So a
dump with a -n switch is never going to select an extension.

By and large, if the current behavior bothers you, ISTM it probably
means you are using these tables in a way other than what the concept of
an extension configuration table was meant for: namely, to hold
configuration data that would be referenced by the functions in that
extension, but would not normally be considered part of the user's data.
There has been some talk of trying to cater for a more general notion of
tables created by extensions, but we do not have a design or even a
clear idea of a set of requirements for that. Perhaps it would be good
if you explained what is your use-case --- why are you concerned about
being able to manage these tables as if they were regular data?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philipp Kraus 2012-06-09 12:49:27 pass NEW / OLD variable in trigger to table
Previous Message Yeb Havinga 2012-06-09 08:54:55 Re: Extension table data