On Wed, 16 Aug 2006 19:31:30 +0200, Oleg Broytmann <[EMAIL PROTECTED]>
wrote:
> On Wed, Aug 16, 2006 at 07:21:00PM +0200, Michel Albert wrote:
>> ProgrammingError: ERROR: invalid name syntax
>>
>> SELECT NEXTVAL('""Hotel"_"idHotel"_seq"')
>> -----------------------------------------------------------------------------------
>>
>> The last line reveals that it has trouble to deal with the added quotes.
>>
>> Is there a possibility to get around this
>
> Look at the code that generated the exception. It is
> PostgresConnection._queryInsertID():
>
> sequenceName = getattr(soInstance, '_idSequence',
> '%s_%s_seq' % (table, idName))
>
> Enlightened? ;)
>
> Oleg.
In my earlier post, I submitted a quick-fix that made a change in that
line which provides a quick and dirty workaround. But thanks anyway for
your quick reply ;)
Still, I beleive this is an issue that needs to be addressed soon. It
seriously impedes development with SQLObject and Postgre. Especially in
the case you need to re-use an old database, as in this case.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
