Re: [PATCH] parser: optionally warn about missing AS for column and table aliases

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Oskari Saarenmaa <os(at)ohmu(dot)fi>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
Date: 2014-09-05 21:06:50
Message-ID: 540A25EA.8070002@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2014-09-05 22:56, Oskari Saarenmaa wrote:
> What'd be a good name for the GUC controlling this,
> missing_column_as_warning?

I don't know about others, but I've previously had the idea of having
more warnings like this (my go-to example is DELETE FROM foo WHERE bar
IN (SELECT bar FROM barlesstable); where "barlesstable" doesn't have a
column "bar"). Perhaps it would be better to have a guc with a list of
warnings, similarly to what we did for plpgsql.extra_warnings?

Now that I start thinking about it, more ideas for such warnings start
springing up..

.marko

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2014-09-05 21:11:53 Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
Previous Message Oskari Saarenmaa 2014-09-05 20:56:37 Re: [PATCH] parser: optionally warn about missing AS for column and table aliases