On 2004.11.16 16:25 Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes: > I deleted the 'public' schema from my databases > in 7.3, now in 7.4 they are back.
IMHO this is not a bug. It is not pg_dump's charter to remove system-created objects...
I can live with this, but I find the implication distasteful -- that there is no way to move a database from one cluster to another and have an exact copy. Not even when both clusters are running the same release.
I don't care that much about the behavior, it's easy enough to delete 'public'. I do think that a note should be made in the administrator manual regards system upgrades where pg_dump(all) scripts are given if this is going to be the behavior.
Thanks for postgresql.
Karl <[EMAIL PROTECTED]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
