On Mon, Apr 13, 2009 at 2:09 PM, Glenn Maynard <glennfmayn...@gmail.com> wrote:
> Your PK is a composite of (entry, order)? Won't your foreign keys > elsewhere all break when you shift the order around? If there really are foreign keys, then an update will not be allowed to shift a primary key unless the foreign key is set with ON UPDATE CASCADE then the shifts will be cascaded to all references automatically. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
