From: | tomasz konefal <twkonefal(at)yahoo(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | transactions outside the database... |
Date: | 2002-01-31 14:46:28 |
Message-ID: | 20020131144628.13200.qmail@web12007.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello,
i'm hoping that someone can help me with a transaction problem i'm stuck
on. i have a little web site which allows (authorized) people to create user
accounts on a FreeBSD box via web interface. i keep track of these user
accounts via postgres database (things like activation
date/status/expiry/quota/billing/etc..) this is implemented in perl using
dbi. i also call a second secure script that creates the system accounts
using a call to 'pw'.
my problem is that i don't know how to guarantee that the account is
created/modified/erased in BOTH the system password database and the postgres
database. i figured that maybe i could reverse one transaction if the other
failed, but what if for some reason i can't reverse a modification to the
system password db? can anyone offer any advice, or pointers on handling
this problem?
thanks,
twkonefal
______________________________________________________________________
Web-hosting solutions for home and business! http://website.yahoo.ca
From | Date | Subject | |
---|---|---|---|
Next Message | David Link | 2002-01-31 15:03:57 | Re: Upgrade 7.0.3 -> 7.1.3 problems! |
Previous Message | David.Lofstrand | 2002-01-31 14:41:30 | Re: runtime queries... |