sql: `create table x; begin; drop table x; create table x`: relation `x` already exists #13686

tbg · 2017-02-21T09:13:22Z

I believe this was discussed somewhere already, but wasn't able to find it. It's perhaps similar in spirit to #13505.

The problem is (presumably) that the table is really only dropped when the transaction commits, but the recreation in the same txn explicitly requires it to be (assumed) gone before commit.

Found while trying to use diesel-rs, which reliably triggers this with when following http://diesel.rs/guides/getting-started/ at diesel migration run; diesel migration redo.

The text was updated successfully, but these errors were encountered:

nvanbenschoten · 2017-02-21T09:14:39Z

IIRC, @andreimatei is intimately familiar with this issue.

a-robinson · 2017-02-21T13:44:24Z

Yeah, we already have some discussion about this on #12123.

tbg added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Feb 21, 2017

a-robinson closed this as completed Feb 21, 2017

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

sql: `create table x; begin; drop table x; create table x`: relation `x` already exists #13686

sql: `create table x; begin; drop table x; create table x`: relation `x` already exists #13686

tbg commented Feb 21, 2017

nvanbenschoten commented Feb 21, 2017

a-robinson commented Feb 21, 2017

sql: create table x; begin; drop table x; create table x: relation x already exists #13686

sql: create table x; begin; drop table x; create table x: relation x already exists #13686

Comments

tbg commented Feb 21, 2017

nvanbenschoten commented Feb 21, 2017

a-robinson commented Feb 21, 2017

sql: `create table x; begin; drop table x; create table x`: relation `x` already exists #13686

sql: `create table x; begin; drop table x; create table x`: relation `x` already exists #13686