PgSql

WIP: preloading of ispell dictionary
Pavel Stehule <pavel.stehule(a)gmail.com> wrote: I wrote some small patch, that allow preloading of selected ispell dictionary. It solve the problem with slow tsearch initialisation with some language configuration. I afraid so this module doesn't help on MS Windows. I think it should work on all ... 24 Mar 2010 11:11

pgsql: Prevent the injection ofinvalidly encoded strings by PL/Python
On mån, 2010-03-22 at 19:29 -0400, Tom Lane wrote: Peter Eisentraut <peter_e(a)gmx.net> writes: I have never used Tcl before just now, and the documentation is sketchy, but it looks like the behavior of Tcl is kind of mixed in this area. Escapes such as "\xd0" are apparently converted to Unicode cod... 22 Mar 2010 20:40

pgsql: Prevent the injection of invalidly encoded strings by PL/Python
Peter Eisentraut <peter_e(a)gmx.net> writes: I have never used Tcl before just now, and the documentation is sketchy, but it looks like the behavior of Tcl is kind of mixed in this area. Escapes such as "\xd0" are apparently converted to Unicode code points rather than bytes when the appropriate OS locale i... 22 Mar 2010 20:40

pgsql: Prevent the injection of invalidly encodedstrings by PL/Python
On fre, 2010-03-19 at 11:50 -0400, Andrew Dunstan wrote: Peter Eisentraut wrote: Log Message: ----------- Prevent the injection of invalidly encoded strings by PL/Python into PostgreSQL with a few strategically placed pg_verifymbstr calls. Awesome. Do we need to fix pltcl too? Short answe... 22 Mar 2010 19:14

Comments on Exclusion Constraints and relateddatatypes
On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote: Simon Riggs <simon(a)2ndQuadrant.com> writes: * Exclusion indexes are created with the suffix "_exclusion". That's a very long suffix and will overflow most defined reports/screens. It would be much better to use just "_excl", No particular objec... 22 Mar 2010 16:50

ALTER TABLE .... make constraint DEFERRABLE
Simon Riggs <simon(a)2ndQuadrant.com> writes: Am I missing something? That we're long past feature freeze? Some of these might be reasonable TODO items. None of them are happening for 9.0. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your ... 22 Mar 2010 10:31

Comments on Exclusion Constraints and related datatypes
On Mon, Mar 22, 2010 at 9:15 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: Exclusion constraints are good. There's a few annoyances around them, that are minor but feel should be addressed for 9.0. * Exclusion indexes are created with the suffix "_exclusion". That's a very long suffix and will overflow ... 22 Mar 2010 16:50

[HACKERS] ALTER TABLE .... make constraint DEFERRABLE
Deferrable unique constraints seem an interesting feature, though I have either some questions or some issues, not sure which. I don't seem to be able to find any way to do an ALTER TABLE that adds this new capability to an existing table. There is no way to add a constraint via a CREATE TABLE AS SELECT, so ... 22 Mar 2010 10:31

Updated Turkish stopwords list for Tsearch2
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim(a)gunduz.org> writes: Attached is updated Turkish stopword list for Tsearch2, against 8.4 and HEAD. It would be a good idea to submit this upstream at the snowball project, else it might get lost in future updates. regards, tom lane -- Sent via pgsql-hacker... 22 Mar 2010 09:23

how to link an external lib on Windows
2010/3/22 chaoyong wang <catcher_wang(a)hotmail.com> Hi, I build PG on VS2005, which files should I change to use a external lib in my own contrib, for example, Berkeley DB 4.8.26? Until now, I have tried the following 2 ways, but both failed. 1. Add the target include and lib ... 22 Mar 2010 06:04