temp table::persistance problem

Started by Emmanuel SARACCOover 24 years ago3 messagesgeneral
Jump to latest
#1Emmanuel SARACCO
emmanuel.saracco@d-interactive.com

hi,

I have big problem with temp tables on a v7.1... sometime they are not
deleted!
what can happened?
those temporaries tables are created in stored procedures who are called in
php.

any idea?

thanks, by

please, reply on esaracco@noos.fr and esaracco@aspasia.fr

#2Bruce Momjian
bruce@momjian.us
In reply to: Emmanuel SARACCO (#1)
Re: temp table::persistance problem

Not sure. We had some deletion problems in 7.0.X but 7.1.X should be OK.

hi,

I have big problem with temp tables on a v7.1... sometime they are not
deleted!
what can happened?
those temporaries tables are created in stored procedures who are called in
php.

any idea?

thanks, by

please, reply on esaracco@noos.fr and esaracco@aspasia.fr

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#3Keary Suska
hierophant@pcisys.net
In reply to: Emmanuel SARACCO (#1)
Re: temp table::persistance problem

Do you mean, not deleted "ever" or not when you expect them to be? If you
are using persistent connections in PHP, the table will remain until the
Apache process that possesses the connection is destroyed, or you
specifically destroy the table.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

Show quoted text

From: "Emmanuel SARACCO" <emmanuel.saracco@d-interactive.com>
Organization: Hub.Org Networking Services (http://www.hub.org)
Reply-To: "Emmanuel SARACCO" <emmanuel.saracco@d-interactive.com>
Date: Tue, 25 Sep 2001 16:14:56 +0200
To: pgsql-general@postgresql.org
Subject: [GENERAL] temp table::persistance problem

hi,

I have big problem with temp tables on a v7.1... sometime they are not
deleted!
what can happened?
those temporaries tables are created in stored procedures who are called in
php.

any idea?

thanks, by

please, reply on esaracco@noos.fr and esaracco@aspasia.fr

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster