aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-03-10 17:30:18 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2011-03-10 17:30:46 -0500
commit7564654adf07ec26b83c7effc7f54f7183e04519 (patch)
tree0c532167c51cba9e1ae963762594402dcf834dcc /doc/src
parent551c07d84ae2f0d3b7dde68e52322edf9cb87ba5 (diff)
downloadpostgresql-7564654adf07ec26b83c7effc7f54f7183e04519.tar.gz
postgresql-7564654adf07ec26b83c7effc7f54f7183e04519.zip
Revert addition of third argument to format_type().
Including collation in the behavior of that function promotes a world view we do not want. Moreover, it was producing the wrong behavior for pg_dump anyway: what we want is to dump a COLLATE clause on attributes whose attcollation is different from the underlying type, and likewise for domains, and the function cannot do that for us. Doing it the hard way in pg_dump is a bit more tedious but produces more correct output. In passing, fix initdb so that the initial entry in pg_collation is properly pinned. It was droppable before :-(
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/func.sgml6
1 files changed, 2 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 5a021db33b7..4635cf2bb5e 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -13269,7 +13269,7 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
<tbody>
<row>
- <entry><literal><function>format_type(<parameter>type_oid</parameter> [, <parameter>typemod</> [, <parameter>collation_oid</> ]])</function></literal></entry>
+ <entry><literal><function>format_type(<parameter>type_oid</parameter>, <parameter>typemod</>)</function></literal></entry>
<entry><type>text</type></entry>
<entry>get SQL name of a data type</entry>
</row>
@@ -13410,9 +13410,7 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
<para>
<function>format_type</function> returns the SQL name of a data type that
is identified by its type OID and possibly a type modifier. Pass NULL
- for the type modifier or omit the argument if no specific modifier is known.
- If a collation is given as third argument, a <literal>COLLATE</> clause
- followed by a formatted collation name is appended.
+ for the type modifier if no specific modifier is known.
</para>
<para>