"Tom Lane" <[EMAIL PROTECTED]> writes:
> 1. DefineIndex() treats an omitted tablespace clause differently from
> explicitly specifying the tablespace that is the database's default:
> if you explicitly specify the space then you must have permissions on
> it, otherwise you don't need any. (This
"Andrew Gilligan" <[EMAIL PROTECTED]> writes:
> test=> CREATE TABLE t2 (LIKE t1 INCLUDING INDEXES);
> ERROR: permission denied for tablespace pg_default
How annoying :-(. We could work around this particular manifestation
with a patch to make generateClonedIndexStmt() not set index->tableSpa
The following bug has been logged online:
Bug reference: 3921
Logged by: Andrew Gilligan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0
Operating system: FreeBSD 4.11
Description:CREATE TABLE / INCLUDING INDEXES fails with permission
denied
Details:
Hi a