Re: open item: tablespace handing in pg_dump/pg_restore

On Mon, 4 Oct 2004, Reini Urban wrote:

> But the regression test fails: (the only failing test against cvs HEAD)
> This is not only a pg_dump/pg_restore issue, or?
>
> -- Will fail with bad path
> CREATE TABLESPACE badspace LOCATION '/no/such/location';
> ERROR:  could not set permissions on directory "/no/such/location": No
> such file or directory
> -- No such tablespace
> CREATE TABLE bar (i int) TABLESPACE nosuchspace;
> ERROR:  tablespace "nosuchspace" does not exist
> -- Fail, not empty
> DROP TABLESPACE testspace;
> ERROR:  tablespace "testspace" is not empty
> DROP SCHEMA testschema CASCADE;
> NOTICE:  drop cascades to table testschema.foo
> -- Should succeed
> DROP TABLESPACE testspace;
>
> =>
>
> ***************
> *** 38,45 ****
>    ERROR:  tablespace "nosuchspace" does not exist
>    -- Fail, not empty
>    DROP TABLESPACE testspace;
> ! ERROR:  tablespace "testspace" is not empty
>    DROP SCHEMA testschema CASCADE;
> ! NOTICE:  drop cascades to table testschema.foo
>    -- Should succeed
>    DROP TABLESPACE testspace;
> --- 41,49 ----
>    ERROR:  tablespace "nosuchspace" does not exist
>    -- Fail, not empty
>    DROP TABLESPACE testspace;
> ! ERROR:  tablespace "testspace" does not exist
>    DROP SCHEMA testschema CASCADE;
> ! ERROR:  schema "testschema" does not exist
>    -- Should succeed
>    DROP TABLESPACE testspace;
> + ERROR:  tablespace "testspace" does not exist

I cannot recreate on Linux. What platform, etc, are you on?

Gavin