options_patched.out
application/octet-stream
Filename: options_patched.out
Type: application/octet-stream
Part: 3
/*
* --------------------------------------------------------------------------
* Commands either completely without parameters, or without defelem or similar
* parameters which are matched using string comparisons, and thus left out of
* scope of this patch.
* --------------------------------------------------------------------------
*/
-- ABORT — abort the current transaction
-- ALTER AGGREGATE — change the definition of an aggregate function
-- ALTER COLLATION — change the definition of a collation
-- ALTER CONVERSION — change the definition of a conversion
-- ALTER DOMAIN — change the definition of a domain
-- ALTER EVENT TRIGGER — change the definition of an event trigger
-- ALTER EXTENSION — change the definition of an extension
-- ALTER LANGUAGE — change the definition of a procedural language
-- ALTER LARGE OBJECT — change the definition of a large object
-- ALTER MATERIALIZED VIEW — change the definition of a materialized view
-- ALTER OPERATOR CLASS — change the definition of an operator class
-- ALTER OPERATOR FAMILY — change the definition of an operator family
-- ALTER POLICY — change the definition of a row level security policy
-- ALTER RULE — change the definition of a rule
-- ALTER SCHEMA — change the definition of a schema
-- ALTER STATISTICS — change the definition of an extended statistics object
-- ALTER TEXT SEARCH CONFIGURATION — change the definition of a text search configuration
-- ALTER TEXT SEARCH PARSER — change the definition of a text search parser
-- ALTER TEXT SEARCH TEMPLATE — change the definition of a text search template
-- ALTER TRIGGER — change the definition of a trigger
-- ALTER TYPE — change the definition of a type
-- ANALYZE — collect statistics about a database
-- CALL — invoke a procedure
-- CHECKPOINT — force a write-ahead log checkpoint
-- CLOSE — close a cursor
-- CLUSTER — cluster a table according to an index
-- COMMENT — define or change the comment of an object
-- COMMIT — commit the current transaction
-- COMMIT PREPARED — commit a transaction that was earlier prepared for two-phase commit
-- CREATE ACCESS METHOD — define a new access method
-- CREATE CAST — define a new cast
-- CREATE CONVERSION — define a new encoding conversion
-- CREATE DOMAIN — define a new domain
-- CREATE FOREIGN TABLE — define a new foreign table
-- CREATE LANGUAGE — define a new procedural language
-- CREATE MATERIALIZED VIEW — define a new materialized view
-- CREATE OPERATOR CLASS — define a new operator class
-- CREATE POLICY — define a new row level security policy for a table
-- CREATE PROCEDURE — define a new procedure
-- CREATE RULE — define a new rewrite rule
-- CREATE SCHEMA — define a new schema
-- CREATE TRANSFORM — define a new transform
-- CREATE TRIGGER — define a new trigger
-- DEALLOCATE — deallocate a prepared statement
-- DECLARE — define a cursor
-- DELETE — delete rows of a table
-- DISCARD — discard session state
-- DO — execute an anonymous code block
-- DROP ACCESS METHOD — remove an access method
-- DROP AGGREGATE — remove an aggregate function
-- DROP CAST — remove a cast
-- DROP COLLATION — remove a collation
-- DROP CONVERSION — remove a conversion
-- DROP DATABASE — remove a database
-- DROP DOMAIN — remove a domain
-- DROP EVENT TRIGGER — remove an event trigger
-- DROP EXTENSION — remove an extension
-- DROP FOREIGN DATA WRAPPER — remove a foreign-data wrapper
-- DROP FOREIGN TABLE — remove a foreign table
-- DROP FUNCTION — remove a function
-- DROP GROUP — remove a database role
-- DROP INDEX — remove an index
-- DROP LANGUAGE — remove a procedural language
-- DROP MATERIALIZED VIEW — remove a materialized view
-- DROP OPERATOR — remove an operator
-- DROP OPERATOR CLASS — remove an operator class
-- DROP OPERATOR FAMILY — remove an operator family
-- DROP OWNED — remove database objects owned by a database role
-- DROP POLICY — remove a row level security policy from a table
-- DROP PROCEDURE — remove a procedure
-- DROP PUBLICATION — remove a publication
-- DROP ROLE — remove a database role
-- DROP ROUTINE — remove a routine
-- DROP RULE — remove a rewrite rule
-- DROP SCHEMA — remove a schema
-- DROP SEQUENCE — remove a sequence
-- DROP SERVER — remove a foreign server descriptor
-- DROP TABLE — remove a table
-- DROP TEXT SEARCH CONFIGURATION — remove a text search configuration
-- DROP TEXT SEARCH DICTIONARY — remove a text search dictionary
-- DROP TEXT SEARCH PARSER — remove a text search parser
-- DROP TEXT SEARCH TEMPLATE — remove a text search template
-- DROP TRANSFORM — remove a transform
-- DROP STATISTICS — remove extended statistics
-- DROP SUBSCRIPTION — remove a subscription
-- DROP TABLESPACE — remove a tablespace
-- DROP TRIGGER — remove a trigger
-- DROP TYPE — remove a data type
-- DROP USER — remove a database role
-- DROP VIEW — remove a view
-- END — commit the current transaction
-- EXECUTE — execute a prepared statement
-- FETCH — retrieve rows from a query using a cursor
-- GRANT — define access privileges
-- LISTEN — listen for a notification
-- LOAD — load a shared library file
-- LOCK — lock a table
-- MOVE — position a cursor
-- NOTIFY — generate a notification
-- PREPARE — prepare a statement for execution
-- PREPARE TRANSACTION — prepare the current transaction for two-phase commit
-- REASSIGN OWNED — change the ownership of database objects owned by a database role
-- REFRESH MATERIALIZED VIEW — replace the contents of a materialized view
-- REINDEX — rebuild indexes
-- RELEASE SAVEPOINT — destroy a previously defined savepoint
-- REVOKE — remove access privileges
-- ROLLBACK — abort the current transaction
-- ROLLBACK PREPARED — cancel a transaction that was earlier prepared for two-phase commit
-- ROLLBACK TO SAVEPOINT — roll back to a savepoint
-- SAVEPOINT — define a new savepoint within the current transaction
-- SECURITY LABEL — define or change a security label applied to an object
-- SET CONSTRAINTS — set constraint check timing for the current transaction
-- SET ROLE — set the current user identifier of the current session
-- TRUNCATE — empty a table or set of tables
-- UNLISTEN — stop listening for a notification
-- VACUUM — garbage-collect and optionally analyze a database
-- VALUES — compute a set of rows
/*
* --------------------------------------------------------------------------
* Commands using parameters with case insensitive matches on user input via
* reloptions
* --------------------------------------------------------------------------
*/
-- CREATE TABLESPACE — define a new tablespace
create tablespace ts1 location '/tmp/ts' with (seq_page_cost = 1);
CREATE TABLESPACE
drop tablespace ts1;
DROP TABLESPACE
create tablespace ts1 location '/tmp/ts' with (Seq_page_cost = 1);
CREATE TABLESPACE
drop tablespace ts1;
DROP TABLESPACE
create tablespace ts1 location '/tmp/ts' with ("Seq_page_cost" = 1);
psql:../11dev/defname.sql:140: ERROR: unrecognized parameter "Seq_page_cost"
create tablespace ts1 location '/tmp/ts' with ("seq_page_cost" = 1);
CREATE TABLESPACE
-- ALTER TABLESPACE — change the definition of a tablespace
alter tablespace ts1 set (seq_page_cost = 1);
ALTER TABLESPACE
alter tablespace ts1 set (Seq_page_cost = 1);
ALTER TABLESPACE
alter tablespace ts1 set ("seq_page_cost" = 1);
ALTER TABLESPACE
alter tablespace ts1 set ("Seq_page_cost" = 1);
psql:../11dev/defname.sql:146: ERROR: unrecognized parameter "Seq_page_cost"
-- CREATE TABLE AS — define a new table from the results of a query
create table tas1 with (fillfactor = 10) as select 1 a;
SELECT 1
create table tas2 with ("Fillfactor" = 10) as select 1 a;
psql:../11dev/defname.sql:149: ERROR: unrecognized parameter "Fillfactor"
-- CREATE TABLE — define a new table
create table t1 (a integer, b integer) with (oids);
CREATE TABLE
create table t2 (a integer, b integer) with (Oids);
CREATE TABLE
create table t3 (a integer, b integer) with ("oids");
CREATE TABLE
create table t4 (a integer, b integer) with ("Oids");
psql:../11dev/defname.sql:154: ERROR: unrecognized parameter "Oids"
-- ALTER TABLE — change the definition of a table
alter table t2 set (fillfactor = 10);
ALTER TABLE
alter table t2 set (Fillfactor = 10);
ALTER TABLE
alter table t2 set ("fillfactor" = "10");
ALTER TABLE
alter table t2 set ("fillfactor" = " 10 ");
ALTER TABLE
alter table t2 set ("Fillfactor" = 10);
psql:../11dev/defname.sql:160: ERROR: unrecognized parameter "Fillfactor"
alter table t2 set ("Fillfactor" = "10");
psql:../11dev/defname.sql:161: ERROR: unrecognized parameter "Fillfactor"
-- CREATE INDEX — define a new index
create index idx1 on t1 (a) with (fillfactor = 10);
CREATE INDEX
create index idx2 on t1 (a) with (Fillfactor = 10);
CREATE INDEX
create index idx3 on t1 (a) with ("fillfactor" = 10);
CREATE INDEX
create index idx4 on t1 (a) with ("Fillfactor" = 10);
psql:../11dev/defname.sql:166: ERROR: unrecognized parameter "Fillfactor"
-- ALTER INDEX — change the definition of an index
alter index idx1 set (fillfactor = 100);
ALTER INDEX
alter index idx1 set (Fillfactor = 100);
ALTER INDEX
alter index idx1 set ("fillfactor" = "100");
ALTER INDEX
alter index idx1 set ("Fillfactor" = 100);
psql:../11dev/defname.sql:171: ERROR: unrecognized parameter "Fillfactor"
-- CREATE VIEW — define a new view
create view vy1 with (check_option = local) as select 1;
psql:../11dev/defname.sql:173: ERROR: WITH CHECK OPTION is supported only on automatically updatable views
HINT: Views that do not select from a single table or view are not automatically updatable.
create view vy1 with (Check_option = Local) as select 1;
psql:../11dev/defname.sql:174: ERROR: WITH CHECK OPTION is supported only on automatically updatable views
HINT: Views that do not select from a single table or view are not automatically updatable.
create view vy1 with ("check_option" = "local") as select 1;
psql:../11dev/defname.sql:175: ERROR: WITH CHECK OPTION is supported only on automatically updatable views
HINT: Views that do not select from a single table or view are not automatically updatable.
create view vy1 with ("Check_option" = "Local") as select 1;
psql:../11dev/defname.sql:176: ERROR: unrecognized parameter "Check_option"
create view vy1 with (check_option = local) as select a from t1;
CREATE VIEW
-- ALTER VIEW — change the definition of a view
alter view vy1 set (check_option = local);
ALTER VIEW
alter view vy1 set (Check_option = local);
ALTER VIEW
alter view vy1 set ("check_option" = "local");
ALTER VIEW
alter view vy1 set ("check_option" = "Local");
psql:../11dev/defname.sql:182: ERROR: invalid value for "check_option" option
DETAIL: Valid values are "local" and "cascaded".
alter view vy1 set ("Check_option" = "Local");
psql:../11dev/defname.sql:183: ERROR: unrecognized parameter "Check_option"
/*
* --------------------------------------------------------------------------
* Commands using parameters with case insensitive matches on user input
* --------------------------------------------------------------------------
*/
-- ALTER SYSTEM — change a server configuration parameter
alter system set wal_level = replica;
ALTER SYSTEM
alter system set Wal_level = Replica;
ALTER SYSTEM
alter system set "wal_level" = "replica";
ALTER SYSTEM
alter system set "Wal_level" = "Replica";
ALTER SYSTEM
-- CREATE AGGREGATE — define a new aggregate function
-- Old syntax
create aggregate agg1 (sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond1 = '0', parallel = safe);
CREATE AGGREGATE
create aggregate agg2 (sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond1 = '0', "parallel" = safe);
CREATE AGGREGATE
create aggregate agg3 ("sfunc1" = int4pl, "basetype" = int4, "stype1" = int4, "initcond1" = '0', "parallel" = safe);
CREATE AGGREGATE
create aggregate agg4 ("Sfunc1" = int4pl, "Basetype" = int4, "Stype1" = int4, "Initcond1" = '0', "Parallel" = safe);
psql:../11dev/defname.sql:203: WARNING: aggregate attribute "Sfunc1" not recognized
psql:../11dev/defname.sql:203: WARNING: aggregate attribute "Basetype" not recognized
psql:../11dev/defname.sql:203: WARNING: aggregate attribute "Stype1" not recognized
psql:../11dev/defname.sql:203: WARNING: aggregate attribute "Initcond1" not recognized
psql:../11dev/defname.sql:203: WARNING: aggregate attribute "Parallel" not recognized
psql:../11dev/defname.sql:203: ERROR: aggregate stype must be specified
-- New syntax
create aggregate agg5(float8) (stype = internal, sfunc = ordered_set_transition, finalfunc = percentile_disc_final, finalfunc_extra = true, finalfunc_modify = read_write, parallel = safe);
psql:../11dev/defname.sql:205: ERROR: function percentile_disc_final(internal, double precision) does not exist
create aggregate agg6(float8) (Stype = internal, Sfunc = ordered_set_transition, Finalfunc = percentile_disc_final, Finalfunc_Extra = true, Finalfunc_Modify = read_write, Parallel = safe);
psql:../11dev/defname.sql:206: ERROR: function percentile_disc_final(internal, double precision) does not exist
create aggregate agg7(float8) ("stype" = internal, "sfunc" = ordered_set_transition, "finalfunc" = percentile_disc_final, "finalfunc_extra" = true, "finalfunc_modify" = read_write, "parallel" = safe);
psql:../11dev/defname.sql:207: ERROR: function percentile_disc_final(internal, double precision) does not exist
create aggregate agg8(float8) ("Stype" = internal, "Sfunc" = ordered_set_transition, "Finalfunc" = percentile_disc_final, "Finalfunc_extra" = true, "Finalfunc_modify" = read_write, "Parallel" = safe);
psql:../11dev/defname.sql:208: WARNING: aggregate attribute "Stype" not recognized
psql:../11dev/defname.sql:208: WARNING: aggregate attribute "Sfunc" not recognized
psql:../11dev/defname.sql:208: WARNING: aggregate attribute "Finalfunc" not recognized
psql:../11dev/defname.sql:208: WARNING: aggregate attribute "Finalfunc_extra" not recognized
psql:../11dev/defname.sql:208: WARNING: aggregate attribute "Finalfunc_modify" not recognized
psql:../11dev/defname.sql:208: WARNING: aggregate attribute "Parallel" not recognized
psql:../11dev/defname.sql:208: ERROR: aggregate stype must be specified
-- CREATE COLLATION — define a new collation
create collation coll1 (lc_collate = "POSIX", lc_ctype = "POSIX" );
CREATE COLLATION
create collation coll2 (Lc_Collate = "POSIX", Lc_Ctype = "POSIX" );
CREATE COLLATION
create collation coll3 ("lc_collate" = "POSIX", "lc_ctype" = "POSIX" );
CREATE COLLATION
create collation coll4 ("Lc_Collate" = "POSIX", "Lc_Ctype" = "POSIX" );
psql:../11dev/defname.sql:214: ERROR: collation attribute "Lc_Collate" not recognized
LINE 1: create collation coll4 ("Lc_Collate" = "POSIX", "Lc_Ctype" =...
^
-- CREATE FUNCTION — define a new function
-- The VOLATILE keyword is a hardcoded defelem, while the parameters in the
-- with() clause are parsed with the IDENT rule
create function func1 (integer) returns void as $$ begin return; end; $$ language plpgsql immutable with (iscachable, isstrict);
CREATE FUNCTION
create function func2 (integer) returns void as $$ begin return; end; $$ language plpgsql Immutable with (isCachable, isStrict);
CREATE FUNCTION
create function func3 (integer) returns void as $$ begin return; end; $$ language plpgsql IMMUTABLE with ("isCachable", "isStrict");
CREATE FUNCTION
create function func4 (integer) returns void as $$ begin return; end; $$ language plpgsql immutable with ("iscachable", "isstrict");
CREATE FUNCTION
-- CREATE OPERATOR — define a new operator
CREATE OPERATOR === (leftarg = box, rightarg = box, procedure = area_equal_procedure, commutator = ===, negator = !==, restrict = area_restriction_procedure, join = area_join_procedure, hashes, merges);
psql:../11dev/defname.sql:225: ERROR: function area_equal_procedure(box, box) does not exist
CREATE OPERATOR === (Leftarg = box, Rightarg = box, Procedure = area_equal_procedure, Commutator = ===, Negator = !==, Restrict = area_restriction_procedure, Join = area_join_procedure, Hashes, Merges);
psql:../11dev/defname.sql:226: ERROR: function area_equal_procedure(box, box) does not exist
CREATE OPERATOR === ("leftarg" = box, "rightarg" = box, "procedure" = area_equal_procedure, "commutator" = ===, "negator" = !==, "restrict" = area_restriction_procedure, "join" = area_join_procedure, "hashes", "merges");
psql:../11dev/defname.sql:227: ERROR: function area_equal_procedure(box, box) does not exist
CREATE OPERATOR === ("Leftarg" = box, "Rightarg" = box, "Procedure" = area_equal_procedure, "Commutator" = ===, "Negator" = !==, "Restrict" = area_restriction_procedure, "Join" = area_join_procedure, "Hashes", "Merges");
psql:../11dev/defname.sql:228: WARNING: operator attribute "Leftarg" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Rightarg" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Procedure" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Commutator" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Negator" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Restrict" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Join" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Hashes" not recognized
psql:../11dev/defname.sql:228: WARNING: operator attribute "Merges" not recognized
psql:../11dev/defname.sql:228: ERROR: operator procedure must be specified
-- ALTER OPERATOR — change the definition of an operator
ALTER OPERATOR & (bit, bit) SET (restrict = _int_contsel, join = _int_contjoinsel);
psql:../11dev/defname.sql:230: ERROR: function _int_contsel(internal, oid, internal, integer) does not exist
ALTER OPERATOR & (bit, bit) SET (Restrict = _int_contsel, Join = _int_contjoinsel);
psql:../11dev/defname.sql:231: ERROR: function _int_contsel(internal, oid, internal, integer) does not exist
ALTER OPERATOR & (bit, bit) SET ("restrict" = _int_contsel, "Join" = _int_contjoinsel);
psql:../11dev/defname.sql:232: ERROR: operator attribute "Join" not recognized
ALTER OPERATOR & (bit, bit) SET ("Restrict" = _int_contsel, "Join" = _int_contjoinsel);
psql:../11dev/defname.sql:233: ERROR: operator attribute "Restrict" not recognized
-- CREATE TYPE — define a new data type
create function int42_in(cstring) returns int42 as 'int4in' language internal strict immutable with (iscachable, isstrict);
psql:../11dev/defname.sql:236: NOTICE: type "int42" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
create function int42_out(int42) returns cstring as 'int4out' language internal strict immutable;
psql:../11dev/defname.sql:237: NOTICE: argument type int42 is only a shell
CREATE FUNCTION
create type int42 (internallength = 4, input = int42_in, output = int42_out, alignment = int4, default = 42, passedbyvalue);
CREATE TYPE
drop type int42 cascade;
psql:../11dev/defname.sql:239: NOTICE: drop cascades to 2 other objects
DETAIL: drop cascades to function int42_in(cstring)
drop cascades to function int42_out(int42)
DROP TYPE
-- ---
create function int42_in(cstring) returns int42 as 'int4in' language internal strict immutable with (iscachable, isstrict);
psql:../11dev/defname.sql:241: NOTICE: type "int42" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
create function int42_out(int42) returns cstring as 'int4out' language internal strict immutable;
psql:../11dev/defname.sql:242: NOTICE: argument type int42 is only a shell
CREATE FUNCTION
create type int42 (Internallength = 4, Input = int42_in, Output = int42_out, Alignment = int4, Default = 42, Passedbyvalue);
CREATE TYPE
drop type int42 cascade;
psql:../11dev/defname.sql:244: NOTICE: drop cascades to 2 other objects
DETAIL: drop cascades to function int42_in(cstring)
drop cascades to function int42_out(int42)
DROP TYPE
-- ---
create function int42_in(cstring) returns int42 as 'int4in' language internal strict immutable with (iscachable, isstrict);
psql:../11dev/defname.sql:246: NOTICE: type "int42" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
create function int42_out(int42) returns cstring as 'int4out' language internal strict immutable;
psql:../11dev/defname.sql:247: NOTICE: argument type int42 is only a shell
CREATE FUNCTION
create type int42 ("internallength" = 4, "input" = int42_in, "output" = int42_out, "alignment" = int4, "default" = 42, "passedbyvalue");
CREATE TYPE
drop type int42 cascade;
psql:../11dev/defname.sql:249: NOTICE: drop cascades to 2 other objects
DETAIL: drop cascades to function int42_in(cstring)
drop cascades to function int42_out(int42)
DROP TYPE
-- ---
create function int42_in(cstring) returns int42 as 'int4in' language internal strict immutable with (iscachable, isstrict);
psql:../11dev/defname.sql:251: NOTICE: type "int42" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
create function int42_out(int42) returns cstring as 'int4out' language internal strict immutable;
psql:../11dev/defname.sql:252: NOTICE: argument type int42 is only a shell
CREATE FUNCTION
create type int42 ("Internallength" = 4, "Input" = int42_in, "Output" = int42_out, "Alignment" = int4, "Default" = 42, "Passedbyvalue");
psql:../11dev/defname.sql:253: WARNING: type attribute "Internallength" not recognized
LINE 1: create type int42 ("Internallength" = 4, "Input" = int42_in,...
^
psql:../11dev/defname.sql:253: WARNING: type attribute "Input" not recognized
LINE 1: create type int42 ("Internallength" = 4, "Input" = int42_in,...
^
psql:../11dev/defname.sql:253: WARNING: type attribute "Output" not recognized
LINE 1: ... int42 ("Internallength" = 4, "Input" = int42_in, "Output" =...
^
psql:../11dev/defname.sql:253: WARNING: type attribute "Alignment" not recognized
LINE 1: ...h" = 4, "Input" = int42_in, "Output" = int42_out, "Alignment...
^
psql:../11dev/defname.sql:253: WARNING: type attribute "Default" not recognized
LINE 1: ...t42_in, "Output" = int42_out, "Alignment" = int4, "Default" ...
^
psql:../11dev/defname.sql:253: WARNING: type attribute "Passedbyvalue" not recognized
LINE 1: ... = int42_out, "Alignment" = int4, "Default" = 42, "Passedbyv...
^
psql:../11dev/defname.sql:253: ERROR: type input function must be specified
drop type int42 cascade;
psql:../11dev/defname.sql:254: NOTICE: drop cascades to 2 other objects
DETAIL: drop cascades to function int42_in(cstring)
drop cascades to function int42_out(int42)
DROP TYPE
-- CREATE TEXT SEARCH CONFIGURATION — define a new text search configuration
create text search configuration tsconf1 (copy = english);
CREATE TEXT SEARCH CONFIGURATION
create text search configuration tsconf2 (Copy = english);
CREATE TEXT SEARCH CONFIGURATION
create text search configuration tsconf3 ("copy" = english);
CREATE TEXT SEARCH CONFIGURATION
create text search configuration tsconf4 ("Copy" = english);
psql:../11dev/defname.sql:260: ERROR: text search configuration parameter "Copy" not recognized
-- CREATE TEXT SEARCH DICTIONARY — define a new text search dictionary
create text search dictionary tsdict1 (template = ispell, dictfile = ispell_sample, afffile = ispell_sample);
CREATE TEXT SEARCH DICTIONARY
create text search dictionary tsdict2 (Template = ispell, DictFile = ispell_sample, AffFile = ispell_sample);
CREATE TEXT SEARCH DICTIONARY
create text search dictionary tsdict3 ("template" = ispell, "dictfile" = ispell_sample, "afffile" = ispell_sample);
CREATE TEXT SEARCH DICTIONARY
create text search dictionary tsdict4 ("Template" = ispell, "DictFile" = ispell_sample, "AffFile" = ispell_sample);
psql:../11dev/defname.sql:266: ERROR: text search template is required
-- ALTER TEXT SEARCH DICTIONARY — change the definition of a text search dictionary
alter text search dictionary tsdict1 (dictfile = ispell_sample);
ALTER TEXT SEARCH DICTIONARY
alter text search dictionary tsdict1 (Dictfile = ispell_sample);
ALTER TEXT SEARCH DICTIONARY
alter text search dictionary tsdict1 ("dictfile" = ispell_sample);
ALTER TEXT SEARCH DICTIONARY
alter text search dictionary tsdict1 ("Dictfile" = ispell_sample);
psql:../11dev/defname.sql:271: ERROR: unrecognized Ispell parameter: "Dictfile"
-- CREATE TEXT SEARCH PARSER — define a new text search parser
create text search parser tspars1 (start = start_function);
psql:../11dev/defname.sql:274: ERROR: function start_function(internal, integer) does not exist
create text search parser tspars1 (Start = start_function);
psql:../11dev/defname.sql:275: ERROR: function start_function(internal, integer) does not exist
create text search parser tspars1 ("start" = start_function);
psql:../11dev/defname.sql:276: ERROR: function start_function(internal, integer) does not exist
create text search parser tspars1 ("Start" = start_function);
psql:../11dev/defname.sql:277: ERROR: text search parser parameter "Start" not recognized
-- CREATE TEXT SEARCH TEMPLATE — define a new text search template
create text search template tstemp1 (init = init_function);
psql:../11dev/defname.sql:280: ERROR: function init_function(internal) does not exist
create text search template tstemp1 (Init = init_function);
psql:../11dev/defname.sql:281: ERROR: function init_function(internal) does not exist
create text search template tstemp1 ("init" = init_function);
psql:../11dev/defname.sql:282: ERROR: function init_function(internal) does not exist
create text search template tstemp1 ("Init" = init_function);
psql:../11dev/defname.sql:283: ERROR: text search template parameter "Init" not recognized
-- SET — change a run-time parameter
set search_path to public;
SET
set Search_path to public;
SET
set "search_path" to public;
SET
set "Search_path" to public;
SET
set search_path to "Public";
SET
-- RESET — restore the value of a run-time parameter to the default value
reset search_path;
RESET
reset Search_path;
RESET
reset "Search_path";
RESET
-- SHOW — show the value of a run-time parameter
show geqo;
geqo
------
on
(1 row)
show Geqo;
geqo
------
on
(1 row)
show "geqo";
geqo
------
on
(1 row)
show "Geqo";
geqo
------
on
(1 row)
/*
* --------------------------------------------------------------------------
* Commands using parameters with case sensitive matches on user input
* --------------------------------------------------------------------------
*/
-- CREATE DATABASE — create a new database
create database db1 with lc_collate 'sv_SE.iso885915' lc_ctype 'sv_SE.iso885915' encoding LATIN9 template template0;
psql:../11dev/defname.sql:310: ERROR: invalid locale name: "sv_SE.iso885915"
create database db2 with Lc_Collate 'sv_SE.iso885915' Lc_Ctype 'sv_SE.iso885915' Encoding LATIN9 Template template0;
psql:../11dev/defname.sql:311: ERROR: invalid locale name: "sv_SE.iso885915"
create database db3 with "lc_collate" 'sv_SE.iso885915' "lc_ctype" 'sv_SE.iso885915' "encoding" LATIN9 "template" template0;
psql:../11dev/defname.sql:312: ERROR: invalid locale name: "sv_SE.iso885915"
create database db4 with "Lc_Collate" 'sv_SE.iso885915' "Lc_Ctype" 'sv_SE.iso885915' "Encoding" LATIN9 "Template" template0;
psql:../11dev/defname.sql:313: ERROR: option "Lc_Collate" not recognized
LINE 1: create database db4 with "Lc_Collate" 'sv_SE.iso885915' "Lc_...
^
-- ALTER DATABASE — change a database
alter database db1 with allow_connections = true connection limit = 10;
psql:../11dev/defname.sql:316: ERROR: database "db1" does not exist
alter database db1 with Allow_Connections = true Connection Limit = 10;
psql:../11dev/defname.sql:317: ERROR: database "db1" does not exist
alter database db1 with "allow_connections" = true "connection limit" = 10;
psql:../11dev/defname.sql:318: ERROR: option "connection limit" not recognized
LINE 1: ...lter database db1 with "allow_connections" = true "connectio...
^
alter database db2 with "Allow_Connections" = true "Connection Limit" = 10; -- ERROR
psql:../11dev/defname.sql:319: ERROR: option "Allow_Connections" not recognized
LINE 1: alter database db2 with "Allow_Connections" = true "Connecti...
^
-- CREATE EVENT TRIGGER — define a new event trigger
create function tf1() returns event_trigger as $$ begin return; end $$ language plpgsql;
CREATE FUNCTION
create event trigger et1 on ddl_command_start when tag in ('create table', 'CREATE FUNCTION') execute procedure tf1();
CREATE EVENT TRIGGER
create event trigger et2 on ddl_command_start when Tag in ('create table', 'CREATE FUNCTION') execute procedure tf1();
CREATE EVENT TRIGGER
create event trigger et3 on ddl_command_start when "tag" in ('create table', 'CREATE FUNCTION') execute procedure tf1();
CREATE EVENT TRIGGER
create event trigger et4 on ddl_command_start when "Tag" in ('create table', 'CREATE FUNCTION') execute procedure tf1(); -- ERROR
psql:../11dev/defname.sql:326: ERROR: unrecognized filter variable "Tag"
-- CREATE OPERATOR FAMILY — define a new operator family
create operator family opfam1 using btree;
CREATE OPERATOR FAMILY
create operator family opfam2 using Btree;
CREATE OPERATOR FAMILY
create operator family opfam3 using "btree";
CREATE OPERATOR FAMILY
create operator family opfam4 using "Btree"; -- ERROR
psql:../11dev/defname.sql:332: ERROR: access method "Btree" does not exist
-- CREATE PUBLICATION — define a new publication
create table t (a integer);
CREATE TABLE
create publication pub1 for table t with (publish = 'insert');
CREATE PUBLICATION
create publication pub2 for table t with (Publish = 'insert');
CREATE PUBLICATION
create publication pub3 for table t with ("publish" = 'insert');
CREATE PUBLICATION
create publication pub4 for table t with ("Publish" = 'insert'); -- ERROR
psql:../11dev/defname.sql:339: ERROR: unrecognized publication parameter: Publish
-- ALTER PUBLICATION — change the definition of a publication
alter publication pub1 set (publish = 'insert');
ALTER PUBLICATION
alter publication pub1 set (Publish = 'insert');
ALTER PUBLICATION
alter publication pub1 set ("publish" = 'insert');
ALTER PUBLICATION
alter publication pub1 set ("Publish" = 'insert'); -- ERROR
psql:../11dev/defname.sql:344: ERROR: unrecognized publication parameter: Publish
-- CREATE SUBSCRIPTION — define a new subscription
create subscription sub1 connection 'dbname=doesnotexist' publication testpub with (connect = false, enabled = false, synchronous_commit = off);
psql:../11dev/defname.sql:347: WARNING: tables were not subscribed, you will have to run ALTER SUBSCRIPTION ... REFRESH PUBLICATION to subscribe the tables
CREATE SUBSCRIPTION
create subscription sub2 connection 'dbname=doesnotexist' publication testpub with (Connect = false, Enabled = false, Synchronous_commit = off);
psql:../11dev/defname.sql:348: WARNING: tables were not subscribed, you will have to run ALTER SUBSCRIPTION ... REFRESH PUBLICATION to subscribe the tables
CREATE SUBSCRIPTION
create subscription sub3 connection 'dbname=doesnotexist' publication testpub with ("connect" = false, "enabled" = false, "synchronous_commit" = off);
psql:../11dev/defname.sql:349: WARNING: tables were not subscribed, you will have to run ALTER SUBSCRIPTION ... REFRESH PUBLICATION to subscribe the tables
CREATE SUBSCRIPTION
create subscription sub4 connection 'dbname=doesnotexist' publication testpub with ("Connect" = false, "Enabled" = false, "Synchronous_commit" = off); -- ERROR
psql:../11dev/defname.sql:350: ERROR: unrecognized subscription parameter: Connect
-- ALTER SUBSCRIPTION — change the definition of a subscription
alter subscription sub1 set (synchronous_commit = off);
ALTER SUBSCRIPTION
alter subscription sub1 set (Synchronous_commit = off);
ALTER SUBSCRIPTION
alter subscription sub1 set ("synchronous_commit" = off);
ALTER SUBSCRIPTION
alter subscription sub1 set ("Synchronous_commit" = off); -- ERROR
psql:../11dev/defname.sql:355: ERROR: unrecognized subscription parameter: Synchronous_commit
-- CREATE STATISTICS — define extended statistics
-- The statistics_kind parameter is case sensitive, but it's not actually a
-- defelem but is parsed with the name_list rule coming via via makeString()
create table tt (a integer, b integer);
CREATE TABLE
create statistics stat1 (dependencies) on a,b from tt;
CREATE STATISTICS
create statistics stat2 (Dependencies) on a,b from tt;
CREATE STATISTICS
create statistics stat3 ("dependencies") on a,b from tt;
CREATE STATISTICS
create statistics stat4 ("Dependencies") on a,b from tt; -- ERROR
psql:../11dev/defname.sql:364: ERROR: unrecognized statistics kind "Dependencies"
-- COPY — copy data between a file and a table
copy tt to '/tmp/tt' with (format csv);
COPY 0
copy tt to '/tmp/tt' with (Format csv);
COPY 0
copy tt to '/tmp/tt' with ("format" csv);
COPY 0
copy tt to '/tmp/tt' with ("Format" csv); -- ERROR
psql:../11dev/defname.sql:370: ERROR: option "Format" not recognized
LINE 1: copy tt to '/tmp/tt' with ("Format" csv);
^
-- EXPLAIN — show the execution plan of a statement
explain (analyze, buffers) select 1;
QUERY PLAN
------------------------------------------------------------------------------------
Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)
Planning time: 0.021 ms
Execution time: 0.027 ms
(3 rows)
explain (analyze, Buffers) select 1;
QUERY PLAN
------------------------------------------------------------------------------------
Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)
Planning time: 0.013 ms
Execution time: 0.015 ms
(3 rows)
explain (analyze, "buffers") select 1;
QUERY PLAN
------------------------------------------------------------------------------------
Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)
Planning time: 0.013 ms
Execution time: 0.012 ms
(3 rows)
explain (analyze, "Buffers") select 1; -- ERROR
psql:../11dev/defname.sql:376: ERROR: unrecognized EXPLAIN option "Buffers"
LINE 1: explain (analyze, "Buffers") select 1;
^
-- SET SESSION AUTHORIZATION — set the session user identifier and the current user identifier of the current session
create user myuser;
CREATE ROLE
set session authorization myuser;
SET
set session authorization Myuser;
SET
set session authorization "myuser";
SET
set session authorization "Myuser"; -- ERROR
psql:../11dev/defname.sql:383: ERROR: role "Myuser" does not exist
/*
* --------------------------------------------------------------------------
* Commands using parameters with case sensitive matches on hardcoded defelem
* entries from the parser
* --------------------------------------------------------------------------
*/
-- ALTER DEFAULT PRIVILEGES — define default access privileges
-- ALTER FUNCTION — change the definition of a function
-- ALTER GROUP — change role name or membership
-- ALTER PROCEDURE — change the definition of a procedure
-- ALTER ROLE — change a database role
-- ALTER ROUTINE — change the definition of a routine
-- ALTER SEQUENCE — change the definition of a sequence generator
-- ALTER USER — change a database role
-- BEGIN — start a transaction block
-- CREATE EXTENSION — install an extension
-- CREATE GROUP — define a new database role
-- CREATE ROLE — define a new database role
-- CREATE SEQUENCE — define a new sequence generator
-- CREATE USER — define a new database role
-- SET TRANSACTION — set the characteristics of the current transaction
-- START TRANSACTION — start a transaction block
/*
* --------------------------------------------------------------------------
* DML commands not considered in this patch.
* --------------------------------------------------------------------------
*/
-- INSERT — create new rows in a table
-- SELECT — retrieve rows from a table or view
-- SELECT INTO — define a new table from the results of a query
-- UPDATE — update rows of a table
/*
* --------------------------------------------------------------------------
* SQL/MED commands which perform where matching against the options defined
* is performed in the FDW extension, postgres_fdw is performing case sensitive
* matching but each external module is free to do whichever. 'handler' and
* 'validator' are hardcoded defelem parameters handled by the foreign command
* code.
* --------------------------------------------------------------------------
*/
create extension postgres_fdw;
psql:../11dev/defname.sql:430: ERROR: permission denied to create extension "postgres_fdw"
HINT: Must be superuser to create this extension.
-- CREATE FOREIGN DATA WRAPPER — define a new foreign-data wrapper
-- ALTER FOREIGN DATA WRAPPER — change the definition of a foreign-data wrapper
-- ALTER FOREIGN TABLE — change the definition of a foreign table
-- ALTER USER MAPPING — change the definition of a user mapping
-- CREATE SERVER — define a new foreign server
CREATE SERVER fs1 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', dbname 'foodb', port '5432');
psql:../11dev/defname.sql:436: ERROR: foreign-data wrapper "postgres_fdw" does not exist
CREATE SERVER fs2 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', DBname 'foodb', port '5432');
psql:../11dev/defname.sql:437: ERROR: foreign-data wrapper "postgres_fdw" does not exist
CREATE SERVER fs3 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', "dbname" 'foodb', port '5432');
psql:../11dev/defname.sql:438: ERROR: foreign-data wrapper "postgres_fdw" does not exist
CREATE SERVER fs4 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'foo', "DBname" 'foodb', port '5432');
psql:../11dev/defname.sql:439: ERROR: foreign-data wrapper "postgres_fdw" does not exist
-- ALTER SERVER — change the definition of a foreign server
-- CREATE USER MAPPING — define a new mapping of a user to a foreign server
-- DROP USER MAPPING — remove a user mapping for a foreign server
-- IMPORT FOREIGN SCHEMA — import table definitions from a foreign server