This time I've included the log file...
su-2.02$ cat postmaster.log
DEBUG: database system was shut down at 2002-03-03 19:43:39 EST
DEBUG: checkpoint record is at 0/109664
DEBUG: redo record is at 0/109664; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system is ready
FATAL 1: The database system is starting up
ERROR: DROP GROUP: group "regressgroup1" does not exist
ERROR: oidin: error in "asdfasd": can't parse "asdfasd"
ERROR: oidin: error in "99asdfasd": can't parse "asdfasd"
ERROR: pg_atoi: error in "34.5": can't parse ".5"
ERROR: Bad float4 input format -- overflow
ERROR: Bad float4 input format -- overflow
ERROR: pg_atoi: error reading "100000": Numerical result out of range
ERROR: Bad float4 input format -- underflow
ERROR: pg_atoi: error in "asdf": can't parse "asdf"
ERROR: Bad float4 input format -- underflow
ERROR: float4div: divide by zero error
ERROR: bit string length does not match type bit(11)
ERROR: bit string length does not match type bit(11)
ERROR: pg_atoi: error in "34.5": can't parse ".5"
ERROR: pg_atoi: error reading "1000000000000": Numerical result out of
range
ERROR: pg_atoi: error in "asdf": can't parse "asdf"
ERROR: value too long for type character(1)
ERROR: value too long for type character varying(1)
ERROR: bit string too long for type bit varying(11)
ERROR: Bad boolean external representation 'XXX'
ERROR: Bad float8 input format -- overflow
ERROR: pow() result is out of range
ERROR: can't take log of zero
ERROR: can't take log of a negative number
ERROR: exp() result is out of range
ERROR: float8div: divide by zero error
ERROR: Input '10e400' is out of range for float8
ERROR: Input '-10e400' is out of range for float8
ERROR: value too long for type character varying(4)
ERROR: value too long for type character(4)
ERROR: cannot AND bit strings of different sizes
ERROR: cannot OR bit strings of different sizes
ERROR: cannot XOR bit strings of different sizes
DEBUG: --Relation num_exp_add--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: Analyzing num_exp_add
DEBUG: --Relation num_exp_sub--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: Analyzing num_exp_sub
DEBUG: --Relation num_exp_div--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: Analyzing num_exp_div
DEBUG: --Relation num_exp_mul--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: Analyzing num_exp_mul
DEBUG: --Relation num_exp_sqrt--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Analyzing num_exp_sqrt
DEBUG: --Relation num_exp_ln--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Analyzing num_exp_ln
DEBUG: --Relation num_exp_log10--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Analyzing num_exp_log10
DEBUG: --Relation num_exp_power_10_ln--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Analyzing num_exp_power_10_ln
ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4
scale 4
ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4
scale 4
ERROR: parser: parse error at or near "'"
ERROR: value too long for type character(10)
DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable
DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable
DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable
DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable
DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable
DEBUG: connection startup failed (fork failure): Resource temporarily
unavailable
ERROR: table "inet_tbl" does not exist
ERROR: Bad reltime external representation 'badly formatted reltime'
ERROR: Bad reltime external representation '@ 30 eons ago'
ERROR: Bad abstime external representation 'bad time specifications'
ERROR: Bad abstime external representation ''
ERROR: invalid CIDR value '192.168.1.2/24': has bits set to right of mask
ERROR: invalid CIDR value '192.168.1.2/24': has bits set to right of mask
ERROR: Bad timestamp external representation 'current'
ERROR: Bad box external representation '(2.3, 4.5)'
ERROR: Bad box external representation 'asdfasdf(ad'
ERROR: Bad interval external representation 'badly formatted interval'
ERROR: Bad interval external representation '@ 30 eons ago'
ERROR: Unable to identify an operator '+' for types 'time with time zone'
and 'time with time zone' You will have to retype this query using an explicit cast
ERROR: Bad date external representation '1997-02-29'
ERROR: Bad polygon external representation '0.0'
ERROR: Bad polygon external representation '(0.0 0.0'
ERROR: Bad polygon external representation '(0,1,2)'
ERROR: Bad polygon external representation '(0,1,2,3'
ERROR: Bad polygon external representation 'asdf'
ERROR: Bad path external representation '[(,2),(3,4)]'
ERROR: Bad path external representation '[(1,2),(3,4)'
ERROR: TIMESTAMP WITH TIME ZONE 'invalid' no longer supported
ERROR: Bad timestamp external representation 'Invalid Abstime'
ERROR: Bad circle external representation '<(-100,0),-100>'
ERROR: Bad timestamp external representation 'Undefined Abstime'
ERROR: Bad circle external representation '1abc,3,5'
ERROR: Bad circle external representation '(3,(1,2),3)'
ERROR: Bad timestamp external representation 'Feb 29 17:32:01 1997'
ERROR: Bad timestamp external representation 'Feb 16 17:32:01 -0097'
ERROR: TIMESTAMP WITH TIME ZONE out of range 'Feb 16 17:32:01 5097 BC'
ERROR: to_timestamp(): bad value for MON/Mon/mon
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "lseg_tbl" does not exist
ERROR: Relation "lseg_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Relation "point_tbl" does not exist
ERROR: Bad time external representation '040506.789+08'
ERROR: Bad time external representation '040506.789-08'
ERROR: Bad time external representation 'T040506.789+08'
ERROR: Bad time external representation 'T040506.789-08'
ERROR: Unable to identify an operator '-' for types 'date' and 'time with
time zone' You will have to retype this query using an explicit cast
ERROR: Bad time external representation '11:00-5'
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Cannot cast type 'time with time zone' to 'interval'
ERROR: Cannot cast type 'interval' to 'time with time zone'
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "time_tbl" does not exist
ERROR: Relation "time_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
NOTICE: DateStyle is SQL with US (NonEuropean) conventions
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
NOTICE: DateStyle is Postgres with European conventions
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
NOTICE: DateStyle is ISO with European conventions
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
NOTICE: DateStyle is SQL with European conventions
ERROR: Relation "timestamp_tbl" does not exist
ERROR: Relation "abstime_tbl" does not exist
NOTICE: ProcedureCreate: type widget is not yet defined
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"name"
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"age"
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"location"
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"class"
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"a"
NOTICE: hobbies_r.name%TYPE converted to text
NOTICE: hobbies_r.person%TYPE converted to text
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"aa"
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute
"aa"
ERROR: parser: parse error at or near ","
ERROR: parser: parse error at or near "IN"
ERROR: ExecAppend: rejected due to CHECK constraint check_con
ERROR: ExecAppend: rejected due to CHECK constraint check_con
ERROR: ExecAppend: rejected due to CHECK constraint check_con
ERROR: check_fkeys2_pkey_exist: tuple references non-existing key in pkeys
ERROR: check_fkeys_pkey_exist: tuple references non-existing key in pkeys
ERROR: check_fkeys_pkey2_exist: tuple references non-existing key in fkeys2
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
ERROR: ExecAppend: rejected due to CHECK constraint sequence_con
ERROR: ExecAppend: rejected due to CHECK constraint sequence_con
ERROR: ExecAppend: rejected due to CHECK constraint sequence_con
ERROR: ExecAppend: rejected due to CHECK constraint sequence_con
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ExecAppend: rejected due to CHECK constraint $2
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ExecAppend: rejected due to CHECK constraint $2
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ExecAppend: rejected due to CHECK constraint insert_child_cy
ERROR: ExecAppend: rejected due to CHECK constraint $1
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ttdummy (tttest): you can't change price_on and/or price_off columns
(use set_ttdummy)
NOTICE: insert_seq.nextval: sequence was re-created
ERROR: ExecAppend: rejected due to CHECK constraint insert_con
ERROR: ExecReplace: rejected due to CHECK constraint insert_con
ERROR: copy: line 2, CopyFrom: rejected due to CHECK constraint copy_con
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'primary_tbl_pkey' for table 'primary_tbl'
ERROR: Cannot insert a duplicate key into unique index primary_tbl_pkey
ERROR: ExecAppend: Fail to add null value in not null attribute i
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'primary_tbl_pkey' for table 'primary_tbl'
ERROR: ExecAppend: Fail to add null value in not null attribute i
NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_tbl_i_key'
for table 'unique_tbl'
ERROR: Cannot insert a duplicate key into unique index unique_tbl_i_key
NOTICE: CREATE TABLE will create implicit sequence 'serialtest_f2_seq' for
SERIAL column 'serialtest.f2'
NOTICE: CREATE TABLE / UNIQUE will create implicit index
'serialtest_f2_key' for table 'serialtest'
NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_tbl_i_key'
for table 'unique_tbl'
ERROR: ExecAppend: Fail to add null value in not null attribute f2
ERROR: Cannot insert a duplicate key into unique index unique_tbl_i_key
ERROR: Cannot insert a duplicate key into unique index func_index_index
DEBUG: --Relation pg_type--
DEBUG: Index pg_type_oid_index: Pages 2; Tuples 266: Deleted 42. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index pg_type_typname_index: Pages 4; Tuples 266: Deleted 42. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 42 tuples in 4 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 6: Changed 4, Empty 0; Tup 266: Vac 42, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation pg_attribute--
DEBUG: Index pg_attribute_relid_attnam_index: Pages 24; Tuples 2041:
Deleted 419. CPU 0.00s/0.01u sec elapsed 0.33 sec.
DEBUG: Index pg_attribute_relid_attnum_index: Pages 11; Tuples 2041:
Deleted 419. CPU -1.99s/0.02u sec elapsed 0.09 sec.
DEBUG: Removed 419 tuples in 15 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 36: Changed 18, Empty 0; Tup 2041: Vac 419, Keep 0, UnUsed 0. Total CPU 0.00s/0.04u sec elapsed
0.43sec.
DEBUG: --Relation pg_class--
DEBUG: Index pg_class_oid_index: Pages 4; Tuples 282: Deleted 411. CPU 0.00s/0.01u sec elapsed 0.01 sec.
DEBUG: Index pg_class_relname_index: Pages 8; Tuples 282: Deleted 411. CPU 0.00s/0.01u sec elapsed 0.01 sec.
DEBUG: Removed 411 tuples in 12 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 13: Changed 6, Empty 0; Tup 282: Vac 411, Keep 0, UnUsed 0. Total CPU -1.99s/0.02u sec elapsed 0.02
sec.
DEBUG: --Relation pg_group--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_database--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 2. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_inherits--
DEBUG: Index pg_inherits_relid_seqno_index: Pages 2; Tuples 17: Deleted 1. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 1 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 1, Empty 0; Tup 17: Vac 1, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_index--
DEBUG: Index pg_index_indrelid_index: Pages 2; Tuples 113: Deleted 18. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index pg_index_indexrelid_index: Pages 2; Tuples 113: Deleted 18. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 18 tuples in 2 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 4: Changed 3, Empty 0; Tup 113: Vac 18, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation pg_operator--
DEBUG: Index pg_operator_oid_index: Pages 4; Tuples 630: Deleted 1. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index pg_operator_oprname_l_r_k_index: Pages 8; Tuples 630: Deleted
1. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 1 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 10: Changed 1, Empty 0; Tup 630: Vac 1, Keep 0, UnUsed 0. Total CPU 0.00s/-1.99u sec elapsed 0.00
sec.
DEBUG: --Relation pg_opclass--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 51: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_am--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_amop--
DEBUG: Pages 2: Changed 0, Empty 0; Tup 180: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation pg_amproc--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 57: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_language--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.06 sec.
DEBUG: --Relation pg_largeobject--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_aggregate--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 63: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_trigger--
DEBUG: Index pg_trigger_tgconstrname_index: Pages 2; Tuples 1: Deleted 7. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index pg_trigger_tgconstrrelid_index: Pages 2; Tuples 1: Deleted 7. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index pg_trigger_tgrelid_index: Pages 2; Tuples 1: Deleted 7. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index pg_trigger_oid_index: Pages 2; Tuples 1: Deleted 7. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 7 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 1, Empty 0; Tup 1: Vac 7, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_listener--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_shadow--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 1: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation float4_tbl--
DEBUG: Removed 3 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 3, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.04 sec.
DEBUG: --Relation pg_attrdef--
DEBUG: Index pg_attrdef_adrelid_adnum_index: Pages 2; Tuples 9: Deleted 6. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 6 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 1, Empty 0; Tup 9: Vac 6, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_16384--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation int2_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.04 sec.
DEBUG: --Relation pg_description--
DEBUG: Pages 12: Changed 0, Empty 0; Tup 1303: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/-1.99u sec elapsed 0.01
sec.
DEBUG: --Relation pg_toast_16416--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation num_data--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_proc--
DEBUG: Pages 31: Changed 1, Empty 0; Tup 1283: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/-1.99u sec elapsed 0.05
sec.
DEBUG: --Relation pg_toast_1255--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation int4_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_relcheck--
DEBUG: Index pg_relcheck_rcrelid_index: Pages 2; Tuples 5: Deleted 3. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 3 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 1, Empty 0; Tup 5: Vac 3, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_16386--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation float8_tbl--
DEBUG: Removed 10 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 10, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
DEBUG: --Relation pg_rewrite--
DEBUG: Pages 4: Changed 1, Empty 0; Tup 26: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_16410--
DEBUG: Pages 2: Changed 0, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.02 sec.
DEBUG: --Relation int8_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation text_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 2: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_16573--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_statistic--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 20: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_16408--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation varchar_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation num_result--
DEBUG: Removed 786 tuples in 6 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 6: Changed 0, Empty 0; Tup 8: Vac 786, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01
sec.
DEBUG: --Relation char_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
DEBUG: --Relation num_exp_add--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU -1.99s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation num_exp_sub--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation num_exp_div--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation num_exp_mul--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation num_exp_sqrt--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
DEBUG: --Relation num_exp_ln--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
DEBUG: --Relation num_exp_log10--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation num_exp_power_10_ln--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation tinterval_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation reltime_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 6: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation timestamptz_tbl--
DEBUG: Removed 8 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 64: Vac 8, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation timetz_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
DEBUG: --Relation box_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation interval_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.02 sec.
DEBUG: --Relation date_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 15: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation polygon_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18100--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation path_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 8: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18143--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation circle_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 6: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation inet_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 14: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation hobbies_r--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18304--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation equipment_r--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18309--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation person--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 50: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18320--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation emp--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18325--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation student--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 2: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18330--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU -1.99s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation stud_emp--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18335--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation city--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation dept--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18342--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation slow_emp4000--
DEBUG: Pages 26: Changed 0, Empty 0; Tup 3100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/-1.99u sec elapsed 0.00
sec.
DEBUG: --Relation real_city--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18366--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation a_star--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation b_star--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18373--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation d_star--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 16: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18380--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation c_star--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/-1.99u sec elapsed 0.00 sec.
DEBUG: --Relation e_star--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 7: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation f_star--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 16: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_18387--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation aggtest--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.05 sec.
DEBUG: --Relation default_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_120238--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation b--
DEBUG: Removed 18 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 0: Vac 18, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Truncated 1 --> 0 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_120900--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation c--
DEBUG: Removed 12 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 0: Vac 12, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Truncated 1 --> 0 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_123161--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation a--
DEBUG: Removed 18 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 0: Vac 18, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Truncated 1 --> 0 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_118720--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation d--
DEBUG: Removed 18 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 0: Vac 18, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Truncated 1 --> 0 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_123527--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation onek--
DEBUG: Index onek_unique1: Pages 5; Tuples 1000: Deleted 0. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index onek_unique2: Pages 5; Tuples 1000: Deleted 0. CPU -1.99s/0.00u sec elapsed 0.00 sec.
DEBUG: Index onek_hundred: Pages 5; Tuples 1000: Deleted 0. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index onek_stringu1: Pages 9; Tuples 1000: Deleted 0. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 1000 tuples in 23 pages. CPU 0.00s/-1.99u sec elapsed 0.00 sec.
DEBUG: Pages 46: Changed 0, Empty 0; Tup 1000: Vac 1000, Keep 0, UnUsed 0. Total CPU 0.00s/0.01u sec elapsed
0.02sec.
DEBUG: --Relation tenk1--
DEBUG: Pages 228: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.03s/-1.99u sec elapsed
0.03sec.
DEBUG: --Relation tenk2--
DEBUG: Pages 228: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.02s/0.00u sec elapsed 0.03
sec.
DEBUG: --Relation road--
DEBUG: Pages 81: Changed 0, Empty 0; Tup 5124: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01
sec.
DEBUG: --Relation pg_toast_18351--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation ihighway--
DEBUG: Pages 10: Changed 0, Empty 0; Tup 479: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation pg_toast_18356--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation shighway--
DEBUG: Index six: Pages 2; Tuples 77: Deleted 0. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 77 tuples in 2 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 3: Changed 0, Empty 0; Tup 77: Vac 77, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation pg_toast_18361--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation bt_i4_heap--
DEBUG: Pages 55: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.01s/0.00u sec elapsed 0.01
sec.
DEBUG: --Relation bt_name_heap--
DEBUG: Pages 89: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.01s/0.00u sec elapsed 0.01
sec.
DEBUG: --Relation bt_txt_heap--
DEBUG: Pages 59: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.01u sec elapsed 0.01
sec.
DEBUG: --Relation pg_toast_18409--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation bt_f8_heap--
DEBUG: Pages 59: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01
sec.
DEBUG: --Relation defaultexpr_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation check_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation check2_tbl--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 2: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_127812--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation insert_tbl--
DEBUG: Removed 14 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 5: Vac 14, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_128852--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation copy_tbl--
DEBUG: Removed 1 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 0, Empty 0; Tup 2: Vac 1, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_134008--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation bprime--
DEBUG: Pages 23: Changed 23, Empty 0; Tup 1000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00
sec.
DEBUG: --Relation ramp--
DEBUG: Pages 8: Changed 8, Empty 0; Tup 427: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/-1.99u sec elapsed 0.00
sec.
DEBUG: --Relation pg_toast_134016--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation iportaltest--
DEBUG: Pages 1: Changed 1, Empty 0; Tup 2: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_135083--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation serialtest--
DEBUG: Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_135108--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation onek2--
DEBUG: Index onek2_u1_prtl: Pages 2; Tuples 39. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index onek2_u2_prtl: Pages 2; Tuples 39. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Index onek2_stu1_prtl: Pages 2; Tuples 39. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 23: Changed 0, Empty 0; Tup 1000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.01
sec.
DEBUG: --Relation fast_emp4000--
DEBUG: Index rect2ind: Pages 28; Tuples 3100. CPU -1.99s/0.01u sec elapsed 0.01 sec.
DEBUG: Pages 26: Changed 0, Empty 0; Tup 3100: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.02u sec elapsed 0.02
sec.
DEBUG: --Relation hash_i4_heap--
DEBUG: Index hash_i4_index: Pages 39; Tuples 10000. CPU 0.00s/0.11u sec elapsed 0.12 sec.
DEBUG: Pages 55: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.01s/0.11u sec elapsed 0.13
sec.
DEBUG: --Relation hash_name_heap--
DEBUG: Index hash_name_index: Pages 100; Tuples 10000. CPU 0.00s/0.11u sec elapsed 0.12 sec.
DEBUG: Pages 89: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.01s/0.13u sec elapsed 0.14
sec.
DEBUG: --Relation hash_txt_heap--
DEBUG: Index hash_txt_index: Pages 83; Tuples 10000. CPU 0.01s/0.11u sec elapsed 0.12 sec.
DEBUG: Pages 69: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.02s/0.11u sec elapsed 0.13
sec.
DEBUG: --Relation pg_toast_18398--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation hash_f8_heap--
DEBUG: Index hash_f8_index: Pages 40; Tuples 10000. CPU -1.99s/0.12u sec elapsed 0.12 sec.
DEBUG: Pages 59: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU -1.99s/0.13u sec elapsed 0.13
sec.
DEBUG: --Relation func_index_heap--
DEBUG: Index func_index_index: Pages 2; Tuples 4: Deleted 0. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Removed 1 tuples in 1 pages. CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: Pages 1: Changed 1, Empty 0; Tup 4: Vac 1, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
DEBUG: --Relation pg_toast_135140--
DEBUG: Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0. Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
ERROR: parser: parse error at or near "select"
ERROR: Attribute 'nonesuch' not found
ERROR: Attribute 'nonesuch' not found
ERROR: Attribute 'nonesuch' not found
ERROR: parser: parse error at or near "from"
ERROR: Attribute 'foobar' not found
ERROR: parser: parse error at or near ";"
ERROR: Relation "nonesuch" does not exist
ERROR: parser: parse error at or near ";"
ERROR: table "nonesuch" does not exist
ERROR: parser: parse error at or near ";"
ERROR: Relation "nonesuch" does not exist
ERROR: Relation "nonesuch" does not exist
ERROR: renamerel: Illegal class name: "pg_stud_emp" -- pg_ is reserved for
system catalogs
ERROR: renamerel: relation "aggtest" exists
ERROR: renamerel: relation "stud_emp" exists
ERROR: Relation "nonesuchrel" does not exist
ERROR: renameatt: attribute "nonesuchatt" does not exist
ERROR: renameatt: attribute "manager" exists
ERROR: renameatt: attribute "oid" exists
NOTICE: ROLLBACK: no transaction in progress
NOTICE: COMMIT: no transaction in progress
ERROR: AggregateCreate: function 'int2um(int4)' does not exist
ERROR: Define: "basetype" unspecified
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near "314159"
ERROR: index "nonesuch" does not exist
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near "314159"
ERROR: RemoveAggregate: type 'nonesuch' does not exist
ERROR: RemoveAggregate: aggregate 'nonesuch' for type integer does not
exist
ERROR: RemoveAggregate: aggregate 'newcnt' for type real does not exist
ERROR: parser: parse error at or near "("
ERROR: parser: parse error at or near "314159"
ERROR: RemoveFunction: function 'nonesuch()' does not exist
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near "314159"
ERROR: RemoveType: type 'nonesuch' does not exist
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near "equals"
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near "int4"
ERROR: parser: parse error at or near "("
ERROR: parser: parse error at or near ")"
ERROR: parser: argument type missing (use NONE for unary operators)
ERROR: RemoveOperator: binary operator '===' taking 'int4' and 'int4' does
not exist
ERROR: parser: argument type missing (use NONE for unary operators)
ERROR: parser: parse error at or near ","
ERROR: RemoveOperator: type 'nonesuch' does not exist
ERROR: RemoveOperator: type 'nonesuch' does not exist
ERROR: parser: parse error at or near ")"
ERROR: parser: parse error at or near ";"
ERROR: parser: parse error at or near "314159"
ERROR: Rule or view "nonesuch" not found
ERROR: parser: parse error at or near "tuple"
ERROR: parser: parse error at or near "instance"
ERROR: parser: parse error at or near "rewrite"
DEBUG: Analyzing onek2
ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY
expressions
ERROR: Attribute test_missing_target.b must be GROUPed or used in an
aggregate function
ERROR: GROUP BY position 3 is not in target list
ERROR: Column reference "b" is ambiguous
ERROR: Attribute test_missing_target.b must be GROUPed or used in an
aggregate function
ERROR: Column reference "i" is ambiguous
ERROR: Column reference "b" is ambiguous
ERROR: value too long for type character(5)
ERROR: Column reference "b" is ambiguous
ERROR: Attribute 'q2' not found
ERROR: UNION JOIN is not implemented yet
ERROR: CREATE USER: user name "regressuser4" already exists
NOTICE: ALTER GROUP: user "regressuser2" is already in group
"regressgroup2"
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: LOCK TABLE: permission denied
ERROR: atest2: Permission denied.
ERROR: permission denied
ERROR: atest2: Permission denied.
ERROR: atest1: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest1: Permission denied.
ERROR: atest1: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest1: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest2: Permission denied.
ERROR: atest3: Permission denied.
ERROR: has_table_privilege: relation "pg_shad" does not exist
ERROR: user "nosuchuser" does not exist
ERROR: has_table_privilege: invalid privilege type sel
ERROR: pg_aclcheck: invalid user id 4293967297
ERROR: has_table_privilege: invalid relation oid 1
DEBUG: XLogWrite: new log file created - consider increasing WAL_FILES
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to locate type name 'dt' in catalog
ERROR: <unnamed> referential integrity violation - key referenced from
fktable not found in pktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "fktable"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Relation 'tmp' does not have attribute 'k'
ERROR: constrname referential integrity violation - key referenced from
fktable not found in pktable
ERROR: constrname referential integrity violation - key referenced from
fktable not found in pktable
ERROR: constrname referential integrity violation - MATCH FULL doesn't
allow mixing of NULL and NON-NULL key values
ERROR: constrname referential integrity violation - MATCH FULL doesn't
allow mixing of NULL and NON-NULL key values
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "fktable"
ERROR: Unable to locate type name 'dt' in catalog
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: constrname2 referential integrity violation - key referenced from
fktable not found in pktable
ERROR: constrname2 referential integrity violation - key referenced from
fktable not found in pktable
ERROR: constrname2 referential integrity violation - MATCH FULL doesn't
allow mixing of NULL and NON-NULL key values
ERROR: constrname2 referential integrity violation - MATCH FULL doesn't
allow mixing of NULL and NON-NULL key values
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "fktable"
ERROR: Relation 'tmp' does not have attribute 'k'
DEBUG: --Relation tenk1--
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: <unnamed> referential integrity violation - key referenced from
fktable not found in pktable
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from fktable
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from fktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "fktable"
DEBUG: Pages 228: Changed 0, Empty 0; Tup 10000: Vac 0, Keep 0, UnUsed 0. Total CPU 0.03s/0.00u sec elapsed 1.37
sec.
DEBUG: Analyzing tenk1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: constrname3 referential integrity violation - key referenced from
fktable not found in pktable
ERROR: constrname3 referential integrity violation - key in pktable still
referenced from fktable
ERROR: constrname3 referential integrity violation - key in pktable still
referenced from fktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: constrname3 referential integrity violation - key referenced from
fktable not found in pktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'tmp2_pkey'
for table 'tmp2'
ERROR: constrname3 referential integrity violation - key referenced from
fktable not found in pktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: CREATE TABLE / UNIQUE will create implicit index 'tmp4_a_key' for
table 'tmp4'
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: ALTER TABLE: column "c" referenced in foreign key constraint does
not exist
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: UNIQUE constraint matching given keys for referenced table "tmp2"
not found
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: tmpconstr referential integrity violation - key referenced from tmp3
not found in tmp2
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: UNIQUE constraint matching given keys for referenced table "tmp4"
not found
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "tmp2"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "tmp2"
ERROR: constrname3 referential integrity violation - key referenced from
fktable not found in pktable
ERROR: constrname3 referential integrity violation - key referenced from
fktable not found in pktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: CREATE TABLE: column "ftest2" referenced in foreign key constraint
does not exist
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: UNIQUE constraint matching given keys for referenced table "pktable"
not found
ERROR: table "fktable_fail1" does not exist
ERROR: table "fktable_fail2" does not exist
NOTICE: CREATE TABLE / UNIQUE will create implicit index
'pktable_ptest1_key' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: UNIQUE constraint matching given keys for referenced table "pktable"
not found
ERROR: table "fktable_fail1" does not exist
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "fktable"
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "fktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
ERROR: Attribute 'f1' not found
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'integer' and 'text' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'integer' and 'text' You will have to retype this query
usingan explicit cast
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
ERROR: ExecAppend: rejected due to CHECK constraint atacc_test1
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
ERROR: AlterTableAddConstraint: rejected due to CHECK constraint
atacc_test1
ERROR: Attribute 'test1' not found
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: ExecAppend: rejected due to CHECK constraint atacc_test1
ERROR: ExecAppend: rejected due to CHECK constraint $2
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'integer' and 'text' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
ERROR: ExecAppend: rejected due to CHECK constraint foo
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE / UNIQUE will create implicit index
'pktable_base1_key' for table 'pktable'
ERROR: ExecAppend: rejected due to CHECK constraint foo
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: <unnamed> referential integrity violation - key referenced from
fktable not found in pktable
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from fktable
ERROR: ExecAppend: rejected due to CHECK constraint foo
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from fktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index 'atacc_test1'
for table 'atacc1'
ERROR: <unnamed> referential integrity violation - key referenced from
fktable not found in pktable
ERROR: Cannot insert a duplicate key into unique index atacc_test1
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from fktable
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index 'atacc_oid1'
for table 'atacc1'
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from fktable
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: DROP TABLE implicitly drops referential integrity trigger from
table "pktable"
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index 'atacc_test1'
for table 'atacc1'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
ERROR: Cannot create unique index. Table contains non-unique values
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: ALTER TABLE: column "test1" named in key does not exist
ERROR: <unnamed> referential integrity violation - key referenced from
pktable not found in pktable
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from pktable
ERROR: <unnamed> referential integrity violation - key in pktable still
referenced from pktable
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index 'atacc_test1'
for table 'atacc1'
ERROR: Cannot insert a duplicate key into unique index atacc_test1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE / UNIQUE will create implicit index 'atacc1_test_key'
for table 'atacc1'
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index
'atacc1_test2_key' for table 'atacc1'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'integer' and 'text' You will have to retype this query
usingan explicit cast
ERROR: Cannot insert a duplicate key into unique index atacc1_test_key
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text[]' and 'text' You will have to retype this query using
anexplicit cast
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'integer' and 'text' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'pktable_pkey' for table 'pktable'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query
usingan explicit cast
ERROR: table "pktable" does not exist
ERROR: Relation "temptest" does not exist
ERROR: Cannot insert a duplicate key into unique index pfield_name
ERROR: WS.not.there does not exist
ERROR: illegal backlink beginning with XX
ERROR: PS.not.there does not exist
ERROR: illegal slotlink beginning with XX
ERROR: Cannot insert a duplicate key into unique index hslot_name
ERROR: no manual manipulation of HSlot
ERROR: no manual manipulation of HSlot
ERROR: system "notthere" does not exist
ERROR: IFace slotname "IF.orion.ethernet_interface_name_too_long" too long
(20 char max)
DEBUG: smart shutdown request
DEBUG: shutting down
DEBUG: database system is shut down
On 4/3/02 4:36, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> Steven Núñez <nunez@itl-global.com> writes:
>> I've just compiled and checked version 7.2 of the system on BSDI 4.0 and
>> have noticed the following errors in the regression.diffs file
>
>> ! psql: PQconnectPoll() -- couldn't send startup packet: errno=32
>> ! Broken pipe
>
> What shows up in the postmaster log?
>
> regards, tom lane
>