From smccloud@geo-comm.com Fri Dec 3 16:56:39 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0AFD51337B89 for ; Fri, 3 Dec 2010 12:56:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 33303-05 for ; Fri, 3 Dec 2010 16:56:31 +0000 (UTC) X-Greylist: delayed 00:05:21.638137 by SQLgrey-1.7.6 Received: from mail.geo-comm.com (mail.geo-comm.com [66.173.42.242]) by mail.postgresql.org (Postfix) with ESMTP id 454DE1337B2F for ; Fri, 3 Dec 2010 12:56:30 -0400 (AST) Received: from EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca]) by EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca%11]) with mapi id 14.01.0255.000; Fri, 3 Dec 2010 10:51:03 -0600 From: Shaun McCloud To: "pgsql-sql@postgresql.org" Subject: Union Question Thread-Topic: Union Question Thread-Index: AcuTCkSVCb6Qu6IuT/O6Lw83Dqg9tg== Date: Fri, 3 Dec 2010 16:51:02 +0000 Message-ID: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ninja-pim: Scanned by Ninja x-ninja-attachmentfiltering: (no action) x-originating-ip: [192.168.10.29] Content-Type: multipart/alternative; boundary="_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/16 X-Sequence-Number: 34852 --_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, I need to union three PostgreSQL tables and this won't be a problem but the= tables are on different servers. Basically, I have an administrative serv= er that needs the tables viewable in a web administrator and three query se= rvers that log the needed data locally. Is there a way I can do this witho= ut using Slony-I to replicate the data to the administrative server? Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician (MCDST) Do or do not, there is no try. -Yoda --_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

I need to union three PostgreSQL tables and this won= ’t be a problem but the tables are on different servers.  Basica= lly, I have an administrative server that needs the tables viewable in a we= b administrator and three query servers that log the needed data locally.  Is there a way I can do this without us= ing Slony-I to replicate the data to the administrative server?<= /p>

 

Shaun McCloud - Software Testing Analy= st
GeoComm Inc.
601 W. Saint Germain St., Saint Cloud, MN 56301
Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666
click here to visit www.geo-comm.com<= /a>

Microsoft Certified Desktop Support Technician (MCDS= T)

 

Do or do not, there is n= o try.

    &nb= sp; -Yoda

 

 

--_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_-- From JRPlugge@west.com Fri Dec 3 17:05:15 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 873E01337BC5 for ; Fri, 3 Dec 2010 13:05:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 24459-03-2 for ; Fri, 3 Dec 2010 17:05:07 +0000 (UTC) X-Greylist: delayed 00:06:38.929705 by SQLgrey-1.7.6 Received: from mail143.messagelabs.com (mail143.messagelabs.com [216.82.254.35]) by mail.postgresql.org (Postfix) with ESMTP id A07C71337BC2 for ; Fri, 3 Dec 2010 13:05:06 -0400 (AST) X-VirusChecked: Checked X-Env-Sender: JRPlugge@west.com X-Msg-Ref: server-5.tower-143.messagelabs.com!1291395505!67056120!1 X-StarScan-Version: 6.2.9; banners=-,-,- X-Originating-IP: [216.57.102.107] Received: (qmail 483 invoked from network); 3 Dec 2010 16:58:26 -0000 Received: from unknown (HELO linux512.wic.west.com) (216.57.102.107) by server-5.tower-143.messagelabs.com with DHE-RSA-AES256-SHA encrypted SMTP; 3 Dec 2010 16:58:26 -0000 Received: from OMA00CHUB01.corp.westworlds.com (oma-inet-pub2 [216.57.102.249]) by linux512.wic.west.com (8.13.1/8.13.1) with ESMTP id oB3GwPv4010636 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=FAIL); Fri, 3 Dec 2010 11:58:25 -0500 Received: from oma00cexmbx03.corp.westworlds.com ([10.27.116.57]) by OMA00CHUB01.corp.westworlds.com ([10.27.116.96]) with mapi; Fri, 3 Dec 2010 10:58:24 -0600 From: "Plugge, Joe R." To: Shaun McCloud , "pgsql-sql@postgresql.org" Date: Fri, 3 Dec 2010 10:58:23 -0600 Subject: Re: Union Question Thread-Topic: Union Question Thread-Index: AcuTCkSVCb6Qu6IuT/O6Lw83Dqg9tgAAP6eg Message-ID: References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> In-Reply-To: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_BD69807DAE0CE44CA00A8338D0FDD08302E92E4E7Foma00cexmbx03_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.199 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201012/18 X-Sequence-Number: 34854 --_000_BD69807DAE0CE44CA00A8338D0FDD08302E92E4E7Foma00cexmbx03_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You may want to try dblink. http://www.postgresql.org/docs/current/static/dblink.html From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org= ] On Behalf Of Shaun McCloud Sent: Friday, December 03, 2010 10:51 AM To: pgsql-sql@postgresql.org Subject: [SQL] Union Question Hello, I need to union three PostgreSQL tables and this won't be a problem but the= tables are on different servers. Basically, I have an administrative serv= er that needs the tables viewable in a web administrator and three query se= rvers that log the needed data locally. Is there a way I can do this witho= ut using Slony-I to replicate the data to the administrative server? Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician (MCDST) Do or do not, there is no try. -Yoda --_000_BD69807DAE0CE44CA00A8338D0FDD08302E92E4E7Foma00cexmbx03_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

You may want to try dblink.

 

http://www.postgresql.org/docs/current/static/dblink.html<= /o:p>

 

 

From: pgsql-sql-own= er@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Shaun McCloud Sent: Friday, December 03, 2010 10:51 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Union Question

 

Hello,

 

I need to union three PostgreSQL tables and this won&#= 8217;t be a problem but the tables are on different servers.  Basically, I have an administrative server that needs the tables viewable in a web administrator= and three query servers that log the needed data locally.  Is there a way = I can do this without using Slony-I to replicate the data to the administrati= ve server?

 

Shaun McCloud - Software Testing Analyst
GeoComm Inc.
601 W. Saint Germain St., Saint Cloud, MN 56301
Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666
click here to visit <= i>www.geo-comm.com<= /a>

Microsoft Certi= fied Desktop Support Technician (MCDST)

 

Do or do not, there is no try.

      -Yoda

 = ;

 

--_000_BD69807DAE0CE44CA00A8338D0FDD08302E92E4E7Foma00cexmbx03_-- From smccloud@geo-comm.com Fri Dec 3 17:04:58 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id BFF671337B5A for ; Fri, 3 Dec 2010 13:04:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 49202-02 for ; Fri, 3 Dec 2010 17:04:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.geo-comm.com (mail.geo-comm.com [66.173.42.242]) by mail.postgresql.org (Postfix) with ESMTP id 707AF1337B4A for ; Fri, 3 Dec 2010 13:04:49 -0400 (AST) Received: from EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca]) by EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca%11]) with mapi id 14.01.0255.000; Fri, 3 Dec 2010 11:04:43 -0600 From: Shaun McCloud To: "Plugge, Joe R." , "pgsql-sql@postgresql.org" Subject: Re: Union Question Thread-Topic: Union Question Thread-Index: AcuTCkSVCb6Qu6IuT/O6Lw83Dqg9tgAAP6egAAAwSuA= Date: Fri, 3 Dec 2010 17:04:43 +0000 Message-ID: <7742DD496427B743BC8B7BBF6D380BA0A2F1E8@EXCHANGE10.geo-comm.local> References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ninja-pim: Scanned by Ninja x-ninja-attachmentfiltering: (no action) x-originating-ip: [192.168.10.29] Content-Type: multipart/alternative; boundary="_000_7742DD496427B743BC8B7BBF6D380BA0A2F1E8EXCHANGE10geocomm_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/17 X-Sequence-Number: 34853 --_000_7742DD496427B743BC8B7BBF6D380BA0A2F1E8EXCHANGE10geocomm_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I'm trying that, but I am getting an error that says "ERROR: function dbli= nk_connect(unknown, unknown) does not exist" Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician (MCDST) Do or do not, there is no try. -Yoda From: Plugge, Joe R. [mailto:JRPlugge@west.com] Sent: Friday, December 03, 2010 10:58 To: Shaun McCloud; pgsql-sql@postgresql.org Subject: RE: Union Question You may want to try dblink. http://www.postgresql.org/docs/current/static/dblink.html From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org= ] On Behalf Of Shaun McCloud Sent: Friday, December 03, 2010 10:51 AM To: pgsql-sql@postgresql.org Subject: [SQL] Union Question Hello, I need to union three PostgreSQL tables and this won't be a problem but the= tables are on different servers. Basically, I have an administrative serv= er that needs the tables viewable in a web administrator and three query se= rvers that log the needed data locally. Is there a way I can do this witho= ut using Slony-I to replicate the data to the administrative server? Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician (MCDST) Do or do not, there is no try. -Yoda --_000_7742DD496427B743BC8B7BBF6D380BA0A2F1E8EXCHANGE10geocomm_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I’m trying that,= but I am getting an error that says “ERROR:  function dblink_co= nnect(unknown, unknown) does not exist”

 

 

From: Plugge, = Joe R. [mailto:JRPlugge@west.com]
Sent: Friday, December 03, 2010 10:58
To: Shaun McCloud; pgsql-sql@postgresql.org
Subject: RE: Union Question

 

You may want to try dblink.<= o:p>

 

http://www.postgresql.org/docs/cu= rrent/static/dblink.html

 

 

From: pgsql-sq= l-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Shaun McCloud
Sent: Friday, December 03, 2010 10:51 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Union Question

 

Hello,

 

I need to union three PostgreSQL tables and this won= ’t be a problem but the tables are on different servers.  Basica= lly, I have an administrative server that needs the tables viewable in a we= b administrator and three query servers that log the needed data locally.  Is there a way I can do this without us= ing Slony-I to replicate the data to the administrative server?<= /p>

 

Shaun McCloud - Software Testing Analy= st
GeoComm Inc.
601 W. Saint Germain St., Saint Cloud, MN 56301
Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.= 436.2666
click here to visit <= i>www.geo-comm.com<= /i>

Microsoft Certified Desktop Support Technician (MCDS= T)

 

Do or do not, there is n= o try.

    &nb= sp; -Yoda

 

 

--_000_7742DD496427B743BC8B7BBF6D380BA0A2F1E8EXCHANGE10geocomm_-- From xof@thebuild.com Fri Dec 3 17:08:21 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 45F521337B4A for ; Fri, 3 Dec 2010 13:08:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 11575-10 for ; Fri, 3 Dec 2010 17:08:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp116.dfw.emailsrvr.com (smtp116.dfw.emailsrvr.com [67.192.241.116]) by mail.postgresql.org (Postfix) with ESMTP id 7C31E1337B2F for ; Fri, 3 Dec 2010 13:08:13 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp21.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id 9A1102405C2; Fri, 3 Dec 2010 12:08:12 -0500 (EST) X-Virus-Scanned: OK Received: by smtp21.relay.dfw1a.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id E75B7240243; Fri, 3 Dec 2010 12:08:11 -0500 (EST) References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> <7742DD496427B743BC8B7BBF6D380BA0A2F1E8@EXCHANGE10.geo-comm.local> In-Reply-To: <7742DD496427B743BC8B7BBF6D380BA0A2F1E8@EXCHANGE10.geo-comm.local> Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=windows-1252 Message-Id: Content-Transfer-Encoding: quoted-printable Cc: "Plugge, Joe R." , "pgsql-sql@postgresql.org" From: Christophe Pettus Subject: Re: Union Question Date: Fri, 3 Dec 2010 09:08:10 -0800 To: Shaun McCloud X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201012/19 X-Sequence-Number: 34855 On Dec 3, 2010, at 9:04 AM, Shaun McCloud wrote: > I=92m trying that, but I am getting an error that says =93ERROR: = function dblink_connect(unknown, unknown) does not exist=94 dblink is a contrib module, and needs to be installed before use: http://www.postgresql.org/docs/9.0/interactive/dblink.html -- -- Christophe Pettus xof@thebuild.com From smccloud@geo-comm.com Fri Dec 3 17:08:51 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9B4D11337B5A for ; Fri, 3 Dec 2010 13:08:51 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 07031-09 for ; Fri, 3 Dec 2010 17:08:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.geo-comm.com (mail.geo-comm.com [66.173.42.242]) by mail.postgresql.org (Postfix) with ESMTP id 0EE2B1337B4A for ; Fri, 3 Dec 2010 13:08:44 -0400 (AST) Received: from EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca]) by EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca%11]) with mapi id 14.01.0255.000; Fri, 3 Dec 2010 11:08:43 -0600 From: Shaun McCloud To: Christophe Pettus CC: "Plugge, Joe R." , "pgsql-sql@postgresql.org" Subject: Re: Union Question Thread-Topic: [SQL] Union Question Thread-Index: AcuTCkSVCb6Qu6IuT/O6Lw83Dqg9tgAAP6egAAAwSuAADLvlAAAMj7Qg Date: Fri, 3 Dec 2010 17:08:42 +0000 Message-ID: <7742DD496427B743BC8B7BBF6D380BA0A2F46B@EXCHANGE10.geo-comm.local> References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> <7742DD496427B743BC8B7BBF6D380BA0A2F1E8@EXCHANGE10.geo-comm.local> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ninja-pim: Scanned by Ninja x-ninja-attachmentfiltering: (no action) x-originating-ip: [192.168.10.29] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/20 X-Sequence-Number: 34856 That would be nice to see in the documentation for dblink Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician (MCDST) Do or do not, there is no try. -Yoda -----Original Message----- From: Christophe Pettus [mailto:xof@thebuild.com]=20 Sent: Friday, December 03, 2010 11:08 To: Shaun McCloud Cc: Plugge, Joe R.; pgsql-sql@postgresql.org Subject: Re: [SQL] Union Question On Dec 3, 2010, at 9:04 AM, Shaun McCloud wrote: > I'm trying that, but I am getting an error that says "ERROR: function db= link_connect(unknown, unknown) does not exist" dblink is a contrib module, and needs to be installed before use: http://www.postgresql.org/docs/9.0/interactive/dblink.html -- -- Christophe Pettus xof@thebuild.com From xof@thebuild.com Fri Dec 3 17:27:47 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DA2981337BA6 for ; Fri, 3 Dec 2010 13:27:47 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19834-04 for ; Fri, 3 Dec 2010 17:27:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp116.dfw.emailsrvr.com (smtp116.dfw.emailsrvr.com [67.192.241.116]) by mail.postgresql.org (Postfix) with ESMTP id 9D4911337B4A for ; Fri, 3 Dec 2010 13:27:40 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp21.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id 448162403BA; Fri, 3 Dec 2010 12:27:38 -0500 (EST) X-Virus-Scanned: OK Received: by smtp21.relay.dfw1a.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id ECDA3240453; Fri, 3 Dec 2010 12:27:14 -0500 (EST) References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> <7742DD496427B743BC8B7BBF6D380BA0A2F1E8@EXCHANGE10.geo-comm.local> <7742DD496427B743BC8B7BBF6D380BA0A2F46B@EXCHANGE10.geo-comm.local> In-Reply-To: <7742DD496427B743BC8B7BBF6D380BA0A2F46B@EXCHANGE10.geo-comm.local> Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii Message-Id: <64A8377E-5995-412F-99B6-910BDBD5ED0F@thebuild.com> Content-Transfer-Encoding: quoted-printable Cc: "Plugge, Joe R." , "pgsql-sql@postgresql.org" From: Christophe Pettus Subject: Re: Union Question Date: Fri, 3 Dec 2010 09:27:13 -0800 To: Shaun McCloud X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201012/21 X-Sequence-Number: 34857 On Dec 3, 2010, at 9:08 AM, Shaun McCloud wrote: > That would be nice to see in the documentation for dblink It's true of all contrib modules; that's mentioned at the start of the = contrib section: http://www.postgresql.org/docs/9.0/interactive/contrib.html -- -- Christophe Pettus xof@thebuild.com From smccloud@geo-comm.com Fri Dec 3 17:30:39 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 1B2C91337B4A for ; Fri, 3 Dec 2010 13:30:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 11323-09 for ; Fri, 3 Dec 2010 17:30:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.geo-comm.com (mail.geo-comm.com [66.173.42.242]) by mail.postgresql.org (Postfix) with ESMTP id F3A351337B2F for ; Fri, 3 Dec 2010 13:30:30 -0400 (AST) Received: from EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca]) by EXCHANGE10.geo-comm.local ([fe80::6c7f:cda2:fec:58ca%11]) with mapi id 14.01.0255.000; Fri, 3 Dec 2010 11:30:26 -0600 From: Shaun McCloud To: Christophe Pettus CC: "Plugge, Joe R." , "pgsql-sql@postgresql.org" Subject: Re: Union Question Thread-Topic: [SQL] Union Question Thread-Index: AcuTCkSVCb6Qu6IuT/O6Lw83Dqg9tgAAP6egAAAwSuAADLvlAAAMj7Qg//+g1ICAAGPNoA== Date: Fri, 3 Dec 2010 17:30:26 +0000 Message-ID: <7742DD496427B743BC8B7BBF6D380BA0A2F71E@EXCHANGE10.geo-comm.local> References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> <7742DD496427B743BC8B7BBF6D380BA0A2F1E8@EXCHANGE10.geo-comm.local> <7742DD496427B743BC8B7BBF6D380BA0A2F46B@EXCHANGE10.geo-comm.local> <64A8377E-5995-412F-99B6-910BDBD5ED0F@thebuild.com> In-Reply-To: <64A8377E-5995-412F-99B6-910BDBD5ED0F@thebuild.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ninja-pim: Scanned by Ninja x-ninja-attachmentfiltering: (no action) x-originating-ip: [192.168.10.29] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/22 X-Sequence-Number: 34858 Ah, ok. My bad for not reading good enough. Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician (MCDST) Do or do not, there is no try. -Yoda -----Original Message----- From: Christophe Pettus [mailto:xof@thebuild.com]=20 Sent: Friday, December 03, 2010 11:27 To: Shaun McCloud Cc: Plugge, Joe R.; pgsql-sql@postgresql.org Subject: Re: [SQL] Union Question On Dec 3, 2010, at 9:08 AM, Shaun McCloud wrote: > That would be nice to see in the documentation for dblink It's true of all contrib modules; that's mentioned at the start of the cont= rib section: http://www.postgresql.org/docs/9.0/interactive/contrib.html -- -- Christophe Pettus xof@thebuild.com From jasen@xnet.co.nz Fri Dec 3 23:20:58 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 418291337B77 for ; Fri, 3 Dec 2010 19:20:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 14561-09 for ; Fri, 3 Dec 2010 23:20:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtpcorp.com (smtpcorp.com [67.192.120.76]) by mail.postgresql.org (Postfix) with ESMTP id C6BD51337B2F for ; Fri, 3 Dec 2010 19:20:49 -0400 (AST) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=smtpcorp.com; s=main; h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:Message-ID:Date:Subject:From:To; bh=3mMnwpuSRnV+NJsVWJv+5CC/UlbC1ZWw/pmTJNZ2HVM=; b=NKI6sWgZO6Qk+Zowv6ZNgJhS/Y97VleOWSBWDl8K8XydiyEJjXI/x6kIt4wINzlKeJrBF3pHEGWAYSv9cCxGXCJ60C+VGMWk0I7Y87qH4wVEDYF1gFv3BZmY2Firyi2Z; Received: from ip-118-90-137-55.xdsl.xnet.co.nz ([118.90.137.55] helo=gonzo) by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70) id 1POevn-0007Iw-9m; mid 144 for pgsql-sql@postgresql.org; Fri, 03 Dec 2010 23:20:47 +0000 Received: from news by gonzo with local (Exim 4.72) (envelope-from ) id 1POevZ-00011r-U6 for pgsql-sql@postgresql.org; Sat, 04 Dec 2010 12:20:33 +1300 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: Union Question Date: 3 Dec 2010 23:20:33 GMT Organization: Dis (not Dat) Organisation Lines: 18 Message-ID: References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: reversiblemaps.ath.cx 1291418433 3933 127.0.0.1 (3 Dec 2010 23:20:33 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-18 (Linux) X-Smtpcorp-Track: 17553936.1.47212676 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_SORBS_DUL=0.001 X-Spam-Level: X-Archive-Number: 201012/24 X-Sequence-Number: 34860 On 2010-12-03, Shaun McCloud wrote: > --_000_7742DD496427B743BC8B7BBF6D380BA0A2F114EXCHANGE10geocomm_ > Content-Type: text/plain; charset="us-ascii" > Content-Transfer-Encoding: quoted-printable > > Hello, > > I need to union three PostgreSQL tables and this won't be a problem but the= > tables are on different servers. Basically, I have an administrative serv= > er that needs the tables viewable in a web administrator and three query se= > rvers that log the needed data locally. Is there a way I can do this witho= > ut using Slony-I to replicate the data to the administrative server? modify the web adminsitrator to connect to the three servers and do the union itself. -- ⚂⚃ 100% natural From bricklen@gmail.com Mon Dec 6 19:39:33 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9F6941337B2F for ; Mon, 6 Dec 2010 15:39:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 42839-03 for ; Mon, 6 Dec 2010 19:39:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f174.google.com (mail-yx0-f174.google.com [209.85.213.174]) by mail.postgresql.org (Postfix) with ESMTP id 7469E1337B51 for ; Mon, 6 Dec 2010 15:39:25 -0400 (AST) Received: by yxt3 with SMTP id 3so5713933yxt.19 for ; Mon, 06 Dec 2010 11:39:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=Hovhq3TwEKf2XJ0vpTJDQ4zJa8kECXE7703fvqN8Yvw=; b=SQG1YblFQdrkmpq7KS56Tbl2h+k8qhXgL+Hc6YGyVquF4rdS/xGv1UwDXNw0y/Dtij vYv4X141WZi86mKY1Qot9UxrOzlKNLEQOdZO5UmkXiwu5P/GdL61ig6dPt4IBotAGMCZ mmKXlrw3PYf+wKR9r/E2uqFAkVwjlT3BS2pvQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=vFOLLjXBGqOwV0cse6DXdrmDpvIwPPUqPoh6au41Lpun4smyoKmeOTtEMeAAct1SRG /Dy9NRRPirXH40ro3cQmEbUmgixz6EVNqiBbWuGFCORwqpZ9f+UV7nS3HxCDYPj9uFqR EdYKoTCyWIcsUm0CnGIsBmUwr02JLbPKKOHaA= MIME-Version: 1.0 Received: by 10.216.93.9 with SMTP id k9mr5172935wef.89.1291664363896; Mon, 06 Dec 2010 11:39:23 -0800 (PST) Received: by 10.216.164.17 with HTTP; Mon, 6 Dec 2010 11:39:23 -0800 (PST) In-Reply-To: References: <7742DD496427B743BC8B7BBF6D380BA0A2F114@EXCHANGE10.geo-comm.local> Date: Mon, 6 Dec 2010 11:39:23 -0800 Message-ID: Subject: Re: Union Question From: bricklen To: Shaun McCloud Cc: "pgsql-sql@postgresql.org" Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201012/33 X-Sequence-Number: 34869 On Fri, Dec 3, 2010 at 8:58 AM, Plugge, Joe R. wrote: > Hello, > > I need to union three PostgreSQL tables and this won=E2=80=99t be a probl= em but the > tables are on different servers.=C2=A0 Basically, I have an administrativ= e server > that needs the tables viewable in a web administrator and three query > servers that log the needed data locally.=C2=A0 Is there a way I can do t= his > without using Slony-I to replicate the data to the administrative server? PL/Proxy might fit the bill also. http://pgfoundry.org/projects/plproxy/ http://wiki.postgresql.org/wiki/PL/Proxy