Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DDL generation for sequences with Postgres generates a wrong value for cache #5156

Closed
ghusta opened this issue Jan 30, 2019 · 0 comments
Closed

Comments

@ghusta
Copy link

ghusta commented Jan 30, 2019

System information:

  • DBeaver 5.3.3

Connection specification:

  • Postgres 9.6
  • Driver 42.1.4

Describe the problem you're observing:

Wrong value for cache (0) in generated DDL for sequence.

It will generate something like :

-- DROP SEQUENCE my_schema.my_seq;

CREATE SEQUENCE my_schema.my_seq
	INCREMENT BY 1
	MINVALUE 1
	MAXVALUE 9223372036854775807
	START 38761
	CACHE 0
	NO CYCLE;

Steps to reproduce, if exist:

Include any warning/errors/backtraces from the logs

When executing this DDL script with Postgres 9.6, I got this error :

SQL Error [22023]: ERROR: CACHE (0) must be greater than zero

According to Postgres documentation, cache value must be at least equal to 1 (https://www.postgresql.org/docs/9.6/sql-createsequence.html).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants