transactions outside the database...

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

In response to

Responses

Browse pgsql-general by date

  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...