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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
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 22:00:11
Message-ID: Pine.LNX.4.44.0309262358230.11938-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

scott.marlowe writes:

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

The table is the one the COPY command on line 869 in file webport.sql
mentions and the problem data is on line 928 of that file.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-26 22:02:12 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous Message Tom Lane 2003-09-26 21:14:36 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-26 22:02:12 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous Message Hiroshi Inoue 2003-09-26 21:52:44 Re: pgsql-server/src/backend catalog/index.c comma ...

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2003-09-26 22:02:12 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous Message Tom Lane 2003-09-26 21:14:36 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)