OSDN > Finden Software > PG-REX > SCM > git > syncrep > Commit

PG-REX
Fork

syncrep: Commit

PostgreSQL9.0用の同期レプリケーションパッチ

Set user_defined_types.data_type to null

On re-reading the standard, this field is only used for distinct or
reference types.

--- a/doc/src/sgml/information_schema.sgml

+++ b/doc/src/sgml/information_schema.sgml

		@@ -5925,11 +5925,7 @@ ORDER BY c.ordinal_position;
5925	5925	<row>
5926	5926	<entry><literal>data_type</literal></entry>
5927	5927	<entry><type>character_data</type></entry>
5928		- <entry>
5929		- Always <literal>USER-DEFINED TYPE</literal> (for joining
5930		- against <literal>object_type</literal> columns in other
5931		- views)
5932		- </entry>
	5928	+ <entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5933	5929	</row>
5934	5930
5935	5931	<row>

--- a/src/backend/catalog/information_schema.sql

+++ b/src/backend/catalog/information_schema.sql

		@@ -2198,7 +2198,7 @@ CREATE VIEW user_defined_types AS
2198	2198	CAST(null AS sql_identifier) AS ordering_routine_schema,
2199	2199	CAST(null AS sql_identifier) AS ordering_routine_name,
2200	2200	CAST(null AS character_data) AS reference_type,
2201		- CAST('USER-DEFINED TYPE' AS character_data) AS data_type,
	2201	+ CAST(null AS character_data) AS data_type,
2202	2202	CAST(null AS cardinal_number) AS character_maximum_length,
2203	2203	CAST(null AS cardinal_number) AS character_octet_length,
2204	2204	CAST(null AS sql_identifier) AS character_set_catalog,