Re: Views, views, views: Summary of Arguments - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Views, views, views: Summary of Arguments
Date
Msg-id 92ed4a0568288fd3da51c17f9e44ec5b@biglumber.com
Whole thread Raw
In response to Re: Views, views, views: Summary of Arguments  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Views, views, views: Summary of Arguments
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> interface designers who are designing for 3rd-party multi-database
> products who are not supporting PostgreSQL yet and will be
> unlikely to learn the system tables

There's a scary thought.

So they are willing to learn the new system views, but not the system
tables? The above seems an argument for I_S, or at least an expanded I_S.

So... the reason we don't want to expand (not alter) I_S is that it is a
"standard" that very few RDBMS actually bother to implement, is already
out of date, and is incomplete? Seems we bend the rules in other ways when
needed (e.g. lowercase relation names), we could certainly add additional
tables and columns here, while maintaining the "standard" set for applications
looking for them.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505100635
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCgI6UvJuQZxSWSsgRAsp3AJ9aY8qeVzpKTcq5yXkhmtkJvuFRWACfXPST
TNNRK32VwbaHimNhB9hjWb8=
=Saja
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Cleaning up unreferenced table files
Next
From: Simon Riggs
Date:
Subject: Re: Table Partitioning, Part 1