Everything was on OS X. Looks like it was a problem with spaces vs. tabs. Anyway, I went through and fixed all the lines and everything went in.
We had a strange problem restoring a 8.0.4 dump to a 8.1.1 server and this was the last of the data that had to be re-imported. > From: Scott Marlowe <[EMAIL PROTECTED]> > Date: Tue, 20 Dec 2005 16:41:32 -0600 > To: Hunter's Lists <[EMAIL PROTECTED]> > Cc: PostgreSQL <pgsql-general@postgresql.org> > Subject: Re: [GENERAL] Syntax Error Inserting From STDIN? > > quick answer, try a different editor. > > Are you editing in the same environment as the database is in, or are > you editing on windows and feeding the copy data in on another platform? > > On Tue, 2005-12-20 at 14:40, Hunter's Lists wrote: >> Interesting. >> >> How would I go about solving that? >> >> I inserted an extra line between the two, no dice. >> >>> From: Scott Marlowe <[EMAIL PROTECTED]> >>> Date: Tue, 20 Dec 2005 13:53:37 -0600 >>> To: Hunter's Lists <[EMAIL PROTECTED]> >>> Cc: PostgreSQL <pgsql-general@postgresql.org> >>> Subject: Re: [GENERAL] Syntax Error Inserting From STDIN? >>> >>> On Tue, 2005-12-20 at 13:30, Hunter's Lists wrote: >>>> I am trying to run the following: >>>> >>>> COPY departments (id, issue_id, title, description, feature_type) FROM >>>> stdin; >>>> 23 4 Local Buzz Things to do, people to see, places to go. aspen >>>> >>>> I get back: >>>> >>>> COPY departments (id, issue_id, title, description, feature_type) FROM >>>> stdin; >>>> >>>> 23 4 Local Buzz Things to do, people to see, places to go. aspen >>>> >>>> ERROR: syntax error at or near "23" at character 80 >>> >>> Seeing that "character 80" I'm gonna guess this is a CR/LF issue. I.e. >>> pgsql on your machine is seeing the 23 as being on the same line as the >>> copy departments statement. >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
