Re: [GENERAL] Upgrade 8.3

2008-04-18 Thread Rodrigo Gonzalez
E.J. Moloney escribió: I am running the following query update tempportfwdconnectiona set srcid=interface.objectid from interface where tempportfwdconnectiona.hostid=interface.host and tempportfwdconnectiona.spantreeport=interface.stpport For application reasons the spantreeport in one table

Re: [GENERAL] Upgrade 8.3

2008-04-18 Thread Craig Ringer
E.J. Moloney wrote: I am running the following query update tempportfwdconnectiona set srcid=interface.objectid from interface where tempportfwdconnectiona.hostid=interface.host and tempportfwdconnectiona.spantreeport=interface.stpport For application reasons the spantreeport in one table is

[GENERAL] Upgrade 8.3

2008-04-18 Thread E.J. Moloney
I am running the following query update tempportfwdconnectiona set srcid=interface.objectid from interface where tempportfwdconnectiona.hostid=interface.host and tempportfwdconnectiona.spantreeport=interface.stpport For application reasons the spantreeport in one table is a text field and an