Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group