Re: BUG #4040: psql should provide option to not prompt for password - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #4040: psql should provide option to not prompt for password
Date
Msg-id 200805080028.m480SNE04970@momjian.us
Whole thread Raw
In response to Re: BUG #4040: psql should provide option to not prompt for password  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > BTW while reading the psql manpage I noticed this statement:
>
> >        A popular application of this facility is to refer to  the  last
> >        inserted OID in subsequent statements to build a foreign key
> >        scenario.
>
> > (This refers to :foo interpolation.)  Talking about popular application
> > of OIDs in FKs seems so 90's.  Should we remove that phrase?
>
> Yeah, probably; it's been a very long time since that was considered
> a good way to do things.  Can you think of some other example to replace
> that with?

I have removed the mention of OID usage with the attached patch.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/ref/psql-ref.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v
retrieving revision 1.201
diff -c -c -r1.201 psql-ref.sgml
*** doc/src/sgml/ref/psql-ref.sgml    5 May 2008 01:38:08 -0000    1.201
--- doc/src/sgml/ref/psql-ref.sgml    8 May 2008 00:19:55 -0000
***************
*** 2440,2448 ****
      </para>

      <para>
!     A popular application of this facility is to refer to the last
!     inserted <acronym>OID</acronym> in subsequent statements to build a
!     foreign key scenario. Another possible use of this mechanism is to
      copy the contents of a file into a table column. First load the file into a
      variable and then proceed as above:
  <programlisting>
--- 2440,2446 ----
      </para>

      <para>
!     One  possible use of this mechanism is to
      copy the contents of a file into a table column. First load the file into a
      variable and then proceed as above:
  <programlisting>

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG: aliases does not work ((
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #4040: psql should provide option to not prompt for password