System tables since 7.0.0

Started by Peter Mountover 25 years ago4 messages
#1Peter Mount
petermount@it.maidstone.gov.uk

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

#2Peter Mount
petermount@it.maidstone.gov.uk
In reply to: Peter Mount (#1)
RE: System tables since 7.0.0

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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Mount (#1)
Re: 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

#4Peter Mount
petermount@it.maidstone.gov.uk
In reply to: Tom Lane (#3)
RE: System tables since 7.0.0

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