On Monday 28 May 2007 23:43:37 Michael Bayer wrote:
> On May 28, 2007, at 3:33 AM, [EMAIL PROTECTED] wrote:
> > To avoid trouble if erasing fails, i may also add some sort of
> > state-flag "is_temporary" to all those records, so they can be
> > visible within the transaction (flag is True), but n
On May 28, 2007, at 8:33 PM, dvd wrote:
>
>
>
> On May 28, 10:49 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
>> On May 28, 2007, at 11:57 AM, dvd wrote:
>>
>>
>>
>>> If temporary tables are useful for other people, I can write an
>>> acceptable patch
>>> to the Table/Engine code (currently I do
On May 28, 1:45 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On May 28, 2007, at 3:28 AM, Eric Ongerth wrote:
> > Obviously a minor concern, and why am I even bothering? Because i'm
> > stuck in sqlite until I can get psycopg2 working in order to migrate
> > to postgresql so I can actually U
On May 28, 10:49 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On May 28, 2007, at 11:57 AM, dvd wrote:
>
>
>
> > If temporary tables are useful for other people, I can write an
> > acceptable patch
> > to the Table/Engine code (currently I don't even know whether
> > temporary tables are
> > s
On May 28, 2007, at 11:57 AM, dvd wrote:
>
> If temporary tables are useful for other people, I can write an
> acceptable patch
> to the Table/Engine code (currently I don't even know whether
> temporary tables are
> supported by all the DBMSes).
this is fine, i would add the flag "temporary=T
On May 28, 2007, at 3:28 AM, Eric Ongerth wrote:
>
> Just to get this into the searchable domain in case anyone else runs
> into the same errors...
>
> sqlalchemy docs indicate that sqlite "parses foreign key constraints,
> but does not enforce them". So far, so good. But it doesn't mention
>
On May 28, 2007, at 3:33 AM, [EMAIL PROTECTED] wrote:
> To avoid trouble if erasing fails, i may also add some sort of
> state-flag "is_temporary" to all those records, so they can be
> visible within the transaction (flag is True), but not outside -
> without the flag being cleared. Thus if rem
On May 28, 2007, at 2:27 AM, Alchemist wrote:
>
> I developed my web application in TurboGears 1.0.1 (Python 2.4,
> CherryPy 2.2.1 and SQLAlchemy 0.3.6) and used Postgresql 8.2 as my
> backend. Also, I am using psycopg2.
>
> I am running stress tests (using tools such as WAPT and Web
> Applicat
Hi all,
I need to create a temporary table on PostgreSQL, but unfortunately
the Table
object doesn't support this.
I'd like to know how to obtain the "CREATE TABLE" instruction out of a
Table
object without actually creating it. That way I can alter the SQL
instruction
with something like this:
Recompiled pysqlite2 using MinGW tools. For those who interested -
http://techtonik.rainforce.org/2007/05/how-to-compile-pysqlite-for-windows.html
Direct link to binary distribution: http://rainforce.org/sqlite/bindings/
--~--~-~--~~~---~--~~
You received this me
On May 28, 12:03 am, I wrote:
> I'm attempting to switch from sqlite to postgresql (i want to make use
> of postgresql's enforcement of foreign key constraints, among other
> features) and having a tough time getting anywhere with the psycopg2
> adapter.
Federico the developer answered my email
@Andreas Jung
Thanks.
So the problems might be coming either from CherryPy (the TurboGears
server/controller) or from Kid templates (TurboGears templates).
Andreas Jung wrote:
> --On 27. Mai 2007 23:45:43 -0700 Alchemist <[EMAIL PROTECTED]> wrote:
>
> >
> > @Andreas Jung
> > What SA configurat
Just to get this into the searchable domain in case anyone else runs
into the same errors...
sqlalchemy docs indicate that sqlite "parses foreign key constraints,
but does not enforce them". So far, so good. But it doesn't mention
(nor could I find any reference to this in sqlite3's own docs) t
I'm attempting to switch from sqlite to postgresql (i want to make use
of postgresql's enforcement of foreign key constraints, among other
features) and having a tough time getting anywhere with the psycopg2
adapter.
psycopg's website is down and was down the last two times I looked for
it over t
> > > add on top of this versioning/bitemporalism and things get
> > > tough...
> >
> > big words again...hold on...zero google hits for
> > 'bitemporalism'...OK i guess that means "two things happening at
> > once"
>
> I think he means the distinction between actual time and record
> time of temp
15 matches
Mail list logo