DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=VZVGbFqBPmARQvdLBvZXOAkuZE/YP3V1EaBmc0/Qtzy6dmZAX+bmr5mqamjMEQ62sOBOzQJnk6AmOYBuHFlIWzxJQ6LiFDp8w3hKsDcZyRVs55/6tmGRUWO3URiCTe5TdiuyZrMfXszb0qg9D34ij9zQOFfbD1OtaxR6ypKChBg=;
References: 
 <CAFwQ8reYH0cuHhFnnv_USHrXvjmwY9+Fw_KEuqhQjecU_-bAtQ@mail.gmail.com>
	<51676326.9040807@internode.on.net>
Message-ID: <1365731562.72107.YahooMailNeo@web162902.mail.bf1.yahoo.com>
Date: Thu, 11 Apr 2013 18:52:42 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Invalid SQL not rejected?
To: Julian Glass <tempura@internode.on.net>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <51676326.9040807@internode.on.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Julian Glass <tempura@internode.on.net> wrote:

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

I agree.=A0 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


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