Tom,
> This is absolutely NOT an error. iddomain in the subquery is a
> legitimate outer reference, if it's not otherwise known in the subquery.
> There is no clause in the SQL spec that says that outer references are
> invisible in any context ... even if it means you just deleted your
> whole t
Josh Berkus <[EMAIL PROTECTED]> writes:
> Came across this counter-intuitive behavior on IRC today:
Given that this step in your example failed:
> test1=> create table forwarding(idforwarding serial primary key, iddomain
> integer references domain, baz integer);
> NOTICE: CREATE TABLE will cre
On Tue, 21 Oct 2003, Josh Berkus wrote:
> Folks,
>
> Came across this counter-intuitive behavior on IRC today:
> test1=> --this generates an error
> test1=> select iddomain from vhost where IDvhost = 100;
> ERROR: column "iddomain" does not exist
> test1=> -- This should generate an error, becau
Folks,
Came across this counter-intuitive behavior on IRC today:
test1=> create table vhost(idvhost serial primary key, foo integer);
NOTICE: CREATE TABLE will create implicit sequence "vhost_idvhost_seq" for
"serial" column "vhost.idvhost"
NOTICE: CREATE TABLE / PRIMARY KEY will create implic
Tom you right!!
We only set PGDATESTYLE on root env and then restart the httpd
thanks
Tom Lane wrote:
"Ivan E. Rivera Uria" <[EMAIL PROTECTED]> writes:
the date format that we use is DD/MM/ but whet we execute a select
command we get this information:
Sounds to me like you haven't told t
