Re: Length of Varchar - Mailing list pgsql-admin

From Tom Lane
Subject Re: Length of Varchar
Date
Msg-id 13426.1043423139@sss.pgh.pa.us
Whole thread Raw
In response to Re: Length of Varchar  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Length of Varchar  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Robert Treat <xzilla@users.sourceforge.net> writes:
> There is a "gamblers lunch", for those willing to risk total system
> failure and the lives of there first born child.

Aw, it's not that dangerous ;-).  You can improve your odds considerably
if you issue BEGIN; before you start dorking with the system tables,
and COMMIT only after you're satisfied you have things right.  If you
realize you blew it, ROLLBACK.

Still, I'd recommend practicing on a scratch database before you do it
for real.

            regards, tom lane

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Length of Varchar
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: VACUUM warning message.