# PG::ReadOnlySqlTransaction: ERRORE: impossibile eseguire SELECT in una transizione di sola lettura
**URL:** https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799
**Category:** Self-hosting
**Created:** [11 Ottobre 2019, 4:28pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799 "2019-10-11T16:28:07Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Shubham\_Ranjan](https://meta.discourse.org/u/Shubham_Ranjan)
#### Post date: [11 Ottobre 2019, 4:28pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/1 "2019-10-11T16:28:07Z")
Volevo chiudere alcuni vecchi argomenti eseguendo una query in [Data Explorer](https://meta.discourse.org/t/32566?silent=true) e impostando il campo closed su true tramite una query. Sembra che non possa modificare i dati, nemmeno con i privilegi di **amministratore**. Esiste un modo per farlo senza dover chiudere manualmente gli argomenti uno per uno?
Viene sempre restituito un errore: **PG::ReadOnlySqlTransaction: ERRORE: impossibile eseguire SELECT in una transizione di sola lettura**
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [11 Ottobre 2019, 4:29pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/2 "2019-10-11T16:29:19Z")
È per questo che si chiama _esploratore_ dei dati e non _modificatore_ dei dati 🙂
---
### Author:  [@Shubham\_Ranjan](https://meta.discourse.org/u/Shubham_Ranjan)
#### Post date: [11 Ottobre 2019, 4:31pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/3 "2019-10-11T16:31:13Z")
Ciao @RGJ,
Grazie per la tua risposta 🙂
> [@Shubham\_Ranjan](#):
>
> Volevo chiudere alcuni vecchi argomenti
C’è qualche modo per riuscirci?
---
### Author:  [@bts](https://meta.discourse.org/u/bts)
#### Post date: [11 Ottobre 2019, 4:36pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/4 "2019-10-11T16:36:47Z")
Non l’ho ancora usato, ma se stai cercando uno strumento per eseguire query SQL dirette, credo che questo sia quello che fa per te! —
> [@New official direct SQL access API for Discourse (mini\_sql)](https://meta.discourse.org/t/new-official-direct-sql-access-api-for-discourse-mini-sql/90441):
>
> I just finished “officializing” and “extracting” our direct DB access helpers in Discourse. I would like to cover what was done and what this means to plugin authors and core contributors. From the very first version of Discourse, @eviltrout introduced some helpers internally for safely executing direct SQL in Discourse. It looked like this. ActiveRecord::Base.exec\_sql("select \* from topics where id = :id", id: 1) # or Topic.exec\_sql("select \* from topics where id = :id", id: 1) This is a p…
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [12 Ottobre 2019, 12:35pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/5 "2019-10-12T12:35:35Z")
> [@Shubham\_Ranjan](#):
>
> Volevo chiudere alcuni vecchi argomenti eseguendo una query
Puoi farlo dalla console di Rails. Ci sono alcuni argomenti “how-to” per apportare modifiche di massa a varie impostazioni.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [16 Giugno 2023, 3:16pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/6 "2023-06-16T15:16:41Z")
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [16 Giugno 2023, 3:18pm UTC](https://meta.discourse.org/t/pg-error-cannot-execute-select-in-a-read-only-transaction/130799/7 "2023-06-16T15:18:02Z")