Re: temp tables

2007-04-17 Thread Phil Davis
On 16/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: [...] > After they are displayed...they can be nuked...but the guy working on > this piece told me he couldn't get the temp table to stick around long > enough with the django connection to be able to get the results back > because I believ

Re: temp tables

2007-04-17 Thread Atilla
On 16/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > We are trying to use them to generate a report where a bunch of > calculations are being made... via a custom sql query... then hand all > of the results back to my django view to display. > > After they are displayed...they can be

Re: temp tables

2007-04-16 Thread [EMAIL PROTECTED]
We are trying to use them to generate a report where a bunch of calculations are being made... via a custom sql query... then hand all of the results back to my django view to display. After they are displayed...they can be nuked...but the guy working on this piece told me he couldn't get the

Re: temp tables

2007-04-16 Thread Atilla
> Is there a way to force the db connection to stay open if you are > excecuting raw sql that is creating a temp table? When the connection > closes...the temp tables go away. > Temp tables are meant to be temporary. You can't guarantee, even with persistent db-connection pooling that the same