Re: [HACKERS] proposal: schema variables

2017-11-13 Thread Pavel Golub
Hello, Pavel. You wrote: PS> Hi, PS> I propose a  new database object - a variable. The variable is PS> persistent object, that holds unshared session based not PS> transactional in memory value of any type. Like variables in any PS> other languages. The persistence is required for possibility

Re: [HACKERS] GUC for cleanup indexes threshold.

2017-10-10 Thread Pavel Golub
Hello, Darafei. You wrote: DP> The following review has been posted through the commitfest application: DP> make installcheck-world: tested, passed DP> Implements feature: tested, passed DP> Spec compliant: tested, passed DP> Documentation:tested, passed DP> We're

Re: [HACKERS] AlterUserStmt anmd RoleSpec rules in grammar.y

2017-08-01 Thread Pavel Golub
Hello, Robert. Sorry, if I was rough. My English is not so excellent. My point is that I was trying to distinguish behavior of EDB installer and "build from source" PG. And the result is that EDB executes ALTER USER and I don't know why. You wrote: RH> On Thu, Jul 27, 2017 at 2

Re: [HACKERS] AlterUserStmt anmd RoleSpec rules in grammar.y

2017-07-27 Thread Pavel Golub
Hello, Tom. You wrote: TL> Pavel Golub <pa...@microolap.com> writes: >> I need someone to throw some light on grammar (gram.y). >> I'm investigating beta2 regression tests, and found new statement >> `ALTER USER ALL SET application_name to 'SLAP';` >>

Re: [HACKERS] AlterUserStmt anmd RoleSpec rules in grammar.y

2017-07-27 Thread Pavel Golub
Hello, Tom. You wrote: TL> Pavel Golub <pa...@microolap.com> writes: >> I need someone to throw some light on grammar (gram.y). >> I'm investigating beta2 regression tests, and found new statement >> `ALTER USER ALL SET application_name to 'SLAP';` >>

[HACKERS] AlterUserStmt anmd RoleSpec rules in grammar.y

2017-07-26 Thread Pavel Golub
Hello, hackers. I need someone to throw some light on grammar (gram.y). I'm investigating beta2 regression tests, and found new statement `ALTER USER ALL SET application_name to 'SLAP';` ^^^ I know for sure that in beta1 this operator fails. So I decided to recheck gram.y:

Re: [HACKERS] Refactor pg_dump as a library?

2016-05-20 Thread Pavel Golub
Hello, Jakob. You wrote: JE> Would anybody else be interested in a pg_dump library? I've found JE> a thread from 2013 related to the idea, but the discussion came to nothing. JE> Thread started here: JE>

Re: [HACKERS] Database schema diff

2015-10-15 Thread Pavel Golub
Hello, Michal. Take a look in MicroOLAP Database Designer for PostgreSQL. You may use it in such way: 1. Reverse Engineering for existent database 2. Apply some changes 3. Modify database - you will get SQL script with all changes http://microolap.com/products/database/postgresql-designer/ You

Re: [HACKERS] Remaining 'needs review' patchs in July commitfest

2015-07-29 Thread Pavel Golub
Hello, Heikki. You wrote: HL 21 patches remain in Needs Review state, in the July commitfest. Some of HL them have a reviewer signed up. I have highlighted some of them below HL that worry me the most. What are we going to do about these? For each of HL them, I'd like the authors to have some

Re: [HACKERS] raw output from copy

2015-07-01 Thread Pavel Golub
Hello Pavel. I looked through the patch. Sources are OK. However I didn't find any docs and test cases. Would you please provide me with short description on this feature and why it is important. Because I didn't manage to find the old Andrew Dunstan's post either. On Sat, Apr 11, 2015 at 12:26

Re: [HACKERS] 9.5: UPDATE/DELETE .. ORDER BY .. LIMIT ..

2014-02-26 Thread Pavel Golub
Hello, Robert. You wrote: RH On Sat, Feb 22, 2014 at 7:02 PM, Rukh Meski rukh.me...@yahoo.ca wrote: Sorry, I wanted to minimize the attention my message attracts. I mostly posted it to let people know I plan on working on this for 9.5 to avoid duplicated effort. I will post more

[HACKERS] getenv used in libpq caused missing values under Windows

2014-01-10 Thread Pavel Golub
Hello, Pgsql-hackers. As you probably know dealing with Windows MSVCRT is some kind of hell. That's why we have src/port/win32env.c particulalry, because there may be several CRT's loaded at the same time. libpq unfortunately is using standard getenv function call to fill connection parameters

Re: [HACKERS] Proposal: variant of regclass

2013-12-05 Thread Pavel Golub
Hello, Andres. You wrote: AF On 2013-12-04 20:25:53 -0500, Tom Lane wrote: Tatsuo Ishii is...@sraoss.co.jp writes: I would like to add a variant of regclass, which is exactly same as current regclass except it does not raise an error when the target table is not found. Instead it returns

Re: [HACKERS] Proposal: variant of regclass

2013-12-04 Thread Pavel Golub
Hello, Tom. You wrote: TL Tatsuo Ishii is...@sraoss.co.jp writes: I would like to add a variant of regclass, which is exactly same as current regclass except it does not raise an error when the target table is not found. Instead it returns InvalidOid (0). TL I've sometimes thought we should

Re: [HACKERS] commit fest 2013-11 week 1 report

2013-11-22 Thread Pavel Golub
Hello, Peter. Is is possible to add small patch to the current commit fest? You wrote: PE We started with PE Fri Nov 15 PE Status Summary. Needs Review: 79, Waiting on Author: 7, Ready for PE Committer: 5, Committed: 7, Returned with Feedback: 3, Rejected: 1. Total: 102. PE We are now at

Re: [HACKERS] LISTEN / NOTIFY enhancement request for Postgresql

2013-11-19 Thread Pavel Golub
that we don't break existing code. I suppose it should be GUC variable (not only global entry) for per session settings. SZ On 11/15/2013 8:19 AM, Pavel Golub wrote: Hello, Dimitri. You wrote: DF Bruce Momjian br...@momjian.us writes: • is used to separate names in a path • * is used

Re: [HACKERS] LISTEN / NOTIFY enhancement request for Postgresql

2013-11-15 Thread Pavel Golub
Hello, Dimitri. You wrote: DF Bruce Momjian br...@momjian.us writes: • is used to separate names in a path • * is used to match any name in a path • is used to recursively match any destination starting from this name For example using the example above, these subscriptions are

[HACKERS] exit_horribly vs exit_nicely in pg_dump

2013-11-05 Thread Pavel Golub
Hello. Examining pg_dump sources recently I've found that different exit procedure used for the same situations. A quick example from pg_dump.c: if (dataOnly schemaOnly) exit_horribly(NULL, options -s/--schema-only and -a/--data-only cannot be used together\n);

[HACKERS] Error message for CREATE VIEW is confusing

2013-07-31 Thread Pavel Golub
Hello, PostgreSQL. Let's assume we have created MATERIALIZED VIEW, e.g. CREATE MATERIALIZED VIEW customer_v AS SELECT ; Then one wants to redefine this view as a regular view, e.g. CREATE OR REPLACE VIEW customer_v AS ; Error is rising: ERROR: customer_v is not a view **

Re: [HACKERS] Slicing TOAST

2013-05-15 Thread Pavel Golub
Hello, Heikki. You wrote: HL On 14.05.2013 21:36, Josh Berkus wrote: I'm proposing this now as a possible GSoC project; I don't propose to actively work on it myself. The deadline for submitting GSOC projects (by students) was a week ago. So is this a project suggestion for next year

Re: [HACKERS] [GSOC] questions about idea rewrite pg_dump as library

2013-04-11 Thread Pavel Golub
Hello, Tom. You wrote: TL Pavel Golub pa...@microolap.com writes: From my point of view the new library should export only two functions: 1. The execution function: ExecStatusType PGdumpdbParams(const char * const *keywords, const char * const *values); TL

Re: [HACKERS] [GSOC] questions about idea rewrite pg_dump as library

2013-04-10 Thread Pavel Golub
) pg_dump and 帅 pg_restore utilities as libraries (.so, .dll .dylib). 帅 These days, I had a talk with Mr. Pavel Golub by email, the 帅 author of this post. And asked some questions about this idea. He 帅 adviced me to post the question to this mail list. 帅 My question is: 帅

Re: [HACKERS] Building on MinGW

2013-03-04 Thread Pavel Golub
Hello, Jeff. You wrote: JJ Changed subject from Strange Windows problem, lock_timeout test request JJ On Thu, Jan 24, 2013 at 11:41 AM, Andrew Dunstan and...@dunslane.net wrote: JJ On 01/24/2013 01:44 PM, Jeff Janes wrote: JJ On Sat, Jan 19, 2013 at 12:15 PM, Andrew Dunstan

Re: [HACKERS] Call for Google Summer of Code mentors, admins

2013-02-15 Thread Pavel Golub
Hello, Josh. You wrote: JB Folks, JB Once again, Google is holding Summer of Code. We need to assess whether JB we want to participate this year. JB Questions: JB - Who wants to mentor for GSOC? JB - Who can admin for GSOC? Thom? JB - Please suggest project ideas for GSOC My suggestion

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Pavel Golub
Hello, Pavel. You wrote: PS Hello PS Can we implement REGROLE type, that simplify role name - oid transformations? +1 from me. My old wish. PS Regards PS Pavel -- With best wishes, Pavel mailto:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list

Re: [HACKERS] pg_tablespace.spclocation column removed in 9.2

2012-06-25 Thread Pavel Golub
Hello, Guillaume. You wrote: GL Hi Pavel, GL On Mon, 2012-06-25 at 08:26 +0300, Pavel Golub wrote: Hello, Pgsql-bugs. According to the Moving tablespaces thread started by Bruce http://archives.postgresql.org/pgsql-docs/2011-12/msg3.php pg_tablespace.spclocation column is removed

[HACKERS] pg_tablespace.spclocation column removed in 9.2

2012-06-24 Thread Pavel Golub
Hello, Pgsql-bugs. According to the Moving tablespaces thread started by Bruce http://archives.postgresql.org/pgsql-docs/2011-12/msg3.php pg_tablespace.spclocation column is removed in the 9.2beta. However this breaks backward compatibility for a bunch of products, e.g. pgAdmin, phpPgAdmin,

Re: [HACKERS] Google Summer of Code? Call for mentors.

2012-02-15 Thread Pavel Golub
Hello, Josh. You wrote: JB Hackers, JB The call is now open for Google Summer of Code. JB If you are interested in being a GSoC mentor this summer, please reply JB to this email. I want to gauge whether or not we should participate JB this summer. JB -- JB Josh Berkus JB PostgreSQL Experts

Re: [HACKERS] Can PQstatus() be used by Application to check connection to postgres periodically?

2012-02-07 Thread Pavel Golub
Hello, sujayr06. You wrote: s Hello All, sMy application has to do a real time data upload to PostgreSQL s server. sEvery time i have to do a real time upload, i do not wish to open s new connection. sI want to open a connection once [when my application

Re: [HACKERS] LibreOffice driver 1: Building libpq with Mozilla LDAP instead of OpenLDAP

2011-12-13 Thread Pavel Golub
Hello, Tom. You wrote: TL Greg Smith g...@2ndquadrant.com writes: On 12/13/2011 11:07 AM, Lionel Elie Mamane wrote: On MacOS X and Microsoft Windows, the world is far more messy. There are several ways to install libpq (one-click installer, fink, MacPorts, ...), and each of these ways allows

Re: [HACKERS] [PATCH] PostgreSQL fails to build with 32bit MinGW-w64

2011-11-24 Thread Pavel Golub
Hello, Lars. You wrote: LK Hi PostgreSQL hackers, LK LK support for Mingw-w64 compiler was added to postgres with commit LK 91812df. Unfortunately only the 64 bit output is working right LK now. This issue was already highlighted with initial patch in LK

[HACKERS] Client library cross-compiling: Win32, Win64, MacOSX. Possible?

2011-11-15 Thread Pavel Golub
Hello. Are there any howto's or articles about building client access library (libpq) for several target OSes, e.g. Win32, Win64, MacOS in the same MinGW environment? And is it possible at all? I know that there is MinGW-w64 to produce Win64 binaries, but I want to have one farm for all. If

[HACKERS] MicrOLAP Database Designer with PostgreSQL 9.1 support is out!

2011-09-20 Thread Pavel Golub
Hello. Database Designer for PostgreSQL is an easy CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ. This release introduces new functionality as well as several bug fixes. Support for PostgreSQL 9.1 added, new Create HTML Report functionality present, unlogged

Re: [HACKERS] pg_dump.c

2011-09-08 Thread Pavel Golub
Hello, Andrew. You wrote: AD In the refactoring Large C files discussion one of the biggest files AD Bruce mentioned is pg_dump.c. There has been discussion in the past of AD turning lots of the knowledge currently embedded in this file into a AD library, which would make it available to other

Re: [HACKERS] rc1 or beta4?

2011-08-17 Thread Pavel Golub
Hello, Dave. You wrote: DP The current plan (or, the last one I recall) is to push another 9.1 DP release tomorrow, for Monday release. Are we going with beta4 or rc1? +1 for RC1 DP -- DP Dave Page DP Blog: http://pgsnake.blogspot.com DP Twitter: @pgsnake DP EnterpriseDB UK:

Re: [HACKERS] Error in PQsetvalue

2011-07-18 Thread Pavel Golub
Hello, Andrew. I hope you don't mind I've added this patch to CommitFest: https://commitfest.postgresql.org/action/patch_view?id=606 You wrote: AC On 6/3/2011 10:26 PM, Andrew Chernow wrote: I disagree -- I think the fix is a one-liner. line 446: if (tup_num == res-ntups

Re: [HACKERS] fixing PQsetvalue()

2011-07-18 Thread Pavel Golub
Hello, Merlin. I hope it's OK that I've added Andrew's patch to CommitFest: https://commitfest.postgresql.org/action/patch_view?id=606 I did this becuase beta3 already released, but nut nothig is done on this bug. You wrote: MM On Thu, Jun 23, 2011 at 7:54 AM, Andrew Chernow a...@esilo.com

Re: [HACKERS] fixing PQsetvalue()

2011-07-06 Thread Pavel Golub
Hello. Any news on these issues? Becuase beta3 is scheduled for July 11th... You wrote: MM On Jun 6 MM (http://archives.postgresql.org/pgsql-hackers/2011-06/msg00272.php), MM Pavel discovered an issue with PQsetvalue that could cause libpq to MM wander off into unallocated memory that was

[HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near binary

2011-07-05 Thread Pavel Golub
Hello. System: PostgreSQL v9.0 Windows XP SP3 SQL: COPY tablename TO STDOUT WITH (FORMAT binary) ERROR: syntax error at or near binary LINE 1: ...OPY tablename TO STDOUT WITH (FORMAT binary) ^ ** Error ** ERROR: syntax error at

Re: [HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near binary

2011-07-05 Thread Pavel Golub
Hello, Alvaro. You wrote: AH Excerpts from Pavel Golub's message of mar jul 05 10:52:06 -0400 2011: Hello. System: PostgreSQL v9.0 Windows XP SP3 SQL: COPY tablename TO STDOUT WITH (FORMAT binary) ERROR: syntax error at or near binary LINE 1: ...OPY tablename TO STDOUT WITH (FORMAT

Re: [BUGS] [HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near binary

2011-07-05 Thread Pavel Golub
Hello, Robert. You wrote: RH On Tue, Jul 5, 2011 at 11:06 AM, Alvaro Herrera RH alvhe...@commandprompt.com wrote: Excerpts from Pavel Golub's message of mar jul 05 10:52:06 -0400 2011: Hello. System: PostgreSQL v9.0 Windows XP SP3 SQL: COPY tablename TO STDOUT WITH (FORMAT binary) ERROR:  

Re: [BUGS] [HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near binary

2011-07-05 Thread Pavel Golub
Hello, Robert. You wrote: RH On Tue, Jul 5, 2011 at 11:37 AM, Pavel Golub pa...@microolap.com wrote: RH Yeah.  In particular, it conflicts with the ancient copy syntax which RH we still support for backwards compatibility with versions 7.3.  We RH can fix the immediate problem with something

Re: [HACKERS] fixing PQsetvalue()

2011-06-23 Thread Pavel Golub
Hello, Merlin. You wrote: MM On Jun 6 MM (http://archives.postgresql.org/pgsql-hackers/2011-06/msg00272.php), MM Pavel discovered an issue with PQsetvalue that could cause libpq to MM wander off into unallocated memory that was present in 9.0.x. A MM fairly uninteresting fix was quickly

Re: [HACKERS] Error in PQsetvalue

2011-06-08 Thread Pavel Golub
Hello, Merlin. You wrote: MM On Wed, Jun 8, 2011 at 11:03 AM, Tom Lane t...@sss.pgh.pa.us wrote: Merlin Moncure mmonc...@gmail.com writes: On Wed, Jun 8, 2011 at 10:18 AM, Tom Lane t...@sss.pgh.pa.us wrote: Merlin Moncure mmonc...@gmail.com writes: I went ahead and tested andrew's second

Re: [HACKERS] Error in PQsetvalue

2011-06-06 Thread Pavel Golub
Hello, guys. You wrote: MM On Fri, Jun 3, 2011 at 10:36 PM, Andrew Chernow a...@esilo.com wrote: On 6/3/2011 10:26 PM, Andrew Chernow wrote: I disagree -- I think the fix is a one-liner. line 446: if (tup_num == res-ntups !res-tuples[tup_num]) should just become if (tup_num == res-ntups)

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-03 Thread Pavel Golub
Hello, Andrew. You wrote: AC On 6/2/2011 11:02 AM, Alvaro Herrera wrote: Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011: Andrew, why we have PQmakeEmptyPGresult, PQcopyResult, PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course there's no big

[HACKERS] Error in PQsetvalue

2011-06-03 Thread Pavel Golub
Hello. Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If PQsetvalue is called with second parameter equals to PQntuples then memory corruption appears. But it should grow internal tuples array and populate the last item with provided data. Please see the code: #include

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 Thread Pavel Golub
Hello, Merlin. You wrote: MM 2011/6/1 Pavel Golub pa...@microolap.com: Hello. I'm some kind of PQdeleteTuple function will be very usefull in libpq. Because right now after deleting some record I need refetch result set, or mark tuple as deleted and this is headache for me. So I checked

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 Thread Pavel Golub
Hello, Andrew. You wrote: AC On 6/1/2011 11:43 AM, Pavel Golub wrote: Hello. I'm some kind of PQdeleteTuple function will be very usefull in libpq. Because right now after deleting some record I need refetch result set, or mark tuple as deleted and this is headache for me. AC IMHO

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 Thread Pavel Golub
Hello. So having studied the fe-exec.c sources, I came to this conclusion: we may just ignore deleted tuple and it will be destroyed by PQclear automatically, becuase PQclear deals with memory blocks. int PQdeleteTuple(PGresult *src, int tup_num) { if (!src) return NULL;

Re: [HACKERS] BLOB support

2011-06-02 Thread Pavel Golub
Hello, Pavel. You wrote: PS 2011/6/2 Peter Eisentraut pete...@gmx.net: On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote: I partialy implemented following missing LOBs types. Requirement for this was to give ability to create (B/C)LOB columns and add casting functionality e.g.

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 Thread Pavel Golub
Hello, Andrew. You wrote: AC On 6/2/2011 4:28 AM, Pavel Golub wrote: Hello, Andrew. You wrote: AC On 6/1/2011 11:43 AM, Pavel Golub wrote: Hello. I'm some kind of PQdeleteTuple function will be very usefull in libpq. Because right now after deleting some record I need refetch result

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 Thread Pavel Golub
Hello, Alvaro. You wrote: AH Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011: Andrew, why we have PQmakeEmptyPGresult, PQcopyResult, PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course there's no big deal with their absence but let's be

[HACKERS] PQdeleteTuple function in libpq

2011-06-01 Thread Pavel Golub
Hello. I'm some kind of PQdeleteTuple function will be very usefull in libpq. Because right now after deleting some record I need refetch result set, or mark tuple as deleted and this is headache for me. So I checked fe-exec.c sources and wrote this: int PQdeleteTuple(PGresult *src, int

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Pavel Golub
Hello. Congratulations! You wrote: DP I'm pleased to announce that effective immediately, Magnus Hagander DP will be joining the PostgreSQL Core Team. DP Magnus has been a contributor to PostgreSQL for over 12 years, and DP played a major part in the development and ongoing maintenance of the

[HACKERS] Warning during PostgreSQL 9.0.4 libpq.dll build on WinXP+MinGW

2011-04-19 Thread Pavel Golub
Hello, Pgsql-hackers. Today I built libpq.dll library on Windows XP using MinGW and got one warning message: Pablo@computer /z/pasha/postgresql-9.0.4/src/interfaces/libpq $ make ... gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels

Re: [HACKERS] Please review test report form

2011-04-06 Thread Pavel Golub
Hello, Josh. You wrote: JB All, JB For 9.1, I'm trying to get beta testing a *bit* more organized in hopes JB of shortening the beta period. Since we're not up and running on Django JB on the main website yet, and thus I can't make an app for collecting JB test reports, I've created a Google

Re: [HACKERS] Warning compiling pg_dump (MinGW, Windows XP)

2011-01-18 Thread Pavel Golub
Hello, Andrew. You wrote: AD On 01/17/2011 03:51 PM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net writes: On 01/17/2011 07:18 AM, Pavel Golub wrote: So you think I should just ignore these warnings? Because I can't remember the same behaviour on 8.x branches... We've had them all

Re: [HACKERS] MingW + GCC 4.5.2 + Relocate libpq.dll = SegFault

2011-01-18 Thread Pavel Golub
Hello, Charlie. Can you please express your opinion about my request Warning compiling pg_dump (MinGW, Windows XP) to pgsql-hackers on Thu, 13 Jan 2011. Do you have the same warnings using MinGW environment? You wrote: CS I'm compiling postgresql 9.0.2 using msys + mingw + gcc 4.5.2 (latest CS

Re: [HACKERS] Warning compiling pg_dump (MinGW, Windows XP)

2011-01-17 Thread Pavel Golub
Hello, Robert. You wrote: RH 2011/1/13 Pavel Golub pa...@microolap.com: Hello, Pgsql-hackers. I'm getting such warnings: pg_dump.c: In function 'dumpSequence': pg_dump.c:11449:2: warning: unknown conversion type character 'l' in format pg_dump.c:11449:2: warning: too many arguments

Re: [HACKERS] Warning compiling pg_dump (MinGW, Windows XP)

2011-01-17 Thread Pavel Golub
Hello, Andrew. You wrote: AD On 01/17/2011 05:54 AM, Pavel Golub wrote: Hello, Robert. You wrote: RH 2011/1/13 Pavel Golubpa...@microolap.com: Hello, Pgsql-hackers. I'm getting such warnings: pg_dump.c: In function 'dumpSequence': pg_dump.c:11449:2: warning: unknown conversion type

[HACKERS] Warning compiling pg_dump (MinGW, Windows XP)

2011-01-13 Thread Pavel Golub
Hello, Pgsql-hackers. I'm getting such warnings: pg_dump.c: In function 'dumpSequence': pg_dump.c:11449:2: warning: unknown conversion type character 'l' in format pg_dump.c:11449:2: warning: too many arguments for format pg_dump.c:11450:2: warning: unknown conversion type character 'l' in

Re: [HACKERS] Cannot compile Pg 9.0.2 with MinGW under Windows

2010-12-24 Thread Pavel Golub
Thanks, Andrew. I'll check my environment one more time. You wrote: AD On 12/23/2010 07:11 AM, Pavel Golub wrote: Hello, Pgsql-bugs. Tried to use MinGw under windows to build client libraries at least. However failed on ./configure --withou-zlib stage. Please find attached log file

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Pavel Golub
Hello, Pavel. You wrote: PS Hello PS Dne 21. prosince 2010 21:11 Tomáš Mudruňka to...@mudrunka.cz napsal(a): Thx for you answers :-) Well... i know that i can write my own plugin and i am familiar with C so this is not the problem, but i think that such feature should be implemented

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Pavel Golub
Hello. Guys, guys! It was only a joke! :) Please accept my appologies. Anyway I find such function usefull even though I still hadn't situation when it might be needed. You wrote: AD On 12/21/2010 04:28 PM, Pavel Golub wrote: PS * It isn't a typical and often request, PS

Re: [HACKERS] add label to enum syntax

2010-10-28 Thread Pavel Golub
Hello, Andrew. You wrote: AD It occurred to me in the dead of the night that instead of: AD ALTER TYPE enumtype ADD 'newlabel' AD it might be better to have: AD ALTER TYPE enumtype ADD LABEL 'newlabel' AD That way if we later wanted to support some other sort of ADD operation AD

Re: [HACKERS] add label to enum syntax

2010-10-28 Thread Pavel Golub
Hello, Andrew. You wrote: AD It occurred to me in the dead of the night that instead of: AD ALTER TYPE enumtype ADD 'newlabel' AD it might be better to have: AD ALTER TYPE enumtype ADD LABEL 'newlabel' AD That way if we later wanted to support some other sort of ADD operation AD

Re: [HACKERS] add label to enum syntax

2010-10-28 Thread Pavel Golub
Hello, Alvaro. You wrote: AH Excerpts from Pavel Golub's message of jue oct 28 07:50:24 -0300 2010: Forgot link to poll: http://pgolub.wordpress.com/2010/10/28/poll-alter-type-enumtype-add-what-newlabel/ AH Hah, there are 17 votes as of right now, no option is below 23% and no AH option is

Re: [HACKERS] Why do we have a database specification in .pgpass?

2010-10-14 Thread Pavel Golub
Hello, Bruce. You wrote: BM We have a database specification in .pgpass: BM hostname:port:database:username:password BM What is the purpose of 'database' since username/password combinations BM are global, not per database? I would like to documents its purpose. BM -- BM Bruce

Re: [HACKERS] Windows Tools

2010-09-06 Thread Pavel Golub
Hello, David. We are still using MinGW. Why? How? And other questions are answered in my post: http://pgolub.wordpress.com/2008/12/15/building-postgresql-client-library-using-mingw-under-winxp-sp3/ You wrote: DF Hello, DF At work, I've been tasked with providing some Windows connection DF

Re: [HACKERS] regclass without error?

2010-09-03 Thread Pavel Golub
Hello, guys. You wrote: TI Hi, TI Is there any way to use regclass without having ERROR? TI pgpool-II needs to find the oid from table name and for the purpose it TI issues something like SELECT 'table_name'::regproc::oid. Problem is, TI if the table does not exist, an error occured and the

Re: [HACKERS] keepalive in libpq using

2010-07-08 Thread Pavel Golub
Hello, Fujii. You wrote: FM On Wed, Jul 7, 2010 at 10:04 PM, Robert Haas robertmh...@gmail.com wrote: On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub pa...@microolap.com wrote: While I'm very excited about enabling keepalives in libpq, I want to know how can I use this functionality in my

[HACKERS] keepalive in libpq using

2010-07-06 Thread Pavel Golub
Hello all. While I'm very excited about enabling keepalives in libpq, I want to know how can I use this functionality in my application? Let's imagine that I connect to a server with keepalives option, other options (keepalives_idle, keepalives_interval, keepalives_count) are used either. Then

Re: [HACKERS] Keepalives win32

2010-06-30 Thread Pavel Golub
Hello, Bruce. You wrote: BM Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Mon, Jun 28, 2010 at 8:24 PM, Tom Lane t...@sss.pgh.pa.us wrote: What I was trying to say is I think we could dispense with the setsockopt() code path, and just always use the WSAIoctl() path anytime

Re: [HACKERS] Keepalives win32

2010-06-30 Thread Pavel Golub
Hello, Magnus. You wrote: MH 2010/6/30 Pavel Golub pa...@microolap.com: Hello, Bruce. You wrote: BM Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Mon, Jun 28, 2010 at 8:24 PM, Tom Lane t...@sss.pgh.pa.us wrote: What I was trying to say is I think we could dispense

Re: [HACKERS] Keepalives win32

2010-06-30 Thread Pavel Golub
Hello, Tom. You wrote: TL Bruce Momjian br...@momjian.us writes: Tom Lane wrote: What's your idea of affecting the fewest people? There is no previous history to be backward-compatible with, because we never supported keepalive on Windows before. Well, starting in 9.0, keepalives in libpq

[HACKERS] Bug in CREATE FUNCTION with character types if RETURNS TABLE used

2010-04-14 Thread Pavel Golub
Hello. Already sent this to psql-bugs, but noticed one more issue. Since the first issue is critical for me as a developer, the second one confuses my clients (and me a little) ;) PostgreSQL version: 8.4.x Operating system: All == 1 ISSUE = If RETURNS TABLE clause of CREATE FUNCTION

Re: [HACKERS] PQftype implementation

2010-03-18 Thread Pavel Golub
Hello, Tom. Yes, you are absolutely right. My bad! Sorry guys! :) You wrote: TL Pavel Golub pa...@microolap.com writes: Here I created user-defined type my_varchar for internal tests. But PQftype returns 1043 (varchar oid) for the info column. TL Really? I tried it and got 172069, which

[HACKERS] PQftype implementation

2010-03-17 Thread Pavel Golub
Hello, Pgsql-hackers. The script: CREATE TYPE my_varchar; CREATE OR REPLACE FUNCTION my_varcharout(my_varchar) RETURNS cstring AS 'varcharout' LANGUAGE 'internal' IMMUTABLE STRICT COST 1; CREATE OR REPLACE FUNCTION my_varcharin(cstring, oid, integer) RETURNS my_varchar AS 'varcharin'

Re: [HACKERS] bytea vs. pg_dump

2009-07-09 Thread Pavel Golub
Hello, Bernd. You wrote: BH --On Dienstag, Juli 07, 2009 18:07:08 -0400 Tom Lane t...@sss.pgh.pa.us BH wrote: Enum. If we do this then it seems entirely fair that someone might want other settings someday. Also, it seems silly to pick a format partly on the grounds that it's expansible,

Re: [HACKERS] Named transaction

2009-06-18 Thread Pavel Golub
Hello. You wrote: TL Pavel Golub pa...@microolap.com writes: Is there any possibility that Postgres will have named transaction ever, like Firebird? TL What in heck is a named transaction, and why should we care? TL regards, tom lane Sorry guys, my bad. The thing

[HACKERS] Named transaction

2009-06-17 Thread Pavel Golub
Hello, pgsql-hackers. Is there any possibility that Postgres will have named transaction ever, like Firebird? Now for each transaction client should open separate connection. But CONNECTION LIMIT option for database make this a little bit harder -- With best wishes, Pavel

[HACKERS] Keep alive in libpq

2009-05-27 Thread Pavel Golub
Hello, postgresmen. I found solution how to implement keep alive through sockets in archive: http://archives.postgresql.org/pgsql-interfaces/2006-11/msg00014.php However, it is dated 2006 year and I am wonder if this is for real? At least in Windows environment? If not are there any solutions?

Re: [HACKERS] [PATCH] Borland C Compiler compatibility issues

2009-04-20 Thread Pavel Golub
On Mon, Apr 20, 2009 at 1:38 AM, Tom Lane t...@sss.pgh.pa.us wrote: Pavel Golub pa...@microolap.com writes: Here the patch to /src/include/pg_config_os.h attached improving Borland C++ Compiler compatibility. Applied along with your other two patches.  Please note in future

[HACKERS] [PATCH] Borland C Compiler compatibility issues

2009-04-18 Thread Pavel Golub
Here the patch to /src/include/pg_config_os.h attached improving Borland C++ Compiler compatibility. Issues described here: http://pgolub.wordpress.com/2009/04/13/building-postgresql-client-library-using-borland-c-compiler-bcc-under-winxp/ This patch defines missing constants needed by

[HACKERS] [PATCH] MinGW compatibility issues

2009-04-18 Thread Pavel Golub
Here the patches to /src/include/libpq/libpq-be.h and /src/interfaces/libpq/libpq-int.h attached improving MinGW compatibility. Issues described here: http://pgolub.wordpress.com/2008/12/15/building-postgresql-client-library-using-mingw-under-winxp-sp3/ This patch adds missing includes with

[HACKERS] [PATCH] Borland C Compiler compatibility issues

2009-04-18 Thread Pavel Golub
Here the patch to /src/interfaces/libpq/bcc32.mak attached improving Borland C++ Compiler compatibility. Issues described here: http://pgolub.wordpress.com/2009/04/13/building-postgresql-client-library-using-borland-c-compiler-bcc-under-winxp/ This patch changes order of include folders placing