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:56:10 |
Message-ID: | Pine.LNX.4.58.0410042255050.13367@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:
> 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
Hmm.. sounds like we're trying to support tablespaces on a system which
doesn't actually support symlinks (in the way we need them). Can any of
the windows guys help?
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Reini Urban | 2004-10-04 13:15:33 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Reini Urban | 2004-10-04 12:42:49 | Re: open item: tablespace handing in pg_dump/pg_restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2004-10-04 13:00:54 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Reini Urban | 2004-10-04 12:42:49 | Re: open item: tablespace handing in pg_dump/pg_restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Reini Urban | 2004-10-04 13:15:33 | Re: open item: tablespace handing in pg_dump/pg_restore |
Previous Message | Oliver D. | 2004-10-04 12:50:59 | Re: Win32 libpq : Static Link ? |