Re: [BUGS] more information on OSX pg_dump problem

2002-12-01 Thread Theodore Petrosky
I've just finished the install of 7.3 release on mac OSX 10.2.2. I notice that initdb will permit me to init a directory for use, then when running postmaster using the directory I get a fatal error: FATAL: invalid value for option 'LC_TIME': 'en' Shouldn't initdb check and not init with this lo

Re: [BUGS] more information on OSX pg_dump problem

2002-11-24 Thread Theodore Petrosky
Tom, I have checked the dump file with hexedit and find that the lines end with '0A' hex. Only one character. What is strange is that I have multiple tables, some of them are going in fine. Ted -- Tom Lane <[EMAIL PROTECTED]> wrote: > Theodore Petrosky <[EMAIL PROTECTED]> writes: > > COPY "fco

Re: [BUGS] more information on OSX pg_dump problem

2002-11-24 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > COPY "fcopenjobs" FROM stdin; > If I copy and paste the lines (from the dump file) > into psql one by one, it will input fine. However, If > I cut and paste more that two lines, the input fails. I'm wondering about newline representations, myself.

[BUGS] more information on OSX pg_dump problem

2002-11-24 Thread Theodore Petrosky
So, as I said I have a problem restoring data created with pg_dump. Here is something interesting. The pg_dump file contains a couple of tables. Some of them are working. If I go to the line that psql is telling me is failing, I find the commands to begin recreating the table: COPY "fcopenjobs" F