-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 15/12/2005 17:20, Perica Veljanovski uttered:
ProgrammingError: ERROR: missing FROM-clause entry for table
"netboxcategory"
SELECT netboxid,netboxcategory.category FROM netbox WHERE
netboxcategory.netboxid=netboxid
Now I have no experience with postgressql, but have about 5 years of mysql
experience, and this query doesn't make much since to me. There is no
reference to netboxcategory in the FROM clause, but the SELECT uses it!?
Thanks for your analysis, but you didn't need to go through all this
trouble :)
As I said, there is a bug in EditDB which seems to appear when there are
no netboxcategories (I cannot immediately confirm this claim, as I have
no clean installation to test it on at the moment, and I don't see this
error on our current installation). Since the SQL statement is
generated in a number of steps, fixing the bug is not as simple as just
rewriting a hard coded query in the code. That's why I said I'll have
to look into it further (I didn't write the editdb code, but it seems to
be monstrously big and all lumped into one single Python module).
Morten, I have a favor to ask. Since I have a deadline until Monday
to get NAV running (or we will use cacti+kannel), could you look into
my ip devices->edit problem. I'm more of a Perl guy, so Python is new
to me.
I haven't been to work since Thursday, so I didn't read this until now.
I'll be taking a closer look into this today, so we'll see what happens.
- --
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
iD8DBQFDpnW/XxIl0kpcOkQRAoQ8AJ0dU6ksiY+xH+X98+kL4mE3zsFqSgCfcAlT
gCxjwpf7vmLZ3FBrPL1IWqE=
=5jPB
-----END PGP SIGNATURE-----
>From morten.vold at ntnu.no Mon Dec 19 10:28:35 2005
From: morten.vold at ntnu.no (Morten Vold)
Date: Mon Dec 19 10:28:34 2005
Subject: [Nav-users] missing FROM-clause entry for table netboxcategory
In-Reply-To:
CARMENbC8wSA1XvpFVj00000042@carmen.akton.si
References:
CARMENbC8wSA1XvpFVj00000042@carmen.akton.si
Message-ID:
43A67D43.3090707@ntnu.no
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 15/12/2005 17:20, Perica Veljanovski uttered:
> ProgrammingError: ERROR: missing FROM-clause entry for table
> "netboxcategory"
> SELECT netboxid,netboxcategory.category FROM netbox WHERE
> netboxcategory.netboxid=netboxid
Having looked slightly closer at it now, I would like to know which
PostgreSQL version you are running?
I realize that this piece of SQL still has errors in it, but both
PostgreSQL 7.4 and PostgreSQL 8.0 seem to be very forgiving in this
situation. When I issue this statement on these databases, PostgreSQL
tells me:
NOTICE: adding missing FROM-clause entry for table "netboxcategory"
This tells me that the bug probably isn't related to the contents of any
table at all, but to PostgreSQL version or configuration. The reason
we've never discovered the bug before is that our PostgreSQL
installations have fixed the SQL statement for us.
- --
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
iD8DBQFDpn1CXxIl0kpcOkQRAuUcAJ4+JWsgkdx1SCPBU7KsqXa6wKEDXACcCgEu
li2UFbNeRMV7WR93viRyuZs=
=E03s
-----END PGP SIGNATURE-----
>From perica at akton.com.mk Mon Dec 19 10:54:46 2005
From: perica at akton.com.mk (Perica Veljanovski)
Date: Mon Dec 19 10:54:59 2005
Subject: [Nav-users] missing FROM-clause entry for table netboxcategory
In-Reply-To:
43A67D43.3090707@ntnu.no
Message-ID:
CARMENtIIZS2TRqf69a0000011f@carmen.akton.si
> -----Original Message-----
> From: Morten Vold [mailto:morten.vold@ntnu.no]
> Sent: Monday, December 19, 2005 10:29
> 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 15/12/2005 17:20, Perica Veljanovski uttered:
>
> > ProgrammingError: ERROR: missing FROM-clause entry for table
> > "netboxcategory"
>
> > SELECT netboxid,netboxcategory.category FROM netbox WHERE
> > netboxcategory.netboxid=netboxid
>
> Having looked slightly closer at it now, I would like to know which
> PostgreSQL version you are running?
>
> I realize that this piece of SQL still has errors in it, but both
> PostgreSQL 7.4 and PostgreSQL 8.0 seem to be very forgiving in this
> situation. When I issue this statement on these databases, PostgreSQL
> tells me:
>
> NOTICE: adding missing FROM-clause entry for table "netboxcategory"
>
> This tells me that the bug probably isn't related to the contents of any
> table at all, but to PostgreSQL version or configuration. The reason
> we've never discovered the bug before is that our PostgreSQL
> installations have fixed the SQL statement for us.
>
>
> - --
> 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
>
> iD8DBQFDpn1CXxIl0kpcOkQRAuUcAJ4+JWsgkdx1SCPBU7KsqXa6wKEDXACcCgEu
> li2UFbNeRMV7WR93viRyuZs=
> =E03s
> -----END PGP SIGNATURE-----
Thanks for taking the time mate!
postgresql-server-8.1.0
postgresql-client-8.1.0
