Re: [PATCHES] Proposed patch for bug #3921

2008-02-03 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: An issue that this patch doesn't address is what happens if the source index is in a non-default tablespace that the current user does not have CREATE permission for. With both current CVS HEAD and this patch, that will result in an error. Is that okay?

Re: [PATCHES] Proposed patch for bug #3921

2008-02-03 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: So the syntax would be CREATE TABLE foo (..., LIKE bar INCLUDING INDEXES USING INDEX TABLESPACE foo_ts, ...) This (presumably) forces all the indexes into the same tablespace, so I don't find it to be a complete solution, just a wart. We could get the

[PATCHES] Proposed patch for bug #3921

2008-02-02 Thread Tom Lane
Attached is a proposed patch for bug #3921, which complained that CREATE TABLE LIKE INCLUDING INDEXES fails inappropriately for non-superusers. There are two parts to the patch: the first follows Greg Starks' opinion that explicitly specifying the current database's default tablespace shouldn't