Re: stored procs - Mailing list pgsql-general

From Alban Hertroys
Subject Re: stored procs
Date
Msg-id CAF-3MvPgDxHtbG3Y5D69dxa4NZ6XkMrDAckOGoCE_bairg200Q@mail.gmail.com
Whole thread Raw
In response to Re: stored procs  ("J.V." <jvsrvcs@gmail.com>)
List pgsql-general
On 30 September 2011 11:20, J.V. <jvsrvcs@gmail.com> wrote:
> For tables that already exist and have a foreign key relationship, is there
> an equivalent alter statement for the statement below?
>
> Does this mean that if table xxx.id primary key value changes, the foreign
> key value will change as well?

They do if you tell them to CASCADE on UPDATE.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: "J.V."
Date:
Subject: Re: stored procs
Next
From: "Albe Laurenz"
Date:
Subject: Re: stored procedures (packages)