Re: {Spam} [GENERAL] FOREIGN KEY migration of syntax, help needed

2007-08-01 Thread Mike Haberman
wow.. Thank you. mike On Wed, Aug 01, 2007 at 10:31:16AM +0200, Dimitri Fontaine wrote: > Le mardi 31 juillet 2007, Mike Haberman a ?crit?: > >My old database has the old-style FOREIGN KEY syntax: > > I've had this very same transition to make on a database here, and

Re: [GENERAL] FOREIGN KEY migration of syntax, help needed

2007-07-31 Thread Mike Haberman
Thank you for the quick response. If all my old constraints are NOT DEFERRABLE INITIALLY IMMEDIATE does that mean I don't have to worry about the deferrable keyword? mike On Tue, Jul 31, 2007 at 04:00:59PM -0400, Tom Lane wrote: > Mike Haberman <[EMAIL PROTECT

[GENERAL] FOREIGN KEY migration of syntax, help needed

2007-07-31 Thread Mike Haberman
Hi, Quick question: My old database has the old-style FOREIGN KEY syntax: CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON assettype FROM assettype NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins"('', 'assettype', 'assettype'

Re: [GENERAL] PL/pgSQL - mailng list

1999-05-24 Thread Mike Haberman
be helpful. thanks a ton mike haberman [EMAIL PROTECTED] > > On Sat, 22 May 1999, Andy Lewis wrote: > > How can we tell you more if we don't know what you know? It's > usually pretty safe to just go ahead and ask the question. You'll be > redirected