--- ./expected/opr_sanity.out Mon Jul 14 21:55:49 2008 +++ ./results/opr_sanity.out Tue Jul 15 11:03:04 2008 @@ -87,8 +87,10 @@ p1.provolatile != p2.provolatile OR p1.pronargs != p2.pronargs); oid | proname | oid | proname ------+---------+-----+--------- -(0 rows) +------+----------+-------+------------ + 2414 | textrecv | 16478 | citextrecv + 2415 | textsend | 16479 | citextsend +(2 rows) -- Look for uses of different type OIDs in the argument/result type fields -- for different aliases of the same built-in function. @@ -110,8 +112,9 @@ prorettype | prorettype ------------+------------ 25 | 1043 + 25 | 16475 1114 | 1184 -(2 rows) +(3 rows) SELECT DISTINCT p1.proargtypes[0], p2.proargtypes[0] FROM pg_proc AS p1, pg_proc AS p2 @@ -124,10 +127,12 @@ -------------+------------- 25 | 1042 25 | 1043 + 25 | 16475 + 1042 | 16475 1114 | 1184 1560 | 1562 2277 | 2283 -(5 rows) +(7 rows) SELECT DISTINCT p1.proargtypes[1], p2.proargtypes[1] FROM pg_proc AS p1, pg_proc AS p2 @@ -139,10 +144,11 @@ proargtypes | proargtypes -------------+------------- 23 | 28 + 25 | 16475 1114 | 1184 1560 | 1562 2277 | 2283 -(4 rows) +(5 rows) SELECT DISTINCT p1.proargtypes[2], p2.proargtypes[2] FROM pg_proc AS p1, pg_proc AS p2 @@ -305,7 +311,8 @@ 142 | 25 | 0 | a 142 | 1043 | 0 | a 142 | 1042 | 0 | a -(6 rows) + 16475 | 1042 | 0 | a +(7 rows) -- **************** pg_operator **************** -- Look for illegal values in pg_operator fields. ====================================================================== --- ./expected/copy.out Tue Jul 15 11:03:00 2008 +++ ./results/copy.out Tue Jul 15 11:03:06 2008 @@ -7,6 +7,7 @@ COPY aggtest FROM '/Users/david/dev/pgsql.citext/src/test/regress/data/agg.data'; COPY onek FROM '/Users/david/dev/pgsql.citext/src/test/regress/data/onek.data'; COPY onek TO '/Users/david/dev/pgsql.citext/src/test/regress/results/onek.data'; +ERROR: could not open file "/Users/david/dev/pgsql.citext/src/test/regress/results/onek.data" for writing: Permission denied DELETE FROM onek; COPY onek FROM '/Users/david/dev/pgsql.citext/src/test/regress/results/onek.data'; COPY tenk1 FROM '/Users/david/dev/pgsql.citext/src/test/regress/data/tenk.data'; @@ -45,16 +46,27 @@ 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/pgsql.citext/src/test/regress/results/copytest.csv' csv; +ERROR: could not open file "/Users/david/dev/pgsql.citext/src/test/regress/results/copytest.csv" for writing: Permission denied create temp table copytest2 (like copytest); copy copytest2 from '/Users/david/dev/pgsql.citext/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 --------+------+-------- -(0 rows) +---------+----------+-------- + DOS | abc\r | 1 + : def + Mac | abc\rdef | 3 + Unix | abc | 2 + : def + esc\ape | a\r\\r\ | 4 + : \nb +(4 rows) truncate copytest2; --- same test but with an escape char different from quote char copy copytest to '/Users/david/dev/pgsql.citext/src/test/regress/results/copytest.csv' csv quote '''' escape E'\\'; +ERROR: could not open file "/Users/david/dev/pgsql.citext/src/test/regress/results/copytest.csv" for writing: Permission denied copy copytest2 from '/Users/david/dev/pgsql.citext/src/test/regress/results/copytest.csv' csv quote '''' escape E'\\'; select * from copytest except select * from copytest2; style | test | filler ====================================================================== --- ./expected/misc.out Tue Jul 15 11:03:00 2008 +++ ./results/misc.out Tue Jul 15 11:03:15 2008 @@ -42,6 +42,7 @@ -- copy -- COPY onek TO '/Users/david/dev/pgsql.citext/src/test/regress/results/onek.data'; +ERROR: could not open file "/Users/david/dev/pgsql.citext/src/test/regress/results/onek.data" for writing: Permission denied DELETE FROM onek; COPY onek FROM '/Users/david/dev/pgsql.citext/src/test/regress/results/onek.data'; SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1; @@ -61,6 +62,7 @@ (2 rows) COPY BINARY stud_emp TO '/Users/david/dev/pgsql.citext/src/test/regress/results/stud_emp.data'; +ERROR: could not open file "/Users/david/dev/pgsql.citext/src/test/regress/results/stud_emp.data" for writing: Permission denied DELETE FROM stud_emp; COPY BINARY stud_emp FROM '/Users/david/dev/pgsql.citext/src/test/regress/results/stud_emp.data'; SELECT * FROM stud_emp; ====================================================================== --- ./expected/largeobject.out Tue Jul 15 11:03:00 2008 +++ ./results/largeobject.out Tue Jul 15 11:03:25 2008 @@ -246,11 +246,7 @@ END; SELECT lo_export(loid, '/Users/david/dev/pgsql.citext/src/test/regress/results/lotest.txt') FROM lotest_stash_values; - lo_export ------------ - 1 -(1 row) - +ERROR: could not create server file "/Users/david/dev/pgsql.citext/src/test/regress/results/lotest.txt": Permission denied \lo_import 'results/lotest.txt' \set newloid :LASTOID -- just make sure \lo_export does not barf ====================================================================== --- ./expected/tablespace.out Tue Jul 15 11:03:00 2008 +++ ./results/tablespace.out Tue Jul 15 11:03:29 2008 @@ -1,51 +1,56 @@ -- create a tablespace we can use CREATE TABLESPACE testspace LOCATION '/Users/david/dev/pgsql.citext/src/test/regress/testtablespace'; +ERROR: could not set permissions on directory "/Users/david/dev/pgsql.citext/src/test/regress/testtablespace": Operation not permitted -- 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 ----------+----------- - foo | testspace -(1 row) +---------+--------- +(0 rows) INSERT INTO testschema.foo VALUES(1); +ERROR: relation "testschema.foo" does not exist INSERT INTO testschema.foo VALUES(2); +ERROR: relation "testschema.foo" does not exist -- 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 -----------+----------- - asselect | testspace -(1 row) +---------+--------- +(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 ------------+----------- - asexecute | testspace -(1 row) +---------+--------- +(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 ----------+----------- - foo_idx | testspace -(1 row) +---------+--------- +(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" @@ -63,12 +68,9 @@ ERROR: tablespace "nosuchspace" does not exist -- Fail, not empty DROP TABLESPACE testspace; -ERROR: tablespace "testspace" is not empty +ERROR: tablespace "testspace" does not exist 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 +NOTICE: drop cascades to table testschema.atable -- Should succeed DROP TABLESPACE testspace; +ERROR: tablespace "testspace" does not exist ======================================================================