| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> |
| Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_get_triggerdef in pg_dump |
| Date: | 2003-06-18 16:16:51 |
| Message-ID: | 1055953010.48114.24.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> There might be other cases of legal direct change of system catalog
> entries, e,g. varchar to text, if they all are only names for internally
> identical data structures. Can you tell which datatypes may be legally
> interchanged?
If pg_cast.castfunc is 0, you should might be able to do a datatype
change safely.
http://candle.pha.pa.us/main/writings/pgsql/sgml/catalog-pg-cast.html#AEN49071
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Figueiredo Jr. | 2003-06-18 16:23:30 | Re: Fields float4 don't return any row when selecting a |
| Previous Message | Merlin Moncure | 2003-06-18 16:13:23 | Re: information Windows - PostgreSQL |