| From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: "Transaction over connections" |
| Date: | 2003-11-20 08:54:31 |
| Message-ID: | 200311201424.31676.shridhar_daithankar@persistent.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 20 November 2003 13:22, Lada 'Ray' Lostak wrote:
> So, my direct question: can I invoke automatically some function in PgSql
> to make condition to EVERY sql statement ? Or what way will be the best for
> performace ? Does PgSql allready include some support for this thing ? I
> have done something for Oracle, but it will not work at PgSql world.I am
> novice to PgSql at all.
Instead of transaction id use a boolean column which is isProduction and
default it to false.
When you want to make it visible, just update relevant table in a single
transaction and expose it thr. a view.
I think this is already suggested.
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-11-20 09:23:15 | Re: "Transaction over connections" |
| Previous Message | Lada 'Ray' Lostak | 2003-11-20 08:47:50 | Re: "Transaction over connections" |