<pre><pre>hello,<br />everyone!<br /> I want to know how postgresql remain its unique index unique after <br />i have
changeit.For example:<br /> create table human(age int,name char(2));<br />then in the pg_attribute catalog the unique
indexpg_attribute_relid_attnum_index will<br />use relid of 'human'and attnum of age to create a index tuple for
attribute:age,whichis a unique index tuple for a tuple which describe age in pg_attribute,and i do:<br /> alter table
humanrename age to birthdate;<br />then in the unique index pg_attribute_relid_attnum_index will appear two index tuple
<br/>which keys are relid of 'human' and attnum:1 to describe age ,but there is no error happening!!!!So i am
interestedin the method of remain the dynamic index very much.<br /> would you please tell how postgres do it and the
srcof this? <br />thanks :) </pre><pre> </pre><pre> 致<br />礼!<br /> </pre><pre> 庄继锋<br /> <a
href="mailto:zhuangjifeng@263.net">zhuangjifeng@263.net</a><br/> 2004-04-29</pre></pre>
==========================263电子邮件-信赖邮自专业