On Friday 24 January 2003 07:37, Andre Schubert wrote:
> i have a little question on changing the length of a varchar field.
> Is there another way than dump and reload if i want to change the length
> of a varchar field ?
in 7.3:
BEGIN;
ALTER TABLE foo RENAME your_field TO your_field_old;
ALTER
On Friday 24 January 2003 09:26, Ian Barwick wrote:
> On Friday 24 January 2003 07:37, Andre Schubert wrote:
> > i have a little question on changing the length of a varchar field.
> > Is there another way than dump and reload if i want to change the length
> > of a varchar field ?
>
> in 7.3:
>
>
Dear All,
We are considering moving our existing PostgreSQL installation from a single
server hosting both live and test DBs and backend processing, to a dual node
RedHat Advanced server cluster.
We envisage the live DB on one node and test DB and backend processing on
the other with external sha
On Fri, 2003-01-24 at 05:33, Ian Barwick wrote:
> On Friday 24 January 2003 09:26, Ian Barwick wrote:
> > On Friday 24 January 2003 07:37, Andre Schubert wrote:
> > > i have a little question on changing the length of a varchar field.
> > > Is there another way than dump and reload if i want to cha
Robert Treat <[EMAIL PROTECTED]> 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 ta
I get the following messages while vacuuming
is there anything alarming?
regds
mallah.
On Saturday 25 January 2003 07:11 am, you wrote:
> SET autocommit TO 'on';VACUUM ANALYZE
> WARNING: Rel site_search: Uninitialized page 1 - fixing
> WARNING: Rel site_search: Uninitialized page 2 - fixing
