Skip to content

Cannot create keyless temporary tables with serial columns #2326

@NathanGabrielson

Description

@NathanGabrielson

This should be allowed, currently fails.

postgres=> create temporary table tbl (id serial);
ERROR:  relation "tbl" does not exist (errno 1105) (sqlstate HY000)

This query will work, however:

postgres=> create temporary table tbl (id serial primary key);
CREATE TABLE

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions