[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
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 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
[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 : > 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 : > 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)1000000) > > 2011/7/25, pasman pasmański : >> 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 : > 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 2011-07-19 10:27:50 Committer: pasman 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