by ROCLASI » Thu Sep 29, 2011 4:14 pm
Hi Rogel,
There are indeed some differences in syntax/behavior between the vendors. For example in PostgreSQL a temp table is only visible in the connection (session) it was created in. So multiple sessions can create the same temp table. Other vendors allow such temp table to be visible to other sessions as well.
Anyway, I think for your solution you need to use plain SQL to create any table since (if I am not mistaken) the maintainance plugin won't do it for you in web/headless/smart client. And you need to make sure this table name is then unique as well for this specific user.
And since DDL (create/drop table, etc) with transactaction support (being able to roll it back) is also not cross-vendor you would have to handle that yourself as well (the cleaning up of the table).