| From: | Andreas <maps(dot)on(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | can I define own variables? |
| Date: | 2007-10-12 22:18:45 |
| Message-ID: | 470FF2C5.1080308@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
can I define connection-global variables within a ODBC connection ?
Like that:
connect to the DB
set my_user_id = 42
Later a trigger would set a timestamp and the user-id when a record gets
updated.
obviously different connections would need differnt variable-values.
the variable should only live until the connection gets terminated.
this user-id represent users of my application and I can't use postgres'
internal user-ids because I have the data sitting in a operational
server and another one for developing and testing, so the postgres ids
arent necessarily consistent between the 2 server-systems.
My application has it's own user management and those keys are used for
rel. integrity.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | brian | 2007-10-12 23:42:23 | Re: can I define own variables? |
| Previous Message | wido | 2007-10-12 21:25:29 | Re: Importing MySQL dump into PostgreSQL 8.2 |