Discussion:
pgsql-server: Fix unintended assignment of sequences to the containing
(too old to reply)
Tom Lane
2004-08-31 17:10:38 UTC
Permalink
Log Message:
-----------
Fix unintended assignment of sequences to the containing schema's
default tablespace --- they should always go in the database's default
tablespace. Adjust heap_create() API so that it is passed the relkind
to make this easier; should simplify any further tweaking of the same
sort.

Modified Files:
--------------
pgsql-server/src/backend/bootstrap:
bootparse.y (r1.72 -> r1.73)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/bootstrap/bootparse.y.diff?r1=1.72&r2=1.73)
pgsql-server/src/backend/catalog:
heap.c (r1.275 -> r1.276)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/catalog/heap.c.diff?r1=1.275&r2=1.276)
index.c (r1.238 -> r1.239)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/catalog/index.c.diff?r1=1.238&r2=1.239)
pgsql-server/src/include/catalog:
heap.h (r1.70 -> r1.71)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/heap.h.diff?r1=1.70&r2=1.71)

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Fabien COELHO
2004-09-01 06:52:15 UTC
Permalink
Dear Tom,
Post by Tom Lane
Fix unintended assignment of sequences to the containing schema's
default tablespace
You might consider fixing the "CREATE SCHEMA" documentation as well.

Thanks, have a nice day,
--
Fabien Coelho - ***@cri.ensmp.fr

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Tom Lane
2004-09-01 14:09:51 UTC
Permalink
Post by Fabien COELHO
You might consider fixing the "CREATE SCHEMA" documentation as well.
Good catch --- thanks!

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Loading...