--- Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Tue, Jul 01, 2003 at 02:35:48 -0700, > Rudy Koento <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I've realised that my tables' constraint was set > to > > IMMEDIATE. So, when I update one table, there's > error > > because of referential integrity. Reading the > docs, I > > read that SET CONSTRAINTS has no effect on > IMMEDIATE > > (and I've confirmed that by trying it out). > > > > Is there anyway I can circumvent this? I > remembered I > > can delete using pgAdminII. However, I don't have > a > > windows box now, and therefore I can't use > pgAdminII. > > You can use alter table to drop the constraint and > then to add the corrected > constraint. I am not sure if this was available > prior to 7.3.
I solved it by using pgAdminII remotely through ssh port forwarding. I'm curious though, as to why does pgAdminII is able to defer the constraints whereas using command line cannot... __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
