ts on
this.
Thanks!
--
Best Regards
Andy Fan
On Thu, May 14, 2020 at 9:33 PM Laurenz Albe
wrote:
> On Thu, 2020-05-14 at 16:26 +0800, Andy Fan wrote:
> > Thanks, actually I don't know how to use prepared transaction and how
> it works.
> > I care about this because there is a long prepared transaction exists in
>
On Thu, May 14, 2020 at 4:05 PM Michael Paquier wrote:
> On Thu, May 14, 2020 at 03:38:24PM +0800, Andy Fan wrote:
> > I want to know what happens been done for an uncommitted prepared
> > transaction with pg_waldump, however I can't find it.
> >
> > demo=*# prep
On Thu, May 14, 2020 at 3:38 PM Andy Fan wrote:
> I can get the log for "prepared command" only, but nothing was found for
> the insert
> statement. what should I do?
>
> My version is 9.4.
>
> Sorry, my production version is 9.4 and my demo above is v12.
Hi:
I want to know what happens been done for an uncommitted prepared
transaction with pg_waldump, however I can't find it.
demo=# begin;
BEGIN
demo=*# select txid_current();
txid_current
--
608
(1 row)
demo=*# prepare transaction 's';
PREPARE TRANSACTION
demo=# insert int
Got it, thank you!
On Thu, Feb 28, 2019 at 12:48 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wednesday, February 27, 2019, Andy Fan
> wrote:
>
>>
>> The following way works with 2 commands:
>>
>> zhifan=# create table t1 (a jsonb);
&g
The following way works with 2 commands:
zhifan=# create table t1 (a jsonb);
CREATE TABLE
zhifan=# create unique index t1_a_name on t1 ((a->'name'));
CREATE INDEX
but know I want to merge them into 1 command, is it possible?
zhifan=# create table t2 (a jsonb, constraint uk_t2_a_name
unique((a->'
