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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
