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
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
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
Hi again, I really must be missing something fundamental here as I
cannot seem to solve this problem:
I have a loop that queries one table (without any contraints) and
writes to a second table (with constraints). Here's what the loop
looks like in pseudo-code:
while True:
1) query old table
On Oct 1, 2007, at 11:02 AM, [EMAIL PROTECTED] wrote:
Hi again, I really must be missing something fundamental here as I
cannot seem to solve this problem:
I have a loop that queries one table (without any contraints) and
writes to a second table (with constraints). Here's what the loop
Hi Michael,
As I tried to show in the pseudo-code, the INSERTS look like they're
happening during the query (in step 1), well after the save/commit. I
even tried to add a flush and, when I turn on echo mode, I see inserts
happening at the query step. Is this even possible?
Mark
On Oct 1, 11:49
On Oct 1, 2007, at 12:12 PM, [EMAIL PROTECTED] wrote:
Hi Michael,
As I tried to show in the pseudo-code, the INSERTS look like they're
happening during the query (in step 1), well after the save/commit. I
even tried to add a flush and, when I turn on echo mode, I see inserts
happening at
Hi Michael,
I'm creating the session by:
Session = sessionmaker(bind = engine,
autoflush = True,
transactional = True)
session = Session()
and I'm not using any threading at all (therefore no thread-local
storage). The only thing between the
On Oct 1, 2007, at 2:29 PM, [EMAIL PROTECTED] wrote:
Hi Michael,
I'm creating the session by:
Session = sessionmaker(bind = engine,
autoflush = True,
transactional = True)
session = Session()
and I'm not using any threading at all