-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 19/12/2005 10:54, Perica Veljanovski uttered:
Thanks for taking the time mate!
postgresql-server-8.1.0
postgresql-client-8.1.0
Ok, I don't know what changed from 8.0 to 8.1 - for all I know, it could
be related to the default configuration installed in a FreeBSD package
of PostgreSQL.
I believe a quick work-around for your problem would be to edit your
postgresql.conf and make sure the following line is present:
add_missing_from = true
- From the PostgreSQL manual:
add_missing_from (boolean)
When true, tables that are referenced by a query will be
automatically added to the FROM clause if not already present. The
default is true for compatibility with previous releases of PostgreSQL.
However, this behavior is not SQL-standard, and many people dislike it
because it can mask mistakes. Set to false for the SQL-standard behavior
of rejecting references to tables that are not listed in FROM.
I'll take a look into fixing the actual SQL query in NAV later.
- --
Morten Vold, ITEA, NTNU
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Thunderbird -
http://enigmail.mozdev.org
iD8DBQFDpoZAXxIl0kpcOkQRAl6lAKChOU9kOBhBmH/LSE8XcHGnm/KzlgCgxUFU
kkmV6nVlgWdPxvBBMxS17oI=
=8Qdh
-----END PGP SIGNATURE-----
>From perica at akton.com.mk Mon Dec 19 11:38:58 2005
From: perica at akton.com.mk (Perica Veljanovski)
Date: Mon Dec 19 11:39:06 2005
Subject: [Nav-users] missing FROM-clause entry for table netboxcategory
In-Reply-To:
43A68640.5020506@ntnu.no
Message-ID:
CARMENZIhTrBoe2U8QV00000126@carmen.akton.si
> -----Original Message-----
> From: Morten Vold [mailto:morten.vold@ntnu.no]
> Sent: Monday, December 19, 2005 11:07
> To: Perica Veljanovski
> Cc: nav-users@itea.ntnu.no
> Subject: Re: [Nav-users] missing FROM-clause entry for table
> netboxcategory
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 19/12/2005 10:54, Perica Veljanovski uttered:
>
> > Thanks for taking the time mate!
>
> > postgresql-server-8.1.0
> > postgresql-client-8.1.0
>
> Ok, I don't know what changed from 8.0 to 8.1 - for all I know, it could
> be related to the default configuration installed in a FreeBSD package
> of PostgreSQL.
>
> I believe a quick work-around for your problem would be to edit your
> postgresql.conf and make sure the following line is present:
>
> add_missing_from = true
>
> - From the PostgreSQL manual:
>
> add_missing_from (boolean)
>
> When true, tables that are referenced by a query will be
> automatically added to the FROM clause if not already present. The
> default is true for compatibility with previous releases of PostgreSQL.
> However, this behavior is not SQL-standard, and many people dislike it
> because it can mask mistakes. Set to false for the SQL-standard behavior
> of rejecting references to tables that are not listed in FROM.
>
>
>
> I'll take a look into fixing the actual SQL query in NAV later.
>
> - --
> Morten Vold, ITEA, NTNU
>
> A: Because it messes up the order in which people normally read text.
> Q: Why is it such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing on usenet and in e-mail?
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (MingW32)
> Comment: Using GnuPG with Thunderbird -
http://enigmail.mozdev.org
>
> iD8DBQFDpoZAXxIl0kpcOkQRAl6lAKChOU9kOBhBmH/LSE8XcHGnm/KzlgCgxUFU
> kkmV6nVlgWdPxvBBMxS17oI=
> =8Qdh
> -----END PGP SIGNATURE-----
Thanks mate!
You were right. add_missing_from is off by default in pgsql 8.1
This should solve a couple of my problems. I discovered a similar "missing
FROM-clause entry" problem in the messages module. Anyway, you know how to
look for it now ;)
Thanks again.
Perica Veljanovski
