Re: pg_dump -> \i infile

From: Erik Price <eprice(at)ptc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump -> \i infile
Date: 2003-06-12 16:30:12
Message-ID: 3EE8AA94.5090508@ptc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Erik Price <eprice(at)ptc(dot)com> writes:
>
>>I am doing some unit testing of my application code, which requires me
>>to often reset my Postgres 7.3.2 (Cygwin) development database to
>>certain known data. The problem that I am running into seems to be
>>this: if I try to load a database (schema and data) using the
>>"\i filename" command in psql, it fails. However, it works fine when I
>>try to load the exact same file from outside of the psql client (i.e.,
>>my bash shell in Cygwin) using the "psql -d databasename -f filename"
>>command.
>
>
> I do that all the time, and it works fine for me. I suspect some
> Cygwin-specific problem (or, perhaps, pilot error?). What failure are
> you seeing, exactly?

Args. Looks like you're right, it was a one-day (multiple-time) error.
Now it seems to work fine.

Thanks anyway Tom.

Erik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-06-12 16:33:08 Re: Is the max size of a table limited by the max file size
Previous Message Jeff Boes 2003-06-12 16:25:01 Temp tables, indexes and DELETE vs. TRUNCATE