AIP - Assessoria Inform=E1tica e Prote=E7=E3o LTDA</TITL= E> <META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type= ><BASE=20 href=3Dfile://d:\pedroigor\docs\email\> <META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff text=3D#000000> <DIV>Someone knows how is going the implementation of cross database refere= nces=20 in pgsql ?</DIV> <DIV>Would have some future release with this great functionality ?</D= IV> <DIV> </DIV> <DIV>Thanks,</DIV> <DIV> </DIV> <DIV>Pedro Igor</DIV></BODY></HTML> ------=_NextPart_000_0018_01C2C6F2.E6075260-- From jasont@indigoindustrial.co.nz Tue Jan 28 23:40:53 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9BD74477082 for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 18:40:53 -0500 (EST) Received: from grunt2.ihug.co.nz (grunt2.ihug.co.nz [203.109.254.42]) by postgresql.org (Postfix) with ESMTP id B874847658C for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 17:37:51 -0500 (EST) Received: from 203-173-247-180.nzwide.ihug.co.nz (camille.indigoindustrial.co.nz) [203.173.247.180] by grunt2.ihug.co.nz with esmtp (Exim 3.35 #1 (Debian)) id 18deMT-00067C-00; Wed, 29 Jan 2003 11:37:45 +1300 Received: (from jasont@localhost) by camille.indigoindustrial.co.nz (8.9.3/8.9.3) id LAA12464; Wed, 29 Jan 2003 11:37:44 +1300 Date: Wed, 29 Jan 2003 11:37:44 +1300 From: Jason Turner <jasont@indigoindustrial.co.nz> To: Pedro Igor Craveiro e Silva <pedroigor@aip.com.br> Cc: pgsql-sql@postgresql.org Subject: Re: Cross-database references Message-ID: <20030129113744.B12431@camille.indigoindustrial.co.nz> References: <001b01c2c703$aa384940$0b00010a@aip.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i In-Reply-To: <001b01c2c703$aa384940$0b00010a@aip.com.br>; from pedroigor@aip.com.br on Tue, Jan 28, 2003 at 05:30:06PM -0200 X-mailer: mutt 1.2.5i X-Priority: Booga booga X-FOTD: Persimmon X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/447 X-Sequence-Number: 11312 On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? This is usually left up to the front-end. Usually for me, perl DBI. This way, I can connect to multiple databases, possibly all of different types (PgSQL, Oracle, Informix, ...). I'm sure the SQL gurus can corret me, but I was under the impression that cross-database references in the backend would be capital-D Difficult to implement with transaction support. Then there's the further tearing asunder of the ANSI SQL standard... Jason -- Indigo Industrial Controls Ltd. 64-21-343-545 jasont@indigoindustrial.co.nz From rmello@cc.usu.edu Wed Jan 29 02:48:11 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BB314477588 for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 21:48:11 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id EAE54477830 for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 20:22:23 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18dh1a-0005zv-00; Tue, 28 Jan 2003 18:28:22 -0700 Date: Tue, 28 Jan 2003 18:28:22 -0700 From: Roberto Mello <rmello@cc.usu.edu> To: Pedro Igor Craveiro e Silva <pedroigor@aip.com.br> Cc: pgsql-sql@postgresql.org Subject: Re: Cross-database references Message-ID: <20030129012822.GC22600@cc.usu.edu> References: <001b01c2c703$aa384940$0b00010a@aip.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <001b01c2c703$aa384940$0b00010a@aip.com.br> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/449 X-Sequence-Number: 11314 On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? Olá Pedro, Look at the dblink module under the contrib section of PostgreSQL. It implements the feature you're looking for. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + "There's 2 kind of people: those who knows assembler and the rest"

From pedroigor@aip.com.br Tue Jan 28 20:30:47 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5FC4F479716 for ; Tue, 28 Jan 2003 15:30:47 -0500 (EST) Received: from server45.aip.com.br (unknown [200.199.192.5]) by postgresql.org (Postfix) with ESMTP id E93924775BB for ; Tue, 28 Jan 2003 14:38:57 -0500 (EST) Received: from DEV01 ([10.1.0.11]) by server45.aip.com.br with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id D6CK3GLC; Tue, 28 Jan 2003 17:41:27 -0300 Message-ID: <001b01c2c703$aa384940$0b00010a@aip.com.br> From: "Pedro Igor Craveiro e Silva" To: Subject: Cross-database references Date: Tue, 28 Jan 2003 17:30:06 -0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0018_01C2C6F2.E6075260" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/441 X-Sequence-Number: 11306 This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C2C6F2.E6075260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable AIP - Assessoria Inform=E1tica e Prote=E7=E3o LTDASomeone knows how is goin= g the implementation of cross database references in pgsql ? Would have some future release with this great functionality ? Thanks, Pedro Igor ------=_NextPart_000_0018_01C2C6F2.E6075260 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable AIP - Assessoria Inform=E1tica e Prote=E7=E3o LTDA</TITL= E> <META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type= ><BASE=20 href=3Dfile://d:\pedroigor\docs\email\> <META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff text=3D#000000> <DIV>Someone knows how is going the implementation of cross database refere= nces=20 in pgsql ?</DIV> <DIV>Would have some future release with this great functionality ?</D= IV> <DIV> </DIV> <DIV>Thanks,</DIV> <DIV> </DIV> <DIV>Pedro Igor</DIV></BODY></HTML> ------=_NextPart_000_0018_01C2C6F2.E6075260-- From jasont@indigoindustrial.co.nz Tue Jan 28 23:40:53 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9BD74477082 for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 18:40:53 -0500 (EST) Received: from grunt2.ihug.co.nz (grunt2.ihug.co.nz [203.109.254.42]) by postgresql.org (Postfix) with ESMTP id B874847658C for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 17:37:51 -0500 (EST) Received: from 203-173-247-180.nzwide.ihug.co.nz (camille.indigoindustrial.co.nz) [203.173.247.180] by grunt2.ihug.co.nz with esmtp (Exim 3.35 #1 (Debian)) id 18deMT-00067C-00; Wed, 29 Jan 2003 11:37:45 +1300 Received: (from jasont@localhost) by camille.indigoindustrial.co.nz (8.9.3/8.9.3) id LAA12464; Wed, 29 Jan 2003 11:37:44 +1300 Date: Wed, 29 Jan 2003 11:37:44 +1300 From: Jason Turner <jasont@indigoindustrial.co.nz> To: Pedro Igor Craveiro e Silva <pedroigor@aip.com.br> Cc: pgsql-sql@postgresql.org Subject: Re: Cross-database references Message-ID: <20030129113744.B12431@camille.indigoindustrial.co.nz> References: <001b01c2c703$aa384940$0b00010a@aip.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i In-Reply-To: <001b01c2c703$aa384940$0b00010a@aip.com.br>; from pedroigor@aip.com.br on Tue, Jan 28, 2003 at 05:30:06PM -0200 X-mailer: mutt 1.2.5i X-Priority: Booga booga X-FOTD: Persimmon X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/447 X-Sequence-Number: 11312 On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? This is usually left up to the front-end. Usually for me, perl DBI. This way, I can connect to multiple databases, possibly all of different types (PgSQL, Oracle, Informix, ...). I'm sure the SQL gurus can corret me, but I was under the impression that cross-database references in the backend would be capital-D Difficult to implement with transaction support. Then there's the further tearing asunder of the ANSI SQL standard... Jason -- Indigo Industrial Controls Ltd. 64-21-343-545 jasont@indigoindustrial.co.nz From rmello@cc.usu.edu Wed Jan 29 02:48:11 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BB314477588 for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 21:48:11 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id EAE54477830 for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 20:22:23 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18dh1a-0005zv-00; Tue, 28 Jan 2003 18:28:22 -0700 Date: Tue, 28 Jan 2003 18:28:22 -0700 From: Roberto Mello <rmello@cc.usu.edu> To: Pedro Igor Craveiro e Silva <pedroigor@aip.com.br> Cc: pgsql-sql@postgresql.org Subject: Re: Cross-database references Message-ID: <20030129012822.GC22600@cc.usu.edu> References: <001b01c2c703$aa384940$0b00010a@aip.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <001b01c2c703$aa384940$0b00010a@aip.com.br> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/449 X-Sequence-Number: 11314 On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? Olá Pedro, Look at the dblink module under the contrib section of PostgreSQL. It implements the feature you're looking for. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + "There's 2 kind of people: those who knows assembler and the rest"