Обсуждение:

Поиск
Список
Период
Сортировка

От
zhuangjifeng
Дата:
<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电子邮件－信赖邮自专业

Re:

От
Tom Lane
Дата:
zhuangjifeng <zhuangjifeng@263.net> writes:
> PGh0bWw+PHByZT48UFJFPmhlbGxvLDxCUj5ldmVyeW9uZSE8QlI+Jm5ic3A7
> SSB3YW50IHRvIGtub3cgaG93IHBvc3RncmVzcWwgcmVtYWluIGl0cyB1bmlx
> dWUgaW5kZXggdW5pcXVlIGFmdGVyIDxCUj5pIGhhdmUgY2hhbmdlIGl0LkZv
> ciBleGFtcGxlOjxCUj4mbmJzcDtjcmVhdGUgdGFibGUgaHVtYW4oYWdlIGlu
> dCxuYW1lIGNoYXIoMikpOzxCUj50aGVuIGluIHRoZSBwZ19hdHRyaWJ1dGUg
> Y2F0YWxvZyB0aGUgdW5pcXVlIGluZGV4IHBnX2F0dHJpYnV0ZV9yZWxpZF9h
> dHRudW1faW5kZXggd2lsbDxCUj51c2UgcmVsaWQgb2YgJ2h1bWFuJ2FuZCBh
> dHRudW0gb2YgYWdlIHRvIGNyZWF0ZSBhIGluZGV4IHR1cGxlIGZvciBhdHRy
> aWJ1dGU6YWdlLHdoaWNoIGlzIGEgdW5pcXVlIGluZGV4IHR1cGxlIGZvciBh
> IHR1cGxlIHdoaWNoIGRlc2NyaWJlIGFnZSBpbiBwZ19hdHRyaWJ1dGUsYW5k
> IGkgZG86PEJSPiZuYnNwO2FsdGVyIHRhYmxlIGh1bWFuIHJlbmFtZSBhZ2Ug
> dG8gYmlydGhkYXRlOzxCUj50aGVuIGluIHRoZSB1bmlxdWUgaW5kZXggcGdf
> YXR0cmlidXRlX3JlbGlkX2F0dG51bV9pbmRleCB3aWxsIGFwcGVhciB0d28g
> aW5kZXggdHVwbGUgPEJSPndoaWNoIGtleXMgYXJlIHJlbGlkIG9mICdodW1h
> bicgYW5kIGF0dG51bToxIHRvIGRlc2NyaWJlIGFnZSAsYnV0IHRoZXJlIGlz
> IG5vIGVycm9yIGhhcHBlbmluZyEhISFTbyBpIGFtIGludGVyZXN0ZWQgaW4g
> dGhlIG1ldGhvZCBvZiByZW1haW4gdGhlIGR5bmFtaWMgaW5kZXggdmVyeSBt
> dWNoLjxCUj4mbmJzcDt3b3VsZCB5b3UgcGxlYXNlIHRlbGwgaG93IHBvc3Rn
> cmVzIGRvIGl0IGFuZCB0aGUgc3JjIG9mIHRoaXM/IDxCUj50aGFua3MgOikg
> PC9QUkU+PFBSRT4mbmJzcDs8L1BSRT48UFJFPqGhoaGhoaGhoaGhoaGhoaHW
> wjxCUj7A8aOhPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzwv
> UFJFPjxQUkU+oaGhoaGhoaGhoaGhoaGhodevvMy35jxCUj6hoaGhoaGhoaGh
> oaGhoaGhPEEgaHJlZj0ibWFpbHRvOnpodWFuZ2ppZmVuZ0AyNjMubmV0Ij56
> aHVhbmdqaWZlbmdAMjYzLm5ldDwvQT48QlI+oaGhoaGhoaGhoaGhoaGhoaGh
> oaEyMDA0LTA0LTI5PC9QUkU+PC9wcmU+PC9odG1sPg0KDQoNCg0KDQoNCj09
> PT09PT09PT09PT09PT09PT09PT09PT09DQoyNjO159fT08q8/qOt0MXAtdPK
> 19TXqNK1

I'd have answered this if my editor could quote it reasonably,
but I don't have the energy to deal with the above...

In future, please post to pghackers in plain text (lose the
HTML, too) and include a relevant Subject: line.
        regards, tom lane