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 migh

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 pr

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, >> >> Probabl

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

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 corr

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, s

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 differ

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 th