pg.ddx.io pgsql-testers@postgresql.org mailing list archive
help / color / mirror / Atom feedschema.table.column syntax no longer supported?
4+ messages / 3 participants
[nested] [flat]
* schema.table.column syntax no longer supported?
@ 2010-04-15 23:29 Matthew Bellew <matthewb@labkey.com>
2010-04-15 23:45 ` Re: schema.table.column syntax no longer supported? Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Matthew Bellew @ 2010-04-15 23:29 UTC (permalink / raw)
To: pgsql-testers
[TEST REPORT]
[Release]: 9.0Alpha4
[Test Type]: Application
[Test]: SELECT w/ schema qualified table name
[Platform]: Snow Leopard
[Parameters]:
[Failure]: comptibility issue, fails under 9.0 works 8.x
[Results]:
create schema S;
create table S.T (x int, y int);
select S.T.* from S.T;
results in this error
ERROR: invalid reference to FROM-clause entry for table "t"
This was hit while trying to install a server (www.labkey.org). The
install scripts had dozens of failures of this type under 9.0Alpha4.
INSERT,UPDATE,DELETE had variations on this error message.
[Comments]:
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: schema.table.column syntax no longer supported?
2010-04-15 23:29 schema.table.column syntax no longer supported? Matthew Bellew <matthewb@labkey.com>
@ 2010-04-15 23:45 ` Josh Berkus <josh@agliodbs.com>
2010-04-27 22:04 ` Re: schema.table.column syntax no longer supported? Steve Singer <ssinger@ca.afilias.info>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2010-04-15 23:45 UTC (permalink / raw)
To: Matthew Bellew <matthewb@labkey.com>; +Cc: pgsql-testers
> This was hit while trying to install a server (www.labkey.org). The
> install scripts had dozens of failures of this type under 9.0Alpha4.
> INSERT,UPDATE,DELETE had variations on this error message.
Thanks, will see if I can replicate.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: schema.table.column syntax no longer supported?
2010-04-15 23:29 schema.table.column syntax no longer supported? Matthew Bellew <matthewb@labkey.com>
2010-04-15 23:45 ` Re: schema.table.column syntax no longer supported? Josh Berkus <josh@agliodbs.com>
@ 2010-04-27 22:04 ` Steve Singer <ssinger@ca.afilias.info>
2010-04-27 22:29 ` Re: schema.table.column syntax no longer supported? Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Steve Singer @ 2010-04-27 22:04 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: Matthew Bellew <matthewb@labkey.com>; pgsql-testers
Josh Berkus wrote:
>> This was hit while trying to install a server (www.labkey.org). The
>> install scripts had dozens of failures of this type under 9.0Alpha4.
>> INSERT,UPDATE,DELETE had variations on this error message.
>
> Thanks, will see if I can replicate.
>
I can replicate this as well with a recent cvs/git build.
CREATE TABLE a(a int4);
CREATE TABLE b(b int4);
UPDATE public.a SET a=1 FROM public.b WHERE public.a.a=public.b.b;
will replicate this issue
It works fine in 8.4
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: schema.table.column syntax no longer supported?
2010-04-15 23:29 schema.table.column syntax no longer supported? Matthew Bellew <matthewb@labkey.com>
2010-04-15 23:45 ` Re: schema.table.column syntax no longer supported? Josh Berkus <josh@agliodbs.com>
2010-04-27 22:04 ` Re: schema.table.column syntax no longer supported? Steve Singer <ssinger@ca.afilias.info>
@ 2010-04-27 22:29 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2010-04-27 22:29 UTC (permalink / raw)
To: Steve Singer <ssinger@ca.afilias.info>; +Cc: Matthew Bellew <matthewb@labkey.com>; pgsql-testers
Steve,
That's a bug alright. Raising it on -hackers.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-04-27 22:29 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-15 23:29 schema.table.column syntax no longer supported? Matthew Bellew <matthewb@labkey.com>
2010-04-15 23:45 ` Josh Berkus <josh@agliodbs.com>
2010-04-27 22:04 ` Steve Singer <ssinger@ca.afilias.info>
2010-04-27 22:29 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox