From:
hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To:
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>,pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: pg_dump -s dumps data?!
Date:
2012-02-02 11:24:00
Message-ID:
20120202112400.GA13401@depesz.com (view raw or flat )
Thread:
2012-01-27 22:19:18 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-27 23:00:24 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-27 23:05:30 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-27 23:11:32 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-28 09:29:22 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-28 18:10:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-30 13:08:41 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 15:34:49 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-30 15:39:13 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 16:20:15 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-30 16:25:54 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 17:03:47 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-30 16:12:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-30 16:24:06 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 16:30:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-30 17:23:15 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 17:43:46 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-30 17:45:09 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 17:51:58 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-30 17:53:45 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-30 22:20:24 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-31 04:18:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-31 10:30:14 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-31 12:36:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-31 22:37:45 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-31 23:07:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-31 15:54:28 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-01-31 22:48:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-01 04:10:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-06 17:18:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-07 19:56:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-07 22:00:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-08 20:31:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-10 19:54:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-31 20:02:59 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2012-01-31 20:23:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-02-01 21:02:14 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-02-02 11:24:00 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
2012-01-28 18:11:03 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2012-01-28 01:03:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-28 09:30:11 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
Lists:
pgsql-general pgsql-hackers
On Wed, Feb 01, 2012 at 10:02:14PM +0100, Dimitri Fontaine wrote:
> The case for a table that is partly user data and partly extension data
> is very thin, I think that if I had this need I would use inheritance
> and a CHECK(user_data is true/false) constraint to filter the data.
definitely agree. i.e. i don't really see a case when we'd have data
from both extension, and normal usage, in the same table.
and the overhead of tracking source of data seems to be excessive.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
In response to
pgsql-hackers by date
Next :From: Pavel StehuleDate: 2012-02-02 11:44:01Subject : Re: Patch pg_is_in_backup()Previous :From : Marti RaudseppDate : 2012-02-02 11:23:02Subject : Re: Patch pg_is_in_backup()
pgsql-general by date
Next :From: bdmytrak@eranet.plDate: 2012-02-02 11:30:48Subject : Deadlock reportPrevious :From : SaurabhDate : 2012-02-02 10:26:13Subject : Facing issue in online recovery of pgpool-II
