Interval in hours but not in days Leap second not taken into account

Hello, # An interval in " years months ... seconds " given in seconds by EXTRACT(EPOCH ...) transtyped into INTERVAL : SELECT (EXTRACT(EPOCH FROM ('3 years 2 months 1 day 10 hours 11 minutes 12 seconds'::interval) ) || ' seconds')::interval ; interval - 27772:11:12 # The same

ERROR: unsupported Unicode escape sequence - in JSON-type column

Hi team, Our customer was able to sneak in an Unicode data into a column of a JSON Type and now that record fails on select. [cid:part1.hzRCQplU.TJZnhVJk@eftlab.com.au] Would you be able to suggest any way out of this? E.g. finding infringing row, updating its data ... ? Thanks & Cheers, Jan

Re: Event Triggers unable to capture the DDL script executed

Hi Laurenz, Is it possible to access the pg_ddl_command using C function? In the shared links, I couldn't find one. Can you please share an example for the same? Thanks & Regards, Neethu From: Laurenz Albe Sent: Thursday, February 23, 2023 4:20 PM To: Neethu P ;

Re: Give me details of some attributes!!

On Sun, 2023-02-26 at 22:29 +0800, jack...@gmail.com wrote: > > here are the source codes from src/include/access/htup_details.h. > /* >  * information stored in t_infomask: >  */ > #define HEAP_HASNULL 0x0001 /* has null attribute(s) */ > #define HEAP_HASVARWIDTH 0x

Comparing Postgres logical replication to MySQL

Hi All, I am wondering if there is any article comparing Postgres logical replication to MySQL row based replication? https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html Are these two equivalent? If not, what are the differences? S.

Give me details of some attributes!!

here are the source codes from src/include/access/htup_details.h. /* * information stored in t_infomask: */ #define HEAP_HASNULL 0x0001 /* has null attribute(s) */ #define HEAP_HASVARWIDTH 0x0002 /* has variable-width attribute(s) */ #define HEAP_HASEXTERNAL 0x0004 /* has external stored attribu