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 PROTECTED]> 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to