Friday, February 19, 2010

ERROR: column notation .id applied to type name, which is not a composite type


When doing an EJB3 web application with PostgreSQL I have this error message when I try to do a simple SELECT query on my table "user".

After investigation, I've found that:

User is a reserve table in PostgreSQL. We must not have a table named like this! By changing the name of the table, it corrects the problem!!!

1 comment:

  1. simple call the squema name before your table, like public.user