| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | Konstantin Goudkov <bcc(at)idftech(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Temp tables and copy |
| Date: | 2003-09-10 01:42:24 |
| Message-ID: | Pine.LNX.4.21.0309101141120.21349-100000@linuxworld.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 8 Sep 2003, Konstantin Goudkov wrote:
>
> Hey guys, not sure if this is the right place to post.
> Not even sure if this is a bug or a feature :)
>
> When I create a temp table and then try to copy some data into the
> table, if the data is corrupt and the synchronization is lost - the
> table also seems to get lost.
Temp tables only exist for the current session (connection). If there is a
problem with the copy and the connection gets reset, the session is
therefore ended and the temp table remove. As such it is a feature.
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-10 01:46:35 | Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...) |
| Previous Message | Gavin Sherry | 2003-09-10 01:40:05 | Re: Can I use PostgreSQL to develop a self-organizing |