X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F266C9DC88D for ; Thu, 2 Mar 2006 09:14:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62761-09 for ; Thu, 2 Mar 2006 09:14:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54309.mail.yahoo.com (web54309.mail.yahoo.com [206.190.49.119]) by postgresql.org (Postfix) with SMTP id B544A9DC80A for ; Thu, 2 Mar 2006 09:14:50 -0400 (AST) Received: (qmail 31094 invoked by uid 60001); 2 Mar 2006 13:14:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding; b=TViU09D//jQKovSbHycv2lmLWmS68TbIXA9HbHuB9rEr8INMY/WranBQ6O+THOZSWrlNHgf1LI1B9sz5tDHdHFXScopEo8YHMRiAZng9Jw7gOk+dNXiTbt8sOjYabeba51hGg7fEgusdAe8/601DYfM2rwgZIwvU4b6mfIy7ve8= ; Message-ID: <20060302131454.31092.qmail@web54309.mail.yahoo.com> Received: from [213.91.244.26] by web54309.mail.yahoo.com via HTTP; Thu, 02 Mar 2006 05:14:54 PST Date: Thu, 2 Mar 2006 05:14:54 -0800 (PST) From: Emil Rachovsky Subject: Without OIDs To: "pgsql-general@postgresql.org" Cc: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.845 required=5 tests=[AWL=-0.513, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 0.845 X-Spam-Level: X-Archive-Number: 200603/52 X-Sequence-Number: 91917 Hello, I'm creating a temporary table in a function and using Alter Table ... Without OIDs, but when the function is called for the second time I get an error "relation with OIDs ... doesn't exist" on an insert statement to the table. I'm using Postgre 8.0 which says that supports without OIDs. Any suggestions? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com