Re: text and varchar are not equivalent

2024-02-09 Thread Tom Lane
"David G. Johnston" writes: > On Fri, Feb 9, 2024, 10:12 PG Doc comments form > wrote: >> The documentation implies that the data types text and varchar are >> equivalent, but this is not the case with this test in Postgresql version >> 16. > Fair point. But I'd rather further emphasize that ch

Re: text and varchar are not equivalent

2024-02-09 Thread David G. Johnston
On Fri, Feb 9, 2024, 10:12 PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/datatype-character.html > Description: > > The documentation implies that the data types text and varchar are > equivalent, but

text and varchar are not equivalent

2024-02-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-character.html Description: The documentation implies that the data types text and varchar are equivalent, but this is not the case with this test in Postgresql version 16. CREATE

Re: Add a different archive_command example for Linux / Unix

2024-02-09 Thread gparc
Hello Stephen, For the missing fsync directory, in case of a system crash which I had in mind using this command, I thought that fsck will fixed the discrepancy. I support your proposal i.e. archive_command = 'backup_tool %p /mnt/server/archivedir/%f' as at least people will investigate what