[HACKERS] Compile file_fdw with Mingw Developer Studio

2011-11-02 Thread pasman pasmański
Hi. Is possible to use Mingw Developer Studio to compile parts of postgres (file_fdw) ? Anybody tried it ? pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] ecpg-related build failure with make 3.82

2011-10-30 Thread pasman pasmański
Hi. I tested that make 3.82 - win32 version hasn't any new functionalities for example .ONESHELL. -- pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Include commit identifier in version() function

2011-10-27 Thread pasman pasmański
Hi. I think, it be useful to include in version() function a hexadecimal identifier of commit, for fast checkout to it in git. -- pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

[HACKERS] Extend file_fdw wrapper

2011-10-10 Thread pasman pasmański
Attached patch. pasman 0001-Extend-file_fdw-wrapper.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Extend file_fdw wrapper

2011-10-10 Thread pasman pasmański
Hi. Current behaviour is error message when foreign table and foreign server have the same option defined. I don't know how to write regression test, may i read about it somewhere? -- pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

[HACKERS] Extend extension file_fdw

2011-10-06 Thread pasman pasmański
Hi. I plan to extend file_fdw wrapper. I will add options to foreign server: encoding, format, header, delimiter, dir. And i have some asks: - it's better to change name of extension or not - other suggestions -- pasman -- Sent via pgsql-hackers mailing list

Re: [HACKERS] spinlocks on HP-UX

2011-08-28 Thread pasman pasmański
Pity that this patch works only on hpux :(. But i have an idea: maybe when executor stop at locked row, it should process next row instead of wait. Of course if query not contain order by or windowing functions. -- pasman -- Sent via pgsql-hackers mailing list

Re: [HACKERS] compiling 9.2 : WinXp+mingw

2011-08-11 Thread pasman pasmański
Its problem on my computer. But prepacked souces compile good. Maybe git need specific configuration for postgres ? Or some buggy sed/gawk/grep skip pg_config.h file? 2011/8/11, pasman pasmański pasma...@gmail.com: Hi. Compiling 9.1 sources from packed tgz file works ok. When compile

Re: [HACKERS] Problem with sources.

2011-08-10 Thread pasman pasmański
Success ! I can't use git protocol, but github via http works fine. Thank you Andrew :) pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Problem with sources.

2011-08-09 Thread pasman pasmański
When i try to fetch sources via git, there is an error: error: Unable to find 676e3c735dec32ba0448fdd0faf9ace37c1fa792 under http://git.postgresql.org/git/postgresql.git Cannot obtain needed object 676e3c735dec32ba0448fdd0faf9ace37c1fa792 error: Fetch failed. How to get current branch ?

[HACKERS] Netbeans and postgres

2011-07-28 Thread pasman pasmański
Hi. I install netbeans 7. When i try to configure postgresql project, path is set up incorectly - gcc not found How to set the path ? -- pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] problem with compiling beta3 on mingw32+WinXP

2011-07-26 Thread pasman pasmański
After reinstalling mingw is ok. 2011/7/25, pasman pasmański pasma...@gmail.com: After googling i found that mingw's gcc works with 64 bit integers. But printf is incompatible :( . Possible workaround: include inttypes.h , define macros and convert printf strings: printf(% LL,(long long

Re: [HACKERS] problem with compiling beta3 on mingw32+WinXP

2011-07-25 Thread pasman pasmański
After googling i found that mingw's gcc works with 64 bit integers. But printf is incompatible :( . Possible workaround: include inttypes.h , define macros and convert printf strings: printf(% LL,(long long)100) 2011/7/25, pasman pasmański pasma...@gmail.com: Hi. When i try to compile

[HACKERS] Exclude core dumps from project - example patch

2011-07-19 Thread pasman pasmański
Hi. I am learn the git. For test my skills, here is patch to exclude core dumps from git tree. Author: pasman pasma...@gmail.com 2011-07-19 10:27:50 Committer: pasman pasma...@gmail.com 2011-07-19 10:27:50 Parent: 6307fff3586294214e3f256035b82bbba9a9054a (Fix typo) Branch: master Follows:

[HACKERS] Using mingw

2011-01-10 Thread pasman pasmański
Hi. I try to compile postgres with mingw32. When configure runs, it tells that found perl 5.6 which is too old. I install perl 5.10 from activestate but configure cant find it. How to set up path to newer perl? -- Sent from my mobile device pasman -- Sent via pgsql-hackers

Re: [HACKERS] managment of large patches

2011-01-02 Thread pasman pasmański
Hello. Maybe are any often bugs? they may be found by more asserts to track internal state of structures. Or tools like lastly developed script for c++ keywords. -- Sent from my mobile device pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] contrib/snapshot

2010-12-31 Thread pasman pasmański
Hi. Will be useful to add a column with timestamp of the revision and a comment can you do it? not today in order that your friends dont kill you .. -- Sent from my mobile device pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] function(contants) evaluated for every row

2010-11-25 Thread pasman pasmański
I've seen this as well be a performance issue, in particular with partitioned tables. Out of habit I now write functions that always cache the value of the function in a variable and use the variable in the actual query to avoid this particular gotcha. subquery may be used to cache constants: