Re: About the stability of COPY BINARY data

2024-11-07 Thread Dominique Devienne
On Thu, Nov 7, 2024 at 7:04 PM Adrian Klaver wrote: > On 11/7/24 09:55, Dominique Devienne wrote: > > On Thu, Nov 7, 2024 at 6:39 PM Daniel Verite > > wrote: > >> Dominique Devienne wrote: > >>> Also, does the code for per-type _send() and _recv() functions > >>> really change across ve

Re: About the stability of COPY BINARY data

2024-11-07 Thread Adrian Klaver
On 11/7/24 09:55, Dominique Devienne wrote: On Thu, Nov 7, 2024 at 6:39 PM Daniel Verite wrote: Dominique Devienne wrote: Also, does the code for per-type _send() and _recv() functions really change across versions of PostgreSQL? How common are instances of such changes across version

Re: About the stability of COPY BINARY data

2024-11-07 Thread Dominique Devienne
On Thu, Nov 7, 2024 at 6:39 PM Daniel Verite wrote: > Dominique Devienne wrote: > > Also, does the code for per-type _send() and _recv() functions > > really change across versions of PostgreSQL? How common are > > instances of such changes across versions? Any examples of such > > backwar

Re: About the stability of COPY BINARY data

2024-11-07 Thread Daniel Verite
Dominique Devienne wrote: > Also, does the code for per-type _send() and _recv() functions > really change across versions of PostgreSQL? How common are > instances of such changes across versions? Any examples of such > backward-incompatible changes, in the past? For the timestamp types,

Re: About the stability of COPY BINARY data

2024-11-07 Thread Dominique Devienne
On Thu, Nov 7, 2024 at 5:37 PM Adrian Klaver wrote: > > On 11/6/24 08:20, Dominique Devienne wrote: > >>From https://www.postgresql.org/docs/current/sql-copy.html: > > |> binary-format file is less portable across machine architectures > > and PostgreSQL versions > > > > In my experience, the bina

Re: About the stability of COPY BINARY data

2024-11-07 Thread Adrian Klaver
On 11/6/24 08:20, Dominique Devienne wrote: From https://www.postgresql.org/docs/current/sql-copy.html: |> binary-format file is less portable across machine architectures and PostgreSQL versions In my experience, the binary encoding of binding/resultset/copy is endian neutral (network byte ord

About the stability of COPY BINARY data

2024-11-06 Thread Dominique Devienne
>From https://www.postgresql.org/docs/current/sql-copy.html: |> binary-format file is less portable across machine architectures and PostgreSQL versions In my experience, the binary encoding of binding/resultset/copy is endian neutral (network byte order), so what is the less portable across machi