| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: [ADMIN] syntax error for no apparent reason |
| Date: | 2010-12-04 01:45:36 |
| Message-ID: | 4CF99D40.90306@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin |
> I've encountered this before, psql gives me a syntax error for no clear
> reason. It's allways on the first character of a sql file.
> I think that there must be some strange character code at the first
> position, maybe it is because i share a ntfs partition with the windows
> installation on my laptop and move files around.
Yeah, this is caused by pgadmin adding a unicode marker at the first
position of the file. If you uncheck "Read and Write Unicode UTF-8
Files" in the preferences, this issue should go away.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2010-12-04 12:46:15 | Re: [ADMIN] syntax error for no apparent reason |
| Previous Message | Willy-Bas Loos | 2010-12-04 01:40:30 | [ADMIN] syntax error for no apparent reason |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2010-12-04 12:46:15 | Re: [ADMIN] syntax error for no apparent reason |
| Previous Message | Willy-Bas Loos | 2010-12-04 01:40:30 | [ADMIN] syntax error for no apparent reason |