Re: generate sql from entity modeler in Eclipse
Re: generate sql from entity modeler in Eclipse
- Subject: Re: generate sql from entity modeler in Eclipse
- From: Theodore Petrosky <email@hidden>
- Date: Sun, 18 Nov 2007 17:44:59 -0800 (PST)
Yes I am using Postgresql and this fixes most of the
problems... however I see that the sql creates a temp
table:
CREATE TEMP TABLE EOF_TMP_TABLE AS SELECT
SETVAL('maintable_seq', (SELECT MAX(theoid) FROM
maintable));
Notice the table name is not quoted so postgresq1 will
fold the name to lower case. the next line deletes the
table and fails:
DROP TABLE EOF_TMP_TABLE;
again because it is not quoted... Where should I send
the information about this bug?
Ted
--- Guido Neitzer <email@hidden> wrote:
> On 18.11.2007, at 08:01, Theodore Petrosky wrote:
>
> > I have a little problem (looks like a bug)
> >
> > I created a rather simple Entity with only two
> > columns.. when I press "Generate SQL" the "NOT
> NULL"
> > constraint has no space before it.... I don't know
> if
> > this is an old issue or a new one.
> >
> > CREATE TABLE MainTable ("personname" textNOT NULL,
> > "theoid" int4NOT NULL);
>
> If you're using PostgreSQL you can update to the
> latest plugin from
> Wonder. That solves that problem and others, mainly
> related to
> identifier quoting.
>
> You can get the latest PostgreSQLPlugin from the
> Wonder binary build at
>
> http://webobjects.mdimension.com/wonder/
>
> cug
>
> --
> http://www.event-s.net
>
>
____________________________________________________________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/
_______________________________________________
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