2107 pgbouncer-admin 2107 Synopsis 2107 Description 2107 Options 2108 Command Syntax 2108 Administration Commands 2108 SHOW Command 2109 CLIENTS 2110 VMware Greenplum 6 Documentation VMware, Inc Backup/restore storage plugin API Server Documentation Tanzu Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security structures. Greenplum now eliminates alien nodes before execution for entry db. 13997 The psql command \d+ now shows correct index information for append-only auxiliary tables. 13739 Resolves an issue where

2157 pgbouncer-admin 2157 Synopsis 2157 Description 2157 Options 2157 Command Syntax 2157 Administration Commands 2158 SHOW Command 2159 CLIENTS 2160 CONFIG 2160 DATABASES 2161 DNS_HOSTS 2161 Extension Framework (PXF) Server Documentation VMware Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security or gpstate would fail if the MASTER_DATA_DIRECTORY environment variable was not set, even if the -d option was specified to provide the directory. 16356 The gpcheckperf utility was changed to ensure

2031 pgbouncer-admin 2031 Synopsis 2032 Description 2032 Options 2032 Command Syntax 2032 Administration Commands 2032 SHOW Command 2034 CLIENTS 2034 CONFIG 2035 DATABASES 2035 DNS_HOSTS 2036 Backup/restore storage plugin API Server Documentation Tanzu Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security structures. Greenplum now eliminates alien nodes before execution for entry db. 13997 The psql command \d+ now shows correct index information for append-only auxiliary tables. 13739 Resolves an issue where

2114 pgbouncer-admin 2114 Synopsis 2114 Description 2114 Options 2114 Command Syntax 2114 Administration Commands 2115 SHOW Command 2116 CLIENTS 2117 CONFIG 2117 DATABASES 2117 DNS_HOSTS 2118 Backup/restore storage plugin API Server Documentation VMware Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security or gpstate would fail if the MASTER_DATA_DIRECTORY environment variable was not set, even if the -d option was specified to provide the directory. 16356 The gpcheckperf utility was changed to ensure

AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+———+— 1 | [1,2,3] | json_to_recordset(json) jsonb_to_recordset(jsonb) setof record Builds AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+———+— 1 | [1,2,3] | json_to_recordset(json) jsonb_to_recordset(jsonb) setof record Builds 2038 pgbouncer-admin 2038 Synopsis 2038 Description 2038 Options 2038 Command Syntax 2039 Administration Commands 2039 SHOW Command 2040 CLIENTS 2041 CONFIG 2042 DATABASES 2042 DNS_HOSTS 2042

the Notes. select * from json_populate_record(null::myrowtype, ‘{“a”: 1, “b”: [“2”, “a b”], “c”: {“d”: 4, “e”: “a b c”}}’) a | b | c —+———–+————- 1 | {2,“a b”} | (4,“a b c”) json_populate_recordset(base “c”:[1,2,3],“e”:“bar”,“r”: {“a”: 123, “b”: “a b c”}}’) as x(a int, b text, c int[], d text, r myrowtype) a | b | c | d | r —+———+———+—+————— 1 | [1,2,3] | {1,2,3} | | (123,“a b c”) json_to_recordset(json) Extension Framework (PXF) Server Documentation VMware Greenplum server installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security

to hundreds of terabytes. Server Documentation Tanzu Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security errors that it encounter s while loading data: d a t a t y p e p a r s i n g e r r o r s u n e x p e c t e d v a l u VMware Greenplum v6.17 Documentation VMware Inc. 155 e t y p e e r r o r s d a t a t y p e c o n v e r s i o n e r r o r s e r r o r s r e t u r n e d b y n a ti v e a n VMware Greenplum

Backup/restore storage plugin API Server Documentation Tanzu Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security server instances in the cluster. See Restarting PXF. The pxf [cluster] sync command now recognizes a [-d | --delete] option. When specified, PXF deletes files on the remote host(s) that are not present in the utility cannot acquire shared table locks within the specified number of milliseconds. The -d and -D command-line options are removed from the pg_dump and pg_dumpall utilities. The corresponding long

Backup/restore storage plugin API Server Documentation Tanzu Greenplum installation, configuration, administration, and maintenance information: Release Notes Installation Guide Administrator Guide Security server instances in the cluster. See Restarting PXF. The pxf [cluster] sync command now recognizes a [-d | --delete] option. When specified, PXF deletes files on the remote host(s) that are not present in the utility cannot acquire shared table locks within the specified number of milliseconds. The -d and -D command-line options are removed from the pg_dump and pg_dumpall utilities. The corresponding long

AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+ ———+— 1 | [1,2,3] | json_to_recordset(json) jsonb_to_recordset(jsonb) setof record Builds AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+ ———+— 1 | [1,2,3] | json_to_recordset(json) jsonb_to_recordset(jsonb) setof record Builds 1795 pgbouncer-admin 1795 Synopsis 1795 Description 1796 Options 1796 Command Syntax 1796 Administration Commands 1796 SHOW Command 1797 CLIENTS 1798 CONFIG 1799 DATABASES 1799 DNS_HOSTS 1799