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 t

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 us

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

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

2017-07-26 Thread Pavel Golub
Hello, Tom. You wrote: TL> Pavel Golub 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';` >> ^^^ TL&g

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

2017-07-26 Thread Pavel Golub
Hello, Tom. You wrote: TL> Pavel Golub 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';` >> ^^^ TL&g

[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: AlterUse

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> http://www.postgresql.org/message-id/71e01949.2e16b.13df4707405.coremail.shuai900...@126.co

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 som

Re: [HACKERS] raw output from copy

2015-06-30 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 A

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 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 documentation and my r

[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 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 Invalid

Re: [HACKERS] Proposal: variant of regclass

2013-12-04 Thread Pavel Golub
Hello, Tom. You wrote: TL> Tatsuo Ishii 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 just make a

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 a

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

2013-11-19 Thread Pavel Golub
ql.conf to disable this SZ> enhancement so 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>

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

2013-11-15 Thread Pavel Golub
Hello, Dimitri. You wrote: DF> Bruce Momjian 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 poss

[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 ** Err

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

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

2013-04-11 Thread Pavel Golub
Hello, Tom. You wrote: TL> Pavel Golub 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 *

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

2013-04-10 Thread Pavel Golub
;m interested in the idea "Rewrite (add) 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 que

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 wrote: JJ> On 01/24/2013 01:44 PM, Jeff Janes wrote: JJ> On Sat, Jan 19, 2013 at 12:15 PM, Andrew Dunstan wrote: JJ> On 01/19/2013 02:36

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 sugges

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

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

[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 E

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, s>My application has to do a real time data upload to PostgreSQL s> server. s>Every time i have to do a real time upload, i do not wish to open s> new connection. s>I want to open a connection once [when my applicati

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 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 the user

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> http://archives.postgresql.org/pgs

[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 not,

[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

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: http://www

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 wrote: >>>    you

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&& !res->t

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 pr

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 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 imme

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> 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:  syntax

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

[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 erro

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 pro

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 wrote: >> Merlin Moncure writes: >>> On Wed, Jun 8, 2011 at 10:18 AM, Tom Lane wrote: Merlin Moncure writes: > I went ahead and tested andrew's second patch -- can we get this > reviewed and committed? >> >>>

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 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 (tu

[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 #inclu

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 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 th

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

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 funct

Re: [HACKERS] BLOB support

2011-06-02 Thread Pavel Golub
Hello, Pavel. You wrote: PS> 2011/6/2 Peter Eisentraut : >> 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. 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] 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 delet

Re: [HACKERS] PQdeleteTuple function in libpq

2011-06-02 Thread Pavel Golub
Hello, Merlin. You wrote: MM> 2011/6/1 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

[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 tup_num)

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 t

[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 -fno-strict-alia

Re: [HACKERS] Please review test report form

2011-04-05 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 Goog

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

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 Dunstan 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 beha

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 Golub: >>>> Hello, Pgsql-hackers. >>>> >>>> I'm getting such warnings: >

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 : >> 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 for

[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 format

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 --

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 typi

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 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 directly in

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> optio

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

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

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> Bruc

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

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 wrote: >> On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub wrote: >>> While I'm very excited about enabling keepalives in libpq, I want to >>> know how can I use this functionality in my ap

[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 ne

Re: [HACKERS] Keepalives win32

2010-06-30 Thread Pavel Golub
Hello, Tom. You wrote: TL> Bruce Momjian 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

Re: [HACKERS] Keepalives win32

2010-06-30 Thread Pavel Golub
Hello, Magnus. You wrote: MH> 2010/6/30 Pavel Golub : >> Hello, Bruce. >> >> You wrote: >> >> BM> Tom Lane wrote: >>>> Robert Haas writes: >>>> > On Mon, Jun 28, 2010 at 8:24 PM, Tom Lane wrote: >>>> >> What I

Re: [HACKERS] Keepalives win32

2010-06-30 Thread Pavel Golub
Hello, Bruce. You wrote: BM> Tom Lane wrote: >> Robert Haas writes: >> > On Mon, Jun 28, 2010 at 8:24 PM, Tom Lane 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 >> >> keepalives are turne

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

2010-04-13 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 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 t

[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 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, and then not

Re: [HACKERS] Named transaction

2009-06-17 Thread Pavel Golub
Hello. You wrote: TL> Pavel Golub 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. T

[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 wrote: > Pavel Golub 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 that > pg_config_os.h is

[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 .

[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 appro

[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 /port/dire