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