pg_regress: rowtypes.sql : An update having references like column.* generates

ERROR:  Cannot generate remote UPDATE plan. Since we are not going to fix the
issue in release 1.0, this commit accommodates this ERROR message in
rowtypes_1.out so as to make the test pass. rowtypes_1.out also had some old
changes which are not required now, so removed those.

1 files changed, 7 insertions, 11 deletions

diff --git a/src/test/regress/expected/rowtypes_1.out b/src/test/regress/expected/rowtypes_1.out
index 574dc4c21f..bcce748459 100644
--- a/src/test/regress/expected/rowtypes_1.out
+++ b/src/test/regress/expected/rowtypes_1.out
@@ -103,14 +103,14 @@ select * from people;
  (Joe,Blow,Jr) | 01-10-1984
 (1 row)
 
---- PGXCTODO: This test case makes a server crash due to query deparsing in planner
---- insert into quadtable (f1, q.c1.r, q.c2.i) values(44,55,66);
+insert into quadtable (f1, q.c1.r, q.c2.i) values(44,55,66);
 select * from quadtable order by f1, q;
  f1 |             q             
 ----+---------------------------
   1 | ("(3.3,4.4)","(5.5,6.6)")
   2 | ("(,4.4)","(5.5,6.6)")
-(2 rows)
+ 44 | ("(55,)","(,66)")
+(3 rows)
 
 -- The object here is to ensure that toasted references inside
 -- composite values don't cause problems.  The large f1 value will
@@ -307,32 +307,28 @@ CREATE TABLE price (
     active BOOLEAN NOT NULL,
     price NUMERIC
 );
-ERROR:  Postgres-XC does not support SERIAL yet
-DETAIL:  The feature is not currently supported
+NOTICE:  CREATE TABLE will create implicit sequence "price_id_seq" for serial column "price.id"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "price_pkey" for table "price"
 CREATE TYPE price_input AS (
     id INTEGER,
     price NUMERIC
 );
-ERROR:  current transaction is aborted, commands ignored until end of transaction block
 CREATE TYPE price_key AS (
     id INTEGER
 );
-ERROR:  current transaction is aborted, commands ignored until end of transaction block
 CREATE FUNCTION price_key_from_table(price) RETURNS price_key AS $$
     SELECT $1.id
 $$ LANGUAGE SQL;
-ERROR:  current transaction is aborted, commands ignored until end of transaction block
 CREATE FUNCTION price_key_from_input(price_input) RETURNS price_key AS $$
     SELECT $1.id
 $$ LANGUAGE SQL;
-ERROR:  current transaction is aborted, commands ignored until end of transaction block
 insert into price values (1,false,42), (10,false,100), (11,true,17.99);
-ERROR:  current transaction is aborted, commands ignored until end of transaction block
 UPDATE price
     SET active = true, price = input_prices.price
     FROM unnest(ARRAY[(10, 123.00), (11, 99.99)]::price_input[]) input_prices
     WHERE price_key_from_table(price.*) = price_key_from_input(input_prices.*);
-ERROR:  current transaction is aborted, commands ignored until end of transaction block
+ERROR:  Cannot generate remote UPDATE plan
+DETAIL:  This relation rowtype cannot be fetched
 select * from price;
 ERROR:  current transaction is aborted, commands ignored until end of transaction block
 rollback;