PgSql

Problems with variable cursorname in ecpg
Hi, Michael Meskes �rta: Hi, I did some more testing on ecpg and found that allowing variables as cursor names seems to produce more problems than I anticipated. But then maybe it's just some missing checks to throw out error messages. Anyway, I attach a small test program that, from my understandi... 1 Apr 2010 05:44

[HACKERS] Problems with variable cursorname in ecpg
Hi, I did some more testing on ecpg and found that allowing variables as cursor names seems to produce more problems than I anticipated. But then maybe it's just some missing checks to throw out error messages. Anyway, I attach a small test program that, from my understanding, should work, but dosn't. Could some... 29 Mar 2010 08:02

[HACKERS] Using HStore type in TSearch
Hi, I've asked this question in novice group and another Postgres forum, but didn't get any help. What I want to do is to use HStore data type (namely the HStore keys) in TSearch. I don't want use TSVector and the original ts_match_vq function, because I want to be able to control exact values that are passed ... 29 Mar 2010 08:02

[HACKERS] proposal - structured funcid and lineno as new fields in error message
Hello can we add well structured information about function id and lineno to ErrorData? Actually we sending some info - but formated as string and only when Log_error_verbosity >= PGERROR_VERBOSE. I hope, so this feature can help to some interactive GUI managers as pgAdmin, and to psql too. Regards Pa... 29 Mar 2010 05:50

[HACKERS] enable_joinremoval
We have planner method parameters for many important parts of the planner. We don't have any parameter for join removal, AFAIK. The first question I get asked is "can I see the tables it removed?". This has been asked of me 3 times now this year, always first question. Same issue applies to constraint exclusion... 29 Mar 2010 04:45

five-key syscaches
On Mon, Mar 29, 2010 at 12:32 AM, Robert Haas <robertmhaas(a)gmail.com> wrote: Per previous discussion, PFA a patch to change the maximum number of keys for a syscache from 4 to 5. http://archives.postgresql.org/pgsql-hackers/2010-02/msg01105.php This is intended for application to 9.1, and is supportin... 29 Mar 2010 10:14

[HACKERS] Patch for 9.1: initdb -C option
Hackers, Enclosed is a patch to add a -C option to initdb to allow you to easily append configuration directives to the generated postgresql.conf file for use in programmatic generation. In my case, I'd been creating multiple db clusters with a script and would have specific overrides that I needed to make. This ... 29 Mar 2010 01:31

[HACKERS] GSoC Query
Sir/Ma'am, I am a Mtech student and want to participate in GSoC. I have a project idea and want to discuss its feasibility, usability and chance of selection with you. My idea is to add a functionality of Auto tuning and Auto Indexing/ Reindexing in DB languages. Though I am not working on this I have s... 28 Mar 2010 23:21

Alpha release this week?
On Sun, Mar 28, 2010 at 4:40 PM, Josh Berkus <josh(a)agliodbs.com> wrote: We've got two locations and some individuals signed up for a test-fest this weekend.  Would it be possible to do an alpha release this week? It would really help to be testing later code than Alpha4. I'm willing to do the CVS bits, if t... 5 Apr 2010 17:15

[HACKERS] five-key syscaches
Per previous discussion, PFA a patch to change the maximum number of keys for a syscache from 4 to 5. http://archives.postgresql.org/pgsql-hackers/2010-02/msg01105.php This is intended for application to 9.1, and is supporting infrastructure for knngist. ....Robert ... 28 Mar 2010 18:59