Hi all,
I am having jsonb as C character string received by WAL decoding and want
to extract all its key and value pairs.
Which is the best approach for extracting keys and its values?
i) Converting the C string to a PostgreSQL jsonb object
ii) Using open-source json-c
Hi all
I am building a patch to refresh materialized view incrementally from the
change set decoded by using logical decoding from WAL.
As of now i can able to generate the changes that has to be updated in
the materialized view but the thing was it not possible to do any D
Hi all
I am building a patch to refresh materialized view incrementally from the
change set decoded by using logical decoding from WAL.
As of now i can able to generate the changes that has to be updated in
the materialized view but the thing was it not possible to do any DM
Hi all
I am trying to delete/insert a row on materialized view which has join
from a UDF by using SPI_execute.
Materialized views are not allowed to do any DML changes once created,so
by bypassed that check by enabling MatViewIncrementalMaintenanceIsEnabled. so
DML queries
Hi all,
How postgresql handles full table delete in terms of loading the full
table in these scenarios
consider one big table(tablename: bigtable)
and the query will be >> delete from bigtable;
1)which doesn't have any foreign table reference with any other tables
2)And when this
Hi all,
I tried to execute a join query using SPI_execute() in logical decoding
part and got inconsistent values (i am referring it as inconsistent since it is
returning the old values which is present at the postgresql server start).
My data directory has to tables
table1(a in
