Re: Error: table "eof_tmp_table" does not exist.
Re: Error: table "eof_tmp_table" does not exist.
- Subject: Re: Error: table "eof_tmp_table" does not exist.
- From: Chuck Hill <email@hidden>
- Date: Mon, 14 Nov 2011 20:33:48 -0800
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@hidden/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@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
--
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden