sql_sizing

From: Chris Bowlby <chris(at)pgsql(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: sql_sizing
Date: 2004-04-15 18:34:01
Message-ID: 1082054040.3866.9.camel@morpheus.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

I've got an issue that I've been trying to track down some results to.
I've noticed that on a recent PostgreSQL server that I've been working
on has a few relations that do not exist:

select relname, relnamespace, reltype from pg_class where relname ~*
'sql_';
relname | relnamespace | reltype
-------------------------+--------------+---------
sql_features | 16977 | 17071
sql_implementation_info | 16977 | 17076
sql_languages | 16977 | 17081
sql_packages | 16977 | 17086
sql_sizing | 16977 | 17091
sql_sizing_profiles | 16977 | 17096
(6 rows)

These tables are in the pg_class table, but no where on any PostgreSQL
server that I've been able to look at have these tables been created.
I've been working with 7.4.1 and 7.4.2 versions, and have even initdb'd
a couple of databases only to find that they are not getting created
even though they are being listed in the pg_class table.

I've been working with a series of scripts that floats over the
pg_class table to find a listing of all tables that exist. That was when
I noticed that these ones did not.

Has anyone else run into this problem?, is it safe to remove these
tables from the pg_class table or is it safe to create the tables
themselves?

--
Chris Bowlby <chris(at)pgsql(dot)com>
PostgreSQL Inc.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Weimer 2004-04-15 18:52:57 Re: sql_sizing
Previous Message Peter Eisentraut 2004-04-15 18:29:04 Re: PostgreSQL 7.4.2 and Cygwin a no go?