From: | Reini Urban <rurban(at)x-ray(dot)at> |
---|---|
To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
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:42:49 |
Message-ID: | 41614549.4060703@x-ray.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
Gavin Sherry schrieb:
> 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?
hmm, I'll investigate then.
postgresql latest CVS with 2 minor shlib building patches left
(added -lpgport)
cygwin-1.5.11
gcc-3.4.1
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2004-10-04 12:56:10 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Gavin Sherry | 2004-10-04 12:20:53 | Re: open item: tablespace handing in pg_dump/pg_restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2004-10-04 12:56:10 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Gavin Sherry | 2004-10-04 12:20:53 | Re: open item: tablespace handing in pg_dump/pg_restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver D. | 2004-10-04 12:50:59 | Re: Win32 libpq : Static Link ? |
Previous Message | Gavin Sherry | 2004-10-04 12:20:53 | Re: open item: tablespace handing in pg_dump/pg_restore |