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
Chris Bowlby [EMAIL PROTECTED] writes:
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 ~*
On Thu, 2004-04-15 at 14:34, Chris Bowlby wrote:
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:
I suggest you read up on the information_schema.
Chris Bowlby [EMAIL PROTECTED] writes:
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.
You're probably forgetting to specify the schema name.
information_schema isn't in the default search path ...
Joe Conway writes:
I found the definition in FIPS 127-2:
http://www.itl.nist.gov/fipspubs/fip127-2.htm
The relevant section is section 16.6.
The table described there does not match the schema of the SQL_SIZING
table defined in the SQL standard. I'm also suspicious because the
The information schema is supposed to contain a view SQL_SIZING which is
defined thus:
List the sizing items defined in this standard and, for each of
these, indicate the size supported by the SQL-implementation.
But the standard does not define any sizing item or anything like
Peter Eisentraut wrote:
Unless someone can offer an explanation, I am inclined to just supply an
empty table and check off this item.
I found the definition in FIPS 127-2:
http://www.itl.nist.gov/fipspubs/fip127-2.htm
The relevant section is section 16.6.
Joe
According to:
http://www.itl.nist.gov/fipspubs/fip127-2.htm#FIPS_TOP
15.2 SQL_Sizing table. The SQL_SIZING table shall consist of exactly one
row for each FIPS SQL database construct defined in Section 16.6 of this
standard. The SIZING_ID and DESCRIPTION columns identify the database
construct
