Thread: System tables since 7.0.0
Has anything changed in the system tables pg_proc or pg_type since 7.0.0 was released? This morning I've seen two weird reports on Interfaces that are showing NullPointerExceptions occuring on internal queries to those two tables (in different classes, one queries just pg_type the other pg_proc). There's nothing special about these queries so I'm just wondering if it's something more sinister going on. Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council
One of these is now fixed, but the other (pg_proc) I'm not sure about. Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council -----Original Message----- From: Peter Mount [mailto:petermount@it.maidstone.gov.uk] Sent: Wednesday, July 19, 2000 7:53 AM To: PostgreSQL Developers List (E-mail) Subject: [HACKERS] System tables since 7.0.0 Has anything changed in the system tables pg_proc or pg_type since 7.0.0 was released? This morning I've seen two weird reports on Interfaces that are showing NullPointerExceptions occuring on internal queries to those two tables (in different classes, one queries just pg_type the other pg_proc). There's nothing special about these queries so I'm just wondering if it's something more sinister going on. Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council
Peter Mount <petermount@it.maidstone.gov.uk> writes:
> Has anything changed in the system tables pg_proc or pg_type since 7.0.0 was
> released?
No ... we don't change system tables in patch releases, as a matter of
policy.
The current development tip is another story of course, but I assume
you are looking at reports from people running 7.0.*. Might be useful
to get them to try the same queries in psql.
regards, tom lane
That's what I thought. Yes, it is 7.0.* releases the reports are coming
from. One has been solved (they were closing the connection before using
it), but the other one this morning, and one this afternoon are still
puzzling...
Peter
--
Peter Mount
Enterprise Support Mushroom
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, July 19, 2000 4:13 PM
To: Peter Mount
Cc: PostgreSQL Developers List (E-mail)
Subject: Re: [HACKERS] System tables since 7.0.0
Peter Mount <petermount@it.maidstone.gov.uk> writes:
> Has anything changed in the system tables pg_proc or pg_type since 7.0.0
was
> released?
No ... we don't change system tables in patch releases, as a matter of
policy.
The current development tip is another story of course, but I assume
you are looking at reports from people running 7.0.*. Might be useful
to get them to try the same queries in psql.
regards, tom lane