depended on table types

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: depended on table types
Date: 2005-03-17 22:34:22
Message-ID: 423A05EE.5060805@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-03-17 22:45:54 Re: Lockfile restart failure is still there :-(
Previous Message Simon Riggs 2005-03-17 21:30:12 Re: securing pg_proc