| 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(dot) Evans" <cce(at)clarkevans(dot)com>, Bruno Wolff III <bruno(at)wolff(dot)to> |
| Subject: | Re: constraints and sql92 information_schema compliance |
| Date: | 2006-02-25 22:28:16 |
| Message-ID: | 200602251428.16344.josh@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James William Pye | 2006-02-25 22:47:16 | Re: Pl/Python -- current maintainer? |
| Previous Message | Stephan Szabo | 2006-02-25 22:01:00 | Re: constraints and sql92 information_schema compliance |