| 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: | Whole Thread | Raw Message | 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 |