Kbase P3800: Cannot create SQL-92 Sequence if it is not in a PUB schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/09/2003 |
|
Solution ID: P3800
SYMPTOM(s):
Error "An Invalid reference to a sequence was used" when creating SQL-92 Sequences
The name of sequence is not prefixed with PUB
The sequence cannot be created
CAUSE:
Sequences are only supported in the pub schema for 9.1 releases.
FIX:
Prefix the Schema name with "pub".
Example: create sequence pub.mysequence;