Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

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.

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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)

Browse pgsql-jdbc by date

  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)