From bf56f0759bdfa87f143c3abd09f893a5f530fe88 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 10 Aug 2001 18:57:42 +0000 Subject: Make OIDs optional, per discussions in pghackers. WITH OIDS is still the default, but OIDS are removed from many system catalogs that don't need them. Some interesting side effects: TOAST pointers are 20 bytes not 32 now; pg_description has a three-column key instead of one. Bugs fixed in passing: BINARY cursors work again; pg_class.relhaspkey has some usefulness; pg_dump dumps comments on indexes, rules, and triggers in a valid order. initdb forced. --- contrib/chkpass/chkpass.sql | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'contrib/chkpass') diff --git a/contrib/chkpass/chkpass.sql b/contrib/chkpass/chkpass.sql index f8fce419a9..d5299afc29 100644 --- a/contrib/chkpass/chkpass.sql +++ b/contrib/chkpass/chkpass.sql @@ -4,7 +4,7 @@ -- darcy@druid.net -- http://www.druid.net/darcy/ -- --- $Header: /cvsroot/pgsql/contrib/chkpass/Attic/chkpass.sql,v 1.1 2001/05/03 12:32:13 darcy Exp $ +-- $Header: /cvsroot/pgsql/contrib/chkpass/Attic/chkpass.sql,v 1.2 2001/08/10 18:57:32 tgl Exp $ -- best viewed with tabs set to 4 -- %%PGDIR%% changed to your local directory where modules is -- @@ -73,9 +73,7 @@ create operator <> ( procedure = ne ); -INSERT INTO pg_description (objoid, description) - SELECT oid, 'password type with checks' - FROM pg_type WHERE typname = 'chkpass'; +COMMENT ON TYPE chkpass IS 'password type with checks'; -- -- eof -- cgit v1.2.1