Gah, that's what I get for not doublechekcing what that darn word
completion on my phone did with what I wrote :-)
That looks like it could be a *unicode* BOM. Can you open the file in a
*hex* editor and check the first couple of bytes..
//Magnus
Magnus Hagander wrote:
> Looks like it could be a knocked BOM. Can you open the file in a bed
> editor and check the first couple of bytes?
>=20
> /Magnus
>=20
> > ------- Original Message -------
> > From: Kev <kevinjamesfield@[EMAIL PROTECTED]
>
> > To: pgadmin-sup****t@[EMAIL PROTECTED]
> > Sent: 08-04-07, 22:34:42
> > Subject: [pgadmin-sup****t] win32 psql syntax error running any .sql
> > created by the query editor
> >=20
> > Hi,
> >=20
> > This is reproducible every time on my Windows 2003 Server box
> > running pgAdmin3 1.8.2 and pgsql 8.3.
> >=20
> > 1. Open the query editor.
> > 2. Type any valid query.
> > 3. Save.
> > 4. In a DOS box, run psql -f on the file you just saved.
> >=20
> > I get the following error:
> >=20
> > psql:path/to/test.sql:71: ERROR: syntax error at or near
"=D0=BF=C2=BB=
=D1=97"
> > LINE 1: =D0=BF=C2=BB=D1=97select * from cust
> >=20
> > If I open the file in TextPad, it says it's of UNIX type. If I then
> > save it again using TextPad and run it, it runs fine without errors.
> >=20
> > This also happens even if I go Edit->Line Ends-> and choose either
> > DOS or UNIX in the query editor and then save again.
> >=20
> > I could be wrong, but this sounds like a bug. Thoughts or
> > suggestions?
> >=20
> > Thanks,
> > Kev
> >=20
> > --=20
> > Sent via pgadmin-sup****t mailing list
> > (pgadmin-sup****t@[EMAIL PROTECTED]
) To make changes to your
> > subscription: http://www.postgresql.org/mailpref/pgadmin-sup****t
> >=20
>=20
> --=20
> Sent via pgadmin-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-sup****t
--=20
Sent via pgadmin-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-sup****t
