| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Reducing some DDL Locks to ShareLock |
| Date: | 2008-10-07 18:38:46 |
| Message-ID: | 1223404726.4747.249.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2008-10-07 at 11:15 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> > 2. Also need to decide whether we want pg_class.reltriggers as int2 (as
> > implemented here) or switch to relhastriggers as boolean.
>
> I'd go for changing the column name/type. Yeah, you will break any
> clients that are still trying to manipulate reltriggers directly, but
> better to break them obviously than non-obviously. And I think a silent
> change in the column semantics has significant risk of the latter.
New version with column type change.
Initdb forced, psql, pg_dump changes also.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| Attachment | Content-Type | Size |
|---|---|---|
| ddl_lock_reduce.v6.patch | text/x-patch | 71.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-07 19:32:54 | Re: Reducing some DDL Locks to ShareLock |
| Previous Message | Simon Riggs | 2008-10-07 18:38:42 | Re: Reducing some DDL Locks to ShareLock |