Re: Invalid SQL not rejected? - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Invalid SQL not rejected?
Date
Msg-id 1365731562.72107.YahooMailNeo@web162902.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Invalid SQL not rejected?  (Julian Glass <tempura@internode.on.net>)
List pgsql-admin
Julian Glass <tempura@internode.on.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


pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: after 9.2.4 patch vacuumdb -avz not analyzing all tables
Next
From: Jeff Janes
Date:
Subject: Re: [PERFORM] Postgres log(pg_logs) have lots of message