Re: [PATCHES] [WIP] The shared dependency patch

2004-12-17 Thread Alvaro Herrera
On Thu, Dec 16, 2004 at 12:46:46PM -0500, Tom Lane wrote: IIRC, Rod Taylor did some work on supporting locks for non-table objects back around the beginning of the year. We rejected the patch for various reasons but you might be able to adopt some of it. At the beggining of the past year,

Re: [PATCHES] [WIP] The shared dependency patch

2004-12-17 Thread Rod Taylor
On Fri, 2004-12-17 at 14:48 -0300, Alvaro Herrera wrote: On Thu, Dec 16, 2004 at 12:46:46PM -0500, Tom Lane wrote: IIRC, Rod Taylor did some work on supporting locks for non-table objects back around the beginning of the year. We rejected the patch for various reasons but you might be

Re: [PATCHES] [WIP] The shared dependency patch

2004-12-17 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: On Fri, 2004-12-17 at 14:48 -0300, Alvaro Herrera wrote: Does anyone remember why the patch was backed out? A pointer to the archives would be most helpful. In order to prevent the ability for a domain, schema, etc. to be dropped while another process

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Jaime Casanova
--- Jaime Casanova [EMAIL PROTECTED] escribió: --- Tom Lane [EMAIL PROTECTED] escribió: Jaime Casanova [EMAIL PROTECTED] writes: = select to_ascii('Jiménez'); will retrieve 'Jimenez' at least it works on Latin1 encoding. Why it not work on Latin9, Probably because it hasn't got a

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Tom Lane
Jaime Casanova [EMAIL PROTECTED] writes: Why it not work on Latin9, Probably because it hasn't got a table for Latin9. Feel free to contribute one --- see src/backend/utils/adt/ascii.c. This page shows the differences between Latin1 Latin9: http://www.cs.tut.fi/~jkorpela/latin9.html

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Peter Eisentraut
Jaime Casanova wrote: 188: it's an O merge with an E (sql_ascii = '')??? 189: the same but lower case(sql_ascii = '')??? 'OE' and 'oe', most likely, but someone more familiar with French typography might correct me. -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Jaime Casanova
--- Peter Eisentraut [EMAIL PROTECTED] escribió: Jaime Casanova wrote: 188: it's an O merge with an E (sql_ascii = '')??? 189: the same but lower case(sql_ascii = '')??? 'OE' and 'oe', most likely, but someone more familiar with French typography might correct me.

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Alvaro Herrera
On Fri, Dec 17, 2004 at 11:09:17PM +0100, Peter Eisentraut wrote: Jaime Casanova wrote: 188: it's an O merge with an E (sql_ascii = '')??? 189: the same but lower case(sql_ascii = '')??? 'OE' and 'oe', most likely, but someone more familiar with French typography might correct me.

Re: [PATCHES] default timezone in postgresql.conf

2004-12-17 Thread Bruce Momjian
Patch applied. Thanks. --- Robert Treat wrote: Changes the doc's to reflect what the user will find as default. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL [ Attachment,

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Jaime Casanova
--- Tom Lane [EMAIL PROTECTED] escribió: Jaime Casanova [EMAIL PROTECTED] writes: Why it not work on Latin9, Probably because it hasn't got a table for Latin9. Feel free to contribute one --- see src/backend/utils/adt/ascii.c. This page shows the differences between Latin1

Re: [PATCHES] From latin9 to sql_ascii??

2004-12-17 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: On Fri, Dec 17, 2004 at 11:09:17PM +0100, Peter Eisentraut wrote: 'OE' and 'oe', most likely, but someone more familiar with French typography might correct me. OE and oe would be correct, but we can't do that with the current code. More to the