Thanks Fred:
 
WIll inform the posts that I have found.
 
What is the SEQUENCE_CATALOG field? When I added a sequence using:
 
CREATE SEQUENCE utility_content_SEQ
AS INTEGER
START WITH 1
INCREMENT BY 1;
 
I get null as the SEQUENCE_CATALOG.
 
 

On 4/20/06, fredt <[EMAIL PROTECTED]> wrote:
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



--
Nitin Uchil
(734)945-6463

Reply via email to