| From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | alter column to varchar without view drop/re-creation |
| Date: | 2014-08-29 18:33:52 |
| Message-ID: | 5400C790.50006@encs.concordia.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello list, <br>
<br>
May I know is there a way to "alter column type to varchar"
(previous is varchar(***)) without view drop/re-creation?<br>
<br>
Basically, looking for a way to change column without have to
drop/re-create dependent views. <br>
<br>
varchar(***) to varchar and no date/numeric changes. <br>
<br>
Thanks a lot!<br>
Emi<br>
---<br>
<b>PostgreSQL 8.3.18 on x86_64</b><br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 611 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2014-08-29 19:09:08 | Re: alter column to varchar without view drop/re-creation |
| Previous Message | Patrick Dung | 2014-08-29 18:23:26 | Is there a function to save schema history internally? |