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

From Ram Pratap Maurya
Subject RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
Date
Msg-id KL1PR0601MB443315447A15DE55E259F66AF0CD9@KL1PR0601MB4433.apcprd06.prod.outlook.com
Whole thread Raw
In response to Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs

Hi  David,

 

I am using PostgreSQL version 11.

 

 

 

Regards,

Ram Pratap.

 

From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: 01 September 2021 18:59
To: Ram Pratap Maurya; PostgreSQL mailing lists
Subject: Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09

 

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:

 

 

David J.

pgsql-bugs by date:

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