Hi, TRUNCATE is only supported for 'regular' tables. For linked tables, you need to use DELETE FROM ...
I will document that, and I will add a feature request. Regards, Thomas On Fri, Jan 22, 2010 at 7:47 PM, Dario Fassi <[email protected]> wrote: > Hi, > I have a Linked table defined to a Postgresql table, like > > CREATE LINKED TABLE IF NOT EXISTS TLKT.EMPLOYEE('org.postgresql.Driver', > 'jdbc:postgresql://127.0.0.1/hrla', 'postgres', '***','NOMINA.EMPLOYEE'); > > TRUNCATE TABLE TLKT.EMPLOYEE; > commit; > > This fail with > > Error: Cannot truncate "TLKT.EMPLOYEE"; SQL statement: > TRUNCATE TABLE TLKT.EMPLOYEE [90106-127] > SQLState: 90106 > ErrorCode: 90106 > Error occured in: > TRUNCATE TABLE TLKT.EMPLOYEE > > But the same Sql truncate executed with a direct jdbc conncection to > Postgresql db finish ok. > > I can't figure out what happen when truncate sql is executed via Linked > table to make the difference, since Truncate syntax in postgresql is > compatible with h2 syntax. > > Dario > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
