pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
6+ messages / 3 participants
[nested] [flat]
* BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
@ 2021-09-01 11:17 PG Bug reporting form <noreply@postgresql.org>
2021-09-01 13:28 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: PG Bug reporting form @ 2021-09-01 11:17 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: ram.maurya@lavainternational.in
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
2021-09-01 11:17 BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form <noreply@postgresql.org>
@ 2021-09-01 13:28 ` David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 13:46 ` RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-09-01 13:54 ` RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya <ram.maurya@lavainternational.in>
0 siblings, 2 replies; 6+ messages in thread
From: David G. Johnston @ 2021-09-01 13:28 UTC (permalink / raw)
To: ram.maurya@lavainternational.in, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
2021-09-01 11:17 BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form <noreply@postgresql.org>
2021-09-01 13:28 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
@ 2021-09-01 13:46 ` Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-09-01 13:46 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Ram Pratap Maurya @ 2021-09-01 13:46 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
2021-09-01 11:17 BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form <noreply@postgresql.org>
2021-09-01 13:28 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 13:46 ` RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya <ram.maurya@lavainternational.in>
@ 2021-09-01 13:46 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2021-09-01 13:46 UTC (permalink / raw)
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
2021-09-01 11:17 BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form <noreply@postgresql.org>
2021-09-01 13:28 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
@ 2021-09-01 13:54 ` Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-09-01 14:02 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Ram Pratap Maurya @ 2021-09-01 13:54 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
2021-09-01 11:17 BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form <noreply@postgresql.org>
2021-09-01 13:28 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 13:54 ` RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya <ram.maurya@lavainternational.in>
@ 2021-09-01 14:02 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2021-09-01 14:02 UTC (permalink / raw)
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-09-01 14:02 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-09-01 11:17 BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form <noreply@postgresql.org>
2021-09-01 13:28 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 13:46 ` RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-09-01 13:46 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 13:54 ` RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya <ram.maurya@lavainternational.in>
2021-09-01 14:02 ` Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox