X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 50DF04761DC for ; Fri, 28 Feb 2003 17:06:47 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 41653-01 for ; Fri, 28 Feb 2003 17:06:36 -0500 (EST) Received: from post.webmailer.de (natsmtp00.webmailer.de [192.67.198.74]) by postgresql.org (Postfix) with ESMTP id EF7CE476214 for ; Fri, 28 Feb 2003 15:48:27 -0500 (EST) Received: from ianb.local (pD9EB0F29.dip.t-dialin.net [217.235.15.41]) by post.webmailer.de (8.9.3/8.8.7) with ESMTP id VAA03884; Fri, 28 Feb 2003 21:48:25 +0100 (MET) Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: "Sidar Lopez Cruz" , Subject: Re: Cross-database references Date: Fri, 28 Feb 2003 21:47:56 +0100 X-Mailer: KMail [version 1.4] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200302282147.56298.barwick@gmx.net> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/437 X-Sequence-Number: 7635 On Friday 28 February 2003 16:05, Sidar Lopez Cruz wrote: > When i try to do something like > > templae1=3D# select * from mydatabase.public.mytale; > > this message appear: Cross-database references are not implemented This is normal behaviour for Postgres. This syntax is not supported, even if the database you are referencing is the current one. See also: http://www.postgresql.org/docs/faqs/FAQ.html#4.24 Ian Barwick barwick@gmx.net