On Mon, 28 Jun 2004, Tom Lane wrote: > I don't see any reasonable way for CREATE DATABASE to avoid this > problem, since it can't necessarily look inside the source database. > My thought is that the cleanest fix is to never allow reltablespace > (or nsptablespace) to explicitly specify the database's default > tablespace; that is, if you write > CREATE TABLE ... TABLESPACE x > and "x" is the database-level default, we should silently store zero > instead of x's OID into reltablespace. The table would get created > in the same place either way, but the implications for future cloning > or dump/reload of the database would be different. The table would go > to the new database default tablespace, whatever that is, instead of > staying in "x". > > Thoughts?
I don't see any other way around it than this (other than looking at the template database's data, but that wont happen for 7.5). Thanks, Gavin ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org