Received: from linux.midinet.net (IDENT:root@linux.midinet.net.mx [200.39.128.16]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA43473 for ; Tue, 31 Aug 1999 16:58:30 -0400 (EDT) (envelope-from mrodriguez@interimagen.net.mx) Received: from interimagen.net.mx (200-33-130-8.bozell.com [200.33.130.8] (may be forged)) by linux.midinet.net (8.9.3/8.9.3) with ESMTP id PAA06030; Tue, 31 Aug 1999 15:57:02 -0500 Sender: root@linux.midinet.net Message-ID: <37CC4147.D83D03DA@interimagen.net.mx> Date: Tue, 31 Aug 1999 15:55:35 -0500 From: Mauricio Rodriguez Organization: Interimagen X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9-19mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: php-pgsql@linuxports.com, pgsql-sql@postgresql.org Subject: Question about temporal tables... Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, does anybody know if postgres has a problem when you try to create a temporal table with the same name??? and I mean with a really lot of tries???? I mean, I have an intranet with a php3 script that creates temporal table call "temp1" and this is destroy inmedeately, when the script stop, but, after a lot of times to create this table it says, that can't create the table anymore, postgres has a problem with that??? because when I change the name of the table sometimes it works again, but sometimes, i have to destroy the DB and create again with psql, but I think this isn't normal, isn't it??? thanks -- Mauricio Rodriguez Cruz Interimagen Interactiva Departamento de desarrollo. Tel. 015-7243595 Fax. 015-2027101 Email: mrodriguez@interimagen.net.mx