Skip to content

Error with transactional pgv_insert/pgv_remove #27

Closed
@Fenoman

Description

@Fenoman

Here is a short example that shows the problem:

BEGIN TRANSACTION;

SELECT
    pgv_insert('test', 'x', ROW (1::int), TRUE);

--... do some actions ...

-- remove package (!!!)
SELECT
    pgv_remove('test');

--... do some other actions ...

-- Error: there is a record in the variable "x" with same key
-- But we deleted the package!!!
SELECT
    pgv_insert('test', 'x', ROW (1::int), TRUE);

COMMIT;

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions