pgsql-server/src/bin/pg_dump pg_dump.c

pgsql-server/src/bin/pg_dump pg_dump.c

Post by Bruce Momjian - C » Fri, 21 Mar 2003 16:05:27



CVSROOT:        /cvsroot
Module name:    pgsql-server

Modified files:
        src/bin/pg_dump: pg_dump.c

Log message:
        At present, dates are put into a dump in the format specified by the
        default datestyle.  This is not portable between installations.

        This patch sets DATESTYLE to ISO at the start of a pg_dump, so that the
        dates written into the dump will be restorable onto any database,
        regardless of how its default datestyle is set.

        Oliver Elphick

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

 
 
 

1. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump.h

CVSROOT:        /cvsroot
Module name:    pgsql-server

Modified files:
        src/bin/pg_dump: pg_dump.c pg_dump.h

Log message:
        It has been tested only against CVS backend, however.  Some checking of the
        changes to the SQL to retrieve attributes for older versions of Postgres is
        probably wise.  Also, please make sure that I have mapped the storage types
        to the correct storage names, as this is relatively poorly documented.

        I think that this patch might need to be considered for back-porting to
        7.3.3 since at the moment, people will be losing valuable information after
        upgrades.

        Will dump:

        CREATE TABLE test (
        a text,
        b text,
        c text,
        d text
        );
        ALTER TABLE ONLY test ALTER COLUMN a SET STATISTICS 55;
        ALTER TABLE ONLY test ALTER COLUMN a SET STORAGE PLAIN;
        ALTER TABLE ONLY test ALTER COLUMN b SET STATISTICS 1000;
        ALTER TABLE ONLY test ALTER COLUMN c SET STORAGE EXTERNAL;
        ALTER TABLE ONLY test ALTER COLUMN d SET STORAGE MAIN;

        Christopher Kings-Lynne

---------------------------(end of broadcast)---------------------------

2. BUFFERS limit

3. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...

4. Creating a button in ObjectPal

5. error 3421 on compactdatabase

6. pgsql-server/src/bin/pg_dump pg_dump.c

7. Yukon