re [ANNOUNCE] RC1 Packaged for Testing ... AIX 4.2.1 result - Mailing list pgsql-hackers

system = powerpc-ibm-aix4.2.1.0 


configure command 

env CC=gcc ./configure --with-maxbackends=1024 --with-openssl=/usr/local/ssl --enable-syslog --enable-odbc
--disable-nls

gmake check output file


regression.out
--------------

parallel group (13 tests):  text varchar oid int2 char boolean float4 int4 name int8 float8 bit numeric    boolean
       ... ok    char                 ... ok    name                 ... ok    varchar              ... ok    text
          ... ok    int2                 ... ok    int4                 ... ok    int8                 ... ok    oid
             ... ok    float4               ... ok    float8               ... ok    bit                  ... ok
numeric             ... ok
 
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  lseg date path circle polygon box point time timetz tinterval abstime interval reltime
commentsinet timestamptz timestamp type_sanity opr_sanity oidjoins    point                ... ok    lseg
 ... ok    box                  ... ok    path                 ... ok    polygon              ... ok    circle
    ... ok    date                 ... ok    time                 ... ok    timetz               ... ok    timestamp
       ... ok    timestamptz          ... ok    interval             ... ok    abstime              ... ok    reltime
          ... ok    tinterval            ... ok    inet                 ... ok    comments             ... ok
oidjoins            ... ok    type_sanity          ... ok    opr_sanity           ... ok
 
test geometry             ... FAILED
test horology             ... ok
test insert               ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_aggregate create_operator triggers vacuum inherit constraints create_misc
constraints         ... ok    triggers             ... ok    create_misc          ... ok    create_aggregate     ... ok
  create_operator      ... ok    inherit              ... ok    vacuum               ... ok
 
parallel group (2 tests):  create_view create_index    create_index         ... ok    create_view          ... ok
test sanity_check         ... ok
test errors               ... ok
test select               ... ok
parallel group (16 tests):  select_distinct_on select_into select_having transactions select_distinct random subselect
portalsarrays union select_implicit case aggregates hash_index join btree_index    select_into          ... ok
select_distinct     ... ok    select_distinct_on   ... ok    select_implicit      ... ok    select_having        ... ok
  subselect            ... ok    union                ... ok    case                 ... ok    join                 ...
ok   aggregates           ... ok    transactions         ... ok    random               ... ok    portals
...ok    arrays               ... ok    btree_index          ... ok    hash_index           ... ok
 
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 cluster rules select_views foreign_key    select_views         ... ok
portals_p2          ... ok    rules                ... ok    foreign_key          ... ok    cluster              ...
ok
parallel group (11 tests):  limit truncate temp copy2 domain rangefuncs conversion prepare without_oid plpgsql
alter_table   limit                ... ok    plpgsql              ... ok    copy2                ... ok    temp
       ... ok    domain               ... ok    rangefuncs           ... ok    prepare              ... ok
without_oid         ... ok    conversion           ... ok    truncate             ... ok    alter_table          ...
ok


regression.diffs
-----------------


*** ./expected/geometry-powerpc-aix4.out    Tue Sep 12 17:07:16 2000
--- ./results/geometry.out    Thu Nov 21 21:46:01 2002
***************
*** 114,120 ****         | (5.1,34.5) | [(1,2),(3,4)]                 | (3,4)         | (-5,-12)   | [(1,2),(3,4)]
          | (1,2)         | (10,10)    | [(1,2),(3,4)]                 | (3,4)
 
!         | (0,0)      | [(0,0),(6,6)]                 | (0,0)         | (-10,0)    | [(0,0),(6,6)]                 |
(0,0)        | (-3,4)     | [(0,0),(6,6)]                 | (0.5,0.5)         | (5.1,34.5) | [(0,0),(6,6)]
  | (6,6)
 
--- 114,120 ----         | (5.1,34.5) | [(1,2),(3,4)]                 | (3,4)         | (-5,-12)   | [(1,2),(3,4)]
          | (1,2)         | (10,10)    | [(1,2),(3,4)]                 | (3,4)
 
!         | (0,0)      | [(0,0),(6,6)]                 | (-0,0)         | (-10,0)    | [(0,0),(6,6)]                 |
(0,0)        | (-3,4)     | [(0,0),(6,6)]                 | (0.5,0.5)         | (5.1,34.5) | [(0,0),(6,6)]
  | (6,6)
 
***************
*** 127,133 ****         | (-5,-12)   | [(10,-10),(-3,-4)]            | (-1.60487804878049,-4.64390243902439)         |
(10,10)   | [(10,-10),(-3,-4)]            | (2.39024390243902,-6.48780487804878)         | (0,0)      |
[(-1000000,200),(300000,-40)]| (0.0028402365895872,15.384614860264)
 
!         | (-10,0)    | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473)         | (-3,4)     |
[(-1000000,200),(300000,-40)]| (-2.99789812267519,15.3851688427303)         | (5.1,34.5) |
[(-1000000,200),(300000,-40)]| (5.09647083221496,15.3836744976925)         | (-5,-12)   | [(-1000000,200),(300000,-40)]
|(-4.99494420845634,15.3855375281616)
 
--- 127,133 ----         | (-5,-12)   | [(10,-10),(-3,-4)]            | (-1.60487804878049,-4.64390243902439)         |
(10,10)   | [(10,-10),(-3,-4)]            | (2.39024390243902,-6.48780487804878)         | (0,0)      |
[(-1000000,200),(300000,-40)]| (0.0028402365895872,15.384614860264)
 
!         | (-10,0)    | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472)         | (-3,4)     |
[(-1000000,200),(300000,-40)]| (-2.99789812267519,15.3851688427303)         | (5.1,34.5) |
[(-1000000,200),(300000,-40)]| (5.09647083221496,15.3836744976925)         | (-5,-12)   | [(-1000000,200),(300000,-40)]
|(-4.99494420845634,15.3855375281616)
 
***************
*** 448,454 ****      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994

107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081027))
    |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.4999999999

6464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999

999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
!      |
((-0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999

999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
(6rows)  -- convert the circle to an 8-point polygon
 
--- 448,454 ----      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994

107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081027))
    |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.4999999999

6464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999

999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
!      |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.9999

99998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
(6rows)  -- convert the circle to an 8-point polygon
 
***************
*** 461,467 ****      |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
    |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
    |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      |
((-0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6rows)  --
 
--- 461,467 ----      |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
    |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
    |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6rows)  --
 

======================================================================


postmaster.log
---------------

LOG:  database system was shut down at 2002-11-21 21:44:05 EST
LOG:  checkpoint record is at 0/8484B8
LOG:  redo record is at 0/8484B8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system is ready
ERROR:  DROP GROUP: group "regressgroup1" does not exist
ERROR:  value too long for type character(1)
ERROR:  pg_atoi: error in "34.5": can't parse ".5"
ERROR:  oidin: error in "asdfasd": can't parse "asdfasd"
ERROR:  value too long for type character varying(1)
ERROR:  oidin: error in "99asdfasd": can't parse "asdfasd"
ERROR:  pg_atoi: error reading "1000000000000": Numerical result out of range
ERROR:  pg_atoi: error in "asdf": can't parse "asdf"
ERROR:  pg_atoi: error in "34.5": can't parse ".5"
ERROR:  pg_atoi: error reading "100000": Numerical result out of range
ERROR:  pg_atoi: error in "asdf": can't parse "asdf"
ERROR:  Bad boolean external representation 'XXX'
ERROR:  Bad float4 input format -- overflow
ERROR:  Bad float4 input format -- overflow
ERROR:  Bad float4 input format -- underflow
ERROR:  Bad float4 input format -- underflow
ERROR:  Bit string length 2 does not match type BIT(11)
ERROR:  value too long for type character varying(4)
ERROR:  Bit string length 12 does not match type BIT(11)
ERROR:  value too long for type character(4)
ERROR:  float4div: divide by zero error
ERROR:  Bit string too long for type BIT VARYING(11)
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:  Input '10e-400' is out of range for float8
ERROR:  Input '-10e-400' is out of range for float8
ERROR:  Cannot AND bit strings of different sizes
ERROR:  Cannot OR bit strings of different sizes
ERROR:  Cannot XOR bit strings of different sizes
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 "' - third line'" at character 75
ERROR:  negative substring length not allowed
ERROR:  negative substring length not allowed
ERROR:  field position must be > 0
ERROR:  Bad lseg external representation '(3asdf,2 ,3,4r2)'
ERROR:  Bad lseg external representation '[1,2,3, 4'
ERROR:  Bad lseg external representation '[(,2),(3,4)]'
ERROR:  Bad lseg external representation '[(1,2),(3,4)'
ERROR:  Bad point external representation 'asdfasdf'
ERROR:  Bad point external representation '(10.0 10.0)'
ERROR:  Bad point external representation '(10.0,10.0'
ERROR:  Bad box external representation '(2.3, 4.5)'
ERROR:  Bad box external representation 'asdfasdf(ad'
ERROR:  Bad circle external representation '<(-100,0),-100>'
ERROR:  Bad circle external representation '1abc,3,5'
ERROR:  Bad circle external representation '(3,(1,2),3)'
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:  Bad time external representation '07:07 PST'
ERROR:  Bad time external representation '08:08 EDT'
ERROR:  Unable to identify an operator '+' for types 'time without time zone' and 'time without time zone'You will have
toretype this query using an explicit cast
 
ERROR:  Bad timestamp external representation 'current'
ERROR:  Bad timestamp external representation 'current'
ERROR:  table "inet_tbl" does not exist
ERROR:  Bad abstime external representation 'bad time specifications'
ERROR:  Bad abstime external representation ''
ERROR:  TIMESTAMP WITH TIME ZONE 'invalid' no longer supported
ERROR:  Bad timestamp external representation 'Invalid Abstime'
ERROR:  Bad reltime external representation 'badly formatted reltime'
ERROR:  Bad interval external representation 'badly formatted interval'
ERROR:  Bad interval external representation '@ 30 eons ago'
ERROR:  Bad timestamp external representation 'Undefined Abstime'
ERROR:  Bad reltime external representation '@ 30 eons ago'
ERROR:  Bad abstime external representation 'Feb 35, 1946 10:00:00'
ERROR:  Bad abstime external representation 'Feb 28, 1984 25:08:10'
ERROR:  Bad abstime external representation 'bad date format'
ERROR:  Unable to identify an operator '+' for types 'time with time zone' and 'time with time zone'You will have to
retypethis query using an explicit cast
 
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:  TIMESTAMP 'invalid' no longer supported
ERROR:  Bad timestamp external representation 'Invalid Abstime'
ERROR:  Bad timestamp external representation 'Undefined Abstime'
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:  Bad timestamp external representation 'Feb 29 17:32:01 1997'
ERROR:  Bad timestamp external representation 'Feb 16 17:32:01 -0097'
ERROR:  TIMESTAMP out of range 'Feb 16 17:32:01 5097 BC'
ERROR:  to_timestamp(): bad value for MON/Mon/mon
ERROR:  to_timestamp(): bad value for MON/Mon/mon
ERROR:  Unable to identify an operator '#' for types 'lseg' and 'point'You will have to retype this query using an
explicitcast
 
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
usingan explicit cast
 
ERROR:  Cannot cast type time with time zone to interval
ERROR:  Cannot cast type interval to time with time zone
ERROR:  Unable to convert abstime 'invalid' to timestamp
ERROR:  ExecInsert: Fail to add null value in not null attribute col2
ERROR:  INSERT has more target columns than expressions
ERROR:  INSERT has more target columns than expressions
ERROR:  INSERT has more expressions than target columns
ERROR:  INSERT has more expressions than target columns
NOTICE:  ProcedureCreate: type widget is not yet defined
NOTICE:  Argument type "widget" is only a shell
NOTICE:  ProcedureCreate: type city_budget is not yet defined
NOTICE:  Argument type "city_budget" is only a shell
ERROR:  return type mismatch in function: declared to return integer, returns "unknown"
ERROR:  parser: parse error at or near "not" at character 1
ERROR:  function declared to return integer returns multiple columns in final SELECT
ERROR:  Parameter '$2' is out of range
ERROR:  CREATE FUNCTION: only one AS item needed for sql language
ERROR:  stat failed on file 'nosuchfile': No such file or directory
ERROR:  Can't find function nosuchsymbol in file /audio/kemper/SAH/postgresql-7.3rc1/src/test/regress/regress.so
ERROR:  there is no built-in function named "nosuch"
NOTICE:  ProcedureCreate: type int42 is not yet defined
NOTICE:  Argument type "int42" is only a shell
NOTICE:  ProcedureCreate: type text_w_default is not yet defined
NOTICE:  Argument type "text_w_default" is only a shell
NOTICE:  Drop cascades to function get_default_test()
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.person%TYPE converted to text
NOTICE:  hobbies_r.name%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 "," at character 43
ERROR:  parser: parse error at or near "IN" at character 43
ERROR:  ExecInsert: rejected due to CHECK constraint "check_con" on "check_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "check_con" on "check_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "check_con" on "check_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "sequence_con" on "check2_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "sequence_con" on "check2_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "sequence_con" on "check2_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "sequence_con" on "check2_tbl"
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:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "$1" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "$1" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_child_cy" on "insert_child"
ERROR:  ExecInsert: rejected due to CHECK constraint "$1" on "insert_child"
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_child"
ERROR:  ttdummy (tttest): you can't change price_on and/or price_off columns (use set_ttdummy)
ERROR:  ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  ExecUpdate: rejected due to CHECK constraint "insert_con" on "insert_tbl"
ERROR:  copy: line 2, CopyFrom: rejected due to CHECK constraint "copy_con" on "copy_tbl"
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:  ExecInsert: 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:  ExecInsert: 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 / 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'
ERROR:  ExecInsert: Fail to add null value in not null attribute f2
ERROR:  Cannot change number of columns in view
ERROR:  Cannot change number of columns in view
ERROR:  Cannot change datatype of view column "b"
ERROR:  Cannot insert a duplicate key into unique index func_index_index
ERROR:  parser: parse error at or near ";" at character 7
ERROR:  Relation "nonesuch" does not exist
ERROR:  parser: parse error at or near "from" at character 8
ERROR:  Attribute "nonesuch" not found
ERROR:  Attribute "nonesuch" not found
ERROR:  Attribute "nonesuch" not found
ERROR:  parser: parse error at or near "from" at character 29
ERROR:  Attribute "foobar" not found
ERROR:  parser: parse error at or near ";" at character 12
ERROR:  Relation "nonesuch" does not exist
ERROR:  parser: parse error at or near ";" at character 11
ERROR:  table "nonesuch" does not exist
ERROR:  parser: parse error at or near ";" at character 19
ERROR:  Relation "nonesuch" does not exist
ERROR:  Relation "nonesuch" does not exist
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
WARNING:  ROLLBACK: no transaction in progress
WARNING:  COMMIT: no transaction in progress
ERROR:  AggregateCreate: function int2um(integer) does not exist
ERROR:  Define: "basetype" unspecified
ERROR:  parser: parse error at or near ";" at character 11
ERROR:  parser: parse error at or near "314159" at character 12
ERROR:  index "nonesuch" does not exist
ERROR:  parser: parse error at or near ";" at character 15
ERROR:  parser: parse error at or near ";" at character 23
ERROR:  parser: parse error at or near "314159" at character 16
ERROR:  Type "nonesuch" does not exist
ERROR:  RemoveAggregate: aggregate nonesuch(integer) does not exist
ERROR:  RemoveAggregate: aggregate newcnt(real) does not exist
ERROR:  parser: parse error at or near "(" at character 15
ERROR:  parser: parse error at or near "314159" at character 15
ERROR:  RemoveFunction: function nonesuch() does not exist
ERROR:  parser: parse error at or near ";" at character 10
ERROR:  parser: parse error at or near "314159" at character 11
ERROR:  Type "nonesuch" does not exist
ERROR:  parser: parse error at or near ";" at character 14
ERROR:  parser: parse error at or near ";" at character 21
ERROR:  parser: parse error at or near ";" at character 18
ERROR:  parser: parse error at or near "," at character 19
ERROR:  parser: parse error at or near "(" at character 15
ERROR:  parser: parse error at or near ")" at character 20
ERROR:  parser: argument type missing (use NONE for unary operators)
ERROR:  RemoveOperator: Operator '===' for types 'int4' and 'int4' does not exist
ERROR:  parser: argument type missing (use NONE for unary operators)
ERROR:  parser: parse error at or near "," at character 19
ERROR:  Type "nonesuch" does not exist
ERROR:  Type "nonesuch" does not exist
ERROR:  parser: parse error at or near ")" at character 24
ERROR:  parser: parse error at or near ";" at character 10
ERROR:  parser: parse error at or near "314159" at character 11
ERROR:  Relation "noplace" does not exist
ERROR:  parser: parse error at or near "tuple" at character 6
ERROR:  parser: parse error at or near "instance" at character 6
ERROR:  parser: parse error at or near "rewrite" at character 6
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:  value too long for type character(5)
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:  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
WARNING:  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:  atest2: permission denied
ERROR:  atest2: permission denied
ERROR:  atest1: must be owner
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:  atest2: permission denied
ERROR:  atestv2: permission denied
ERROR:  atestv3: permission denied
ERROR:  atest2: permission denied
ERROR:  language "c" is not trusted
ERROR:  permission denied
ERROR:  invalid privilege type USAGE for function object
ERROR:  GRANT: function testfunc_nosuch(integer) does not exist
ERROR:  sql: permission denied
ERROR:  testfunc1: permission denied
ERROR:  atest2: permission denied
ERROR:  testfunc1: must be owner
ERROR:  Relation "pg_shad" does not exist
ERROR:  user "nosuchuser" does not exist
ERROR:  has_table_privilege: invalid privilege type sel
ERROR:  pg_class_aclcheck: invalid user id 4293967297
ERROR:  pg_class_aclcheck: relation 1 not found
NOTICE:  Drop cascades to rule _RETURN on view atestv4
NOTICE:  Drop cascades to view atestv4
ERROR:  view "atestv4" does not exist
NOTICE:  ALTER TABLE: merging definition of column "a" for child d_star
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 will create implicit sequence 'clstr_tst_s_rf_a_seq' for SERIAL column 'clstr_tst_s.rf_a'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'clstr_tst_s_pkey' for table 'clstr_tst_s'
ERROR:  $1 referential integrity violation - key referenced from fktable not found in pktable
NOTICE:  CREATE TABLE will create implicit sequence 'clstr_tst_a_seq' for SERIAL column 'clstr_tst.a'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'clstr_tst_pkey' for table 'clstr_tst'
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:  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 cascades to constraint constrname on 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:  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:  constraint constrname2 on table fktable depends on table pktable
ERROR:  Cannot drop table pktable because other objects depend on itUse DROP ... CASCADE to drop the dependent objects
too
NOTICE:  Drop cascades to constraint constrname2 on 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:  $1 referential integrity violation - key referenced from fktable not found in pktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from fktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from 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:  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:  CREATE TABLE / PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable'
ERROR:  clstr_tst_con referential integrity violation - key referenced from clstr_tst not found in clstr_tst_s
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:  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:  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 referenced from fktable not found in 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:  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:  CREATE TABLE: column "ptest2" referenced in foreign key constraint does not exist
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
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 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
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 'cidr' and 'integer'You will have to retype this query using an
explicitcast
 
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 using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'integer' and 'inet'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Attribute "f1" 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:  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 'inet'You will have to retype this query using an
explicitcast
 
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 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
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 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
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'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  $1 referential integrity violation - key referenced from fktable not found in pktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from fktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from fktable
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  $1 referential integrity violation - key referenced from fktable not found in pktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from fktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from 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:  $1 referential integrity violation - key referenced from pktable not found in pktable
ERROR:  $1 referential integrity violation - key in pktable still referenced from pktable
ERROR:  $1 referential integrity violation - key referenced from pktable not found in 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:  Unable to identify an operator '=' for types 'cidr' and 'integer'You will have to retype this query using an
explicitcast
 
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 using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'integer' and 'inet'You will have to retype this query using an
explicitcast
 
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 'inet[]' and 'inet'You will have to retype this query using an
explicitcast
 
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 'inet'You will have to retype this query using an
explicitcast
 
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 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
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 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
ERROR:  table "pktable" does not exist
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'fktable_pkey' for table 'fktable'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  $1 referential integrity violation - key referenced from fktable not found in pktable
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'fktable_pkey' for table 'fktable'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  $1 referential integrity violation - key referenced from fktable not found in pktable
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'fktable_pkey' for table 'fktable'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  $1 referential integrity violation - key referenced from fktable not found in pktable
ERROR:  current transaction is aborted, queries ignored until end of transaction block
NOTICE:  CREATE TABLE will create implicit sequence 'x_a_seq' for SERIAL column 'x.a'
ERROR:  DefineDomain: domaindroptest is not a basetype
NOTICE:  Adding missing FROM-clause entry for table "foo2"
ERROR:  FROM function expression may not refer to other relations of same query level
ERROR:  Prepared statement with name "q1" already exists
ERROR:  Type "domaindroptest" does not exist
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'truncate_a_pkey' for table 'truncate_a'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'foo_pkey' for table 'foo'
ERROR:  conversion name "myconv" already exists
ERROR:  default conversion for LATIN1 to UNICODE already exists
ERROR:  Relation "x" has no column "xyz"
ERROR:  Attribute "d" specified more than once
ERROR:  copy: line 1, pg_atoi: zero-length string
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type \ unknown
ERROR:  copy: line 1, Missing data for column "e"
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type \ unknown
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  copy: line 1, Missing data for column "e"
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type \ unknown
ERROR:  value too long for type character varying(5)
ERROR:  copy: line 1, value too long for type character varying(5)
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type \ unknown
ERROR:  copy: line 1, Extra data after last expected column
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type 7 unknown
ERROR:  TRUNCATE cannot be used as table truncate_b references this one via foreign key constraint $1
ERROR:  Relation "temptest" does not exist
ERROR:  COPY: table "no_oids" does not have OIDs
ERROR:  COPY: table "no_oids" does not have OIDs
ERROR:  Domain dnotnull does not allow NULL values
ERROR:  Domain dnotnull does not allow NULL values
ERROR:  Domain dnotnull does not allow NULL values
ERROR:  ExecInsert: Fail to add null value in not null attribute col3
ERROR:  copy: line 1, CopyFrom: Fail to add null value in not null attribute col3
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type \ unknown
ERROR:  Domain dnotnull does not allow NULL values
ERROR:  Domain dnotnull does not allow NULL values
ERROR:  Domain dnotnull does not allow NULL values
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'defaulttest_pkey' for table 'defaulttest'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'foorescan_pkey' for table 'foorescan'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'barrescan_pkey' for table 'barrescan'
ERROR:  Wrong number of parameters, expected 6 but got 1
ERROR:  Wrong number of parameters, expected 6 but got 7
ERROR:  Parameter $3 of type boolean cannot be coerced into the expected type double precisionYou will need to rewrite
orcast the expression
 
ERROR:  Type "nonexistenttype" does not exist
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'tmp2_pkey' for table 'tmp2'
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:  ALTER TABLE: column "b" referenced in foreign key constraint does not exist
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:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
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)
NOTICE:  Drop cascades to constraint $2 on table fktable
NOTICE:  Drop cascades to constraint $1 on table fktable
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 using an
explicitcast
 
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 using an
explicitcast
 
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'integer' and 'inet'You will have to retype this query using an
explicitcast
 
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Unable to identify an operator '=' for types 'inet' and 'integer'You will have to retype this query using an
explicitcast
 
ERROR:  ExecInsert: rejected due to CHECK constraint "atacc_test1" on "atacc1"
ERROR:  AlterTableAddConstraint: rejected due to CHECK constraint atacc_test1
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)
ERROR:  Attribute "test1" not found
ERROR:  ExecInsert: rejected due to CHECK constraint "atacc_test1" on "atacc1"
ERROR:  ExecInsert: rejected due to CHECK constraint "$1" on "atacc1"
ERROR:  ExecInsert: rejected due to CHECK constraint "foo" on "atacc2"
ERROR:  ExecInsert: rejected due to CHECK constraint "foo" on "atacc3"
ERROR:  ExecInsert: rejected due to CHECK constraint "foo" on "atacc2"
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:  ALTER TABLE / ADD UNIQUE will create implicit index 'atacc_oid1' for table 'atacc1'
NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index 'atacc_test1' for table 'atacc1'
ERROR:  Cannot create unique index. Table contains non-unique values
ERROR:  ALTER TABLE: column "test1" named in key does not exist
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 / 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'
ERROR:  Cannot insert a duplicate key into unique index atacc1_test_key
ERROR:  Existing attribute "test" cannot be a PRIMARY KEY because it is not marked NOT NULL
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 'atacc_oid1' for table 'atacc1'
ERROR:  Existing attribute "test" cannot be a PRIMARY KEY because it is not marked NOT NULL
ERROR:  Existing attribute "test" cannot be a PRIMARY KEY because it is not marked NOT NULL
ERROR:  ALTER TABLE: column "test1" named in key does not exist
ERROR:  Existing attribute "test" cannot be a PRIMARY KEY because it is not marked NOT NULL
ERROR:  Existing attribute "test" cannot be a PRIMARY KEY because it is not marked NOT NULL
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'atacc1_pkey' for table 'atacc1'
ERROR:  Cannot insert a duplicate key into unique index atacc1_pkey
ERROR:  ExecInsert: Fail to add null value in not null attribute test
ERROR:  ALTER TABLE: relation "pg_class" is a system catalog
ERROR:  ALTER TABLE: relation "pg_class" is a system catalog
ERROR:  Relation "non_existent" does not exist
ERROR:  Relation "non_existent" does not exist
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 'atacc1_pkey' for table 'atacc1'
ERROR:  ALTER TABLE: Attribute "test" is in a primary key
ERROR:  ALTER TABLE: Attribute "test" contains NULL values
ERROR:  Relation "atacc1" has no column "bar"
ERROR:  Relation "atacc1" has no column "bar"
ERROR:  ALTER TABLE: Cannot alter system attribute "oid"
ERROR:  ALTER TABLE: Cannot alter system attribute "oid"
ERROR:  ALTER TABLE: relation "myview" is not a table
ERROR:  ALTER TABLE: relation "myview" is not a table
ERROR:  ExecInsert: Fail to add null value in not null attribute a
ERROR:  ExecInsert: Fail to add null value in not null attribute a
ERROR:  ALTER TABLE: Attribute "a" contains NULL values
ERROR:  ALTER TABLE: Attribute "a" contains NULL values
ERROR:  ExecInsert: Fail to add null value in not null attribute a
ERROR:  ExecInsert: Fail to add null value in not null attribute a
ERROR:  ExecInsert: Fail to add null value in not null attribute a
ERROR:  pg_atoi: error in "wrong_datatype": can't parse "wrong_datatype"
ERROR:  Relation "def_test" has no column "c3"
ERROR:  ALTER TABLE: relation "pg_class" is a system catalog
ERROR:  Relation "foo" does not exist
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Attribute "a" not found
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  Attribute "a" not found
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  Attribute "a" not found
ERROR:  No such attribute atacc1.a
ERROR:  Attribute "a" not found
ERROR:  Attribute "a" not found
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  No such attribute atacc1.........pg.dropped.1........
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Attribute "a" not found
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  INSERT has more expressions than target columns
ERROR:  INSERT has more expressions than target columns
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Attribute "a" not found
ERROR:  Attribute "........pg.dropped.1........" not found
ERROR:  Relation "atacc1" has no column "bar"
ERROR:  ALTER TABLE: Cannot drop system attribute "oid"
ERROR:  ALTER TABLE: relation "myview" is not a table
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  ALTER TABLE: relation "atacc1" has no column "a"
ERROR:  ALTER TABLE: relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  ALTER TABLE: relation "atacc1" has no column "a"
ERROR:  ALTER TABLE: relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  Relation "atacc1" has no column "a"
ERROR:  Relation "atacc1" has no column "........pg.dropped.1........"
ERROR:  renameatt: attribute "a" does not exist
ERROR:  renameatt: attribute "........pg.dropped.1........" does not exist
ERROR:  ALTER TABLE: column "a" named in key does not exist
ERROR:  ALTER TABLE: column "........pg.dropped.1........" named in key does not exist
ERROR:  ALTER TABLE: column "a" named in key does not exist
ERROR:  ALTER TABLE: column "........pg.dropped.1........" named in key does not exist
ERROR:  Attribute "a" not found
ERROR:  Attribute "........pg.dropped.1........" not found
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'atacc2_id_key' for table 'atacc2'
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  ALTER TABLE: column "a" referenced in foreign key constraint does not exist
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  ALTER TABLE: column "........pg.dropped.1........" referenced in foreign key constraint does not exist
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  ALTER TABLE: column "a" referenced in foreign key constraint does not exist
NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  ALTER TABLE: column "........pg.dropped.1........" referenced in foreign key constraint does not exist
ERROR:  DefineIndex: attribute "a" not found
ERROR:  DefineIndex: attribute "........pg.dropped.1........" not found
ERROR:  Relation "test" has no column "a"
ERROR:  Relation "test" has no column "........pg.dropped.1........"
ERROR:  copy: line 1, Extra data after last expected column
ERROR:  Relation "test" has no column "a"
LOG:  pq_flush: send() failed: Broken pipe
FATAL:  Socket command type 1 unknown
ERROR:  Relation "test" has no column "........pg.dropped.1........"
ERROR:  ALTER TABLE: Cannot drop inherited column "a"
ERROR:  ALTER TABLE: Cannot drop inherited column "b"
ERROR:  renameatt: inherited attribute "a" may not be renamed
ERROR:  Inherited attribute "a" must be renamed in child tables too
ERROR:  Inherited attribute "a" must be renamed in child tables too
ERROR:  Attribute must be added to child tables too
NOTICE:  CREATE TABLE: merging attribute "f1" with inherited definition
ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
ERROR:  Attribute "f1" not found
NOTICE:  Drop cascades to table c1
ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
ERROR:  Attribute "f1" not found
NOTICE:  Drop cascades to table c1
ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
NOTICE:  Drop cascades to table c1
NOTICE:  CREATE TABLE: merging attribute "f1" with inherited definition
ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
NOTICE:  Drop cascades to table c1
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "name"
ERROR:  ALTER TABLE: Cannot drop inherited column "name"
ERROR:  Relation "gc1" has no column "name"
NOTICE:  Drop cascades to table c1
NOTICE:  Drop cascades to table gc1
LOG:  smart shutdown request
LOG:  shutting down
LOG:  recycled transaction log file 0000000000000000
LOG:  recycled transaction log file 0000000000000001
LOG:  database system is shut down


horwitz@argoscomp.com (Samuel A Horwitz)