TechQA.

Question

"SET LOCAL can only be used in transaction blocks" warning in PostgreSQL

score 1406 · Answer 1 · 2023-01-05T09:06:02.493000

0

Answer

1406

Views

"SET LOCAL can only be used in transaction blocks" warning in PostgreSQL

1.4k views Asked by Super Kai - Kazuya Ito At 05 January 2023 at 09:06

score 267 · Answer 2 · 2022-11-01T17:07:28.733000

SQL Server table data deletion while insertion is in progress in another session

267 views Asked by Mahendra Dhaker At 01 November 2022 at 17:07

score 370 · Answer 3 · 2022-06-20T12:25:40.287000

How to initiate tables lock for stored procedure in Azure Synapse Analytics?

370 views Asked by Ken Masters At 20 June 2022 at 12:25

score 1282 · Answer 4 · 2021-11-09T16:45:11.297000

How to remove a lock from a table in a Synapse Dedicated Pool?

1.2k views Asked by v-jh At 09 November 2021 at 16:45

score 497 · Answer 5 · 2020-12-04T08:27:15.153000

Temporal Table and Table locks

497 views Asked by Emil At 04 December 2020 at 08:27

score 181 · Answer 6 · 2020-03-30T22:07:42.043000

locking the same table with different aliases

181 views Asked by neubert At 30 March 2020 at 22:07

score 187 · Answer 7 · 2019-10-08T14:41:43.837000

SQL Server - 2 sec inserts and 5 min archiving - How to avoid table locks?

187 views Asked by MRK_S At 08 October 2019 at 14:41

score 1844 · Answer 8 · 2019-08-15T13:19:10.193000

innodb full table lock during simple insert

1.8k views Asked by Rahul At 15 August 2019 at 13:19

score 1854 · Answer 9 · 2018-08-28T08:47:29.813000

(MySQL 5.7.19 AWS RDS) how to change table column character set without locking

1.8k views Asked by user5013462 At 28 August 2018 at 08:47

score 114 · Answer 10 · 2018-07-31T13:32:02.563000

lock issue on tables due to triggers

114 views Asked by ANUJ PANDIT At 31 July 2018 at 13:32

score 2421 · Answer 11 · 2018-07-24T14:57:33.967000

Laravel database lock table in concurrent request

2.4k views Asked by Shiro At 24 July 2018 at 14:57

score 1649 · Answer 12 · 2017-11-21T11:03:32.843000

SQL Server: lock table during entire stored procedure

1.6k views Asked by Tjekkles At 21 November 2017 at 11:03

score 104 · Answer 13 · 2017-10-03T17:20:52.680000

Is this insert safe?

104 views Asked by posthy At 03 October 2017 at 17:20

score 1493 · Answer 14 · 2017-07-19T15:01:03.487000

Lock tables in long stored procedure in Oracle

1.4k views Asked by sanjay Kumar At 19 July 2017 at 15:01

score 79 · Answer 15 · 2017-04-15T18:59:01.083000

What is a proper way to perform a mysql transaction across different php files under the use of ajax or it is not possible?

79 views Asked by Hang Chen At 15 April 2017 at 18:59

score 933 · Answer 16 · 2016-10-18T03:44:22.057000

Lock a SQL server Table for a given time and check if it is locked

933 views Asked by Madhur Maurya At 18 October 2016 at 03:44

score 101 · Answer 17 · 2016-05-24T02:07:02.697000

How to freeze table header at modal box

101 views Asked by wendy At 24 May 2016 at 02:07

score 1295 · Answer 18 · 2016-03-13T19:43:47.333000

TABLOCKX not working

1.2k views Asked by user2557930 At 13 March 2016 at 19:43

score 765 · Answer 19 · 2016-01-25T05:38:40.597000

Table lock throws exception vs table lock waits for end

765 views Asked by BendEg At 25 January 2016 at 05:38

score 547 · Answer 20 · 2015-09-21T08:15:25.773000

Is it possible to use PDO lastInsertId() when the table was previously locked?

547 views Asked by Nikola F At 21 September 2015 at 08:15

TechQA.

List Question

"SET LOCAL can only be used in transaction blocks" warning in PostgreSQL

SQL Server table data deletion while insertion is in progress in another session

How to initiate tables lock for stored procedure in Azure Synapse Analytics?

How to remove a lock from a table in a Synapse Dedicated Pool?

Temporal Table and Table locks

locking the same table with different aliases

SQL Server - 2 sec inserts and 5 min archiving - How to avoid table locks?

innodb full table lock during simple insert

(MySQL 5.7.19 AWS RDS) how to change table column character set without locking

lock issue on tables due to triggers

Laravel database lock table in concurrent request

SQL Server: lock table during entire stored procedure

Is this insert safe?

Lock tables in long stored procedure in Oracle

What is a proper way to perform a mysql transaction across different php files under the use of ajax or it is not possible?

Lock a SQL server Table for a given time and check if it is locked

How to freeze table header at modal box

TABLOCKX not working

Table lock throws exception vs table lock waits for end

Is it possible to use PDO lastInsertId() when the table was previously locked?

Popular Questions

Trending Questions