citusdata / citusdata/pg_shard

Support multi-statement transactions

Open
#87 8 comments 0 reactions 0 assignees View on GitHub
feature
Dominant language
C
Stars
1.1k
Forks
62
PR merge metrics
No merged PRs in 30d

Description

Currently when attempting to execute a query within a transaction, the following output is produced:

```
ERROR: distributed commands cannot run inside a transaction block
```

Since transactions are not supported, and only single `INSERTS` are allowed, this makes data import _incredibly_ slow. Further, this makes `pg_shard` completely unsuitable for use within a production environment where data integrity is important.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.