[sqlalchemy] Mapping serial(auto increment) Postgres to bigserial

How does one specify that the auto incrementing field should map to big serial and not serial? thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: one-to-many access and modification

-Original Message- From: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ken Pierce Sent: 29 September 2007 00:21 To: sqlalchemy Subject: [sqlalchemy] one-to-many access and modification Hello all, I just got into using sqlalchemy today and I have a

[sqlalchemy] Re: IntegrityError during query?

Hi Michael, sorry about the lack of information; I wasn't clear on what you were looking for. The failing constraint is a customer one for email addresses: CREATE DOMAIN base.email as TEXT CHECK (VALUE ~ '[EMAIL PROTECTED](\\.[-\\w]+)*\\.\\w{2,4}$'); Thanks again! Mark On Oct 1, 5:46

[sqlalchemy] Re: Mapping serial(auto increment) Postgres to bigserial

On Oct 2, 10:06 am, voltron [EMAIL PROTECTED] wrote: How does one specify that the auto incrementing field should map to big serial and not serial? Use the sqlalchemy.databases.postgres.PGBigInteger datatype for that field. --~--~-~--~~~---~--~~ You received

[sqlalchemy] Re: IntegrityError during query?

On Oct 2, 2007, at 7:56 AM, [EMAIL PROTECTED] wrote: Hi Michael, sorry about the lack of information; I wasn't clear on what you were looking for. The failing constraint is a customer one for email addresses: CREATE DOMAIN base.email as TEXT CHECK (VALUE ~ '[EMAIL

[sqlalchemy] Re: IntegrityError during query?

On Oct 2, 2007, at 7:56 AM, [EMAIL PROTECTED] wrote: Hi Michael, sorry about the lack of information; I wasn't clear on what you were looking for. The failing constraint is a customer one for email addresses: CREATE DOMAIN base.email as TEXT CHECK (VALUE ~ '[EMAIL

[sqlalchemy] Re: Multiple database connections - Using ORM to copy table data from one DB to another

I had originally tried the expunge method, as in the code I had attached, but if I just use session.save(policy), I get the aforementioned exception, and if I use session.save_or_update(policy) it simply does nothing. When using session.merge(policy), I get the following exception:

[sqlalchemy] Re: Multiple database connections - Using ORM to copy table data from one DB to another

On Oct 2, 2007, at 10:32 AM, Cory Johns wrote: I had originally tried the expunge method, as in the code I had attached, but if I just use session.save(policy), I get the aforementioned exception, and if I use session.save_or_update(policy) it simply does nothing. When using

[sqlalchemy] Re: Mapping serial(auto increment) Postgres to bigserial

Thanks On Oct 2, 3:54 pm, Ants Aasma [EMAIL PROTECTED] wrote: On Oct 2, 10:06 am, voltron [EMAIL PROTECTED] wrote: How does one specify that the auto incrementing field should map to big serial and not serial? Use the sqlalchemy.databases.postgres.PGBigInteger datatype for that field.

[sqlalchemy] Fwd: Migrate: svndump loaded into google code project

I thought this might be of interest to many of you. We've been trying to gather up a few people to and revive the floundering SQLAlchemy migrations project. There's actually some pretty good code there already, it just needs a bit of love and tenderness to get it up to date wth SQLALchemy 0.4.