Skip site navigation (1) Skip section navigation (2)

Postgres session

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PGSQL-GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Postgres session
Date: 2000-11-16 20:30:16
Message-ID: 3A1443D8.94C0D8E1@ec.gc.ca (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

Is the session between pg_connect() and pg_close() a postgres session?
I am using "select * into temp table temp_table from ...;" to create a
temp table, and I thought it should be drop upon pg_close().

    In fact it is dropped when I check it using psql or pgaccess
(there's no such relation as temp_table); however, upon reloading the
page, a postgres error showed up: "PostgresSQL query failed:  ERROR:
Relation 'temp_table' already exists".  What's wrong here?  Thank you.


- Bernie

Attachment: bernie.huang.vcf
Description: text/x-vcard (315 bytes)

pgsql-general by date

Next:From: Michael ForkDate: 2000-11-16 21:55:02
Subject: Starting Postmaster with -d2
Previous:From: Lisa ReilmanDate: 2000-11-16 20:23:02
Subject: my C pgm

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group