X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DCA4DA2F8 for ; Thu, 6 Oct 2005 03:19:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11173-10 for ; Thu, 6 Oct 2005 06:19:07 +0000 (GMT) Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37]) by svr1.postgresql.org (Postfix) with ESMTP id D6A83DA2E1 for ; Thu, 6 Oct 2005 03:19:07 -0300 (ADT) Received: by mail.kivi.com.tr (Postfix, from userid 1009) id 11E87E81D6; Thu, 6 Oct 2005 09:18:37 +0300 (EEST) Received: from localhost (localhost [127.0.0.1]) by mail.kivi.com.tr (Postfix) with ESMTP id 0A1B3E81B8; Thu, 6 Oct 2005 09:18:37 +0300 (EEST) Date: Thu, 6 Oct 2005 09:18:36 +0300 (EEST) From: Devrim GUNDUZ X-X-Sender: devrim2@mail.kivi.com.tr To: Hui Zhou Cc: pgsql-admin@postgresql.org Subject: Re: RPMs for RedHat ES3.0 - installation problem In-Reply-To: Message-ID: References: MIME-Version: 1.0 X-Kivi-MailScanner-Information: Please contact the ISP for more information X-Kivi-MailScanner: Found to be clean X-Kivi-MailScanner-From: devrim@gunduz.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: Content-Type: TEXT/PLAIN; CHARSET=iso-8859-9; format=flowed Content-Transfer-Encoding: 8BIT Content-ID: X-Archive-Number: 200510/77 X-Sequence-Number: 19149 On Wed, 5 Oct 2005, Hui Zhou wrote: > I have tried suggestion from Philip Yarra but I still could not get the > 8.0.3 installed. Any help is appreciated. Thanks in advance. > > ----------------------------------------------- Command line > ---------------------------------------------- > [root@maramar postgrsqllib]# rpm -i > compat-postgresql-libs-3-3PGDG.i686.rpm > warning: compat-postgresql-libs-3-3PGDG.i686.rpm: V3 DSA signature: > NOKEY, key ID 748f7d0e > error: Failed dependencies: > postgresql-libs < 8.0.2 conflicts with > compat-postgresql-libs-3-3PGDG It seems that you have PostgreSQL 8.0 or 8.0.1 installed on your system. You don't need the compat RPM if you are running those releases of PostgreSQL. If you want to upgrade to 8.0.2 and above, follow the usual upgrade procedure first. Regards, -- Devrim GUNDUZ Kivi Biližim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org From pgsql-admin-owner@postgresql.org Thu Oct 6 05:44:43 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 65616DA407 for ; Thu, 6 Oct 2005 05:44:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03848-04 for ; Thu, 6 Oct 2005 08:44:36 +0000 (GMT) Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by svr1.postgresql.org (Postfix) with ESMTP id 3081ADA3CC for ; Thu, 6 Oct 2005 05:44:36 -0300 (ADT) Received: from bell.credativ.de (p50897593.dip.t-dialin.net [80.137.117.147]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id EA9F6D7656; Thu, 6 Oct 2005 10:44:33 +0200 (CEST) From: Peter Eisentraut To: "Adriano Gaspar" Subject: Re: System Tables Date: Thu, 6 Oct 2005 10:44:19 +0200 User-Agent: KMail/1.8.1 Cc: pgsql-admin@postgresql.org References: <20051005192928.21F902BA66@webemail03.ibest.com.br> In-Reply-To: <20051005192928.21F902BA66@webemail03.ibest.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200510061044.19570.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.055 required=5 tests=[AWL=0.005, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/78 X-Sequence-Number: 19150 Am Mittwoch, 5. Oktober 2005 21:29 schrieb Adriano Gaspar: > I“m interesting in learning Postgre because I“m working with it now, if you > can, i want to know wich are the system tables, and in wich of them can I > find a table with all of the tables, and constrants. I don't know what "Postgre" is supposed to be, but in case you're talking about PostgreSQL, the chapter "System Catalogs" in the documentation should give you all the information you need. -- Peter Eisentraut http://developer.postgresql.org/~petere/