Re: [PATCH] parser: optionally warn about missing AS for column and table aliases - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
Date
Msg-id CAFj8pRDutFHoxn=Eo9WHevtRrzih_OhuoPA0cwZ0evKTbhVLzw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] parser: optionally warn about missing AS for column and table aliases  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers



2014-09-05 23:06 GMT+02:00 Marko Tiikkaja <marko@joh.to>:
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..

I had same idea - maybe some general mode "prune human errors" mode

Pavel
 


.marko



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Oskari Saarenmaa
Date:
Subject: Re: [PATCH] Filter error log statements by sqlstate
Next
From: David G Johnston
Date:
Subject: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases