From 6a7273e14c4df53f5aba191132699ce217901958 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 2 Nov 2002 02:33:03 +0000 Subject: Fix permissions-checking bugs and namespace-search-path bugs in CONVERSION code. Still need to figure out what to do about inappropriate coding in parsing. --- doc/src/sgml/ref/create_conversion.sgml | 31 ++++++++++++------------------- 1 file changed, 12 insertions(+), 19 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 20abdf3bd48..bf8ec00ff7b 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,4 +1,4 @@ - + @@ -14,8 +14,7 @@ CREATE [DEFAULT] CONVERSION conversion_name - FOR source_encoding - TO dest_encoding FROM funcname + FOR source_encoding TO dest_encoding FROM funcname @@ -24,18 +23,16 @@ CREATE [DEFAULT] CONVERSION conversion_name CREATE CONVERSION defines a new encoding - conversion. There are two kinds of conversions. A default - conversion is used for an automatic encoding conversion between - frontend and backend. There should be only one default conversion - for source/destination encodings pair in a schema. None default - conversion never be used for the automatic conversion. Instead it - can be used for CONVERT() function. + conversion. Conversion names may be used in the CONVERT() function + to specify a particular encoding conversion. Also, conversions that + are marked DEFAULT can be used for automatic encoding conversion between + frontend and backend. For this purpose, two conversions, from encoding A to + B AND from encoding B to A, must be defined. To be able to create a conversion, you must have the execute right - on the function and the usage right on the schema the function - belongs to. + on the function and the create right on the destination schema. @@ -49,11 +46,7 @@ CREATE [DEFAULT] CONVERSION conversion_name The DEFAULT clause indicates that this conversion is the default for this particular source to destination encoding. There should be only one default encoding in a schema - for the encoding pair. A default encoding can be used for not - only CONVERT() function, but also for the automatic encoding - conversion between frontend and backend. For this purpose, two - conversions, from encoding A to B AND encoding B to A, must be - defined. + for the encoding pair. @@ -64,8 +57,8 @@ CREATE [DEFAULT] CONVERSION conversion_name The name of the conversion. The conversion name may be - schema-qualified. If it is not, a conversion is defined in the - current schema. The conversion name must be unique with in a + schema-qualified. If it is not, the conversion is defined in the + current schema. The conversion name must be unique within a schema. @@ -102,7 +95,7 @@ CREATE [DEFAULT] CONVERSION conversion_name - The function must have following signature: + The function must have the following signature: conv_proc( -- cgit v1.2.3