Spotted by accident while working on a patch:
Open psql and do:
CREATE TABLE uctest(f1 int, f2 text);
-- Create a temporary child of the permanent table
CREATE TEMP TABLE ucchild () inherits (uctest);
In another terminal:
pg_ctl stop -m immediate
pg_ctl start
psql (9.3devel)
Type "help" for he
On 12 December 2012 01:55, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7752
> Logged by: Maciek Sakrejda
> Email address: m.sakre...@gmail.com
> PostgreSQL version: 9.1.6
> Operating system: Ubuntu 10.04 LTS 64-bit
> Description:
>
> Ran into
Heikki Linnakangas writes:
> Spotted by accident while working on a patch:
> Open psql and do:
> CREATE TABLE uctest(f1 int, f2 text);
> -- Create a temporary child of the permanent table
> CREATE TEMP TABLE ucchild () inherits (uctest);
> In another terminal:
> pg_ctl stop -m immediate
> pg_ctl
I wrote:
> I'm not sure where rd_backend gets set up, but maybe we can fix this
> by not allowing rd_backend to acquire a valid value unless we've begun
> using the temp namespace.
The key bit of code seems to be this in RelationBuildDesc():
switch (relation->rd_rel->relpersistence)
.
On Fri, 2012-12-14 at 17:56 -0500, Tom Lane wrote:
> Perhaps a better idea is to not overload rd_backend to serve both
> the "physical name of file" purpose and the "is it my temp table"
> purpose. We could add an additional relcache field with the
> three possible states "not temp, my temp, someb
The following bug has been logged on the website:
Bug reference: 7754
Logged by: Gavan Schneider
Email address: pg-...@snkmail.com
PostgreSQL version: 9.2.2
Operating system: OSX
Description:
FILE:
postgresql-9.2.2/contrib/start-scripts/osx/PostgreSQL ; and
many p
