[HACKERS] Compile file_fdw with Mingw Developer Studio
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
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
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: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Extend file_fdw wrapper
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
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 to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Extend extension file_fdw
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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] spinlocks on HP-UX
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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] compiling 9.2 : WinXp+mingw
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 sources loaded from git repository, configure pass without errors, config.log looks ok, but in src/include/pg_config.h aren't any defines, only undefines. It seems like src/include/pg_config.h.in. And make generates errors. What going on ? pasman -- 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] Problem with sources.
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.
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 ? 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] Netbeans and postgres
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: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] problem with compiling beta3 on mingw32+WinXP
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)100) 2011/7/25, pasman pasmański pasma...@gmail.com: Hi. When i try to compile postgresql-beta3 on mingw32 ./configure pass ok, but there is error when i do make: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -I../../src/port -DFRONTEND -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND -I../ ../src/include/port/win32 -c -o crypt.o crypt.c In file included from crypt.c:44:0: ../../src/include/c.h:284:2: error: #error must have a working 64-bit integer da tatype In file included from ../../src/include/c.h:851:0, from crypt.c:44: ../../src/include/port.h:390:0: warning: fseeko redefined ../../src/include/pg_config_os.h:228:0: note: this is the location of the previo us definition ../../src/include/port.h:391:0: warning: ftello redefined ../../src/include/pg_config_os.h:229:0: note: this is the location of the previo us definition make[2]: *** [crypt.o] Error 1 make[2]: Leaving directory `/home/rosinkr1/postgresql-9.1beta3/src/port' make[1]: *** [all-port-recurse] Error 2 make[1]: Leaving directory `/home/rosinkr1/postgresql-9.1beta3/src' make: *** [all-src-recurse] Error 2 Make version 3.81. Status file included. What is wrong ? pasman -- pasman -- 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] problem with compiling beta3 on mingw32+WinXP
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 postgresql-beta3 on mingw32 ./configure pass ok, but there is error when i do make: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -I../../src/port -DFRONTEND -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND -I../ ../src/include/port/win32 -c -o crypt.o crypt.c In file included from crypt.c:44:0: ../../src/include/c.h:284:2: error: #error must have a working 64-bit integer da tatype In file included from ../../src/include/c.h:851:0, from crypt.c:44: ../../src/include/port.h:390:0: warning: fseeko redefined ../../src/include/pg_config_os.h:228:0: note: this is the location of the previo us definition ../../src/include/port.h:391:0: warning: ftello redefined ../../src/include/pg_config_os.h:229:0: note: this is the location of the previo us definition make[2]: *** [crypt.o] Error 1 make[2]: Leaving directory `/home/rosinkr1/postgresql-9.1beta3/src/port' make[1]: *** [all-port-recurse] Error 2 make[1]: Leaving directory `/home/rosinkr1/postgresql-9.1beta3/src' make: *** [all-src-recurse] Error 2 Make version 3.81. Status file included. What is wrong ? pasman -- 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] Exclude core dumps from project - example patch
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: REL9_1_BETA2 Precedes: Include core dumps in .gitignore -- .gitignore -- index 1e15ce5..64e3dee 100644 @@ -21,6 +21,8 @@ lcov.info win32ver.rc *.exe lib*dll.def +#Exclude core dumps on Mingw32 +*.stackdump # Local excludes in root directory /GNUmakefile -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Using mingw
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 mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] managment of large patches
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 changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] contrib/snapshot
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 subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] function(contants) evaluated for every row
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: SELECT a_date FROM test WHERE a_date=(SELECT current_date); Seq Scan on test1 (cost=0.01..10.76 rows=5 width=4) Filter: (a_date = $0) InitPlan 1 (returns $0) - Result (cost=0.00..0.01 rows=1 width=0) pasman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers