| From: | Miroslav Šimulčík <simulcik(dot)miro(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: function for setting/getting same timestamp during whole transaction |
| Date: | 2013-02-09 09:13:23 |
| Message-ID: | CAHRNM68ifYbX8Ef4L9ueMwOEdFgekKTjO4-QEqdVV00jia6YoA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> I might be confused here, but I think the point is that if you pass
> "true" as the third argument to set_config, the setting lasts only for
> the duration of the current transaction, like SET LOCAL. Which I
> think solves your problem.
Yes, but at the end of transaction it is reset to the value it has before
transaction (session level value), which can be nonempty. I wrote example
about this problem lately in this thread.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlo Stonebanks | 2013-02-09 17:52:31 | Tcl & PG on Win 7 64 bit - is it working for anyone? |
| Previous Message | Chris Travers | 2013-02-09 05:02:25 | Use case for deferrable check constraints, given inherited tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2013-02-09 09:25:14 | Re: Considering Gerrit for CFs |
| Previous Message | Pavel Stehule | 2013-02-09 08:52:00 | performance regression in 9.2 CTE with SRF function |