Re: Clarification on the docs

David, On Sat, Apr 19, 2025, 7:21 PM David G. Johnston wrote: > On Sat, Apr 19, 2025 at 4:17 PM Igor Korot wrote: > >> >> Could you indicate the default value for every option here? >> >>> >>> > The descriptions clearly indicate the defaults for nearly all of them, and > the one exception is

Re: Clarification on the docs

On Sat, Apr 19, 2025 at 4:17 PM Igor Korot wrote: > > Could you indicate the default value for every option here? > >> >> The descriptions clearly indicate the defaults for nearly all of them, and the one exception is a single click away (gin_pending_list_limit). I don't find that the informatio

Re: Clarification on the docs

Hi, Dvid, On Fri, Apr 11, 2025, 9:04 PM David G. Johnston wrote: > On Fri, Apr 11, 2025 at 6:49 PM Igor Korot wrote: > >> Hi, ALL, >> On the >> https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS >> its said: >> >> [quote] >> The optional WITH clause speci

Re: Error while updating a table

On 2025-04-19 13:06:27 +, sivapostg...@yahoo.com wrote: > Thanks Laurenz, > > it is 100% clear that an earlier statement in the same transaction must > > have got an error. Write your application so that it logs *every* error > > that comes from the database, then you are sure to catch that er

Re: verify checksums online

iirc there used to be a Google snippet that did online checksum verification. it worked pretty well , but I did not let it run the tests of the extension, so it may not be 100% , I just used it for a quick check if there were other problems visible. if it's archived now well :) https://github.com

Re: verify checksums online

On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider wrote: > but i wanted to confirm with someone - my easiest options for online > verifying checksums would be to trigger pg_basebackup then check > pg_stat_database, or to install michael's utility? > Your easiest option is to just use pgbackrest,

Re: Error while updating a table

On Sat, Apr 19, 2025 at 6:06 AM sivapostg...@yahoo.com < sivapostg...@yahoo.com> wrote: > By any chance, if I get that statement, what should I do? > Read it. What are the Steps (or documentation) to correct this issue? > > Impossible to say until the statement is read. David J.

Re: Error while updating a table

Thanks Laurenz, > it is 100% clear that an earlier statement in the same transaction musthave >got an error.  Write your application so that it logs *every* error that comes from the database, then you are sure to catch that error. There is an option to log every sql statement that's executed fr

Re: Error while updating a table

On Sat, 2025-04-19 at 12:38 +, sivapostg...@yahoo.com wrote: > So far, I couldn't find the query that caused the error.   Is there any way > to unlock it?   > > Re-start, Format and fresh install of windows, etc. ? On Windows you have to reboot, bow three times toward sunset, say a prayer to

Re: Error while updating a table

So far, I couldn't find the query that caused the error.   Is there any way to unlock it?   Re-start, Format and fresh install of windows, etc. ? Happiness Always BKR Sivaprakash On Friday 18 April, 2025 at 04:50:52 pm IST, sivapostg...@yahoo.com wrote: If the query caused an error ..