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

From: Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
Date: 2021-09-01 13:46:05
Message-ID: KL1PR0601MB443315447A15DE55E259F66AF0CD9@KL1PR0601MB4433.apcprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi David,

I am using PostgreSQL version 11.

Regards,
Ram Pratap.

From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)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(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-bugs by date

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