On Tue, Nov 30, 2010 at 03:16:37PM +0100, Michael wrote: > > The problem here was the > > where user='name' > > part. When I used phpPgAdmin to generate that select it gave me > > where "user" = 'name' > > instead and that worked. So user seems to be some special name. After I > renamed the row to username it suddenly worked. > > Really weird. > > Is that a bug or a feature? Someone able to enlighten me? :-)
USER is a "SQL Key Word" (reserved word) in PostgreSQL. http://www.postgresql.org/docs/8.4/static/sql-keywords-appendix.html -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net/
