postgres.git / summary / log / commit / refs

commit    c45a45fedbcffecfcd318a0a9349d3e1bbfb5e49
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Wed Oct 25 21:34:47 2023 +0000
First released in: 17.0, 11.22, 12.17, 13.13, 14.10, 15.5, 16.1

    Doc: remove misleading info about ecpg's CONNECT/DISCONNECT DEFAULT.
    
    As far as I can see, ecpg has no notion of a "default" open
    connection.  You can do "CONNECT TO DEFAULT" but that just specifies
    letting libpq use all its default connection parameters --- the
    resulting connection is not special subsequently.  In particular,
    SET CONNECTION = DEFAULT and DISCONNECT DEFAULT simply act on a
    connection named DEFAULT, if you've made one; they do not have
    special lookup rules.  But the documentation of these commands
    makes it look like they do.
    
    Simplest fix, I think, is just to remove the paras suggesting that
    DEFAULT is special here.
    
    Also, SET CONNECTION *does* have one special lookup rule, which
    is that it recognizes CURRENT as an alias for the currently selected
    connection.  SET CONNECTION = CURRENT is a no-op, so it's pretty
    useless, but nonetheless it does something different from selecting
    a connection by name; so we'd better document it.
    
    Per report from Sylvain Frandaz.  Back-patch to all supported
    versions.
    
    Discussion: https://postgr.es/m/169824721149.1769274.1553568436817652238@wrigleys.postgresql.org


 doc/src/sgml/ecpg.sgml | 22 ++--------------------
 1 file changed, 2 insertions(+), 20 deletions(-)

diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml
index 34d0102990c..7f2e6c4bed7 100644
--- a/doc/src/sgml/ecpg.sgml
+++ b/doc/src/sgml/ecpg.sgml
@@ -343,12 +343,6 @@ EXEC SQL DISCONNECT <optional><replaceable>connection</replaceable></optional>;
      </simpara>
     </listitem>
 
-    <listitem>
-     <simpara>
-      <literal>DEFAULT</literal>
-     </simpara>
-    </listitem>
-
     <listitem>
      <simpara>
       <literal>CURRENT</literal>
@@ -6909,7 +6903,6 @@ EXEC SQL DEALLOCATE DESCRIPTOR mydesc;
 <synopsis>
 DISCONNECT <replaceable class="parameter">connection_name</replaceable>
 DISCONNECT [ CURRENT ]
-DISCONNECT DEFAULT
 DISCONNECT ALL
 </synopsis>
    </refsynopsisdiv>
@@ -6950,15 +6943,6 @@ DISCONNECT ALL
       </listitem>
      </varlistentry>
 
-     <varlistentry>
-      <term><literal>DEFAULT</literal></term>
-      <listitem>
-       <para>
-        Close the default connection.
-       </para>
-      </listitem>
-     </varlistentry>
-
      <varlistentry>
       <term><literal>ALL</literal></term>
       <listitem>
@@ -6977,13 +6961,11 @@ DISCONNECT ALL
 int
 main(void)
 {
-    EXEC SQL CONNECT TO testdb AS DEFAULT USER testuser;
     EXEC SQL CONNECT TO testdb AS con1 USER testuser;
     EXEC SQL CONNECT TO testdb AS con2 USER testuser;
     EXEC SQL CONNECT TO testdb AS con3 USER testuser;
 
     EXEC SQL DISCONNECT CURRENT;  /* close con3          */
-    EXEC SQL DISCONNECT DEFAULT;  /* close DEFAULT       */
     EXEC SQL DISCONNECT ALL;      /* close con2 and con1 */
 
     return 0;
@@ -7503,10 +7485,10 @@ SET CONNECTION [ TO | = ] <replaceable class="parameter">connection_name</replac
      </varlistentry>
 
      <varlistentry>
-      <term><literal>DEFAULT</literal></term>
+      <term><literal>CURRENT</literal></term>
       <listitem>
        <para>
-        Set the connection to the default connection.
+        Set the connection to the current connection (thus, nothing happens).
        </para>
       </listitem>
      </varlistentry>


[parent: 85b9e8853fb5]