X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B50B52AB2 for ; Sat, 30 Jul 2005 00:20:29 -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 25447-05 for ; Sat, 30 Jul 2005 03:20:21 +0000 (GMT) Received: from mr1.surnet.cl (smtp1.surnet.cl [216.155.73.162]) by svr1.postgresql.org (Postfix) with ESMTP id 9313752A00 for ; Sat, 30 Jul 2005 00:20:19 -0300 (ADT) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.031.3) id 42587EDE0191668C; Fri, 29 Jul 2005 23:19:32 -0400 Received: from smtp2.surnet.cl (smtp2.surnet.cl []) by mr1.surnet.cl ([216.155.73.168]); Sat, 30 Jul 2005 03:19:32 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE300F7538C; Fri, 29 Jul 2005 23:19:40 -0400 Received: from alvh.no-ip.org (200.85.218.66) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF60005F0C10; Fri, 29 Jul 2005 23:20:10 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 39F10C2D450; Fri, 29 Jul 2005 23:21:15 -0400 (CLT) Date: Fri, 29 Jul 2005 23:21:15 -0400 From: Alvaro Herrera To: Bruce Momjian Cc: Halley Pacheco de Oliveira , pgsql-docs@postgresql.org Subject: Re: current_schemas() Message-ID: <20050730032115.GA21895@alvh.no-ip.org> Mail-Followup-To: Bruce Momjian , Halley Pacheco de Oliveira , pgsql-docs@postgresql.org References: <20050705111440.62083.qmail@web52704.mail.yahoo.com> <200507300230.j6U2UDS27599@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200507300230.j6U2UDS27599@candle.pha.pa.us> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.424 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200507/34 X-Sequence-Number: 3160 On Fri, Jul 29, 2005 at 10:30:13PM -0400, Bruce Momjian wrote: > > Why not just use pg_catalog.current_schemas()? The function is current_schemas(bool), that's why this example doesn't work: > > teste=# SELECT current_schemas(); > > ERROR: function current_schemas() does not exist > > HINT: No function matches the given name and argument types. You may need to add explicit type casts. -- Alvaro Herrera () "Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)