On Sat, Jan 28, 2012 at 01:10:39PM -0500, Tom Lane wrote: > hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > > is it by design that tables listed there (in extconfig column of > > pg_extension) will be dumped with data, even for pg_dump --schema? > > Um, yes. Read the manual. > http://www.postgresql.org/docs/9.1/static/extend-extensions.html#AEN51966 Yes, but: If you create table using extensions, and the you insert data to it - this data will *not* be dumped using pg_dump. If you mark the table with pg_extension_config_dump() - the data fro the table will be dumped *always* - even for -s dump of another table. I.e. pg_dump -s -t a will dump data of table b! So long story short - with currently released versions it is either: - you will never get data for given table in dumps or - you will get data for this table in dump, always, even for schema-only dumps of unrelated tables. Now. I have since made some tests, and it looks like the dumping thing is fixed in 9.2devel from git HEAD, which seems to suggest that it will work sanely in 9.1.3 - so the point is kind of moot. But the fact that is the newest released Pg provides mechanism that completely breaks pg_dump functionality. Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
