X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id BFB1B475458
	for <pgsql-sql@postgresql.org>; Wed, 16 Apr 2003 06:17:48 -0400 (EDT)
Received: from jobs1.unisoftbg.com (unknown [194.12.229.207])
	by postgresql.org (Postfix) with SMTP id C8616475458
	for <pgsql-sql@postgresql.org>; Wed, 16 Apr 2003 06:17:14 -0400 (EDT)
Received: (qmail 10016 invoked from network); 16 Apr 2003 11:51:29 -0000
Received: from unknown (HELO t1.unisoftbg.com) (194.12.229.193)
	by 0 with SMTP; 16 Apr 2003 11:51:29 -0000
Message-ID: <3E9D1F55.9582B0E6@t1.unisoftbg.com>
Date: Wed, 16 Apr 2003 11:16:05 +0200
From: pginfo <pginfo@t1.unisoftbg.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: changing column size and type.
References: <3E9C155B.7A694675@t1.unisoftbg.com>
	<000401c303a4$b2d88500$7308a18e@cleartag>
	<3E9CDF76.C2B2D50@t1.unisoftbg.com> <3E9CF0DB.60509@oasis.net.au>
Content-Type: multipart/alternative;
	boundary="------------24B4518BE36B1F17FA5181C3"
X-Spam-Status: No, hits=-29.0 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,HTML_10_20,ORIGINAL_MESSAGE,
	QUOTED_EMAIL_TEXT,RCVD_IN_DSBL,RCVD_IN_OSIRUSOFT_COM,
	REFERENCES,REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/251
X-Sequence-Number: 12952

--------------24B4518BE36B1F17FA5181C3
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Rudi,

I readet the doc, but it is about how to ann new column.
That is well documented in pgDoc's.

I will to change the column type of existing column.
For example if my columnt was declared as int4, I will to change it to
int8.
Or if it was varchar(20) I will to make it varchar(100) and so on.
Also I will it without to dump the db.

regards,
ivan.

Rudi Starcevic wrote:

>  Ivan,
>
> This link show's how to do it online.
>
> http://www.edoceo.com/liberum/default.php?doc=postgresql-tricks
>
> There are other links around too.
>
> Cheers
> Rudi
>
>
> pginfo wrote:
>
>> Hi George,
>>
>> It is possible to do it so, but I wanted some better solution.
>> For example with oracle I can do it "online".
>>
>> regards,
>> ivan.
>>
>> George Weaver wrote:
>>
>>
>> > Hi Ivan,
>> >
>> > I don't know if this is a recommended practice or not, but you can
>> > try the
>> > following.
>> >
>> > Use PgDump to back up the entire database as a text file.  Edit the
>> > backup
>> > text file and change the CREATE TABLE statement for the table you
>> > want to
>> > change, changing the column width to the new width desired.
>> > Restore the
>> > database.  The database will be restored with the new width for the
>> > column
>> > in the table.
>> >
>> > The ability to do this depends on the size of the database, whether
>> > it can
>> > be taken off line, etc. etc.
>> >
>> > HTH
>> > George
>> >
>> > ----- Original Message -----
>> > From: "pginfo" <pginfo@t1.unisoftbg.com>
>> > To: <pgsql-sql@postgresql.org>
>> > Sent: Tuesday, April 15, 2003 9:21 AM
>> > Subject: [SQL] changing column size and type.
>> >
>> >
>> >>  Hi,
>> >>
>> >>  I am using pg 7.3.2.
>> >>
>> >>  Is it possible to change:
>> >>  - column size ot existing table.
>> >>  - columnt size ( it is varchar basicaly).
>> >>
>> >>  The problem is that the table have many freferences from and to
>> >>  it.
>> >>
>> >>  many thanks,
>> >>  ivan.
>> >>
>> >>
>> >>  ---------------------------(end of
>> >>  broadcast)---------------------------
>> >>  TIP 5: Have you checked our extensive FAQ?
>> >>
>> >>  http://www.postgresql.org/docs/faqs/FAQ.html
>> >>
>> >>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>>
>



--------------24B4518BE36B1F17FA5181C3
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
Hi Rudi,

<P>I readet the doc, but it is about how to ann new column.
<BR>That is well documented in pgDoc's.

<P>I will to change the column type of existing column.
<BR>For example if my columnt was declared as int4, I will to change it
to int8.
<BR>Or if it was varchar(20) I will to make it varchar(100) and so on.
<BR>Also I will it without to dump the db.

<P>regards,
<BR>ivan.

<P>Rudi Starcevic wrote:
<BLOCKQUOTE TYPE=CITE>&nbsp;Ivan,

<P>This link show's how to do it online.

<P><A HREF="http://www.edoceo.com/liberum/default.php?doc=postgresql-tricks" class="moz-txt-link-freetext">http://www.edoceo.com/liberum/default.php?doc=postgresql-tricks</A>

<P>There are other links around too.

<P>Cheers
<BR>Rudi
<BR>&nbsp;

<P>pginfo wrote:
<BLOCKQUOTE type="cite" cite="mid3E9CDF76.C2B2D50@t1.unisoftbg.com">
<PRE wrap="">Hi George,

It is possible to do it so, but I wanted some better solution.
For example with oracle I can do it "online".

regards,
ivan.

George Weaver wrote:

</PRE>

<BLOCKQUOTE type="cite">
<PRE wrap="">Hi Ivan,

I don't know if this is a recommended practice or not, but you can try the
following.

Use PgDump to back up the entire database as a text file.&nbsp; Edit the backup
text file and change the CREATE TABLE statement for the table you want to
change, changing the column width to the new width desired.&nbsp; Restore the
database.&nbsp; The database will be restored with the new width for the column
in the table.

The ability to do this depends on the size of the database, whether it can
be taken off line, etc. etc.

HTH
George

----- Original Message -----
From: "pginfo" <A HREF="mailto:pginfo@t1.unisoftbg.com" class="moz-txt-link-rfc2396E">&lt;pginfo@t1.unisoftbg.com>
</A>To: <A HREF="mailto:pgsql-sql@postgresql.org" class="moz-txt-link-rfc2396E">&lt;pgsql-sql@postgresql.org>
</A>Sent: Tuesday, April 15, 2003 9:21 AM
Subject: [SQL] changing column size and type.

</PRE>

<BLOCKQUOTE type="cite">
<PRE wrap="">Hi,

I am using pg 7.3.2.

Is it possible to change:
- column size ot existing table.
- columnt size ( it is varchar basicaly).

The problem is that the table have many freferences from and to it.

many thanks,
ivan.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

<A HREF="http://www.postgresql.org/docs/faqs/FAQ.html" class="moz-txt-link-freetext">http://www.postgresql.org/docs/faqs/FAQ.html

</A></PRE>
</BLOCKQUOTE>
</BLOCKQUOTE>

<PRE wrap=""><!---->

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

<A HREF="http://www.postgresql.org/docs/faqs/FAQ.html" class="moz-txt-link-freetext">http://www.postgresql.org/docs/faqs/FAQ.html

</A></PRE>
</BLOCKQUOTE>
&nbsp;</BLOCKQUOTE>
&nbsp;</HTML>

--------------24B4518BE36B1F17FA5181C3--