Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

On Wed, Jul 26, 2017 at 11:36 PM, wrote: > On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA > wrote: > > > > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier < > michael.paqu...@gmail.com> wrote: > > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA > >

[GENERAL] tzdata version

Hello, As i understand it, the tzdata on which the timezone information is based is updated regularly (semi-manually) in https://github.com/ postgres/postgres/tree/master/src/timezone Am i correct in stating that there is currently no way to update the tzdata database except by recompiling

Re: [GENERAL] tzdata version

Jerome Wagner writes: > As i understand it, the tzdata on which the timezone information is based > is updated regularly (semi-manually) in https://github.com/ > postgres/postgres/tree/master/src/timezone > Am i correct in stating that there is currently no way to

[GENERAL] tzdata version

Hello, As i understand it, the tzdata on which the timezone information is based is updated regularly (semi-manually) in https://github.com/postgres/postgres/tree/master/src/timezone Am i correct in stating that there is currently no way to update the tzdata database except by recompiling

Re: [GENERAL] RETURNS SETOF RECORD with 1 column

On Thursday, July 27, 2017, Vincenzo Romano wrote: > > The main difference is that with RETURNS SETOF RECORD I still get the > "usual"(tm) function argument list in the usual place: between two > parentheses. > It's a matter of style. And a consistent one. > But I

Re: [GENERAL] RETURNS SETOF RECORD with 1 column

On Thursday, July 27, 2017, David G. Johnston wrote: > On Thursday, July 27, 2017, Vincenzo Romano > wrote: >> >> The main difference is that with RETURNS SETOF RECORD I still

Re: [GENERAL] Developer GUI tools for PostgreSQL

On 2017-07-28 06:31, Tim Uckun wrote: I think it's funny that after all these years pgadmin3 is still the most comprehensive GUI for postgres. Have you looked at EMS SQL-Manager, I don't remember PgAdmin having any where near hte features that it has :-P Even though it's prone to crashing

Re: [GENERAL] RETURNS SETOF RECORD with 1 column

2017-07-28 8:36 GMT+02:00 David G. Johnston : > On Thursday, July 27, 2017, David G. Johnston > wrote: >> >> On Thursday, July 27, 2017, Vincenzo Romano >> wrote: >>> >>> The main difference is that with RETURNS

Re: [GENERAL] Developer GUI tools for PostgreSQL

I don't run windows so I haven't looked at the EMS product. On Fri, Jul 28, 2017 at 6:53 PM, vinny wrote: > On 2017-07-28 06:31, Tim Uckun wrote: > >> I think it's funny that after all these years pgadmin3 is still the >> most comprehensive GUI for postgres. >> > > Have you

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

> On Wed, Jul 27, 2017, PAWAN SHARMA wrote: > > On Wed, Jul 26, 2017, wrote: > > > > You have an environment problem in that the 2 different users have a > > different > > PATH and you're getting 2 different perl executables, or at least that's

Re: [GENERAL] upsert: is there a shortcut?

Daniele Varrazzo wrote: Is there a way to avoid replicating the list of fields and use instead something like (new.*) = (excluded.*) as one could do in a trigger? (that would also imply an (id = excluded.id but it seems harmless). This is certainly something that

Re: [GENERAL] tzdata version

Thank you for your answer. When compiled with "--with-system-tzdata", does postgres need a restart after the system is updated with the new tzdata ? regards, jérôme wagner On Fri, Jul 28, 2017 at 4:06 PM, Tom Lane wrote: > Jerome Wagner

Re: [GENERAL] tzdata version

Jerome Wagner writes: > When compiled with "--with-system-tzdata", does postgres need a restart > after the system is updated with the new tzdata ? No, but existing sessions will carry on with whatever data they've read from the tzdata files; we don't have a provision

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

Hello, everybody. I solved the problem. The index has been corrupted after replication despite it was appeared as not corrupted. It was solved by recreating the index. Thank you for the help. -- Пожалуйста! Используйте кнопку "ответить всем". Не удаляйте историю переписки. Спасибо. С уважением,

Re: [GENERAL] Developer GUI tools for PostgreSQL

You can try DBeaver. It is a generic GUI tool which works with practically all RDBMS. It is java based, and I find it bit slow. However judging by the frequent updates I get, it seems to be very active. -- View this message in context:

Re: [GENERAL] RETURNS SETOF RECORD with 1 column

Vincenzo Romano writes: > I would like to understand the typo protection mentioned by Tom earlier: > I need to understand the reason for creating that special case. Well, case A: create function foo(out x int4) returns setof int8 ... This is indubitably a typo.

[GENERAL] PGpool question

This may be the wrong list, but I am not sure where it needs to go. I am trying to set up pgpool, and I keeping on getting this message: NOTICE: add node from hostname:"xxx" port:9000 pgpool_port: rejected. Jul 28 22:11:49 xx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pid 10768: