Re: Questionable behavior regarding aliasing

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Questionable behavior regarding aliasing
Date: 2015-10-09 20:34:44
Message-ID: 561824E4.4050602@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2015-10-09 10:31 PM, Jim Nasby wrote:
> I was about to report this as a bug until Marko Tiikkaja pointed out on
> IRC that now was being treated as an alias for relname.
>
> I'm not sure if this is required by the spec, but can we at least emit a
> WARNING if not reject this case outright? I think it'd be OK to leave
> the AS syntax alone... presumably it's a lot harder to fumble that. But
> I'm not wed to that.

I'd be happy to turn on a GUC disabling this misfeature. It's only ever
brought pain and unhappiness to me and my family.

.m

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amir Rohan 2015-10-09 20:38:25 Re: Proposal: pg_confcheck - syntactic & semantic validation of postgresql configuration files
Previous Message Jim Nasby 2015-10-09 20:31:03 Questionable behavior regarding aliasing