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 ...
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_sch
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 reln
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 |
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
SQL_FEA
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 b
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
---(
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 lik
