on 10/11/03 6:48 PM, [EMAIL PROTECTED] purportedly said:
> Well, now I am writing a proposal, which among many other points,
> proposes to switch from the current hosting site of a non profit to a
> slightly more expensive one running PostgreSQL, (where I have some other
> projects.) I want to use
<[EMAIL PROTECTED]> writes:
> To follow-up then, if the temp schemas do not disappear, then over time
> what happens (as temp tables are instantiated during normal application
> usage), does the database end up with an ever-increasing number of these
> temp schemas?
No, you will never have more th
<[EMAIL PROTECTED]> writes:
> What's up with these miscellaneous schemas? Are they in fact related to
> the creation of temporary tables? Should they disappear when the session
> closes, as should the temporary table? If they continue persisting after
> the session closes, how do I get rid of them?
Hi David,
David Link wrote:
Hi All,
Here's a Conditional drop_table func for those interested. There was a
thread on this a long time back.
We do this all the time :
DELETE TABLE sales;
CREATE TABLE sales (...);
Hm. "all the time" enables all the warning lights -
what are you doing to have
On Sun, 2003-10-12 at 00:28, Andrew Sullivan wrote:
> On Fri, Oct 10, 2003 at 11:17:53PM +0100, Oliver Elphick wrote:
> > I haven't got any further than this, but I wonder if this is something
> > that would be useful to the whole project and not just to the
> > distributions. Any comments?
>
> N
Whenever I create a temporary table, with something like
CREATE TEMPORARY TABLE temptable1 AS SELECT * FROM paid.ad_hoc_query;
New schemas appear, with names like "pg_temp_1". I guess the appearance
of these schemas with "temp" in the name indicates that they are
"temporary" schemas and related t
On Sun, Oct 12, 2003 at 10:21:39AM +0100, Oliver Elphick wrote:
> I imagine a lot of people have such in-house set-ups. The question is
> whether the project itself should provide the structure to do it.
I'd love to have something like this. It'd be really useful to be able to
install multiple ve
On Thu, Oct 09, 2003 at 04:42:18PM +0200, Thierry Missimilly wrote:
> I don't know if it is really link to Postgres and ECPG but if you
> modifiy pgbch.pgc in the way that the
> transaction is limited to "BEGIN; END; ", it will never hang.
Do you mean it only hangs if you do automatic transaction
