Обсуждение: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09

Поиск
Список
Период
Сортировка

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

От
PG Bug reporting form
Дата:
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

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

От
"David G. Johnston"
Дата:
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.

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

От
Ram Pratap Maurya
Дата:

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.

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

От
"David G. Johnston"
Дата:
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.

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

От
Ram Pratap Maurya
Дата:

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> 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.

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

От
"David G. Johnston"
Дата:
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.