Re: pg_dump -> \i infile - Mailing list pgsql-general

From Erik Price
Subject Re: pg_dump -> \i infile
Date
Msg-id 3EE8AA94.5090508@ptc.com
Whole thread Raw
In response to Re: pg_dump -> \i infile  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

Tom Lane wrote:
> Erik Price <eprice@ptc.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


pgsql-general by date:

Previous
From: Jeff Boes
Date:
Subject: Temp tables, indexes and DELETE vs. TRUNCATE
Next
From: Bruce Momjian
Date:
Subject: Re: Is the max size of a table limited by the max file size