Re: pgsql-server: Clean up generation of default names - Mailing list pgsql-committers

From Christopher Kings-Lynne
Subject Re: pgsql-server: Clean up generation of default names
Date
Msg-id 40C9077D.6050805@familyhealth.com.au
Whole thread Raw
In response to pgsql-server: Clean up generation of default names for constraints,  (tgl@svr1.postgresql.org (Tom Lane))
Responses Re: pgsql-server: Clean up generation of default names
List pgsql-committers
> Clean up generation of default names for constraints, indexes, and serial
> sequences, as per recent discussion.  All these names are now of the
> form table_column_type, with digits added if needed to make them unique.
> Default constraint names are chosen to be unique across their whole schema,
> not just within the parent object, so as to be more SQL-spec-compatible
> and make the information schema views more useful.

Do you do any sort of 'locking of potential names' to ensure that
another process adding a sequence at the same time or something won't
get the same name first, causing yours to still fail or break uniqueness?

Or do we just not care since it's unlikely to happen and our transation
would likely have some exclusive lock anyway?

Chris


pgsql-committers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: pgsql-server: Fix oversight in recent ALTER TABLE
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server: When using extended-query protocol, postpone planning of