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
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 |