Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
Date
Msg-id CAKFQuwYTRYCjdt59FwJDTjgFn_bg97Rfhk4OEYR1iGgdfk1J-w@mail.gmail.com
Whole thread Raw
In response to BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
List pgsql-bugs
Tree view
On Wed, Sep 1, 2021 at 4:44 AM PG Bug reporting form <noreply@postgresql.org> wrote:
ERROR: column "min_value" does not exist at character 19
SELECT last_value,min_value,max_value,increment_by from
public.secondary_sales_secondary_sales_id_seq;


Sequences were reworked in version 10 and that field on that table no longer exists.  There is now a catalog:

https://www.postgresql.org/docs/current/catalog-pg-sequence.html

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #17173: Primary Key ignored resulting in duplicate values