delta/postgresql.git/contrib/dbmirror/MirrorSetup.sql, branch master

Remove contrib modules that have been migrated to pgfoundry: adddepend,

2006-09-05T17:20:29+00:00

dbase, dbmirror, fulltextindex, mac, userlock; or abandoned: mSQL-interface,
tips.

Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in

2006-02-27T16:09:50+00:00

particular get rid of single quotes around language names and old WITH ()
construct.

Change nextval and other sequence functions to specify their sequence

2005-10-02T23:50:16+00:00

argument as a 'regclass' value instead of a text string.  The frontend
conversion of text string to pg_class OID is now encapsulated as an
implicitly-invocable coercion from text to regclass.  This provides
backwards compatibility to the old behavior when the sequence argument
is explicitly typed as 'text'.  When the argument is just an unadorned
literal string, it will be taken as 'regclass', which means that the
stored representation will be an OID.  This solves longstanding problems
with renaming sequences that are referenced in default expressions, as
well as new-in-8.1 problems with renaming such sequences' schemas or
moving them to another schema.  All per recent discussion.
Along the way, fix some rather serious problems in dbmirror's support
for mirroring sequence operations (int4 vs int8 confusion for instance).

Apply patch from Steven Singer for contrib/dbmirror. Changes:

2004-09-10T04:31:06+00:00

-It fixes up some bugs with handling setval calls
-Adds upgrade instructions from prior versions
-Improved the sample config file
-Fixed some things in the clean_pending script

Please apply this patch to contrib/dbmirror

2004-02-17T03:34:35+00:00

In incorperates changes from myself and a number of contributors.

This update to dbmirror provides:

-replication of sequence operations via setval/nextval
-DBMirror.pl support for logging to syslog
-changed the names of the tables to dbmirror_*  (no quotes required)
-Support for writitng SQL statements to files instead of directly to
 a slave database
-More options for DBMirror.pl in the config files.

Steven Singer

Backend support for autocommit removed, per recent discussions. The

2003-05-14T03:26:03+00:00

only remnant of this failed experiment is that the server will take
SET AUTOCOMMIT TO ON.  Still TODO: provide some client-side autocommit
logic in libpq.

It includes

2002-10-19T02:16:40+00:00

-Support for mirroring tables in different Schema's
-Improved documentation for compiling with 7.1.x and 7.2.x
-Fixes a buffer overrun bug.

Steven Singer

Update /contrib for "autocommit TO 'on'".

2002-10-18T18:41:22+00:00

Create objects in public schema.

Make spacing/capitalization consistent.

Remove transaction block use for object creation.

Remove unneeded function GRANTs.

Add a bunch of pseudo-types to replace the behavior formerly associated

2002-08-22T00:01:51+00:00

with OPAQUE, as per recent pghackers discussion.  I still want to do some
more work on the 'cstring' pseudo-type, but I'm going to commit the bulk
of the changes now before the tree starts shifting under me ...

Add dbmirror to /contrib. Minor C cleanups and Makefile.

2002-06-23T21:58:08+00:00

Steven Singer