[GENERAL] Receive a string in Composite-type Arguments

Hi! I am studying how to program extensions for PostgreSQL in C language. In the example to return to return Composite-type Arguments, from the PostgreSQL 9.6 documentation, I could not make the cash from a cstring to the HeapTupleHeader type. That is, instead of the function receive as a

Re: [GENERAL] How to make server generate more output?

On Fri, Aug 11, 2017 at 1:14 PM, Rui Pacheco wrote: > Hello, > > I know this is a bit vague but I’m looking for a configuration > parameter/startup switch that once set or enabled would make Postgresql > return more data that normal. Specifically the wire protocol would

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

On 8/11/17 10:15, Murtuza Zabuawala wrote: > some time whe have 2 process postgres for 1 instance like this > > > exppgs 17769 1 0 01:06 ?00:01:04 > /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h > bd-sillage.info. > exppgs 39922 17769 0 15:39 ?

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

On 08/11/2017 02:35 PM, Peter Eisentraut wrote: On 8/11/17 10:15, Murtuza Zabuawala wrote: some time whe have 2 process postgres for 1 instance like this exppgs*17769* 1 0 01:06 ?00:01:04 /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

Yes exactly. That's the parent PID for that process. On Fri, Aug 11, 2017 at 2:44 PM, Ron Johnson wrote: > On 08/11/2017 02:35 PM, Peter Eisentraut wrote: > > On 8/11/17 10:15, Murtuza Zabuawala wrote: > > some time whe have 2 process postgres for 1 instance like this > >

Re: [GENERAL] streaming replication - crash on standby

>-Original Message- >From: Andres Freund [mailto:and...@anarazel.de] >Sent: Wednesday, August 09, 2017 6:34 PM >To: Seong Son (US) >Cc: pgsql-general@postgresql.org >Subject: Re: [GENERAL] streaming replication - crash on standby > >Hi, > >Please quote properly on

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

Don Seiler writes: > Yes exactly. That's the parent PID for that process. Presumably, the reason the command columns look the same is that the child process hasn't yet had a chance to change its PS display string. The fact that its accumulated runtime shows as 00:00:00 squares

[GENERAL] How to make server generate more output?

Hello, I know this is a bit vague but I’m looking for a configuration parameter/startup switch that once set or enabled would make Postgresql return more data that normal. Specifically the wire protocol would return more notification messages and such. I remember seeing this while developing

[GENERAL] Fwd: 2 process postgres -D for one instance

Forwarding to pgsql-general list. -- Forwarded message -- From: francis cherat Date: Fri, Aug 11, 2017 at 7:36 PM Subject: 2 process postgres -D for one instance To: "pgadmin-supp...@lists.postgresql.org" < pgadmin-supp...@lists.postgresql.org> Hi,

Re: [GENERAL] Receive a string in Composite-type Arguments

On 11/08/2017 16:09, Fabiana Zioti wrote: Hi! I am studying how to program extensions for PostgreSQL in C language. In the example to return to return Composite-type Arguments, from the PostgreSQL 9.6 documentation, I could not make the cash from a cstring to the HeapTupleHeader type. That

Re: [GENERAL] Receive a string in Composite-type Arguments

2017-08-11 16:39 GMT+02:00 Achilleas Mantzios : > On 11/08/2017 16:09, Fabiana Zioti wrote: > > Hi! > > I am studying how to program extensions for PostgreSQL in C language. > > In the example to return to return Composite-type Arguments, from the > PostgreSQL 9.6

Re: [GENERAL] sequence used on null value or get the max value for a column whith concurrency

On Thu, 2017-08-10 at 19:05 -0300, marcelo wrote: > In some table, I have a bigint column which at the app level can be  > null. Call it "DocumentNumber", and of course is not the PK. > In most cases, the applications give some value to the column. > > But sometimes, the value remains null,