Postgres Pro
Downloads
Home   >   mailing lists

Another conversion from ASA to PostGres how to - Mailing list pgsql-general

From Mike Gould
Subject Another conversion from ASA to PostGres how to
Date
Msg-id 20070615150619.850f7f15@mail.allcoast.net
Whole thread Raw
List pgsql-general
Tree view
All,

As the subject says we are converting from Sybase's SQL Anywhere to PostGres 8.2.4.  One of the features in ASA is a SET OPTION PUBLIC.login_procedure='DBA.login_check'.

After a user is authenticated on a connection, if this setting is set, then the database automatically triggers this procedure to be run.  We use this to set up a bunch of "global variables" and other settings which need to be updated when a connection is made.  How would I handle this in PostGres?

Best Regards,

Michael Gould
All Coast Intermodal Services, Inc.
904-376-7030

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: pg_restore out of memory
Next
From: Francisco Reyes
Date:
Subject: pg_restore can't restore using list to select?