BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
The following bug has been logged on the website:
Bug reference: 17174
Logged by: Ram Pratatp maurya
Email address: ram.maurya@lavainternational.in
PostgreSQL version: 11.0
Operating system: RHEL 6
Description:
Dear Team,
Below error generating in PostgreSQL error log file in master and slave both
server , can you please suggest why this error is generate. .
PostgreSQL version -11 on master and slave server.
............................................................................................................................................
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;
Regards,
Ram Pratap
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.
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<mailto: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.
On Wed, Sep 1, 2021 at 6:46 AM Ram Pratap Maurya <
ram.maurya@lavainternational.in> wrote:
I am using PostgreSQL version 11.
Yes, your bug report said as much. What is your point?
David J.
Hi David,
Yes table don’t have field but we face this error last 15 days only.
What is the reason for this error ,there is any program error or any PostgreSQL issue for this.
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<mailto: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.
On Wed, Sep 1, 2021 at 6:54 AM Ram Pratap Maurya <
ram.maurya@lavainternational.in> wrote:
Yes table don’t have field but we face this error last 15 days only.
What is the reason for this error ,there is any program error or any
PostgreSQL issue for this.
There is nothing wrong on PostgreSQL's side. Something in your environment
is executing the query you showed, which when done against a version of
PostgreSQL >= v10, will fail. You need to figure out what that "something"
is, and then probably upgrade it to its newest release which hopefully has
a modified query for v10+ servers.
David J.