Re: [HACKERS] WIP: preloading of ispell dictionary

Takahiro Itagaki wrote: > Pavel Stehule 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

Re: [HACKERS] Ragged latency log data in multi-threaded pgbench

Greg Smith wrote: > By the way: the pgbench.sgml that you committed looks like it passed > through a system that added a CR to every line in it. Probably not the > way you intended to commit that. Oops, fixed. Thanks. Regards, --- Takahiro Itagaki NTT Open Source Software Center -- Sent

Re: [HACKERS] Ragged latency log data in multi-threaded pgbench

Takahiro Itagaki wrote: Greg Smith wrote: Attached is an updated version that I think is ready to commit. Only changes are docs--I rewrote those to improve the wording some. Thanks for the correction. Applied. By the way: the pgbench.sgml that you committed looks like it passed

Re: [HACKERS] 9.0 release notes done

Bruce Momjian wrote: > I have completed the 9.0 release notes: > http://developer.postgresql.org/pgdocs/postgres/release-9-0.html There is an additional incompatibilitiy in pg_largeobject catalog. We need to rewrite queries to test existences of large objests from SELECT DISTINCT(loid) FR

Re: [HACKERS] Streaming replication status

Fujii Masao wrote: > On Tue, Mar 23, 2010 at 7:56 AM, Bruce Momjian wrote: > > Sorry, release notes updated: > > > > ? ? ? ? ? ? ?Add > ? ? ? ? ? ? > > ?linkend="functions-recovery-info-table">pg_last_xlog_receive_location() > > ? ? ? ? ? ? ?and pg_last_xlog_replay_location(), which > > ? ? ? ?

Re: [HACKERS] [BUG] SECURITY DEFINER on call handler makes daemon crash

(2010/03/20 13:37), Tom Lane wrote: > KaiGai Kohei writes: >> Is it an expected behavior that PostgreSQL tries to execute foo() with >> privileges of the owner of language call handler because of its security >> definer property? This server crash is just a result. > > A language call handler has

Re: [HACKERS] Ragged latency log data in multi-threaded pgbench

Greg Smith wrote: > Attached is an updated version that I think is ready to commit. Only > changes are docs--I rewrote those to improve the wording some. Thanks for the correction. Applied. Regards, --- Takahiro Itagaki NTT Open Source Software Center -- Sent via pgsql-hackers mailing li

Re: [HACKERS] Streaming replication status

On Tue, Mar 23, 2010 at 7:56 AM, Bruce Momjian wrote: > Sorry, release notes updated: > >              Add               > linkend="functions-recovery-info-table">pg_last_xlog_receive_location() >              and pg_last_xlog_replay_location(), which >              can be used to monitor standby

Re: [HACKERS] Standalone backends run StartupXLOG in an incorrect environment

Tom Lane wrote: > Bruce Momjian writes: > >> [This is an open item for 9.0, hence the response to an apparently old > >> hackers thread] > > > Thanks for the reply; 9.0 open item removed. > > I think you misread his reply. Please put that back. OK, I re-read it and still don't understand, bu

Re: [HACKERS] Standalone backends run StartupXLOG in an incorrect environment

Bruce Momjian writes: >> [This is an open item for 9.0, hence the response to an apparently old >> hackers thread] > Thanks for the reply; 9.0 open item removed. I think you misread his reply. Please put that back. regards, tom lane -- Sent via pgsql-hackers mailing

Re: [HACKERS] Standalone backends run StartupXLOG in an incorrect environment

Simon Riggs wrote: > On Sat, 2009-09-19 at 13:21 -0400, Tom Lane wrote: > > I realized the truth of $SUBJECT while reading this report: > > http://archives.postgresql.org/pgsql-general/2009-09/msg00712.php > > ... > > > Also, does this have any impact on the Hot Standby stuff? > > It could poten

Re: [HACKERS] WIP: preloading of ispell dictionary

Pavel Stehule 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 platforms if

Re: [HACKERS] Re: [COMMITTERS] pgsql: Prevent the injection of invalidly encoded strings by PL/Python

On mån, 2010-03-22 at 19:29 -0400, Tom Lane wrote: > Peter Eisentraut 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

Re: [HACKERS] 9.0 release notes done

> Uh, I did adjust the subcategories based on what we completed for 9.0. > You will find many added/removed ones compared to 8.4 > >> warranted. Also, within each subcategory, items should be arranged in >> descending order according to how much impact we expect them to have on >> users. > > I

Re: xmlconcat (was [HACKERS] 9.0 release notes done)

Peter Eisentraut wrote: On sön, 2010-03-21 at 13:07 -0400, Andrew Dunstan wrote: Yeah, maybe. According to the only legal child of an XML Document node that is not also a legal child of a DocumentFragment node is a DocumentType no

Re: [HACKERS] Re: [COMMITTERS] pgsql: Prevent the injection of invalidly encoded strings by PL/Python

Peter Eisentraut 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 is

Re: [HACKERS] 9.0 release notes done

Josh Berkus wrote: > Bruce, > > BTW, I didn't say it before, but thanks for getting this draft out > *now*. It's a lot more time than we've had in the past. Sure. For some reason it was easier/faster this time; possible causes: o I am getting better because I have done it before

[HACKERS] Re: [COMMITTERS] pgsql: Prevent the injection of invalidly encoded strings 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

Re: [HACKERS] 9.0 release notes done

Josh Berkus wrote: > > > Uh, are you saying you want to remove the exiting release note > > subcategories and put everything into 7-8 long lists? That hardly seems > > like an improvement, or are you talking about make a user-focused list > > that is shorter with 7-8 categories? > > I'm talking

Re: [HACKERS] 9.0 release notes done

Bruce, BTW, I didn't say it before, but thanks for getting this draft out *now*. It's a lot more time than we've had in the past. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pge

Re: [HACKERS] 9.0 release notes done

> Uh, are you saying you want to remove the exiting release note > subcategories and put everything into 7-8 long lists? That hardly seems > like an improvement, or are you talking about make a user-focused list > that is shorter with 7-8 categories? I'm talking about adjusting which subcategori

Re: [HACKERS] 9.0 release notes done

Josh Berkus wrote: > On 3/22/10 7:46 AM, Bruce Momjian wrote: > > I do not require them to submit SGML; just some format where I can > > identify the lines that changed. I can do the same for the release > > notes. I have to check the diffs anyway so manually merging in the > > changes isn't a p

Re: [HACKERS] 9.0 release notes done

Joachim Wieland wrote: > On Sat, Mar 20, 2010 at 5:02 AM, Bruce Momjian wrote: > > Interestingly the 9.0 release notes contain 201 items, while the 8.4 > > release notes contained 314 items. > > Is the following pg_dump change covered by the release notes? I > couldn't find it. It was the last co

Re: [HACKERS] Streaming replication status

Simon Riggs wrote: > On Thu, 2010-01-14 at 17:33 +0900, Fujii Masao wrote: > > > I added two new functions; > > > > (1) pg_last_xlog_receive_location() reports the last WAL location received > > and synced by walreceiver. If streaming replication is still in progress > > this will increas

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

On mån, 2010-03-22 at 09:54 -0400, Robert Haas wrote: > We have had one previous request for the ability to limit the list of > queries that the user can issue to a fixed set, but it's not clear to > me that that's really all that useful. Well, sudo is pretty useful, and this would be quite simila

Re: [HACKERS] 9.0 release notes done

On Sat, Mar 20, 2010 at 5:02 AM, Bruce Momjian wrote: > Interestingly the 9.0 release notes contain 201 items, while the 8.4 > release notes contained 314 items. Is the following pg_dump change covered by the release notes? I couldn't find it. It was the last committed patch from the 2010-01 comm

Re: [HACKERS] 9.0 release notes done

On Mon, Mar 22, 2010 at 23:18, Josh Berkus wrote: > >> Uh why?  Open the file with a text editor, cut and paste the lines >> elsewhere. > > ... because even one edit by anyone else is a merge conflict.  And CVS > isn't too good with merge conflicts.  Also few of the people whom I'd > want to ask f

Re: [HACKERS] 9.0 release notes done

> Uh why? Open the file with a text editor, cut and paste the lines > elsewhere. ... because even one edit by anyone else is a merge conflict. And CVS isn't too good with merge conflicts. Also few of the people whom I'd want to ask for help are committers -- the release notes are as much about

Re: [HACKERS] An idle thought

On Mon, 2010-03-22 at 16:48 -0400, Bruce Momjian wrote: > I don't think we want to move to 64-bit xids becasue we would still need > to do vacuum freeze to trim the clog. In fact we do vacuum freeze much > more frequently than required for 32-bit xids for this very reason. Good point. I think the

Re: [HACKERS] proposal: more practical view on function's source code

On Mar 22, 2010, at 2:23 PM, Peter Eisentraut wrote: > On sön, 2010-03-21 at 20:40 -0400, Robert Haas wrote: >>> \ef function-name line-number >>> with suitable magic to get the editor to place the cursor at that line. >>> I suspect this wouldn't be too hard to do with emacs --- what do you

Re: [HACKERS] 9.0 release notes done

On Mon, Mar 22, 2010 at 02:18:04PM -0700, Josh Berkus wrote: > On 3/22/10 7:46 AM, Bruce Momjian wrote: > > I do not require them to submit SGML; just some format where I > > can identify the lines that changed. I can do the same for the > > release notes. I have to check the diffs anyway so man

Re: [HACKERS] 9.0 release notes done

On mån, 2010-03-22 at 14:18 -0700, Josh Berkus wrote: > So there are 2 large problems I have with the SGML version, let's see if > we can deal with them separately: > > (1) re-arranging and regrouping the items: the stuff in the release > notes should end up in 7-8 clear categories, with items arr

Re: xmlconcat (was [HACKERS] 9.0 release notes done)

On sön, 2010-03-21 at 13:07 -0400, Andrew Dunstan wrote: > Yeah, maybe. According to > the only > legal child of an XML Document node that is not also a legal child of a > DocumentFragment node is a DocumentType node. So we could probabl

Re: [HACKERS] proposal: more practical view on function's source code

On sön, 2010-03-21 at 20:40 -0400, Robert Haas wrote: > >\ef function-name line-number > > with suitable magic to get the editor to place the cursor at that line. > > I suspect this wouldn't be too hard to do with emacs --- what do you > > think about vi? > > Well, in vi you can just do "v

Re: [HACKERS] 9.0 release notes done

On 3/22/10 7:46 AM, Bruce Momjian wrote: > I do not require them to submit SGML; just some format where I can > identify the lines that changed. I can do the same for the release > notes. I have to check the diffs anyway so manually merging in the > changes isn't a problem. So there are 2 large

Re: [HACKERS] An idle thought

Jeff Davis wrote: > On Tue, 2010-03-16 at 15:29 +, Greg Stark wrote: > > I'm picturing storing a bit in the visibility map indicating that *no* > > records are visible in a given page. > > I've been thinking for a while that we could store the visibility > information in a structure separate f

Re: [HACKERS] [postgis-users] ERROR: array size exceeds themaximumallowed(134217727)

On Mon, Mar 22, 2010 at 4:45 PM, Paul Ramsey wrote: > Did you already try replacing your postgis functions with array_agg > calls to see if we can push the problem back over the fence to pgsql > land? On Sat, Mar 20, 2010 at 9:17 AM, Mike Leahy wrote: > Running this query on various data will pr

Re: [HACKERS] [GENERAL] trouble with to_char('L')

Takahiro Itagaki wrote: > > Bruce Momjian wrote: > > > Takahiro Itagaki wrote: > > > Since 9.0 has GetPlatformEncoding() for the purpose, we could simplify > > > db_encoding_strdup() with the function. Like this: > > > > OK, I don't have any Win32 people testing this patch so if we want this >

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

Simon Riggs wrote: > I think you've missed my point. > What I was talking about was that box '((0,0),(1,1))' && box > '((1,1),(2,2))' returns true, even though they touch at only a > single point, and share zero area. FWIW, that's what I would take away from "one point in common" -Kevin -

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, 2010-03-22 at 10:55 -0700, David Fetter wrote: > On Mon, Mar 22, 2010 at 01:46:51PM -0400, Tom Lane wrote: > > David Fetter writes: > > > I'm seeing a lot of places where this might be documented. Any ideas > > > as to which ones are appropriate? > > > > I would think "Geometric Function

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, Mar 22, 2010 at 1:15 PM, Simon Riggs wrote: > > * Circles, Boxes and other geometric datatypes defined "overlaps" to > include touching shapes. So > > * inet datatypes don't have a commutative operator on which a unique > index can be built. There is no "overlaps" equivalent, which again i

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, Mar 22, 2010 at 04:04:16PM -0300, Alvaro Herrera wrote: > David Fetter wrote: > > > diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml > > index 9881ff4..9313112 100644 > > --- a/doc/src/sgml/func.sgml > > +++ b/doc/src/sgml/func.sgml > > @@ -7134,7 +7134,7 @@ CREATE TYPE rainbow

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

David Fetter wrote: > diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml > index 9881ff4..9313112 100644 > --- a/doc/src/sgml/func.sgml > +++ b/doc/src/sgml/func.sgml > @@ -7134,7 +7134,7 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', > 'green', 'blue', 'purple > >

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, Mar 22, 2010 at 01:46:51PM -0400, Tom Lane wrote: > David Fetter writes: > > I'm seeing a lot of places where this might be documented. Any ideas > > as to which ones are appropriate? > > I would think "Geometric Functions and Operators" would be the most > appropriate spot ... Please f

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

David Fetter writes: > I'm seeing a lot of places where this might be documented. Any ideas > as to which ones are appropriate? I would think "Geometric Functions and Operators" would be the most appropriate spot ... regards, tom lane -- Sent via pgsql-hackers mailing

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, Mar 22, 2010 at 04:47:37PM +, Simon Riggs wrote: > On Mon, 2010-03-22 at 09:00 -0700, David Fetter wrote: > > > > Yes, for most people touching != overlap. So it just looks like a > > > bug. > > > > I don't know which people you've surveyed, but at least in my math > > classes, one po

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, 2010-03-22 at 09:00 -0700, David Fetter wrote: > > Yes, for most people touching != overlap. So it just looks like a > > bug. > > I don't know which people you've surveyed, but at least in my math > classes, one point in common was sufficient for an overlap. I'd be > happy to write up so

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

Simon Riggs wrote: Basically, what you feel is missing is documentation that if two shapes share one or more points they are considered to overlap; there is no requirement that they share an area? Yes, for most people touching != overlap. So it just looks like a bug. I guess I mu

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

Simon Riggs wrote: > Yes, for most people touching != overlap. So it just looks like a > bug. A quick search of the web turned up a definition of overlap in geometry as meaning that two polygons share at least one *internal* point, which would be consistent with your interpretation; but there

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, Mar 22, 2010 at 03:42:39PM +, Simon Riggs wrote: > On Mon, 2010-03-22 at 10:32 -0500, Kevin Grittner wrote: > > Simon Riggs wrote: > > > On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote: > > >> Simon Riggs writes: > > > > >> > * Circles, Boxes and other geometric datatypes defined

Re: [HACKERS] Command to prune archive at restartpoints

On Thu, Mar 18, 2010 at 9:43 AM, Simon Riggs wrote: > On Wed, 2010-03-17 at 11:37 +0200, Heikki Linnakangas wrote: > >> One awkward omission in the new built-in standby mode, mainly used for >> streaming replication, is that there is no easy way to delete old >> archived files like you do with the

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

Robert Haas wrote: > Does the SQL standard specify anything in this area? The only thing that comes to mind for me is the SQL/PSM . -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-ha

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, 2010-03-22 at 10:32 -0500, Kevin Grittner wrote: > Simon Riggs wrote: > > On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote: > >> Simon Riggs writes: > > >> > * Circles, Boxes and other geometric datatypes defined > >> > "overlaps" to include touching shapes. So > >> > SELECT circle '((

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

2010/3/22 Robert Haas : > On Mon, Mar 22, 2010 at 9:39 AM, Stephen Frost wrote: >> * Joseph Adams (joeyadams3.14...@gmail.com) wrote: >>> I propose adding application-level access control to PostgreSQL via a >>> jails concept.  In a nutshell, a jail is created as part of the >>> database definitio

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

Simon Riggs wrote: > On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote: >> Simon Riggs writes: >> > * Circles, Boxes and other geometric datatypes defined >> > "overlaps" to include touching shapes. So >> > SELECT circle '((0,0), 1)' && circle '((2,0),1)'; >> > is true, which is fairly strange

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, 2010-03-22 at 16:40 +0200, Peter Eisentraut wrote: > On mån, 2010-03-22 at 13:15 +, Simon Riggs wrote: > > * inet datatypes don't have a commutative operator on which a unique > > index can be built. There is no "overlaps" equivalent, which again is a > > shame because that stops them b

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

On Mon, Mar 22, 2010 at 10:03 AM, Stephen Frost wrote: > * Robert Haas (robertmh...@gmail.com) wrote: >> Sometimes it would be nice to conditionalize queries on a value other >> than the authenticated role.  I really wish we had some kind of SQL >> variable support.  Talking out of my rear end: >

Re: [HACKERS] 9.0 release notes done

Josh Berkus wrote: > > >> In hindsight I could have loaded the ASCII release notes into a wiki and > >> people could have modified, them, and later I could have converted them > >> to SGML, > > That was, in fact, *exactly* what you said you'd do 3 months ago when we > discussed this. I now remem

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On mån, 2010-03-22 at 13:15 +, Simon Riggs wrote: > * inet datatypes don't have a commutative operator on which a unique > index can be built. There is no "overlaps" equivalent, which again is a > shame because that stops them being used with the new feature. http://pgfoundry.org/projects/ip4r

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

Simon Riggs writes: > On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote: >>> Also, if the only common sense usage of exclusion constraints is GIST, >>> why does the syntax default to "btree"? >> >> Since your "if" isn't a correct statement, the complaint doesn't follow. > Docs say > "The access

Re: [HACKERS] proposal: more practical view on function's source code

2010/3/22 Dimitri Fontaine : > Dimitri Fontaine writes: >> Sure, I should go and write a complete pgsql emacs mode >> with a linum-mode like feature counting lines the way PG does it, … > > Ok maybe just using the current SQL mode and linum mode is enough if we > teach this latter one to count Pos

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote: > Simon Riggs 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 objection her

Re: [HACKERS] ALTER TABLE .... make constraint DEFERRABLE

Simon Riggs 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@postgresql.org) To make changes

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

Simon Riggs 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 objection here. > * Circles, Boxes and other geometric datatypes defined "o

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

* Robert Haas (robertmh...@gmail.com) wrote: > Sometimes it would be nice to conditionalize queries on a value other > than the authenticated role. I really wish we had some kind of SQL > variable support. Talking out of my rear end: I certainly agree- having variable support in the backend woul

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

On Mon, Mar 22, 2010 at 9:15 AM, Simon Riggs 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 most de

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

On Mon, Mar 22, 2010 at 9:39 AM, Stephen Frost wrote: > * Joseph Adams (joeyadams3.14...@gmail.com) wrote: >> I propose adding application-level access control to PostgreSQL via a >> jails concept.  In a nutshell, a jail is created as part of the >> database definition (typically exposing a free v

[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 A

[HACKERS] Comments on Exclusion Constraints and related datatypes

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 most defined reports/screens. It would be much better to use just "_e

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

* Joseph Adams (joeyadams3.14...@gmail.com) wrote: > I propose adding application-level access control to PostgreSQL via a > jails concept. In a nutshell, a jail is created as part of the > database definition (typically exposing a free variable for the > current user). When a jail is activated f

Re: [HACKERS] Updated Turkish stopwords list for Tsearch2

On Mon, 2010-03-22 at 08:55 -0400, Tom Lane wrote: > It would be a good idea to submit this upstream at the snowball > project, else it might get lost in future updates. Ok, will do. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yu

Re: [HACKERS] Updated Turkish stopwords list for Tsearch2

Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= 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

Re: [HACKERS] proposal: more practical view on function's source code

Dimitri Fontaine writes: > Sure, I should go and write a complete pgsql emacs mode > with a linum-mode like feature counting lines the way PG does it, … Ok maybe just using the current SQL mode and linum mode is enough if we teach this latter one to count PostgreSQL function lines the same way as

[HACKERS] Updated Turkish stopwords list for Tsearch2

Hi, Attached is updated Turkish stopword list for Tsearch2, against 8.4 and HEAD. Please apply. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr ht

Re: [HACKERS] how to link an external lib on Windows

2010/3/22 chaoyong wang > > 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 >1). src/too

Re: [HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)

Joseph Adams wrote: > Hello, I'm Joey Adams, and I'm interested in applying for Google > Summer of Code to work on PostgreSQL. I'm a former GSoC student (I > worked on CCAN last year), and a strong C programmer, though I am > still new to working with large, established communities. I apologize >

Re: [HACKERS] C libpq frontend library fetchsize

Robert Haas wrote: This seems pretty reasonable to me, especially considering that JDBC is apparently already doing it. I suppose there will always be projects that want to reimplement the backend protocol so that they can be "pure" some-language, but chipping away at the list of other reasons w

[HACKERS] how to link an external lib on Windows

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 1). src/tools/msvc/config.pl