Kbase 33800: Cannot create SQL-92 Sequence if it is not in a PUB schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P3800
FACT(s) (Environment):
Windows NT 4.0
SYMPTOM(s):
Getting the error, "An Invalid reference to a sequence was used", when creating SQL-92 Sequences
Example: create sequence mysequence; fails
CAUSE:
The Sequence's name is not prefixed by "pub".
Sequences are only supported in the pub schema for 9.1 releases.
FIX:
Prefix the Schema name with "pub".
For Example: create sequence pub.mysequence;