Re: Column qualifier issue

From: "Jim Wilson" <jimw(at)kelcomaine(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Column qualifier issue
Date: 2004-01-13 01:33:10
Message-ID: twig.1073957590.49781@kelcomaine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> said:

> On Mon, 12 Jan 2004, Tom Lane wrote:
>
> > "Jim Wilson" <jimw(at)kelcomaine(dot)com> writes:
> > > As far as I can tell, there isn't a way to get postgresql to accept column
> > > qualifiers (e.g. tablenames). A 'parse error at or near "."' gets returned.
> >
> > You're either very confused or using a *very* old version of Postgres.
> >
> > What version is it, what query are you issuing exactly, and what exactly
> > is the error message? (Cut-and-paste from a psql session would be the
> > best way to answer the last two ... or if the query is being issued from
> > another application, you could turn on query logging and send in an
> > excerpt from the postmaster log.)
>
> My guess from the rest of his message is something like:
>
> sszabo=# insert into a (a.x) values ('3');
> ERROR: syntax error at or near "." at character 17
>
> (from my 7.5 machine).
>
> However, AFAICS in sql92 the above isn't valid, because a.x doesn't meet
> the syntactic requirements for elements in the column name list.

Yes, I think you are correct on that. I was misreading column reference for
column name. Would it be difficult to patch my local copy to either permit
this or strip off the characters from the qualifier portion in the parser?

Best,

Jim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thapliyal, Deepak 2004-01-13 01:39:32 Re: Parse error help needed...
Previous Message Jim Wilson 2004-01-13 01:32:34 Re: Column qualifier issue