public inbox for [email protected]
help / color / mirror / Atom feedRe: 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]>
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-03-08 17:28 Andrey M. Borodin <[email protected]>
parent: 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-03-08 18:01 Joe Conway <[email protected]>
parent: Andrey M. Borodin <[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