|
I'm not aware of the groups where such questions have been
raised. If you know, please let them know.
Fred
----- Original Message -----
Sent: 20 April 2006 14:02
Subject: Re: [Hsqldb-developers] Re:
SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4
Thanks Fred - it works.
But in several use groups this question about SEQUENCES not working has
popped up perhaps because they do not know that INFORMATION_SCHEMA needs to be
prepended.
Best Regards.
Nitin
On 4/20/06, fredt
<[EMAIL PROTECTED]>
wrote:
You need to use:
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES
Please read the docs on SCHEMA and SEQUENCE support. Also
note that you do not use the above query in order to access the
sequences. The _expression_ used is "NEXT VALUE FOR a_sequence"
Fred
----- Original Message -----
Sent: 20 April 2006 12:32
Subject: SEQUENCES DO NOT WORK IN
HSQLDB 1.8.0.4
Hi Fred:
Looks like sequnces still do not work in version 1.8.0.4. I tried:
SELECT * FROM SYSTEM_SEQUENCES
and it gives a table not found error. We are migrating our databases
from Oracle and mySQL and this is one thing that is holding us back.
Nitin Uchil
--
Nitin Uchil
(734)945-6463
|
