Re: [HACKERS] make async slave to wait for lsn to be replayed

2020-11-18 Thread a . pervushina
Hello, I've changed the BEGIN WAIT FOR LSN statement to core functions pg_waitlsn, pg_waitlsn_infinite and pg_waitlsn_no_wait. Currently the functions work inside repeatable read transactions, but waitlsn creates a snapshot if called first in a transaction block, which can possibly lead the

Re: [HACKERS] make async slave to wait for lsn to be replayed

2020-11-16 Thread a . pervushina
Hello, I've changed the BEGIN WAIT FOR LSN statement to core functions pg_waitlsn, pg_waitlsn_infinite and pg_waitlsn_no_wait. Currently the functions work inside repeatable read transactions, but waitlsn creates a snapshot if called first in a transaction block, which can possibly lead the

Re: [HACKERS] make async slave to wait for lsn to be replayed

2020-10-02 Thread a . pervushina
Anna Akenteva писал 2020-04-08 22:36: On 2020-04-08 04:09, Kyotaro Horiguchi wrote: I like your suggested keywords! I think that "AFTER" + "WITHIN" sound the most natural. We could completely give up the LSN keyword for now. The final command could look something like: BEGIN AFTER ‘0/303EC60’

Re: psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, matviews, triggers and tables

2020-08-18 Thread a . pervushina
Anna Akenteva wrote 2020-08-11 13:37: About the patch: 1) There is some code duplication for the exec_command_[sm|si|st|sr] functions. Plus, it seems weird to separate sm (show matview) from sv (show view). Perhaps it would be more convenient to combine some of the code? Maybe by editing the

psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, matviews, triggers and tables

2020-07-28 Thread a . pervushina
sion. Best regards, Alexandra Pervushina. diff --git a/src/bin/psql/command.c b/src/bin/psql/command.c index 560eacc7f0c..c00af2be0ab 100644 --- a/src/bin/psql/command.c +++ b/src/bin/psql/command.c @@ -49,7 +49,11 @@ typedef enum EditableObjectType { EditableFunction, - EditableView + EditableVie