pgsql-server/src/bin/scripts clusterdb

pgsql-server/src/bin/scripts clusterdb

Post by Bruce Momjian - C » Fri, 13 Sep 2002 09:18:18

CVSROOT:        /cvsroot
Module name:    pgsql-server

Modified files:
        src/bin/scripts: clusterdb

Log message:
        > BTW, clusterdb is not schema-aware and will surely fail in any database
        > where more than one schema is in use, because it doesn't trouble to
        > schema-qualify table names.

        Ok, the following patch should solve this concern.  It also tries to
        connect as little times as possible (the previous one would connect one
        time per table plus one per database; this one connects two times per

        Alvaro Herrera

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly


1. pgsql-server/src/bin/scripts clusterdb created ...

CVSROOT:        /cvsroot
Module name:    pgsql-server

Modified files:
        src/bin/scripts: clusterdb createdb createuser
                         dropdb droplang dropuser vacuumdb

Log message:
        Fix script to handle autocommit = 'off' by prepending autocommit 'on' to
        the start of the psql commandline.  This is better than adding BEGIN/END
        because it handles multiple queries well, and allows the return code for
        psql to return the proper value.

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

2. restore db - logical/physical names

3. pgsql-server/src/bin/scripts clusterdb

4. Need query help

5. pgsql/src bin/scripts/ bin/script ...

6. Modifying a cube dimension's SourceTableFilter?

7. pgsql-server/src/bin/scripts createuser

8. 3GL procedures & 4GL code

9. pgsql-server/src/bin/scripts Tag: REL7_3_STABL ...

10. pgsql-server/src bin/scripts/Makefile interfac ...

11. pgsql-server/doc/src/sgml/ref clusterdb.sgml

12. pgsql/src/bin/scripts (

13. pgsql/src/bin/scripts (createdb createuser dropdb droplang dropuser vacuumdb)