Hi Kevin,
On 2011-11-14, at 8:25 PM, Kevin Spake wrote: > 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. You don't need to change the entity name, just the table name. They don't need to be the same, and User is way easier to read in Java. Name a table User was a rather unfortunate choice for a tutorial... > 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? I am not sure, I don't have any current postgres projects. Does the project include the PostgresqlPlugIn.framework from Project Wonder? Chuck > > 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/chill%40global-village.net > > This email sent to [email protected] -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects _______________________________________________ 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]
