-----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