| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Changing column types... |
| Date: | 2002-04-04 04:48:44 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOAEPICBAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
Some questions:
1. What is the difference between abstime and timestamp - they seem to
display equally...
2. Since int4 and abstime are binary compatible (ie int4::abstime works), is
there any serious problem with updating a pg_attribute row for an int4 and
changing it to and abstime? My experiments seem to work.
3. Is there any way of checking pg_type to check that two types are binary
compatible and can be substiuted in this way?
4. Is there any worth in me submitting a patch that will allow rudimentary
column type changing, so long as the types are binary compatible???
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-04-04 04:53:53 | Re: What's the CURRENT schema ? |
| Previous Message | Bruce Momjian | 2002-04-04 04:45:57 | Re: Locale support is now on by default |