Trying now to go through the "WO Tutorial: creating a model" screencast. At 19 minutes in, the instructions say to generate the SQL. At first, I was getting errors that said the problem started around "user". Eventually, I realized that the tutorial involves naming a table "user", but "user" is a reserved word in postgresql. I changed the entity name to T_User and the table name to T_USER. BTW, "password" is also a keyword, but it's not reserved. I changed that column name to "pass_word" anyway.
I'm no longer getting the "user" error, however, I now get: "Failed to generate SQL. ERROR: table "eof_tmp_table" does not exist. There was an error, do you want to cancel the rest of the script?" i chose to continue and it looks like the SQL completed. Below is the info for the wowodc09 db: The only reference I found to this error message is here: http://www.mail-archive.com/[email protected]/msg08878.html Is this a bug, or do I need to do something different, or both? wowodc09=> \d List of relations Schema | Name | Type | Owner --------+---------------------+----------+-------- public | job_description | table | wowodc public | job_description_seq | sequence | wowodc public | t_user | table | wowodc public | t_user_seq | sequence | wowodc (4 rows) wowodc09=> SELECT * FROM job_description; jobdesc_fulldesc | id | jobdesc_lastmodifdate | jobdesc_pubdate | jobdesc_title | jobdesc_user_id_fk ------------------+----+-----------------------+-----------------+---------------+-------------------- (0 rows) wowodc09=> \dwowodc09=> SELECT * FROM t_user; user_first_name | id | user_lastname | user_password | user_title | user_username -----------------+----+---------------+---------------+------------+--------------- (0 rows)
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
