| From: | Mike Haberman <mikeh(at)ncsa(dot)uiuc(dot)edu> |
|---|---|
| To: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: {Spam} FOREIGN KEY migration of syntax, help needed |
| Date: | 2007-08-01 16:04:20 |
| Message-ID: | 20070801160420.GA62063@ncsa.uiuc.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
> successfully used adddepend:
> http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/adddepends/adddepends/
>
> It has been moved out from contrib to pgfoundry as of 8.2, but on a 8.1 server
> where the constraint triggers seem to have been inherited from 7.x times, was
> darn usefull.
>
> Hope this helps,
> --
> dim
--
-----------------------------------------------------------------------
Mike Haberman
Senior Software/Network Research Engineer
National Center for Supercomputing Applications
217.244.9370
-----------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauthier, Dave | 2007-08-01 16:05:29 | how do i get num of recs inserted/deleted/updated in plpgsql |
| Previous Message | Michael Brewer | 2007-08-01 15:44:21 | Re: PostgreSQL, PGDAY, PGParty and OSCON 2007 Rocked! |