Re: Invalid SQL not rejected?

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Julian Glass <tempura(at)internode(dot)on(dot)net>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Invalid SQL not rejected?
Date: 2013-04-12 01:52:42
Message-ID: 1365731562.72107.YahooMailNeo@web162902.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Julian Glass <tempura(at)internode(dot)on(dot)net> wrote:

> You might want to explicitly reference tables (and alias).

I agree.  I find that the best defense against several classes of
silent misbehavior is to alias all table references and qualify all
column references with the alias -- or use a tool which does this
for you.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2013-04-12 06:14:10 Re: [PERFORM] Postgres log(pg_logs) have lots of message
Previous Message Kevin Grittner 2013-04-12 01:48:02 Re: [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables