Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: constraints and sql92 information_schema compliance


  • From: Josh Berkus <josh(at)agliodbs(dot)com>
  • To: pgsql-hackers(at)postgresql(dot)org
  • Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, "Clark C. Evans" <cce(at)clarkevans(dot)com>, Bruno Wolff III <bruno(at)wolff(dot)to>
  • Subject: Re: constraints and sql92 information_schema compliance
  • Date: Sat, 25 Feb 2006 14:28:16 -0800
  • Message-id: <200602251428(dot)16344(dot)josh(at)agliodbs(dot)com>

Guys,

So, based on this discussion, I'd like to consider taking a second stab at 
newsysviews:

1) Implement SQL03 changes into the information_schema, using some of the 
code from newsysviews;

2) Modify the newsysviews to be extensions of the information_schema views:
	e.g. information_schema.tables would have the SQL03 information, and
	information_schema.tables_pg would have pg-specific stuff like table size 
and last analyzed date. 

I think that this should answer the objections expressed to the newsysviews 
and provide a path towards integrating them into the main code.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group