X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 04316D1E3B5 for ; Wed, 12 May 2004 20:48:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16563-02 for ; Wed, 12 May 2004 20:47:54 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id BA204D1E3A3 for ; Wed, 12 May 2004 20:47:51 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i4CNlpSx050388 for ; Wed, 12 May 2004 23:47:51 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i4CNdwQE041392 for pgsql-admin@postgresql.org; Wed, 12 May 2004 23:39:58 GMT From: "Loeke" X-Newsgroups: comp.databases.postgresql.admin Subject: the schema public Date: Thu, 13 May 2004 01:40:05 +0200 Organization: KULeuvenNet Lines: 11 Message-ID: <1084405200.67669@seven.kulnet.kuleuven.ac.be> X-Complaints-To: abuse@belnet.be X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Cache-Post-Path: seven.kulnet.kuleuven.ac.be!unknown@10-4-148-255.kotnet.org X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM, PRIORITY_NO_NAME X-Spam-Level: * X-Archive-Number: 200405/149 X-Sequence-Number: 13465 can someone explain me how this works: on a newly created software db the schema 'public' has the right temporary, and the schema itself (within the db) has the right create and usage, but the creates for example are not temporary.. as in create temporary table.. i'm confused:) help me out plz