depended on table types - Mailing list pgsql-hackers

From Andrew Dunstan
Subject depended on table types
Date
Msg-id 423A05EE.5060805@dunslane.net
Whole thread Raw
Responses Re: depended on table types  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Is one supposed to be able to alter the type of a table whose definition
has been used A  composite in another table? Somewhat surprisingly to
me, the following test did not produce an error:

create table a( x text, y int);
create table b( z a);
insert into b values('(\'aaa\',3)');
select * from b;
alter table a add column q timestamp not null;
select * from b;


cheers

andrew



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: securing pg_proc
Next
From: Greg Stark
Date:
Subject: Re: Lockfile restart failure is still there :-(