postgresql-7.2.3-5.80 error

[David Orlovich]

Well I use MySQL so it might be a little different - but ...

a parse error is pretty straightforward - you're typing something wrong 
- and the incorrect thing you typed is near the semi colon.  If you get 
strange results via PHP as well as a direct entry then it sounds like 
something simple like you're forgetting to close a quote or something 
like that.

If you want more useful help, you should perhaps post the actual line 
you're inserting ... but then again you might get even more help from 
an SQL list ...

cheers, David.


On Wednesday, June 4, 2003, at 04:49 PM, Harold Shanafield wrote:

> I am trying to do a routine insert into a table in
> psql and I am getting a ERROR:  parser: parse error at
> or near ";".  When I try to submit the insert via php
> I get a record inserted, but all of the fields are
> blank.  I've found some cryptic references to the
> error, but nothing to explain it, or more importantly
> on how to fix it.  Seems like a pretty fundamental
> error.  Does anybody use postgresql?  Anybody know
> what's going on?  Running postgresql-7.2.3-5.80.
>
> Thanks,
> Harold
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.yahoo.com
> _______________________________________________
> yellowdog-general mailing list
> yellowdog-general@lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general
>
Dr David Orlovich
Department of Botany,
The University of Otago,
P.O. Box 56,
Dunedin,
New Zealand.

Phone +64 3 479 9060
Fax +64 3 479 7583
david.orlovich@botany.otago.ac.nz
david.orlovich@unix.net
http://www.botany.otago.ac.nz/