create test2 as select * from test On Feb 15, 3:15 pm, Kerry Sainsbury <[email protected]> wrote: > How do you create test? > > Is it definitely a table? (not a view?) > > Can you provide a complete example? > > Cheers > Kerry > > > > On Tue, Feb 16, 2010 at 9:04 AM, gabjos <[email protected]> wrote: > > sorry i put the wrong error message here is the error: > > > truncate table test > > > Cannot truncate PUBLIC.test [90106-63] > > org.h2.jdbc.JdbcSQLException: Cannot truncate PUBLIC.test [90106-63] > > at org.h2.message.Message.getSQLException(Message.java:89) > > at org.h2.message.Message.getSQLException(Message.java:93) > > at org.h2.message.Message.getSQLException(Message.java:71) > > at org.h2.command.ddl.TruncateTable.update(TruncateTable.java:30) > > at org.h2.command.CommandContainer.update(CommandContainer.java: > > 64) > > at org.h2.command.Command.executeUpdate(Command.java:122) > > at org.h2.server.TcpServerThread.process(TcpServerThread.java: > > 241) > > at org.h2.server.TcpServerThread.run(TcpServerThread.java:97) > > at java.lang.Thread.run(Unknown Source) > > > at org.h2.engine.SessionRemote.done(SessionRemote.java:289) > > at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java: > > 164) > > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155) > > at org.h2.server.web.WebThread.getResult(WebThread.java:1392) > > at org.h2.server.web.WebThread.query(WebThread.java:1054) > > at org.h2.server.web.WebThread.process(WebThread.java:375) > > at org.h2.server.web.WebThread.processRequest(WebThread.java:131) > > at org.h2.server.web.WebThread.run(WebThread.java:158) > > > On Feb 15, 2:49 pm, Thomas Mueller <[email protected]> > > wrote: > > > Hi, > > > > > That is exactly what I type > > > No, you wrote: > > > > TRUNCATE TABLE FROM test > > > not > > > TRUNCATE TABLE test > > > > By the way, consider upgrading to a more recent version of H2. You are > > > using version 1.0.63. > > > > Regards, > > > Thomas > > > -- > > 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]<h2-database%2bunsubscr...@googlegroups.com> > > . > > For more options, visit this group at > >http://groups.google.com/group/h2-database?hl=en.- Hide quoted text - > > - Show quoted text -
-- 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.
