Here is an updated version of the "Copy storage parameters" patch. http://archives.postgresql.org/pgsql-hackers/2008-07/msg01417.php
This patch copies only column storage parameters and does not copy reloptions as a result of the discussion, in which reloptions should not be copied because LIKE and INHERITS are not table definitions, but column definitions. Copying reloptions (or copying just table's definition) might be useful in some cases, but it should be done by another independent patch. Inheriting column storage parameters is useful if we duplicate an existing table. CREATE TABLE AS is useful to avoid WALs in that time: CREATE TABLE (LIKE target) WITH (<same as the target table>) AS SELECT * FROM target; However, we cannot execute ALTER COLUMN SET STORAGE after creating the new table and before inserting, because there are no time to execute commands between them. So we need some methods to set column storage parameters at creating a table. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
inherits-column-params.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers