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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
Дата
Msg-id CAFj8pRDutFHoxn=Eo9WHevtRrzih_OhuoPA0cwZ0evKTbhVLzw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] parser: optionally warn about missing AS for column and table aliases  (Marko Tiikkaja <marko@joh.to>)
Список 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 по дате отправления:

Предыдущее
От: Oskari Saarenmaa
Дата:
Сообщение: Re: [PATCH] Filter error log statements by sqlstate
Следующее
От: David G Johnston
Дата:
Сообщение: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases