transactions outside the database... - Mailing list pgsql-general

From tomasz konefal
Subject transactions outside the database...
Date
Msg-id 20020131144628.13200.qmail@web12007.mail.yahoo.com
Whole thread Raw
In response to runtime queries...  (David.Lofstrand@surgical-science.com)
List 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

pgsql-general by date:

Previous
From: Ellen Cyran
Date:
Subject: Function to Pivot data
Next
From: David Link
Date:
Subject: Re: Upgrade 7.0.3 -> 7.1.3 problems!