Re: just upgraded from 7.0 to version 7.3 problem with pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christoph Schmidt <cs(dot)wiechs(dot)ar(at)swol(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: just upgraded from 7.0 to version 7.3 problem with pg_dump
Date: 2002-12-17 23:29:51
Message-ID: 17516.1040167791@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Christoph Schmidt <cs(dot)wiechs(dot)ar(at)swol(dot)de> writes:
> So why not the standard ?

You can write it in the standard syntax if you wish.

pg_dump has its own reasons for using ALTER TABLE (which btw is also
fully standard): it wants to postpone creating indexes until after it's
done the bulk data loading, for speed reasons.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-12-18 00:02:36 Re: [NOVICE] [JDBC] JDBC - Open Office
Previous Message Christoph Schmidt 2002-12-17 20:47:33 just upgraded from 7.0 to version 7.3 problem with pg_dump