| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Replacement for tgisconstraint? (Upgrade from 8.4 to 9.0.5) |
| Date: | 2011-11-19 15:44:38 |
| Message-ID: | 17141.1321717478@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> writes:
> 1) Can anyone suggest equivalent PG9 replacement for those statements, or
> at least give me some hints?
Per
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=9a915e596
I also replaced the tgisconstraint column
with tgisinternal; the old meaning of tgisconstraint can now be had by
testing for nonzero tgconstraint, while there is no other way to get
the old meaning of nonzero tgconstraint, namely that the trigger was
internally generated rather than being user-created.
It's not real clear to me whether your views actually want tgconstraint
= 0, which would be the exact translation, or NOT tgisinternal, which
might be a closer approximation to their intention.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Tanzer | 2011-11-19 16:01:34 | Re: Replacement for tgisconstraint? (Upgrade from 8.4 to 9.0.5) |
| Previous Message | Andrus | 2011-11-19 13:34:59 | Re: How to install latest stable postgresql on Debian |