PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID14825
PG Version10beta4
OSDebian Linux
Opened2017-09-22 18:59:04+00
Reported byBalazs Szilfai
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      14825
Logged by:          Balazs Szilfai
Email address:      (redacted)
PostgreSQL version: 10beta4
Operating system:   Debian Linux
Description:        

Hi,

version: 10rc1

testdb=# begin;
BEGIN
testdb=# create type enumtype as enum ('v1', 'v2');
CREATE TYPE
testdb=# create table testtable (enumcolumn enumtype not null default
'v1');
CREATE TABLE

Everything it's OK! :)

If enum type have "owner to":

testdb=# begin;
BEGIN
testdb=# create type enumtype as enum ('v1', 'v2');
CREATE TYPE
testdb=# alter type enumtype owner to testrole;
ALTER TYPE
testdb=# create table testtable (enumcolumn enumtype not null default
'v1');
ERROR:  unsafe use of new value "v1" of enum type enumtype
HINT:  New enum values must be committed before they can be used.

Is this unsafe?

Balazs


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Messages

DateAuthorSubject
2017-09-22 18:59:04+00balazs(at)obiserver(dot)hu BUG #14825: enum type: unsafe use?
2017-09-22 21:46:08+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-23 01:27:29+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-23 03:19:52+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-23 12:41:25+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-23 15:16:45+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-23 17:48:23+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-23 18:00:56+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-23 19:05:57+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-23 19:52:05+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-23 21:45:46+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-23 22:06:21+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-24 20:19:37+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-24 20:37:30+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-24 21:32:29+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-24 23:06:49+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-25 00:42:25+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-25 14:14:37+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-25 14:24:53+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-25 14:42:59+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-25 14:55:58+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-25 17:32:08+00Christophe PettusRe: BUG #14825: enum type: unsafe use?
2017-09-25 17:34:23+00"David E(dot) Wheeler"Re: BUG #14825: enum type: unsafe use?
2017-09-25 18:17:09+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-25 18:44:34+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-26 17:18:47+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-26 18:37:46+00Tom LaneRe: BUG #14825: enum type: unsafe use?
2017-09-26 19:33:03+00Andrew DunstanRe: BUG #14825: enum type: unsafe use?
2017-09-26 20:07:02+00Tom LaneRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 21:14:19+00Bruce MomjianRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 21:32:15+00Tom LaneRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 21:45:48+00Stephen FrostRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 21:46:18+00Bruce MomjianRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 22:04:26+00Andrew DunstanRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 22:18:53+00Andrew DunstanRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-26 22:49:39+00Tom LaneRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-09-27 18:52:54+00Tom LaneRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-10-03 23:53:41+00Andrew DunstanRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-10-04 01:29:22+00Tom LaneRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-10-04 01:38:56+00Andres FreundRe: [HACKERS] BUG #14825: enum type: unsafe use?
2017-10-05 13:45:14+00Robert HaasRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-01-11 23:01:55+00Thomas MunroRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-01-12 03:19:02+00Robert HaasRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-01-12 04:01:58+00Thomas MunroRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-01-12 12:51:34+00Robert HaasRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-01-12 22:06:12+00Andres FreundRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-01-13 02:42:49+00Robert HaasRe: [HACKERS] BUG #14825: enum type: unsafe use?
2018-09-08 16:01:09+00Thomas MunroRe: [HACKERS] BUG #14825: enum type: unsafe use?