From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tim McAuley <mcauleyt(at)tcd(dot)ie>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
Date: | 2003-09-26 20:50:27 |
Message-ID: | Pine.LNX.4.33.0309261449420.1342-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
> scott.marlowe writes:
>
> > but I get basically the same thing if I dump it to a .sql file and do:
> >
> > psql dbname <dbname.sql
>
> Use psql -f dbname.sql instead.
and the output is:
psql:webport.sql:803: ERROR: function "odbc_user" already exists with
same argument types
REVOKE
REVOKE
GRANT
You are now connected as new user "ayousuff".
psql:webport.sql:869: ERROR: literal newline found in data
HINT: Use "\n" to represent newline.
CONTEXT: COPY FROM, line 59
You are now connected as new user "smarlowe".
You are now connected as new user "ayousuff".
CREATE INDEX
CREATE INDEX
CREATE INDEX
the same. It doesn't tell me which table in my dump caused the problem,
and it certainly isn't line 59 of the dump file, but of the table
producing the error.
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-09-26 20:56:31 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
Previous Message | Tom Lane | 2003-09-26 20:49:30 | Re: Schema backup |
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2003-09-26 20:53:46 | Re: 2-phase commit |
Previous Message | Peter Eisentraut | 2003-09-26 20:47:38 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-09-26 20:56:31 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
Previous Message | Peter Eisentraut | 2003-09-26 20:47:38 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |