regression.diffs
application/octet-stream
Filename: regression.diffs
Type: application/octet-stream
Part: 0
Message:
Re: Review: Extensions Patch
*** /Users/david/dev/postgresql/src/test/regress/expected/tablespace.out 2010-12-03 11:51:54.000000000 -0800
--- /Users/david/dev/postgresql/src/test/regress/results/tablespace.out 2010-12-03 11:51:57.000000000 -0800
***************
*** 1,58 ****
-- create a tablespace we can use
CREATE TABLESPACE testspace LOCATION '/Users/david/dev/postgresql/src/test/regress/testtablespace';
-- try setting and resetting some properties for the new tablespace
ALTER TABLESPACE testspace SET (random_page_cost = 1.0);
ALTER TABLESPACE testspace SET (some_nonexistent_parameter = true); -- fail
! ERROR: unrecognized parameter "some_nonexistent_parameter"
ALTER TABLESPACE testspace RESET (random_page_cost = 2.0); -- fail
! ERROR: RESET must not include values for parameters
ALTER TABLESPACE testspace RESET (random_page_cost, seq_page_cost); -- ok
-- create a schema we can use
CREATE SCHEMA testschema;
-- try a table
CREATE TABLE testschema.foo (i int) TABLESPACE testspace;
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'foo';
! relname | spcname
! ---------+-----------
! foo | testspace
! (1 row)
INSERT INTO testschema.foo VALUES(1);
INSERT INTO testschema.foo VALUES(2);
-- tables from dynamic sources
CREATE TABLE testschema.asselect TABLESPACE testspace AS SELECT 1;
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'asselect';
! relname | spcname
! ----------+-----------
! asselect | testspace
! (1 row)
PREPARE selectsource(int) AS SELECT $1;
CREATE TABLE testschema.asexecute TABLESPACE testspace
AS EXECUTE selectsource(2);
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'asexecute';
! relname | spcname
! -----------+-----------
! asexecute | testspace
! (1 row)
-- index
CREATE INDEX foo_idx on testschema.foo(i) TABLESPACE testspace;
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'foo_idx';
! relname | spcname
! ---------+-----------
! foo_idx | testspace
! (1 row)
-- let's try moving a table from one place to another
CREATE TABLE testschema.atable AS VALUES (1), (2);
CREATE UNIQUE INDEX anindex ON testschema.atable(column1);
ALTER TABLE testschema.atable SET TABLESPACE testspace;
ALTER INDEX testschema.anindex SET TABLESPACE testspace;
INSERT INTO testschema.atable VALUES(3); -- ok
INSERT INTO testschema.atable VALUES(1); -- fail (checks index)
ERROR: duplicate key value violates unique constraint "anindex"
--- 1,69 ----
-- create a tablespace we can use
CREATE TABLESPACE testspace LOCATION '/Users/david/dev/postgresql/src/test/regress/testtablespace';
+ ERROR: could not set permissions on directory "/Users/david/dev/postgresql/src/test/regress/testtablespace": Operation not permitted
-- try setting and resetting some properties for the new tablespace
ALTER TABLESPACE testspace SET (random_page_cost = 1.0);
+ ERROR: tablespace "testspace" does not exist
ALTER TABLESPACE testspace SET (some_nonexistent_parameter = true); -- fail
! ERROR: tablespace "testspace" does not exist
ALTER TABLESPACE testspace RESET (random_page_cost = 2.0); -- fail
! ERROR: tablespace "testspace" does not exist
ALTER TABLESPACE testspace RESET (random_page_cost, seq_page_cost); -- ok
+ ERROR: tablespace "testspace" does not exist
-- create a schema we can use
CREATE SCHEMA testschema;
-- try a table
CREATE TABLE testschema.foo (i int) TABLESPACE testspace;
+ ERROR: tablespace "testspace" does not exist
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'foo';
! relname | spcname
! ---------+---------
! (0 rows)
INSERT INTO testschema.foo VALUES(1);
+ ERROR: relation "testschema.foo" does not exist
+ LINE 1: INSERT INTO testschema.foo VALUES(1);
+ ^
INSERT INTO testschema.foo VALUES(2);
+ ERROR: relation "testschema.foo" does not exist
+ LINE 1: INSERT INTO testschema.foo VALUES(2);
+ ^
-- tables from dynamic sources
CREATE TABLE testschema.asselect TABLESPACE testspace AS SELECT 1;
+ ERROR: tablespace "testspace" does not exist
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'asselect';
! relname | spcname
! ---------+---------
! (0 rows)
PREPARE selectsource(int) AS SELECT $1;
CREATE TABLE testschema.asexecute TABLESPACE testspace
AS EXECUTE selectsource(2);
+ ERROR: tablespace "testspace" does not exist
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'asexecute';
! relname | spcname
! ---------+---------
! (0 rows)
-- index
CREATE INDEX foo_idx on testschema.foo(i) TABLESPACE testspace;
+ ERROR: relation "testschema.foo" does not exist
SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
where c.reltablespace = t.oid AND c.relname = 'foo_idx';
! relname | spcname
! ---------+---------
! (0 rows)
-- let's try moving a table from one place to another
CREATE TABLE testschema.atable AS VALUES (1), (2);
CREATE UNIQUE INDEX anindex ON testschema.atable(column1);
ALTER TABLE testschema.atable SET TABLESPACE testspace;
+ ERROR: tablespace "testspace" does not exist
ALTER INDEX testschema.anindex SET TABLESPACE testspace;
+ ERROR: tablespace "testspace" does not exist
INSERT INTO testschema.atable VALUES(3); -- ok
INSERT INTO testschema.atable VALUES(1); -- fail (checks index)
ERROR: duplicate key value violates unique constraint "anindex"
***************
*** 71,82 ****
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 4 other objects
! DETAIL: drop cascades to table testschema.foo
! drop cascades to table testschema.asselect
! drop cascades to table testschema.asexecute
! drop cascades to table testschema.atable
-- Should succeed
DROP TABLESPACE testspace;
--- 82,90 ----
ERROR: tablespace "nosuchspace" does not exist
-- Fail, not empty
DROP TABLESPACE testspace;
! ERROR: tablespace "testspace" does not exist
DROP SCHEMA testschema CASCADE;
! NOTICE: drop cascades to table testschema.atable
-- Should succeed
DROP TABLESPACE testspace;
+ ERROR: tablespace "testspace" does not exist
======================================================================
*** /Users/david/dev/postgresql/src/test/regress/expected/copy.out 2010-12-03 11:51:54.000000000 -0800
--- /Users/david/dev/postgresql/src/test/regress/results/copy.out 2010-12-03 11:52:20.000000000 -0800
***************
*** 7,12 ****
--- 7,13 ----
COPY aggtest FROM '/Users/david/dev/postgresql/src/test/regress/data/agg.data';
COPY onek FROM '/Users/david/dev/postgresql/src/test/regress/data/onek.data';
COPY onek TO '/Users/david/dev/postgresql/src/test/regress/results/onek.data';
+ ERROR: could not open file "/Users/david/dev/postgresql/src/test/regress/results/onek.data" for writing: Permission denied
DELETE FROM onek;
COPY onek FROM '/Users/david/dev/postgresql/src/test/regress/results/onek.data';
COPY tenk1 FROM '/Users/david/dev/postgresql/src/test/regress/data/tenk.data';
***************
*** 45,60 ****
insert into copytest values('Mac',E'abc\rdef',3);
insert into copytest values(E'esc\\ape',E'a\\r\\\r\\\n\\nb',4);
copy copytest to '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv;
create temp table copytest2 (like copytest);
copy copytest2 from '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv;
select * from copytest except select * from copytest2;
! style | test | filler
! -------+------+--------
! (0 rows)
truncate copytest2;
--- same test but with an escape char different from quote char
copy copytest to '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv quote '''' escape E'\\';
copy copytest2 from '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv quote '''' escape E'\\';
select * from copytest except select * from copytest2;
style | test | filler
--- 46,72 ----
insert into copytest values('Mac',E'abc\rdef',3);
insert into copytest values(E'esc\\ape',E'a\\r\\\r\\\n\\nb',4);
copy copytest to '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv;
+ ERROR: could not open file "/Users/david/dev/postgresql/src/test/regress/results/copytest.csv" for writing: Permission denied
create temp table copytest2 (like copytest);
copy copytest2 from '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv;
+ ERROR: missing data for column "filler"
+ CONTEXT: COPY copytest2, line 1: "DOS,'abc"
select * from copytest except select * from copytest2;
! style | test | filler
! ---------+----------+--------
! DOS | abc\r +| 1
! | def |
! Mac | abc\rdef | 3
! esc\ape | a\r\\r\ +| 4
! | \nb |
! Unix | abc +| 2
! | def |
! (4 rows)
truncate copytest2;
--- same test but with an escape char different from quote char
copy copytest to '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv quote '''' escape E'\\';
+ ERROR: could not open file "/Users/david/dev/postgresql/src/test/regress/results/copytest.csv" for writing: Permission denied
copy copytest2 from '/Users/david/dev/postgresql/src/test/regress/results/copytest.csv' csv quote '''' escape E'\\';
select * from copytest except select * from copytest2;
style | test | filler
======================================================================
*** /Users/david/dev/postgresql/src/test/regress/expected/misc.out 2010-12-03 11:51:54.000000000 -0800
--- /Users/david/dev/postgresql/src/test/regress/results/misc.out 2010-12-03 11:53:06.000000000 -0800
***************
*** 42,47 ****
--- 42,48 ----
-- copy
--
COPY onek TO '/Users/david/dev/postgresql/src/test/regress/results/onek.data';
+ ERROR: could not open file "/Users/david/dev/postgresql/src/test/regress/results/onek.data" for writing: Permission denied
DELETE FROM onek;
COPY onek FROM '/Users/david/dev/postgresql/src/test/regress/results/onek.data';
SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1;
***************
*** 61,66 ****
--- 62,68 ----
(2 rows)
COPY BINARY stud_emp TO '/Users/david/dev/postgresql/src/test/regress/results/stud_emp.data';
+ ERROR: could not open file "/Users/david/dev/postgresql/src/test/regress/results/stud_emp.data" for writing: Permission denied
DELETE FROM stud_emp;
COPY BINARY stud_emp FROM '/Users/david/dev/postgresql/src/test/regress/results/stud_emp.data';
SELECT * FROM stud_emp;
======================================================================
*** /Users/david/dev/postgresql/src/test/regress/expected/largeobject.out 2010-12-03 11:51:54.000000000 -0800
--- /Users/david/dev/postgresql/src/test/regress/results/largeobject.out 2010-12-03 11:53:52.000000000 -0800
***************
*** 257,267 ****
END;
SELECT lo_export(loid, '/Users/david/dev/postgresql/src/test/regress/results/lotest.txt') FROM lotest_stash_values;
! lo_export
! -----------
! 1
! (1 row)
!
\lo_import 'results/lotest.txt'
\set newloid :LASTOID
-- just make sure \lo_export does not barf
--- 257,263 ----
END;
SELECT lo_export(loid, '/Users/david/dev/postgresql/src/test/regress/results/lotest.txt') FROM lotest_stash_values;
! ERROR: could not create server file "/Users/david/dev/postgresql/src/test/regress/results/lotest.txt": Permission denied
\lo_import 'results/lotest.txt'
\set newloid :LASTOID
-- just make sure \lo_export does not barf
======================================================================