*** ./expected/timestamp.out Thu Sep 25 09:58:06 2003 --- ./results/timestamp.out Sun Feb 22 00:25:55 2004 *************** *** 64,70 **** -- Postgres v6.0 standard output format INSERT INTO TIMESTAMP_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST'); INSERT INTO TIMESTAMP_TBL VALUES ('Invalid Abstime'); ! ERROR: date/time value "Invalid Abstime" is no longer supported INSERT INTO TIMESTAMP_TBL VALUES ('Undefined Abstime'); ERROR: date/time value "Undefined Abstime" is no longer supported -- Variations on Postgres v6.1 standard output format --- 64,70 ---- -- Postgres v6.0 standard output format INSERT INTO TIMESTAMP_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST'); INSERT INTO TIMESTAMP_TBL VALUES ('Invalid Abstime'); ! ERROR: invalid input syntax for type timestamp: "Invalid Abstime" INSERT INTO TIMESTAMP_TBL VALUES ('Undefined Abstime'); ERROR: date/time value "Undefined Abstime" is no longer supported -- Variations on Postgres v6.1 standard output format *************** *** 730,736 **** | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRIDAY Friday friday FRI Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | SUNDAY Sunday sunday SUN Sun sun FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb --- 730,736 ---- | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRĘDAY Friday friday FRĘ Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | SUNDAY Sunday sunday SUN Sun sun FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb *************** *** 744,758 **** | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRIDAY Friday friday FRI Fri fri MARCH March march III MAR Mar mar | MONDAY Monday monday MON Mon mon DECEMBER December december XII DEC Dec dec | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed JANUARY January january I JAN Jan jan ! | FRIDAY Friday friday FRI Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat MARCH March march III MAR Mar mar | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed DECEMBER December december XII DEC Dec dec ! | FRIDAY Friday friday FRI Fri fri DECEMBER December december XII DEC Dec dec | SATURDAY Saturday saturday SAT Sat sat JANUARY January january I JAN Jan jan | SUNDAY Sunday sunday SUN Sun sun DECEMBER December december XII DEC Dec dec | MONDAY Monday monday MON Mon mon JANUARY January january I JAN Jan jan --- 744,758 ---- | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRĘDAY Friday friday FRĘ Fri fri MARCH March march III MAR Mar mar | MONDAY Monday monday MON Mon mon DECEMBER December december XII DEC Dec dec | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed JANUARY January january I JAN Jan jan ! | FRĘDAY Friday friday FRĘ Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat MARCH March march III MAR Mar mar | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed DECEMBER December december XII DEC Dec dec ! | FRĘDAY Friday friday FRĘ Fri fri DECEMBER December december XII DEC Dec dec | SATURDAY Saturday saturday SAT Sat sat JANUARY January january I JAN Jan jan | SUNDAY Sunday sunday SUN Sun sun DECEMBER December december XII DEC Dec dec | MONDAY Monday monday MON Mon mon JANUARY January january I JAN Jan jan *************** *** 800,806 **** | TUESDAY Tuesday tuesday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRIDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday FEBRUARY February february II | SUNDAY Sunday sunday FEBRUARY February february II | TUESDAY Tuesday tuesday FEBRUARY February february II --- 800,806 ---- | TUESDAY Tuesday tuesday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRĘDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday FEBRUARY February february II | SUNDAY Sunday sunday FEBRUARY February february II | TUESDAY Tuesday tuesday FEBRUARY February february II *************** *** 814,828 **** | SATURDAY Saturday saturday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRIDAY Friday friday MARCH March march III | MONDAY Monday monday DECEMBER December december XII | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday JANUARY January january I ! | FRIDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday MARCH March march III | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday DECEMBER December december XII ! | FRIDAY Friday friday DECEMBER December december XII | SATURDAY Saturday saturday JANUARY January january I | SUNDAY Sunday sunday DECEMBER December december XII | MONDAY Monday monday JANUARY January january I --- 814,828 ---- | SATURDAY Saturday saturday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRĘDAY Friday friday MARCH March march III | MONDAY Monday monday DECEMBER December december XII | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday JANUARY January january I ! | FRĘDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday MARCH March march III | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday DECEMBER December december XII ! | FRĘDAY Friday friday DECEMBER December december XII | SATURDAY Saturday saturday JANUARY January january I | SUNDAY Sunday sunday DECEMBER December december XII | MONDAY Monday monday JANUARY January january I ====================================================================== *** ./expected/timestamptz.out Thu Sep 25 09:58:06 2003 --- ./results/timestamptz.out Sun Feb 22 00:25:55 2004 *************** *** 59,65 **** -- Postgres v6.0 standard output format INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Invalid Abstime'); ! ERROR: date/time value "Invalid Abstime" is no longer supported INSERT INTO TIMESTAMPTZ_TBL VALUES ('Undefined Abstime'); ERROR: date/time value "Undefined Abstime" is no longer supported -- Variations on Postgres v6.1 standard output format --- 59,65 ---- -- Postgres v6.0 standard output format INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Invalid Abstime'); ! ERROR: invalid input syntax for type timestamp with time zone: "Invalid Abstime" INSERT INTO TIMESTAMPTZ_TBL VALUES ('Undefined Abstime'); ERROR: date/time value "Undefined Abstime" is no longer supported -- Variations on Postgres v6.1 standard output format *************** *** 724,730 **** | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRIDAY Friday friday FRI Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | SUNDAY Sunday sunday SUN Sun sun FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb --- 724,730 ---- | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRĘDAY Friday friday FRĘ Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | SUNDAY Sunday sunday SUN Sun sun FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb *************** *** 738,752 **** | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRIDAY Friday friday FRI Fri fri MARCH March march III MAR Mar mar | MONDAY Monday monday MON Mon mon DECEMBER December december XII DEC Dec dec | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed JANUARY January january I JAN Jan jan ! | FRIDAY Friday friday FRI Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat MARCH March march III MAR Mar mar | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed DECEMBER December december XII DEC Dec dec ! | FRIDAY Friday friday FRI Fri fri DECEMBER December december XII DEC Dec dec | SATURDAY Saturday saturday SAT Sat sat JANUARY January january I JAN Jan jan | SUNDAY Sunday sunday SUN Sun sun DECEMBER December december XII DEC Dec dec | MONDAY Monday monday MON Mon mon JANUARY January january I JAN Jan jan --- 738,752 ---- | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb ! | FRĘDAY Friday friday FRĘ Fri fri MARCH March march III MAR Mar mar | MONDAY Monday monday MON Mon mon DECEMBER December december XII DEC Dec dec | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed JANUARY January january I JAN Jan jan ! | FRĘDAY Friday friday FRĘ Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat MARCH March march III MAR Mar mar | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed DECEMBER December december XII DEC Dec dec ! | FRĘDAY Friday friday FRĘ Fri fri DECEMBER December december XII DEC Dec dec | SATURDAY Saturday saturday SAT Sat sat JANUARY January january I JAN Jan jan | SUNDAY Sunday sunday SUN Sun sun DECEMBER December december XII DEC Dec dec | MONDAY Monday monday MON Mon mon JANUARY January january I JAN Jan jan *************** *** 795,801 **** | TUESDAY Tuesday tuesday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRIDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday FEBRUARY February february II | SUNDAY Sunday sunday FEBRUARY February february II | TUESDAY Tuesday tuesday FEBRUARY February february II --- 795,801 ---- | TUESDAY Tuesday tuesday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRĘDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday FEBRUARY February february II | SUNDAY Sunday sunday FEBRUARY February february II | TUESDAY Tuesday tuesday FEBRUARY February february II *************** *** 809,823 **** | SATURDAY Saturday saturday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRIDAY Friday friday MARCH March march III | MONDAY Monday monday DECEMBER December december XII | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday JANUARY January january I ! | FRIDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday MARCH March march III | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday DECEMBER December december XII ! | FRIDAY Friday friday DECEMBER December december XII | SATURDAY Saturday saturday JANUARY January january I | SUNDAY Sunday sunday DECEMBER December december XII | MONDAY Monday monday JANUARY January january I --- 809,823 ---- | SATURDAY Saturday saturday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II | THURSDAY Thursday thursday FEBRUARY February february II ! | FRĘDAY Friday friday MARCH March march III | MONDAY Monday monday DECEMBER December december XII | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday JANUARY January january I ! | FRĘDAY Friday friday FEBRUARY February february II | SATURDAY Saturday saturday MARCH March march III | TUESDAY Tuesday tuesday DECEMBER December december XII | WEDNESDAY Wednesday wednesday DECEMBER December december XII ! | FRĘDAY Friday friday DECEMBER December december XII | SATURDAY Saturday saturday JANUARY January january I | SUNDAY Sunday sunday DECEMBER December december XII | MONDAY Monday monday JANUARY January january I ====================================================================== *** ./expected/privileges.out Mon Sep 15 03:26:31 2003 --- ./results/privileges.out Sun Feb 22 00:26:07 2004 *************** *** 299,309 **** (1 row) select has_table_privilege(current_user,'pg_shadow','insert'); ! has_table_privilege ! --------------------- ! t ! (1 row) ! select has_table_privilege(t2.usesysid,'pg_shadow','update') from (select usesysid from pg_user where usename = current_user) as t2; has_table_privilege --- 299,305 ---- (1 row) select has_table_privilege(current_user,'pg_shadow','insert'); ! ERROR: unrecognized privilege type: "insert" select has_table_privilege(t2.usesysid,'pg_shadow','update') from (select usesysid from pg_user where usename = current_user) as t2; has_table_privilege *************** *** 343,353 **** select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1, (select usesysid from pg_user where usename = current_user) as t2; ! has_table_privilege ! --------------------- ! t ! (1 row) ! select has_table_privilege('pg_shadow','update'); has_table_privilege --------------------- --- 339,345 ---- select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1, (select usesysid from pg_user where usename = current_user) as t2; ! ERROR: unrecognized privilege type: "insert" select has_table_privilege('pg_shadow','update'); has_table_privilege --------------------- *************** *** 369,379 **** select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1; ! has_table_privilege ! --------------------- ! t ! (1 row) ! -- non-superuser SET SESSION AUTHORIZATION regressuser3; select has_table_privilege(current_user,'pg_class','select'); --- 361,367 ---- select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1; ! ERROR: unrecognized privilege type: "trigger" -- non-superuser SET SESSION AUTHORIZATION regressuser3; select has_table_privilege(current_user,'pg_class','select'); *************** *** 383,393 **** (1 row) select has_table_privilege(current_user,'pg_class','insert'); ! has_table_privilege ! --------------------- ! f ! (1 row) ! select has_table_privilege(t2.usesysid,'pg_class','update') from (select usesysid from pg_user where usename = current_user) as t2; has_table_privilege --- 371,377 ---- (1 row) select has_table_privilege(current_user,'pg_class','insert'); ! ERROR: unrecognized privilege type: "insert" select has_table_privilege(t2.usesysid,'pg_class','update') from (select usesysid from pg_user where usename = current_user) as t2; has_table_privilege *************** *** 427,437 **** select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1, (select usesysid from pg_user where usename = current_user) as t2; ! has_table_privilege ! --------------------- ! f ! (1 row) ! select has_table_privilege('pg_class','update'); has_table_privilege --------------------- --- 411,417 ---- select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1, (select usesysid from pg_user where usename = current_user) as t2; ! ERROR: unrecognized privilege type: "insert" select has_table_privilege('pg_class','update'); has_table_privilege --------------------- *************** *** 453,463 **** select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1; ! has_table_privilege ! --------------------- ! f ! (1 row) ! select has_table_privilege(current_user,'atest1','select'); has_table_privilege --------------------- --- 433,439 ---- select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1; ! ERROR: unrecognized privilege type: "trigger" select has_table_privilege(current_user,'atest1','select'); has_table_privilege --------------------- *************** *** 465,475 **** (1 row) select has_table_privilege(current_user,'atest1','insert'); ! has_table_privilege ! --------------------- ! f ! (1 row) ! select has_table_privilege(t2.usesysid,'atest1','update') from (select usesysid from pg_user where usename = current_user) as t2; has_table_privilege --- 441,447 ---- (1 row) select has_table_privilege(current_user,'atest1','insert'); ! ERROR: unrecognized privilege type: "insert" select has_table_privilege(t2.usesysid,'atest1','update') from (select usesysid from pg_user where usename = current_user) as t2; has_table_privilege *************** *** 509,519 **** select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'atest1') as t1, (select usesysid from pg_user where usename = current_user) as t2; ! has_table_privilege ! --------------------- ! f ! (1 row) ! select has_table_privilege('atest1','update'); has_table_privilege --------------------- --- 481,487 ---- select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'atest1') as t1, (select usesysid from pg_user where usename = current_user) as t2; ! ERROR: unrecognized privilege type: "insert" select has_table_privilege('atest1','update'); has_table_privilege --------------------- *************** *** 535,545 **** select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'atest1') as t1; ! has_table_privilege ! --------------------- ! f ! (1 row) ! -- Grant options SET SESSION AUTHORIZATION regressuser1; CREATE TABLE atest4 (a int); --- 503,509 ---- select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'atest1') as t1; ! ERROR: unrecognized privilege type: "trigger" -- Grant options SET SESSION AUTHORIZATION regressuser1; CREATE TABLE atest4 (a int); ======================================================================