Hello
there is fix a locale dependency of regress tests
Last time I forgot to attach a patch
Regards
Pavel Stehule
*** ./src/test/regress/expected/foreign_data.out.orig 2011-10-04 13:56:41.0 +0200
--- ./src/test/regress/expected/foreign_data.out 2011-10-06 14:06:20.0 +0200
***
*** 631,637
-- CREATE FOREIGN TABLE
CREATE SCHEMA foreign_schema;
! CREATE SERVER sc FOREIGN DATA WRAPPER dummy;
CREATE FOREIGN TABLE ft1 ();-- ERROR
ERROR: syntax error at or near ;
LINE 1: CREATE FOREIGN TABLE ft1 ();
--- 631,637
-- CREATE FOREIGN TABLE
CREATE SCHEMA foreign_schema;
! CREATE SERVER s0 FOREIGN DATA WRAPPER dummy;
CREATE FOREIGN TABLE ft1 ();-- ERROR
ERROR: syntax error at or near ;
LINE 1: CREATE FOREIGN TABLE ft1 ();
***
*** 641,655
CREATE FOREIGN TABLE ft1 (c1 serial) SERVER sc; -- ERROR
NOTICE: CREATE FOREIGN TABLE will create implicit sequence ft1_c1_seq for serial column ft1.c1
ERROR: default values on foreign tables are not supported
! CREATE FOREIGN TABLE ft1 () SERVER sc WITH OIDS;-- ERROR
ERROR: syntax error at or near WITH OIDS
! LINE 1: CREATE FOREIGN TABLE ft1 () SERVER sc WITH OIDS;
^
CREATE FOREIGN TABLE ft1 (
c1 integer OPTIONS (param 1 'val1') NOT NULL,
c2 text OPTIONS (param2 'val2', param3 'val3'),
c3 date
! ) SERVER sc OPTIONS (delimiter ',', quote '', be quoted 'value');
COMMENT ON FOREIGN TABLE ft1 IS 'ft1';
COMMENT ON COLUMN ft1.c1 IS 'ft1.c1';
\d+ ft1
--- 641,655
CREATE FOREIGN TABLE ft1 (c1 serial) SERVER sc; -- ERROR
NOTICE: CREATE FOREIGN TABLE will create implicit sequence ft1_c1_seq for serial column ft1.c1
ERROR: default values on foreign tables are not supported
! CREATE FOREIGN TABLE ft1 () SERVER s0 WITH OIDS;-- ERROR
ERROR: syntax error at or near WITH OIDS
! LINE 1: CREATE FOREIGN TABLE ft1 () SERVER s0 WITH OIDS;
^
CREATE FOREIGN TABLE ft1 (
c1 integer OPTIONS (param 1 'val1') NOT NULL,
c2 text OPTIONS (param2 'val2', param3 'val3'),
c3 date
! ) SERVER s0 OPTIONS (delimiter ',', quote '', be quoted 'value');
COMMENT ON FOREIGN TABLE ft1 IS 'ft1';
COMMENT ON COLUMN ft1.c1 IS 'ft1.c1';
\d+ ft1
***
*** 659,665
c1 | integer | not null | (param 1 'val1') | plain| ft1.c1
c2 | text| | (param2 'val2', param3 'val3') | extended |
c3 | date| || plain|
! Server: sc
FDW Options: (delimiter ',', quote '', be quoted 'value')
Has OIDs: no
--- 659,665
c1 | integer | not null | (param 1 'val1') | plain| ft1.c1
c2 | text| | (param2 'val2', param3 'val3') | extended |
c3 | date| || plain|
! Server: s0
FDW Options: (delimiter ',', quote '', be quoted 'value')
Has OIDs: no
***
*** 667,673
List of foreign tables
Schema | Table | Server | FDW Options | Description
+---++-+-
! public | ft1 | sc | (delimiter ',', quote '', be quoted 'value') | ft1
(1 row)
CREATE INDEX id_ft1_c2 ON ft1 (c2); -- ERROR
--- 667,673
List of foreign tables
Schema | Table | Server | FDW Options | Description
+---++-+-
! public | ft1 | s0 | (delimiter ',', quote '', be quoted 'value') | ft1
(1 row)
CREATE INDEX id_ft1_c2 ON ft1 (c2); -- ERROR
***
*** 717,723
c8 | text| | (p2 'V2') | extended |
c9 | integer | || plain|
c10| integer | | (p1 'v1') | plain|
! Server: sc
FDW Options: (delimiter ',', quote '', be quoted 'value')
Has OIDs: no
--- 717,723
c8 | text| | (p2 'V2') | extended |
c9 | integer | || plain|
c10| integer | | (p1 'v1') | plain|
! Server: s0
FDW Options: (delimiter ',', quote '', be quoted 'value')
Has OIDs: no
***
*** 760,766
c7 | integer | | (p1 'v1', p2 'v2')
c8 | text| | (p2 'V2')
c10 | integer | | (p1 'v1')
! Server: sc
FDW Options: (quote '~', be quoted 'value', escape '@')