]> granicus.if.org Git - postgresql/log
postgresql
22 years agoConsistend spelling for PL/pgSQL
Bruce Momjian [Thu, 31 Jan 2002 21:20:03 +0000 (21:20 +0000)]
Consistend spelling for PL/pgSQL

22 years agoAdd mention of recovery using pg_upgrade.
Bruce Momjian [Thu, 31 Jan 2002 19:13:53 +0000 (19:13 +0000)]
Add mention of recovery using pg_upgrade.

22 years agoUpdate HISTORY/release.sgml for Monday release.
Bruce Momjian [Thu, 31 Jan 2002 18:31:44 +0000 (18:31 +0000)]
Update HISTORY/release.sgml for Monday release.

22 years agoUniformize spelling
Peter Eisentraut [Thu, 31 Jan 2002 00:51:32 +0000 (00:51 +0000)]
Uniformize spelling

22 years agoRebuild from source.
Peter Eisentraut [Thu, 31 Jan 2002 00:46:26 +0000 (00:46 +0000)]
Rebuild from source.

22 years agoUpdate Win32-world version number of libpq++.
Peter Eisentraut [Wed, 30 Jan 2002 21:59:33 +0000 (21:59 +0000)]
Update Win32-world version number of libpq++.

22 years agoDon't put empty paragraphs around tables. This messed up JadeTeX somehow,
Peter Eisentraut [Wed, 30 Jan 2002 21:55:33 +0000 (21:55 +0000)]
Don't put empty paragraphs around tables.  This messed up JadeTeX somehow,
and doesn't make sense strictly speaking.

22 years agoRemove Jade/TeX hack, now that OpenJade 1.3.1 has it fixed.
Peter Eisentraut [Wed, 30 Jan 2002 21:54:17 +0000 (21:54 +0000)]
Remove Jade/TeX hack, now that OpenJade 1.3.1 has it fixed.

22 years agoFix copy-and-paste bug in print style.
Peter Eisentraut [Wed, 30 Jan 2002 21:53:40 +0000 (21:53 +0000)]
Fix copy-and-paste bug in print style.

22 years agoAdd cast to suppress gcc warning on Darwin platform.
Tom Lane [Wed, 30 Jan 2002 19:34:55 +0000 (19:34 +0000)]
Add cast to suppress gcc warning on Darwin platform.

22 years agoupdate
Peter Eisentraut [Tue, 29 Jan 2002 20:39:49 +0000 (20:39 +0000)]
update

22 years agoMake S/390 TAS spell __inline__ the same way as the other eight GCC
Tom Lane [Tue, 29 Jan 2002 15:44:42 +0000 (15:44 +0000)]
Make S/390 TAS spell __inline__ the same way as the other eight GCC
inline routines do.

22 years agoRemove gratuitous redefinition of inline, which should already have been
Tom Lane [Tue, 29 Jan 2002 15:40:45 +0000 (15:40 +0000)]
Remove gratuitous redefinition of inline, which should already have been
taken care of in pg_config.h.

22 years agoRemove dashed items in preparations for 7.3.
Bruce Momjian [Sun, 27 Jan 2002 04:22:35 +0000 (04:22 +0000)]
Remove dashed items in preparations for 7.3.

22 years agoAdd:
Bruce Momjian [Sun, 27 Jan 2002 04:20:38 +0000 (04:20 +0000)]
Add:

> * Allow ORDER BY ... LIMIT to select top values without sort or index

22 years agoRemove link:
Bruce Momjian [Sat, 26 Jan 2002 23:17:32 +0000 (23:17 +0000)]
Remove link:

> * -Allow LOCK TABLE tab1, tab2, tab3 so all tables locked in unison

22 years agoUpdates from Serguei Mokhov
Peter Eisentraut [Sat, 26 Jan 2002 19:00:11 +0000 (19:00 +0000)]
Updates from Serguei Mokhov

22 years agoOverhaul plperl documentation.
Tom Lane [Fri, 25 Jan 2002 19:13:15 +0000 (19:13 +0000)]
Overhaul plperl documentation.

22 years agoTweak pg_dump to say GRANT ALL when appropriate, rather than enumerating
Tom Lane [Fri, 25 Jan 2002 18:49:31 +0000 (18:49 +0000)]
Tweak pg_dump to say GRANT ALL when appropriate, rather than enumerating
the individual privilege bits.  I regard this as an important change for
cross-version compatibility: without this, a 7.1 dump loaded into 7.2
is likely to be short a few privileges.

22 years agoFix typo in usage message, per Oleg.
Tom Lane [Fri, 25 Jan 2002 15:40:13 +0000 (15:40 +0000)]
Fix typo in usage message, per Oleg.

22 years agoFix +/- mixup pointed out by Rod Taylor.
Bruce Momjian [Fri, 25 Jan 2002 02:39:28 +0000 (02:39 +0000)]
Fix +/- mixup pointed out by Rod Taylor.

22 years agoAdd mention of UPDATE
Bruce Momjian [Fri, 25 Jan 2002 02:33:39 +0000 (02:33 +0000)]
Add mention of UPDATE

>  o Allow UPDATE/DELETE WHERE CURRENT OF cursor using per-cursor tid

22 years agoAdd mention of implementation:
Bruce Momjian [Fri, 25 Jan 2002 02:32:59 +0000 (02:32 +0000)]
Add mention of implementation:

>  o Allow DELETE WHERE CURRENT OF cursor using per-cursor tid
>    stored in the backend

22 years agoAdd URL for pgj.
Bruce Momjian [Fri, 25 Jan 2002 02:30:49 +0000 (02:30 +0000)]
Add URL for pgj.

22 years agolet's roll up rc2 .. REL7_2_RC2
PostgreSQL Daemon [Fri, 25 Jan 2002 02:09:26 +0000 (02:09 +0000)]
let's roll up rc2 ..

22 years agoAdd 128 mention:
Bruce Momjian [Fri, 25 Jan 2002 01:04:47 +0000 (01:04 +0000)]
Add 128 mention:

> * Increase identifier length (NAMEDATALEN) if small performance hit,
>   perhaps to standard length of 128;  change struct pgNotify to use pid
>   first, breaks notify API;

22 years agoUpdated:
Bruce Momjian [Thu, 24 Jan 2002 23:50:09 +0000 (23:50 +0000)]
Updated:

> * Increase identifier length (NAMEDATALEN) if small performance hit;
>   change struct pgNotify to use pid first, breaks notify API

22 years agoAdded:
Bruce Momjian [Thu, 24 Jan 2002 23:35:40 +0000 (23:35 +0000)]
Added:

> * Evaluate AIX cs() spinlock macro for performance optimizations (Tatsuo)

22 years agoAnother clarification.
Bruce Momjian [Thu, 24 Jan 2002 22:20:18 +0000 (22:20 +0000)]
Another clarification.

22 years agoClarification on COPY failure options.
Bruce Momjian [Thu, 24 Jan 2002 22:19:48 +0000 (22:19 +0000)]
Clarification on COPY failure options.

22 years agoTweak plperl.c to compile against threaded Perls, per report from
Tom Lane [Thu, 24 Jan 2002 21:40:44 +0000 (21:40 +0000)]
Tweak plperl.c to compile against threaded Perls, per report from
cturner@redhat.com.

22 years agoCope with gcc that outputs a multiline version string, per Trond.
Tom Lane [Thu, 24 Jan 2002 19:50:36 +0000 (19:50 +0000)]
Cope with gcc that outputs a multiline version string, per Trond.

22 years agopltcl's spi_execp didn't handle NULL arguments quite correctly.
Tom Lane [Thu, 24 Jan 2002 19:31:36 +0000 (19:31 +0000)]
pltcl's spi_execp didn't handle NULL arguments quite correctly.
It would try to call the input conversion routines for them anyway.
So, a valid input string for the datatype had to be supplied.

22 years agoFix documentation misstatement: OLD is not valid in ON SELECT.
Tom Lane [Thu, 24 Jan 2002 18:28:15 +0000 (18:28 +0000)]
Fix documentation misstatement: OLD is not valid in ON SELECT.

22 years agoFix incorrect test for whether Perl code is returning undef. This
Tom Lane [Thu, 24 Jan 2002 16:53:42 +0000 (16:53 +0000)]
Fix incorrect test for whether Perl code is returning undef.  This
allows plperl routines to return NULL as intended.

22 years agoFix logic error in insert_fsm_page_entry: because compact_fsm_page_list
Tom Lane [Thu, 24 Jan 2002 15:31:43 +0000 (15:31 +0000)]
Fix logic error in insert_fsm_page_entry: because compact_fsm_page_list
removes any empty chunks, the chunk previously added won't be there
anymore, so it's possible there is zero free space in the rel's page list
afterwards.  Must loop back and rerun the part that adds a chunk to
the list.

22 years agoOverhaul PL/Tcl documentation.
Tom Lane [Wed, 23 Jan 2002 21:08:17 +0000 (21:08 +0000)]
Overhaul PL/Tcl documentation.

22 years agoAdd Goggle mention of previous discussion.
Bruce Momjian [Wed, 23 Jan 2002 19:22:08 +0000 (19:22 +0000)]
Add Goggle mention of previous discussion.

22 years agoRemove long-obsolete version of pltcl documentation.
Tom Lane [Wed, 23 Jan 2002 18:48:39 +0000 (18:48 +0000)]
Remove long-obsolete version of pltcl documentation.

22 years agoClean up Red Hat Tcl RPM brain-damage in a more reliable way: fix the
Tom Lane [Wed, 23 Jan 2002 18:45:41 +0000 (18:45 +0000)]
Clean up Red Hat Tcl RPM brain-damage in a more reliable way: fix the
value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs,
rather than trying to persude gmake to do it.

22 years agoAdd new email;remove old entries.
Bruce Momjian [Wed, 23 Jan 2002 18:40:22 +0000 (18:40 +0000)]
Add new email;remove old entries.

22 years agoAdded patch to temporarily disable locale for descriptors too (Christof)
Michael Meskes [Wed, 23 Jan 2002 16:34:06 +0000 (16:34 +0000)]
Added patch to temporarily disable locale for descriptors too (Christof)

22 years agoAdd:
Bruce Momjian [Wed, 23 Jan 2002 16:14:04 +0000 (16:14 +0000)]
Add:

> * Reorder postgresql.conf WAL items in order of importance
> * Remove wal_files postgresql.conf option because WAL files are now recycled
> * Find proper defaults for postgresql.conf WAL entries
> * Add checkpoint_min_warning postgresql.conf option to warn about checkpoints
>   that are too frequent

22 years agoClarify URL:
Bruce Momjian [Tue, 22 Jan 2002 22:22:34 +0000 (22:22 +0000)]
Clarify URL:

<   http://www1.distributed.net/source, in client/common/cpucheck.cpp
---
>   from distributted.net, http://www1.distributed.net/source,
>   in client/common/cpucheck.cpp

22 years agoDocument SMP detection code.
Bruce Momjian [Tue, 22 Jan 2002 22:15:07 +0000 (22:15 +0000)]
Document SMP detection code.

22 years agoRe-group items.
Bruce Momjian [Tue, 22 Jan 2002 21:55:06 +0000 (21:55 +0000)]
Re-group items.

22 years agoBreak PERFORMANCE up into subsections.
Bruce Momjian [Tue, 22 Jan 2002 20:50:35 +0000 (20:50 +0000)]
Break PERFORMANCE up into subsections.

22 years agoAdd:
Bruce Momjian [Tue, 22 Jan 2002 20:40:27 +0000 (20:40 +0000)]
Add:

> * Add code to detect an SMP machine and handle spinlocks accordingly

22 years agoUpdate FAQ.
Bruce Momjian [Tue, 22 Jan 2002 20:24:14 +0000 (20:24 +0000)]
Update FAQ.

22 years agolibpq++/pgconnection.h must not include postgres_fe.h, else it fails to
Tom Lane [Tue, 22 Jan 2002 19:02:40 +0000 (19:02 +0000)]
libpq++/pgconnection.h must not include postgres_fe.h, else it fails to
compile in client apps that use the standard installed header set.
To allow removing that include, move DLLIMPORT definitions out of c.h
and into the appropriate port-specific header files.

22 years agookay, sorry for delay all ... here is the tag for RC1 ... REL7_2_RC1
PostgreSQL Daemon [Tue, 22 Jan 2002 17:55:30 +0000 (17:55 +0000)]
okay, sorry for delay all ... here is the tag for RC1 ...

22 years agoSuppress bogus soname switch that RedHat RPMs put into tclConfig.sh.
Tom Lane [Mon, 21 Jan 2002 03:27:46 +0000 (03:27 +0000)]
Suppress bogus soname switch that RedHat RPMs put into tclConfig.sh.

22 years agoSpell-check and markup police
Peter Eisentraut [Sun, 20 Jan 2002 22:19:57 +0000 (22:19 +0000)]
Spell-check and markup police

22 years agoMention that 'make distclean' is a good idea when changing configure
Tom Lane [Sun, 20 Jan 2002 05:45:18 +0000 (05:45 +0000)]
Mention that 'make distclean' is a good idea when changing configure
options.  Document --with-pam and --enable-depend, do some minor
copy-editing.

22 years agoAdd IN/EXISTS file.
Bruce Momjian [Sun, 20 Jan 2002 05:12:57 +0000 (05:12 +0000)]
Add IN/EXISTS file.

22 years agoAdd
Bruce Momjian [Sun, 20 Jan 2002 04:56:14 +0000 (04:56 +0000)]
Add

> * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS [exists]

22 years agoUpdate from Kova'cs Zolta'n
Peter Eisentraut [Fri, 18 Jan 2002 21:25:00 +0000 (21:25 +0000)]
Update from Kova'cs Zolta'n

22 years agoAdd missing literal endtag.
Bruce Momjian [Fri, 18 Jan 2002 21:17:07 +0000 (21:17 +0000)]
Add missing literal endtag.

22 years agoAdd info about how to enable large-file support, so that pg_dump won't
Tom Lane [Fri, 18 Jan 2002 20:56:17 +0000 (20:56 +0000)]
Add info about how to enable large-file support, so that pg_dump won't
choke at 2Gb of output.  From Andrew Sullivan.

22 years agoAdd:
Bruce Momjian [Fri, 18 Jan 2002 20:46:37 +0000 (20:46 +0000)]
Add:

> * Use thread-safe crypt() in libpq, if available

22 years agoImprove non-thread-safe mention of libpq's crypt.
Bruce Momjian [Fri, 18 Jan 2002 20:39:04 +0000 (20:39 +0000)]
Improve non-thread-safe mention of libpq's crypt.

22 years agoImprove description of autocommit behavior in ecpg manual pages.
Bruce Momjian [Fri, 18 Jan 2002 20:32:54 +0000 (20:32 +0000)]
Improve description of autocommit behavior in ecpg manual pages.

22 years agoYou might want to run pg_indent on pg_backup_db.c however ...
Bruce Momjian [Fri, 18 Jan 2002 19:17:05 +0000 (19:17 +0000)]
You might want to run pg_indent on pg_backup_db.c however ...

tom lane

22 years agoFixes to getImportedKeys/getExportedKeys from Jason Davies
Dave Cramer [Fri, 18 Jan 2002 17:21:51 +0000 (17:21 +0000)]
Fixes to getImportedKeys/getExportedKeys from Jason Davies
Previous versions did not correctly identify primary/foreign keys

22 years agoFix pg_restore to handle the 'set max oid' entry correctly in archives
Tom Lane [Fri, 18 Jan 2002 17:13:51 +0000 (17:13 +0000)]
Fix pg_restore to handle the 'set max oid' entry correctly in archives
dumped by pg_dump -o.  Per bug report posted by Bruce; fix is from
Philip Warner, reviewed by Tom Lane.

22 years agoAdd missing 'else', per report from sugita@sra.co.jp.
Tom Lane [Fri, 18 Jan 2002 16:14:54 +0000 (16:14 +0000)]
Add missing 'else', per report from sugita@sra.co.jp.

22 years agoAccept subsequent commits. This should have been just a warning anyway. I
Michael Meskes [Fri, 18 Jan 2002 15:51:00 +0000 (15:51 +0000)]
Accept subsequent commits. This should have been just a warning anyway. I
cannot see a reason why it should be an error.

22 years agoEnable /contrib/pg_upgrade, mention little testing.
Bruce Momjian [Fri, 18 Jan 2002 04:38:46 +0000 (04:38 +0000)]
Enable /contrib/pg_upgrade, mention little testing.

22 years agoExplain privileges required for LOCK. Minor wordsmithing too.
Tom Lane [Fri, 18 Jan 2002 01:05:43 +0000 (01:05 +0000)]
Explain privileges required for LOCK.  Minor wordsmithing too.

22 years agoPoint out that superusers bypass privilege checking. Minor wordsmithing.
Tom Lane [Fri, 18 Jan 2002 01:04:53 +0000 (01:04 +0000)]
Point out that superusers bypass privilege checking.  Minor wordsmithing.

22 years agoFix misstatements added by Bruce.
Tom Lane [Wed, 16 Jan 2002 23:51:56 +0000 (23:51 +0000)]
Fix misstatements added by Bruce.

22 years agoAdd more comments to tqual.c for visibility functions.
Bruce Momjian [Wed, 16 Jan 2002 23:09:09 +0000 (23:09 +0000)]
Add more comments to tqual.c for visibility functions.

22 years agoTOAST needs to do at least minimal time-qual checking in order not to
Tom Lane [Wed, 16 Jan 2002 20:29:02 +0000 (20:29 +0000)]
TOAST needs to do at least minimal time-qual checking in order not to
mess up after an aborted VACUUM FULL, per today's pghackers discussion.
Add a suitable HeapTupleSatisfiesToast routine.  Remove useless special-
case test in HeapTupleSatisfiesVisibility macro for xmax =
BootstrapTransactionId; perhaps that was needed at one time, but it's
a waste of cycles now, not to mention actively wrong for SnapshotAny.
Along the way, add some much-needed comments to tqual.c, and simplify
toast_fetch_datum, which no longer needs to assume it may see chunks
out-of-order.

22 years agoFix init_irels to close the pg_internal.init file before returning.
Tom Lane [Wed, 16 Jan 2002 17:34:42 +0000 (17:34 +0000)]
Fix init_irels to close the pg_internal.init file before returning.
This saves one open file descriptor per backend, and avoids an
annoying NOTICE on Cygwin (which has trouble deleting open files).
Bug appears to date back to original coding of init_irels, circa 1992.

22 years agoIf we fail to rename pg_internal.init into place, delete the useless
Tom Lane [Tue, 15 Jan 2002 22:33:20 +0000 (22:33 +0000)]
If we fail to rename pg_internal.init into place, delete the useless
temporary file.  This seems to be a known failure mode under Cygwin,
so we might as well expend the extra line of code to be tidy.

22 years agoAdd more sanity-checking to PageAddItem and PageIndexTupleDelete,
Tom Lane [Tue, 15 Jan 2002 22:14:17 +0000 (22:14 +0000)]
Add more sanity-checking to PageAddItem and PageIndexTupleDelete,
to prevent spreading of corruption when page header pointers are bad.
Merge PageZero into PageInit, since it was never used separately, and
remove separate memset calls used at most other PageInit call points.
Remove IndexPageCleanup, which wasn't used at all.

22 years agoFix typo that caused equalTriggerDescs() to return false in cases where
Tom Lane [Tue, 15 Jan 2002 16:52:47 +0000 (16:52 +0000)]
Fix typo that caused equalTriggerDescs() to return false in cases where
the two trigger sets were logically equal, but not in the same order.
Caught by Holger Krug (hkrug@rationalizer.com).

22 years agoApplied patch submitted by Ryouichi Matsuda (r-matuda@sra.co.jp) that fixed a problem...
Barry Lind [Tue, 15 Jan 2002 07:37:33 +0000 (07:37 +0000)]
Applied patch submitted by Ryouichi Matsuda (r-matuda@sra.co.jp) that fixed a problem with leading zeros being lost on fractional seconds when setting a timestamp value on a PreparedStatement.

22 years agoApplied patch from Ryouichi Matsuda <r-matuda@sra.co.jp> where the jdbc
Barry Lind [Tue, 15 Jan 2002 06:55:13 +0000 (06:55 +0000)]
Applied patch from Ryouichi Matsuda <r-matuda@sra.co.jp> where the jdbc
driver was not properly handling timestamptz datatype when using the
getObject() method on ResultSet.  Fix adds this datatype to the object mappings.

22 years agoManual page improvements.
Bruce Momjian [Tue, 15 Jan 2002 05:41:55 +0000 (05:41 +0000)]
Manual page improvements.

22 years agoMore cleanups.
Bruce Momjian [Tue, 15 Jan 2002 05:10:57 +0000 (05:10 +0000)]
More cleanups.

22 years agopg_upgrade doesn't live here anymore. Remove dangling references.
Tom Lane [Tue, 15 Jan 2002 05:05:49 +0000 (05:05 +0000)]
pg_upgrade doesn't live here anymore.  Remove dangling references.

22 years agoKeep pg_upgrade as disabled.
Bruce Momjian [Tue, 15 Jan 2002 05:03:53 +0000 (05:03 +0000)]
Keep pg_upgrade as disabled.

22 years agoMore wording improvements.
Bruce Momjian [Tue, 15 Jan 2002 05:03:25 +0000 (05:03 +0000)]
More wording improvements.

22 years agoMore updates.
Bruce Momjian [Tue, 15 Jan 2002 04:55:26 +0000 (04:55 +0000)]
More updates.

22 years agoRemove old pg_upgrade script, from Tom.
Bruce Momjian [Tue, 15 Jan 2002 04:52:33 +0000 (04:52 +0000)]
Remove old pg_upgrade script, from Tom.

22 years agoMore cleanups with ideas from Peter.
Bruce Momjian [Tue, 15 Jan 2002 04:50:37 +0000 (04:50 +0000)]
More cleanups with ideas from Peter.

22 years agoAdd Peter's portability and option suggestions.
Bruce Momjian [Tue, 15 Jan 2002 04:05:24 +0000 (04:05 +0000)]
Add Peter's portability and option suggestions.

22 years agoUpdate permissions?
Bruce Momjian [Mon, 14 Jan 2002 22:54:44 +0000 (22:54 +0000)]
Update permissions?

22 years agoReduce severity of 'XLogFlush: request is not satisfied' error condition,
Tom Lane [Mon, 14 Jan 2002 17:55:57 +0000 (17:55 +0000)]
Reduce severity of 'XLogFlush: request is not satisfied' error condition,
per my proposal of a couple days ago.  This will eliminate the unable-
to-restart-database class of problem that we have seen reported half a
dozen times with 7.1.*.

22 years agoEnsure that ecpg/test is cleaned by higher-level 'make clean'.
Tom Lane [Mon, 14 Jan 2002 17:49:56 +0000 (17:49 +0000)]
Ensure that ecpg/test is cleaned by higher-level 'make clean'.

22 years agoAdd README file.
Bruce Momjian [Mon, 14 Jan 2002 17:45:43 +0000 (17:45 +0000)]
Add README file.

22 years agoDoc improvements.
Bruce Momjian [Mon, 14 Jan 2002 17:42:42 +0000 (17:42 +0000)]
Doc improvements.

22 years agoAdd manual page to /contrib. SGML from docs.
Bruce Momjian [Mon, 14 Jan 2002 17:32:36 +0000 (17:32 +0000)]
Add manual page to /contrib.  SGML from docs.

22 years agoMove pg_upgrade to /contrib. Still need to make Peter's portability
Bruce Momjian [Mon, 14 Jan 2002 17:32:07 +0000 (17:32 +0000)]
Move pg_upgrade to /contrib.  Still need to make Peter's portability
changes.

22 years agoSmall AIX fixes from Rick Flower.
Bruce Momjian [Mon, 14 Jan 2002 15:34:41 +0000 (15:34 +0000)]
Small AIX fixes from  Rick Flower.

22 years agotag as beta 5 for *hopefully* a very very short beta cycle on this one? REL7_2_BETA5
PostgreSQL Daemon [Mon, 14 Jan 2002 13:15:28 +0000 (13:15 +0000)]
tag as beta 5 for *hopefully* a very very short beta cycle on this one?

22 years agoFix recreation of sequence files for 7.2 also because of XID change from
Bruce Momjian [Sun, 13 Jan 2002 17:52:00 +0000 (17:52 +0000)]
Fix recreation of sequence files for 7.2 also because of XID change from
beta4 to beta5.

22 years ago - Fixed variable handling for struct members.
Michael Meskes [Sun, 13 Jan 2002 08:52:09 +0000 (08:52 +0000)]
    - Fixed variable handling for struct members.
        - Removed check for array input. An attribut might store the
          complete array.

22 years agoNow works for 7.1 databases.
Bruce Momjian [Sun, 13 Jan 2002 05:36:42 +0000 (05:36 +0000)]
Now works for 7.1 databases.