violation of refrential integrity

Поиск
Список
Период
Сортировка
От amit singh
Тема violation of refrential integrity
Дата
Msg-id 20050203154656.271B7164005@ws1-4.us4.outblaze.com
обсуждение исходный текст
Список pgsql-chat
<div><font face="Arial" size="2">I'm using eRserver on Postgres 7.2-3 version for doing replication on a 2-node cluster
(master/slave).</font></div><div><fontface="Arial" size="2"></font> </div><div><font face="Arial" size="2">I was facing
theproblem of refrential integrity so gone through a online document <font color="blue">(Hacking the refrential
integrityby Joel Burton</font>) in Tech Docs Knowledge base  of Postgres , which talks about playing with the
pg_triggertable and disabling the field (tgenabled = FALSE ) temporarily to get rid away from triggers (foriegn key
constraints).</font></div><div><fontface="Arial" size="2">After making the changes I properly shutdown the database and
startedit up but nothing happens . </font></div><div><font face="Arial" size="2"></font> </div><div><font face="Arial"
size="2">Linkto the Tech doc: <a
href="http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php">http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php</a></font></div><div><font
color="red"face="Arial" size="2"></font> </div><div><font color="red" face="Arial" size="2"> ERROR:violation of
refrentialintegrity key refrenced from <table2> is  not found  in <table 1></font></div><div><font
color="red"face="Arial" size="2"></font> </div><div><font face="Arial" size="2"> Where table1 is parent of
table2.</font></div><div><fontface="Arial" size="2">CAUSE OF ERROR: we are trying to insert something in table2 which
isnot there in table1.</font></div><div><font face="Arial" size="2"></font> </div><div><font color="blue" face="Arial"
size="2">MYQUERY: Document talks about disabling the tgenabled field on pg_trigger will solve the problem of refrential
integrityas it will blindly go and make entries in the table by restricting the triggers to get fired upon
INSERTION,DELETIONand UPDATION. It also says that pg_dump works in the same way so that table data can be inserted in
anyorder without having to worry about refrential integrity rule.</font></div><div><font color="blue" face="Arial"
size="2"></font> </div><div><fontcolor="blue" face="Arial" size="2">So, is this the version(7.2-3) which is not
supportingor something else.</font></div><div><font color="#0000ff" face="Arial" size="2"></font> </div><div><font
color="#0000ff"face="Arial" size="2">A quick reply will be highly appreciated.</font></div><div><font color="#0000ff"
face="Arial"size="2"></font> </div><div><font color="black" face="Arial" size="2">Thanks &
Regds,</font></div><div><fontcolor="black" face="Arial" size="2">Amit Singh.</font></div><div><font face="Arial"
size="2"></font> </div><br/> -- <p>___________________________________________________________<br />Sign-up for Ads
Freeat Mail.com<br /><a href="http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=adsfreejump01"
target="_blank">http://www.mail.com/?sr=signup</a>

В списке pgsql-chat по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Installation of pgsql 8.0 on windows
Следующее
От: Alan Aguia
Дата:
Сообщение: Pregunta de migración