| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Joe Abbate <jma(at)freedomcircle(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Selecting user-defined CASTs |
| Date: | 2011-08-09 07:26:58 |
| Message-ID: | 4E40E142.9060205@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 09.08.2011 08:27, Tom Lane wrote:
> select ... from pg_cast c where c.oid>= 16384;
>
> What that really does is eliminate the casts that were installed during
> initdb, which are at least a subset of the "system" ones, and might be
> all of them depending on what you feel a "system" cast is. The main
> shortcoming of it is that there's no very good way to eliminate casts
> installed by extensions, should you want to not consider those "user"
> casts.
That will also exclude "system" casts that have been removed, and
manually re-created later.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian Weimer | 2011-08-09 07:32:42 | Re: libedit memory stomp is apparently fixed in OS X Lion |
| Previous Message | Shigeru Hanada | 2011-08-09 06:41:10 | Re: psql: display of object comments |