Rails - Jan 2006 - Problems with simple scaffold code

Hi all,

I had scaffold generate some code on a brand new app the trace is here:

http://rafb.net/paste/results/H87GHC68.html

Could you point me to what problem needs to be fixed please as i''ve
been
banging my head against this for some time now?

The table is very simple and its called "user" with id, email,
password
fields. I''ve set pluralize_table_names to false and set_table_name 
''user''. That''s all i tweaked the rest is all
scaffold''s fault ;-)

Ah yeah, my stack is winxp, ruby 1.8.2, rails 1.0, webrick, postgresql 8.1

The connection with the db certainly works otherwise generate/scaffold 
would have generated an error.

Any thoughts?

Lorenzo

"user" is reserved PostgreSQL keyword. Rename the table.
I''d suggest never use table names which clash with reserved keywords.

2006/1/26, Lorenzo Bolognini
<lbolognini@gmail.com>:
> Hi all,
>
> I had scaffold generate some code on a brand new app the trace is here:
>
> http://rafb.net/paste/results/H87GHC68.html
>

> Ah yeah, my stack is winxp, ruby 1.8.2, rails 1.0, webrick, postgresql 
> 8.1
 I just read that user is a reserved keyword in postgresql...try 
renaming your table...

This is secondhand info...

Mikkel

-- 
Posted via http://www.ruby-forum.com/.

Lugovoi Nikolai wrote:
> "user" is reserved PostgreSQL keyword. Rename the table.
> I''d suggest never use table names which clash with reserved
keywords.
Tnx guys! That fixed the problem!

Lorenzo