From mail@joeconway.com Mon Jun 8 11:40:38 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E1BCF475E88 for ; Sat, 31 Aug 2002 19:27:41 -0400 (EDT) Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id 23073475E85 for ; Sat, 31 Aug 2002 19:27:41 -0400 (EDT) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 3.5.9) with ESMTP-TLS id 1317839 for pgsql-patches@postgresql.org; Sat, 31 Aug 2002 16:12:44 -0700 Message-ID: <3D715089.1050507@joeconway.com> Date: Sat, 31 Aug 2002 16:26:01 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: PostgreSQL Patches Subject: pg_settings doc patch Content-Type: multipart/mixed; boundary="------------000107020502040602030209" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/660 X-Sequence-Number: 5196 This is a multi-part message in MIME format. --------------000107020502040602030209 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Here is a documentation patch for the pg_settings virtual table. If there are no objections, please apply. Thanks, Joe --------------000107020502040602030209 Content-Type: text/html; name="pg_settings-doc.1.patch" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="pg_settings-doc.1.patch" Index: doc/src/sgml/catalogs.sgml =================================================================== RCS file: /opt/src/cvs/pgsql-server/doc/src/sgml/catalogs.sgml,v retrieving revision 2.56 diff -c -r2.56 catalogs.sgml *** doc/src/sgml/catalogs.sgml 30 Aug 2002 19:23:18 -0000 2.56 --- doc/src/sgml/catalogs.sgml 31 Aug 2002 22:46:02 -0000 *************** *** 162,167 **** --- 162,172 ---- + pg_settings + current session run-time parameters + + + pg_statistic optimizer statistics *************** *** 2858,2863 **** --- 2863,2924 ---- text[] Session defaults for run-time configuration variables + + + + + + + + + + pg_settings + + + pg_settings virtual table allows display and update + of current session run-time parameters. There is one entry for each of the + available parameters provided by SHOW ALL. But it is + in a form that allows it to be joined with other relations and have a + selection criteria applied. + + + + An UPDATE performed on pg_settings + is equivalent to executing the SET command on that named + parameter. The change only affects the value used by the current session. If + an UPDATE is issued within a transaction that is later + aborted, the effects of the UPDATE command disappear when + the transaction is rolled back. Once the surrounding transaction is + committed, the effects will persist until the end of the session, unless + overridden by another UPDATE or SET. + + + + pg_settings Columns + + + + + Name + Type + References + Description + + + + + + name + text + + The name of a current session run-time parameter + + + + setting + text + + The value of a current session run-time parameter --------------000107020502040602030209-- From tgl@sss.pgh.pa.us Mon Jun 8 11:40:38 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A32F14759E8; Sat, 31 Aug 2002 20:36:24 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id F09154758FB; Sat, 31 Aug 2002 20:36:23 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g810aLZM014045; Sat, 31 Aug 2002 20:36:21 -0400 (EDT) To: Joe Conway Cc: PostgreSQL Patches , pgsql-docs@postgresql.org Subject: Re: [PATCHES] pg_settings doc patch In-reply-to: <3D715089.1050507@joeconway.com> References: <3D715089.1050507@joeconway.com> Comments: In-reply-to Joe Conway message dated "Sat, 31 Aug 2002 16:26:01 -0700" Date: Sat, 31 Aug 2002 20:36:20 -0400 Message-ID: <14044.1030840580@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/29 X-Sequence-Number: 1447 Joe Conway writes: > Here is a documentation patch for the pg_settings virtual table. If > there are no objections, please apply. pg_settings is not a system catalog, so I don't think it belongs in the system catalogs chapter. In fact it doesn't belong anywhere in the Developer's Guide, since it's a user-oriented view. I'm not sure where it *does* belong though :-(. Right at the moment we have no documentation of any of the predefined system views, except for the ones that fit into the "monitoring" chapter of the Admin Guide. I think maybe we ought to make a new chapter for system views ... but where to put it? User's Guide maybe? regards, tom lane From mail@joeconway.com Mon Jun 8 11:40:38 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF16C4759E8; Sat, 31 Aug 2002 20:42:27 -0400 (EDT) Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id 53B914759FC; Sat, 31 Aug 2002 20:42:27 -0400 (EDT) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 3.5.9) with ESMTP-TLS id 1317861; Sat, 31 Aug 2002 17:27:30 -0700 Message-ID: <3D71620F.3050901@joeconway.com> Date: Sat, 31 Aug 2002 17:40:47 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: PostgreSQL Patches , pgsql-docs@postgresql.org Subject: Re: [PATCHES] pg_settings doc patch References: <3D715089.1050507@joeconway.com> <14044.1030840580@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/30 X-Sequence-Number: 1448 Tom Lane wrote: > pg_settings is not a system catalog, so I don't think it belongs in the > system catalogs chapter. In fact it doesn't belong anywhere in the > Developer's Guide, since it's a user-oriented view. > > I'm not sure where it *does* belong though :-(. Right at the moment we > have no documentation of any of the predefined system views, except for > the ones that fit into the "monitoring" chapter of the Admin Guide. > > I think maybe we ought to make a new chapter for system views ... but > where to put it? User's Guide maybe? It didn't seem to fit, but as you point out, there was no place else even close. I'll try to come up with something and submit another patch. Joe From mail@joeconway.com Mon Jun 8 11:40:38 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9B0E3475D41; Sat, 31 Aug 2002 22:54:29 -0400 (EDT) Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id 07BEE475D2D; Sat, 31 Aug 2002 22:54:29 -0400 (EDT) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 3.5.9) with ESMTP-TLS id 1317916; Sat, 31 Aug 2002 19:39:11 -0700 Message-ID: <3D7180EE.4010106@joeconway.com> Date: Sat, 31 Aug 2002 19:52:30 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: PostgreSQL Patches , pgsql-docs@postgresql.org Subject: Re: [PATCHES] pg_settings doc patch References: <3D715089.1050507@joeconway.com> <14044.1030840580@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/34 X-Sequence-Number: 1452 Tom Lane wrote: > pg_settings is not a system catalog, so I don't think it belongs in the > system catalogs chapter. In fact it doesn't belong anywhere in the > Developer's Guide, since it's a user-oriented view. > > I'm not sure where it *does* belong though :-(. Right at the moment we > have no documentation of any of the predefined system views, except for > the ones that fit into the "monitoring" chapter of the Admin Guide. > > I think maybe we ought to make a new chapter for system views ... but > where to put it? User's Guide maybe? > What about putting pg_settings documentation at the bottom of: ->Administrators Guide ->Server run-time environment ->run-time configuration just before the Planner and optimizer tuning subsection? http://developer.postgresql.org/docs/postgres/runtime-config.html I think at some point there should be a consolidated section on system views, but since they are scattered at the moment, this seems like the most logical choice to me. Comments? Joe From vishnu@maxxion.co.in Mon Jun 8 11:40:38 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 04068475DA3 for ; Sun, 1 Sep 2002 01:04:21 -0400 (EDT) Received: from localhost.localdomain (unknown [203.197.151.174]) by postgresql.org (Postfix) with ESMTP id 0C413475D71 for ; Sun, 1 Sep 2002 01:04:19 -0400 (EDT) Received: from vishnu (vishnu.maxxion.co.in [192.168.1.36]) by localhost.localdomain (8.9.3/8.9.3) with SMTP id KAA31972 for ; Sun, 1 Sep 2002 10:33:44 +0530 Message-ID: <011001c25173$d2d5a1a0$2401a8c0@maxxion.co.in> From: "Vishnu" To: References: <3D715089.1050507@joeconway.com> <14044.1030840580@sss.pgh.pa.us> <3D71620F.3050901@joeconway.com> Subject: syntax to access/retrieve data from multiple databases Date: Sun, 1 Sep 2002 10:25:41 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2462.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/10 X-Sequence-Number: 1462 Dear Friend, I need to access/retrieve data from multiple databases using single query ... Is there any syntax ...? Thanks in advance Regards Vishnu.