public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Emitting JSON to file using COPY TO
3+ messages / 2 participants
[nested] [flat]

* Re: Emitting JSON to file using COPY TO
@ 2024-01-08 20:40 Joe Conway <[email protected]>
  2024-03-08 17:28 ` Re: Emitting JSON to file using COPY TO Andrey M. Borodin <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Joe Conway @ 2024-01-08 20:40 UTC (permalink / raw)
  To: Dean Rasheed <[email protected]>; +Cc: Daniel Verite <[email protected]>; Andrew Dunstan <[email protected]>; Davin Shearer <[email protected]>; pgsql-hackers

On 1/8/24 14:36, Dean Rasheed wrote:
> On Thu, 7 Dec 2023 at 01:10, Joe Conway <[email protected]> wrote:
>>
>> The attached should fix the CopyOut response to say one column.
>>
> 
> Playing around with this, I found a couple of cases that generate an error:
> 
> COPY (SELECT 1 UNION ALL SELECT 2) TO stdout WITH (format json);
> 
> COPY (VALUES (1), (2)) TO stdout WITH (format json);
> 
> both of those generate the following:
> 
> ERROR:  record type has not been registered


Thanks -- will have a look

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Emitting JSON to file using COPY TO
  2024-01-08 20:40 Re: Emitting JSON to file using COPY TO Joe Conway <[email protected]>
@ 2024-03-08 17:28 ` Andrey M. Borodin <[email protected]>
  2024-03-08 18:01   ` Re: Emitting JSON to file using COPY TO Joe Conway <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Andrey M. Borodin @ 2024-03-08 17:28 UTC (permalink / raw)
  To: Joe Conway <[email protected]>; +Cc: Dean Rasheed <[email protected]>; Daniel Verite <[email protected]>; Andrew Dunstan <[email protected]>; Davin Shearer <[email protected]>; pgsql-hackers

Hello everyone!

Thanks for working on this, really nice feature!

> On 9 Jan 2024, at 01:40, Joe Conway <[email protected]> wrote:
> 
> Thanks -- will have a look

Joe, recently folks proposed a lot of patches in this thread that seem like diverted from original way of implementation.
As an author of CF entry [0] can you please comment on which patch version needs review?

Thanks!


Best regards, Andrey Borodin.

[0] https://commitfest.postgresql.org/47/4716/





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Emitting JSON to file using COPY TO
  2024-01-08 20:40 Re: Emitting JSON to file using COPY TO Joe Conway <[email protected]>
  2024-03-08 17:28 ` Re: Emitting JSON to file using COPY TO Andrey M. Borodin <[email protected]>
@ 2024-03-08 18:01   ` Joe Conway <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Joe Conway @ 2024-03-08 18:01 UTC (permalink / raw)
  To: Andrey M. Borodin <[email protected]>; +Cc: Dean Rasheed <[email protected]>; Daniel Verite <[email protected]>; Andrew Dunstan <[email protected]>; Davin Shearer <[email protected]>; pgsql-hackers

On 3/8/24 12:28, Andrey M. Borodin wrote:
> Hello everyone!
> 
> Thanks for working on this, really nice feature!
> 
>> On 9 Jan 2024, at 01:40, Joe Conway <[email protected]> wrote:
>> 
>> Thanks -- will have a look
> 
> Joe, recently folks proposed a lot of patches in this thread that seem like diverted from original way of implementation.
> As an author of CF entry [0] can you please comment on which patch version needs review?


I don't know if I agree with the proposed changes, but I have also been 
waiting to see how the parallel discussion regarding COPY extensibility 
shakes out.

And there were a couple of issues found that need to be tracked down.

Additionally I have had time/availability challenges recently.

Overall, chances seem slim that this will make it into 17, but I have 
not quite given up hope yet either.

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2024-03-08 18:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-08 20:40 Re: Emitting JSON to file using COPY TO Joe Conway <[email protected]>
2024-03-08 17:28 ` Andrey M. Borodin <[email protected]>
2024-03-08 18:01   ` Joe Conway <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox