pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
schema.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>
  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:45  Josh Berkus <josh@agliodbs.com>
  parent: Matthew Bellew <matthewb@labkey.com>
  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-27 22:04  Steve Singer <ssinger@ca.afilias.info>
  parent: 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-27 22:29  Josh Berkus <josh@agliodbs.com>
  parent: Steve Singer <ssinger@ca.afilias.info>
  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