Thanks Koen. It works now after updating the relevant lines in createQuerySql functions in Query.C lines from
+ ")"; to + ") as dbofoobar"; Regards Calvin "Koen Deforche" <[email protected]> ??? news:[email protected] ???... Hey Calvin, 2010/9/17 Calvin <[email protected]>: > I am encountering the following error message when I call rowCount() with > a > postgresql backend Wt-3.1.4 debug build: > > [2010-Sep-17 12:49:09.814983] 3200 [/ cETgKbPLteBAA7j5] [error] "Error > during ev > ent handling: ERROR: subquery in FROM must have an alias > LINE 1: select count(1) from (select relation.id, relation.version, ... > ^ > HINT: For example, FROM (SELECT ...) [AS] foo. > > " > [2010-Sep-17 12:49:09.824983] 3200 [/ cETgKbPLteBAA7j5] [fatal] "ERROR: > subquer > y in FROM must have an alias > LINE 1: select count(1) from (select relation.id, relation.version, ... > ^ > HINT: For example, FROM (SELECT ...) [AS] foo. > > The issue does not occur with a sqlite3 backend. Is the alias missing in > the > SQL generation for this as suggested and any recommendations for remedying > this? We took the hint: I fixed this in latest git. The patch is very small so you could also easily back-port it to whatever version of Wt you are running. Regards, koen ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
