Skip site navigation (1) Skip section navigation (2)

Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Jasen Betts <jasen(at)treshna(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Date: 2007-06-22 13:30:44
Message-ID: 467BCF04.10107@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Zdenek Kotala wrote:

> I looked on it, but I think let parser to fill namespace information in 
> ctx->relation structure should be better then do it in this place. There 
> is also unfilled istemp flag.

Ignore this. It is good place.

However, I think add following function into namespace.c
should be nicer solution.

Oid  RelnameGetSchemaid(const char *relname);

See RelnameGetRelid.

You can use

snamespaceid = RelnameGetSchemaid(cxt->relation->relname);

instead of

snamespaceid = RangeVarGetCreationNamespace(cxt->relation);



	Zdenek

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-06-22 15:12:08
Subject: Re: Temp table woes
Previous:From: Gregory StarkDate: 2007-06-22 13:22:53
Subject: Re: Error message that is a bit misleading / weird result from <xid> || null

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group