Questionable behavior regarding aliasing

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Questionable behavior regarding aliasing
Date: 2015-10-09 20:31:03
Message-ID: 56182407.6020509@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I fat-fingered a view create and ended up with this:

...
, schemaname, relname -- other
now
, d_now, ...

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.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2015-10-09 20:34:44 Re: Questionable behavior regarding aliasing
Previous Message David Christensen 2015-10-09 20:27:18 Re: [PATCH] Teach Catalog.pm how many attributes there should be per DATA() line