- Jun 18, 2001
-
-
Bruce Momjian authored
-
Bruce Momjian authored
functions to clear date cache. Allow regression tests to pass when timezone set.
-
Bruce Momjian authored
-
- Jun 15, 2001
-
-
Tom Lane authored
-
- Jun 14, 2001
-
-
Bruce Momjian authored
> >> inet(text), cidr(text): convert a text value into inet/cidr > >> set_masklen(inet): set masklen on the inet value Alex Pilosov
-
- Jun 13, 2001
-
-
Bruce Momjian authored
-
- Jun 12, 2001
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
pg_database now has unique indexes on oid and on datname. pg_shadow now has unique indexes on usename and on usesysid. pg_am now has unique index on oid. pg_opclass now has unique index on oid. pg_amproc now has unique index on amid+amopclaid+amprocnum. Remove pg_rewrite's unnecessary index on oid, delete unused RULEOID syscache. Remove index on pg_listener and associated syscache for performance reasons (caching rows that are certain to change before you need 'em again is rather pointless). Change pg_attrdef's nonunique index on adrelid into a unique index on adrelid+adnum. Fix various incorrect settings of pg_class.relisshared, make that the primary reference point for whether a relation is shared or not. IsSharedSystemRelationName() is now only consulted to initialize relisshared during initial creation of tables and indexes. In theory we might now support shared user relations, though it's not clear how one would get entries for them into pg_class &etc of multiple databases. Fix recently reported bug that pg_attribute rows created for an index all have the same OID. (Proof that non-unique OID doesn't matter unless it's actually used to do lookups ;-)) There's no need to treat pg_trigger, pg_attrdef, pg_relcheck as bootstrap relations. Convert them into plain system catalogs without hardwired entries in pg_class and friends. Unify global.bki and template1.bki into a single init script postgres.bki, since the alleged distinction between them was misleading and pointless. Not to mention that it didn't work for setting up indexes on shared system relations. Rationalize locking of pg_shadow, pg_group, pg_attrdef (no need to use AccessExclusiveLock where ExclusiveLock or even RowExclusiveLock will do). Also, hold locks until transaction commit where necessary.
-
- Jun 11, 2001
-
-
Bruce Momjian authored
-
Tom Lane authored
-
- Jun 10, 2001
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Peter Eisentraut authored
for GRANT/REVOKE is now just that, not "CHANGE". On the way, migrate some of the aclitem internal representation away from the parser and build a real parse tree instead. Also add some 'const' qualifiers.
-
- Jun 09, 2001
-
-
Bruce Momjian authored
-
Tom Lane authored
-
- Jun 07, 2001
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
on RESET ALL those are restored. show all: GUC + non-GUC. SHOW ALL, RESET ALL Marko Kreen
-
- Jun 06, 2001
-
-
Bruce Momjian authored
-
- Jun 05, 2001
-
-
Bruce Momjian authored
types. This version has an elog() to remind the user the type resolution is not dynamic. Ian Lance Taylor
-
- Jun 04, 2001
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- Jun 02, 2001
-
-
Bruce Momjian authored
-
Peter Eisentraut authored
Use --enable-nls to turn it on; see installation instructions for details. See developer's guide how to make use of it in programs and how to add translations. psql sources have been almost fully prepared and an incomplete German translation has been provided. In the backend, only elog() calls are currently translatable, and the provided German translation file is more of a placeholder.
-
- Jun 01, 2001
-
-
Tom Lane authored
report on old-style functions invoked by RI triggers. We had a number of other places that were being sloppy about which memory context FmgrInfo subsidiary data will be allocated in. Turns out none of them actually cause a problem in 7.1, but this is for arcane reasons such as the fact that old-style triggers aren't supported anyway. To avoid getting burnt later, I've restructured the trigger support so that we don't keep trigger FmgrInfo structs in relcache memory. Some other related cleanups too: it's not really necessary to call fmgr_info at all while setting up the index support info in relcache entries, because those ScanKeyEntry structs are never used to invoke the functions. This should speed up relcache initialization a tiny bit.
-
Bruce Momjian authored
-
- May 31, 2001
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-