1253
1253
where oid = 'test_storage'::regclass;
1255
CREATE TABLE test_inh_check (a float check (a > 10.2));
1255
-- ALTER COLUMN TYPE with a check constraint and a child table (bug #13779)
1256
CREATE TABLE test_inh_check (a float check (a > 10.2), b float);
1256
1257
CREATE TABLE test_inh_check_child() INHERITS(test_inh_check);
1259
\d test_inh_check_child
1260
select relname, conname, coninhcount, conislocal, connoinherit
1261
from pg_constraint c, pg_class r
1262
where relname like 'test_inh_check%' and c.conrelid = r.oid
1257
1264
ALTER TABLE test_inh_check ALTER COLUMN a TYPE numeric;
1258
1265
\d test_inh_check
1259
1266
\d test_inh_check_child
1267
select relname, conname, coninhcount, conislocal, connoinherit
1268
from pg_constraint c, pg_class r
1269
where relname like 'test_inh_check%' and c.conrelid = r.oid
1271
-- also try noinherit, local, and local+inherited cases
1272
ALTER TABLE test_inh_check ADD CONSTRAINT bnoinherit CHECK (b > 100) NO INHERIT;
1273
ALTER TABLE test_inh_check_child ADD CONSTRAINT blocal CHECK (b < 1000);
1274
ALTER TABLE test_inh_check_child ADD CONSTRAINT bmerged CHECK (b > 1);
1275
ALTER TABLE test_inh_check ADD CONSTRAINT bmerged CHECK (b > 1);
1277
\d test_inh_check_child
1278
select relname, conname, coninhcount, conislocal, connoinherit
1279
from pg_constraint c, pg_class r
1280
where relname like 'test_inh_check%' and c.conrelid = r.oid
1282
ALTER TABLE test_inh_check ALTER COLUMN b TYPE numeric;
1284
\d test_inh_check_child
1285
select relname, conname, coninhcount, conislocal, connoinherit
1286
from pg_constraint c, pg_class r
1287
where relname like 'test_inh_check%' and c.conrelid = r.oid
1261
1290
-- check for rollback of ANALYZE corrupting table property flags (bug #11638)
1262
1291
CREATE TABLE check_fk_presence_1 (id int PRIMARY KEY, t text);