Along with Chris, the need for having tables defined in the extension
is about keeping control of the table structure so the extension
functions are guaranteed to work as intended and to make upgrading
versions easier. As an example, the fact that I can specifically name
constraints makes it easier
On Sat, Jun 9, 2012 at 5:33 AM, Tom Lane wrote:
> Keith Fiske 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
Keith Fiske 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.)
On 2012-06-09 08:56, Keith Fiske wrote:
Looking at the docs, I think the extension authors may have only had
configuration data in mind for extension tables. I don't see any
reason why we shouldn't be able to put any sort of table in our
extensions, some having actual data, not just config.
Tru
Just found something else rather disturbing. If you try to exclude the
schema that the extension tables are in, their data is still output.
Explicitly naming other schemas doesn't seem to dump the extension
data. So the only way to avoid getting the extension data in a
schema-only dump is to explic
With the current design, I understand what you're saying now. Just
doing some more testing, I was able to do a pg_dump -Fc -s for the
entire database and looking through the resulting object list with
pg_restore -l I'm actually seeing the extension table data included in
the dump file. Doing a res
Keith Fiske writes:
> I've read the documentation for extensions and how their data is not
> normally dumped by pg_dump and how to configure the table so it should
> dump its data
> http://www.postgresql.org/docs/9.1/static/extend-extensions.html
> However, after setting this option for the tables
I've read the documentation for extensions and how their data is not
normally dumped by pg_dump and how to configure the table so it should
dump its data
http://www.postgresql.org/docs/9.1/static/extend-extensions.html
However, after setting this option for the tables, the data is not
being dumped
