Re: pg_get_triggerdef in pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_get_triggerdef in pg_dump
Date: 2003-06-18 16:24:59
Message-ID: 22200.1055953499@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> writes:
> 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?

Right offhand I think text<->varchar and adjustment of length limits in
char, varchar, and perhaps numeric would be the only things useful
enough to worry about handling.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-06-18 16:54:03 Re: information Windows - PostgreSQL
Previous Message Francisco Figueiredo Jr. 2003-06-18 16:23:30 Re: Fields float4 don't return any row when selecting a