Re: [HACKERS] sql_sizing

2004-04-15 Thread Tom Lane
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 ...

Re: [HACKERS] sql_sizing

2004-04-15 Thread Rod Taylor
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

Re: [HACKERS] sql_sizing

2004-04-15 Thread Florian Weimer
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

[HACKERS] sql_sizing

2004-04-15 Thread Chris Bowlby
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 |

Re: [HACKERS] SQL_SIZING view

2003-01-07 Thread Peter Eisentraut
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

Re: [HACKERS] SQL_SIZING view

2003-01-06 Thread Rod Taylor
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

Re: [HACKERS] SQL_SIZING view

2003-01-06 Thread Joe Conway
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 ---(

[HACKERS] SQL_SIZING view

2003-01-06 Thread Peter Eisentraut
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