From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
---|---|
To: | Reini Urban <rurban(at)x-ray(dot)at> |
Cc: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: open item: tablespace handing in pg_dump/pg_restore |
Date: | 2004-10-04 12:20:53 |
Message-ID: | Pine.LNX.4.58.0410042220060.13117@linuxworld.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Reini Urban | 2004-10-04 12:42:49 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Reini Urban | 2004-10-04 11:17:29 | Re: open item: tablespace handing in pg_dump/pg_restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Reini Urban | 2004-10-04 12:42:49 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Reini Urban | 2004-10-04 11:17:29 | Re: open item: tablespace handing in pg_dump/pg_restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Reini Urban | 2004-10-04 12:42:49 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Harald Armin Massa | 2004-10-04 11:33:38 | Re: output file name - was pg_restore / psql |