| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Willy-Bas Loos <willybas(at)gmail(dot)com>, 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 12:46:15 |
| Message-ID: | 4CFA3817.2020400@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin |
Le 04/12/2010 02:45, Josh Berkus a écrit :
>
>> 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.
>
It goes away because the file is no longer in UTF-8, and that may not be
what the OP wants.
I have a patch ready to be commited that will handle this. But you will
need next pgAdmin's release.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-12-04 15:01:11 | Re: [ADMIN] syntax error for no apparent reason |
| Previous Message | Josh Berkus | 2010-12-04 01:45:36 | Re: [ADMIN] syntax error for no apparent reason |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-12-04 15:01:11 | Re: [ADMIN] syntax error for no apparent reason |
| Previous Message | Josh Berkus | 2010-12-04 01:45:36 | Re: [ADMIN] syntax error for no apparent reason |