Re: [HACKERS] Transaction-scope advisory locks

2010-12-13 Thread Szymon Guz
On 13 December 2010 23:52, Marko Tiikkaja marko.tiikk...@cs.helsinki.fiwrote: Hi, I often find myself wanting advisory locks that are automatically released when the transaction ends, so here's a small patch trying to do just that. I don't know much about the lock system so the patch is in

Re: [HACKERS] NOWAIT doesn't work

2012-10-31 Thread Szymon Guz
On 31 October 2012 14:52, Pavel Stehule pavel.steh...@gmail.com wrote: tested on 9.3 Pavel 2012/10/31 Pavel Stehule pavel.steh...@gmail.com: Hello it is expected behave? 1.session postgres=# begin; BEGIN postgres=# lock oo IN ACCESS EXCLUSIVE MODE; LOCK TABLE 2.

Re: [HACKERS] Check if trigger was fired deferred

2013-02-27 Thread Szymon Guz
On 27 February 2013 10:20, Miroslav Šimulčík simulcik.m...@gmail.comwrote: Hi all, how can I check inside C trigger function if it was fired deferred? Thank you. Regards, Miro I'd try tgdeferrable from Trigger struct: http://www.postgresql.org/docs/9.2/static/trigger-interface.html

Re: [HACKERS] issues with dropped columns in plpgsql code again

2013-05-07 Thread Szymon Guz
On 7 May 2013 21:23, Pavel Stehule pavel.steh...@gmail.com wrote: sorry my test create table f1(a int, b int, c varchar, dropped_column numeric, d varchar); create or replace function f1_trg() returns trigger as $$ declare _f1_var f1; begin raise notice 'run trigger'; _f1_var :=

[HACKERS] adding import in pl/python function

2013-05-24 Thread Szymon Guz
Hi, I'm wondering if it would be OK to change the procedure code before execution. I'm thinking about adding magically an import at the beginning of a function. Currently numeric arguments passed to the procedure are converted into floats. This is not good, as it causes loss of information. The

Re: [HACKERS] adding import in pl/python function

2013-05-24 Thread Szymon Guz
On 24 May 2013 21:14, Claudio Freire klaussfre...@gmail.com wrote: On Fri, May 24, 2013 at 4:10 PM, Szymon Guz mabew...@gmail.com wrote: I'm thinking about something else. We could convert it into Decimal (http://docs.python.org/2/library/decimal.html) class in Python. Unfortunately

Re: [HACKERS] adding import in pl/python function

2013-05-24 Thread Szymon Guz
On 24 May 2013 21:46, Claudio Freire klaussfre...@gmail.com wrote: On Fri, May 24, 2013 at 4:22 PM, Szymon Guz mabew...@gmail.com wrote: Hm... maybe you're right. I think I don't understand fully how the procedures are executed, and I need to read more to get it. Well, it's easy

Re: [HACKERS] adding import in pl/python function

2013-05-27 Thread Szymon Guz
On 28 May 2013 01:55, Peter Eisentraut pete...@gmx.net wrote: On Mon, 2013-05-27 at 20:43 -0300, Claudio Freire wrote: On Mon, May 27, 2013 at 8:13 PM, Peter Eisentraut pete...@gmx.net wrote: On Fri, 2013-05-24 at 16:46 -0300, Claudio Freire wrote: Well, it's easy. Instead of

[HACKERS] converting numeric to string in postgres code

2013-05-28 Thread Szymon Guz
Hi, while hacking on some Postgres code I've found a problem. I need to convert numeric to string. I've got datum with numeric inside, so I'm getting it like: Numeric *numeric = DatumGetNumeric(d); but later I need to have string (most probably: const char *). I've found a couple of different

Re: [HACKERS] converting numeric to string in postgres code

2013-05-28 Thread Szymon Guz
On 28 May 2013 12:07, Pavel Stehule pavel.steh...@gmail.com wrote: Hello 2013/5/28 Szymon Guz mabew...@gmail.com: Hi, while hacking on some Postgres code I've found a problem. I need to convert numeric to string. I've got datum with numeric inside, so I'm getting it like

[HACKERS] storing plpython global pointer

2013-05-28 Thread Szymon Guz
Hi, I need to store a global pointer for plpython usage. This is a PyObject* which can be initialized per session I think, as we have to deal with Python 2 and Python 3. This pointer points to a Python constructor of Python's Decimal type, taken from python stdlib. I've got working code, however

Re: [HACKERS] storing plpython global pointer

2013-05-28 Thread Szymon Guz
On 28 May 2013 14:15, Jan Urbański wulc...@wulczer.org wrote: On 28/05/13 14:04, Szymon Guz wrote: Hi, I need to store a global pointer for plpython usage. This is a PyObject* which can be initialized per session I think Where should I keep such a pointer? Hi, you probably could use

[HACKERS] potential bug in JSON

2013-05-28 Thread Szymon Guz
I've found a potential bug. Why the - operator returns JSON instead of TEXT? It doesn't make sens for me, and the documentation doesn't inform about that. postgres=# SELECT ('{id: 1}'::json - 'id')::int; ERROR: cannot cast type json to integer LINE 1: SELECT ('{id: 1}'::json - 'id')::int;

Re: [HACKERS] potential bug in JSON

2013-05-28 Thread Szymon Guz
On 28 May 2013 17:53, Josh Berkus j...@agliodbs.com wrote: On 05/28/2013 08:38 AM, Szymon Guz wrote: I've found a potential bug. Why the - operator returns JSON instead of TEXT? It doesn't make sens for me, and the documentation doesn't inform about that. Yes, it most certainly does

[HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-05-28 Thread Szymon Guz
Hi, I've got a patch. This is for a plpython enhancement. There is an item at the TODO list http://wiki.postgresql.org/wiki/Todo#Server-Side_Languages Fix loss of information during conversion of numeric type to Python float This patch uses a decimal.Decimal type from Python standard library

Re: [HACKERS] Get the offset of a tuple inside a table

2010-09-21 Thread Szymon Guz
On 21 September 2010 23:02, Pei He hepeim...@gmail.com wrote: Hi, When I using an index scan, can I get the offset of the tuple in the table? Thanks -- Pei What do you mean by the offset in the table?

Re: [HACKERS] temporary functions (and other object types)

2010-11-05 Thread Szymon Guz
On 5 November 2010 20:36, Alvaro Herrera alvhe...@alvh.no-ip.org wrote: Hi, A customer of ours has the need for temporary functions. The use case is writing test cases for their databases: the idea being that their code creates a temp function which then goes away automatically at session

Re: [HACKERS] Storing original rows before update or delete

2011-11-04 Thread Szymon Guz
On 4 November 2011 10:20, Miroslav Šimulčík simulcik.m...@gmail.com wrote: Hi. I'm working on transactiontime temporal support for postgresql 9.0.4. Each original table with transactiontime support has associated history table, where original row is stored before each update or delete

Re: [HACKERS] Should a materialized view be based on a view?

2011-11-18 Thread Szymon Guz
On 18 November 2011 23:26, Kevin Grittner kevin.gritt...@wicourts.govwrote: I still have a lot of reading to do before I propose anything concrete for development, but one thing that has already struck me as a common theme for MVs is that a lot of people seem to like the idea of first

[HACKERS] potential bug in trigger with boolean params

2011-05-11 Thread Szymon Guz
Hi, I was trying to create a trigger with parameters. I've found a potential bug when the param is boolean. Here is code replicating the bug: CREATE TABLE x(x TEXT); CREATE OR REPLACE FUNCTION trigger_x() RETURNS TRIGGER AS $$ BEGIN RETURN NEW; END; $$ LANGUAGE PLPGSQL; CREATE TRIGGER

Re: [HACKERS] potential bug in trigger with boolean params

2011-05-11 Thread Szymon Guz
On 11 May 2011 10:56, t...@fuzzy.cz wrote: Hi, I was trying to create a trigger with parameters. I've found a potential bug when the param is boolean. Here is code replicating the bug: CREATE TABLE x(x TEXT); CREATE OR REPLACE FUNCTION trigger_x() RETURNS TRIGGER AS $$ BEGIN

Re: [HACKERS] potential bug in trigger with boolean params

2011-05-11 Thread Szymon Guz
On 11 May 2011 11:01, Andreas Joseph Krogh andr...@officenet.no wrote: På onsdag 11. mai 2011 kl 10:56:19 skrev t...@fuzzy.cz: Hi, I was trying to create a trigger with parameters. I've found a potential bug when the param is boolean. Here is code replicating the bug:

Re: [HACKERS] potential bug in trigger with boolean params

2011-05-11 Thread Szymon Guz
On 11 May 2011 12:06, Andres Freund and...@anarazel.de wrote: Why do you wan't to use a boolean directly if you can't use it as the type itself anyway? Yep, and this is a really good point :) I wanted to have consistent api, so use true when I have a boolean value. I will use 'true' and add

Re: [HACKERS] Add more regression tests for CREATE OPERATOR

2013-06-17 Thread Szymon Guz
On 23 May 2013 00:34, Robins Tharakan thara...@gmail.com wrote: Hi, Please find attached a patch to take code-coverage of CREATE OPERATOR (src/backend/commands/operatorcmds.c) from 56% to 91%. Any and all feedback is welcome. -- Robins Tharakan -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Add regression tests for SET xxx

2013-06-17 Thread Szymon Guz
On 26 May 2013 19:56, Robins Tharakan thara...@gmail.com wrote: Hi, Please find attached a patch to take code-coverage of SET (SESSION / SEED / TRANSACTION / DATESTYLE / TIME ZONE) (src/backend/commands/variable.c) from 65% to 82%. Any and all feedback is welcome. -- Robins Tharakan

Re: [HACKERS] Add regression tests for SET xxx

2013-06-18 Thread Szymon Guz
On 18 June 2013 02:33, Robins Tharakan thara...@gmail.com wrote: Thanks ! PFA the updated patch. Also remove a trailing whitespace at the end of SQL script. -- Robins Tharakan On 17 June 2013 17:29, Szymon Guz mabew...@gmail.com wrote: On 26 May 2013 19:56, Robins Tharakan thara

Re: [HACKERS] Add regression tests for SET xxx

2013-06-18 Thread Szymon Guz
On 18 June 2013 13:10, Michael Paquier michael.paqu...@gmail.com wrote: On Tue, Jun 18, 2013 at 7:01 PM, Szymon Guz mabew...@gmail.com wrote: Could you add me as a reviewer to commitfest website, set this patch a reviewed and add this email to the patch history? I cannot login

Re: [HACKERS] Add regression tests for SET xxx

2013-06-18 Thread Szymon Guz
On 18 June 2013 17:29, Kevin Grittner kgri...@ymail.com wrote: Szymon Guz mabew...@gmail.com wrote: I've checked the patch. Applies cleanly. Tests pass this time :) Could you add me as a reviewer to commitfest website, set this patch a reviewed and add this email to the patch history

Re: [HACKERS] [9.4 CF 1] The Commitfest Slacker List

2013-06-24 Thread Szymon Guz
I'm just wondering about newbies... I've created my first patch, so I'm one of them, I think. I've reviewed some patches, but only some easier ones, like pure regression tests. Unfortunately my knowledge is not enough to review patches making very deep internal changes, or some efficiency

Re: [HACKERS] is it bug? - printing boolean domains in sql/xml function

2013-06-24 Thread Szymon Guz
On 14 March 2013 03:45, Peter Eisentraut pete...@gmx.net wrote: On Mon, 2013-03-04 at 08:35 +0100, Pavel Stehule wrote: in this use case I am think so some regression test is important - It should not be mine, but missing more explicit regression test is reason, why this bug was not

[HACKERS] converting datum to numeric

2013-06-25 Thread Szymon Guz
Hi, I've got a couple of questions. I was using numeric_out like this: DatumGetCString(DirectFunctionCall1(numeric_out, d)); Why do I have to use DirectFunctionCall1 instead of calling numeric_out? I was suggested to use numeric_send instead of numeric_out, however when changing the function

Re: [HACKERS] converting datum to numeric

2013-06-25 Thread Szymon Guz
On 25 June 2013 08:51, Pavel Stehule pavel.steh...@gmail.com wrote: Hello 2013/6/25 Szymon Guz mabew...@gmail.com: Hi, I've got a couple of questions. I was using numeric_out like this: DatumGetCString(DirectFunctionCall1(numeric_out, d)); Why do I have to use

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-25 Thread Szymon Guz
On 25 June 2013 05:16, Steve Singer st...@ssinger.info wrote: One concern I have is that this patch makes pl/python functions involving numerics more than 3 times as slow as before. create temp table b(a numeric); insert into b select generate_series(1,1); create or replace function

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-25 Thread Szymon Guz
On 25 June 2013 05:16, Steve Singer st...@ssinger.info wrote: On 05/28/2013 04:41 PM, Szymon Guz wrote: Hi, I've got a patch. This is for a plpython enhancement. There is an item at the TODO list http://wiki.postgresql.org/** wiki/Todo#Server-Side_**Languageshttp://wiki.postgresql.org

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-25 Thread Szymon Guz
be overkill to try to include such a dependency, but the performance overhead from using decimal is really mitigated by this implementation. 2013/6/25 Szymon Guz mabew...@gmail.com On 25 June 2013 05:16, Steve Singer st...@ssinger.info wrote: On 05/28/2013 04:41 PM, Szymon Guz wrote: Hi

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-26 Thread Szymon Guz
On 26 June 2013 01:40, Steve Singer st...@ssinger.info wrote: On 06/25/2013 06:42 AM, Szymon Guz wrote: Hi, I've attached a new patch. I've fixed all the problems you've found, except for the efficiency problem, which has been described in previous email. thanks, Szymon

Re: [HACKERS] Add more regression tests for CREATE OPERATOR

2013-06-26 Thread Szymon Guz
. Thanks -- Robins Tharakan -- Robins Tharakan On 17 June 2013 05:19, Szymon Guz mabew...@gmail.com wrote: On 23 May 2013 00:34, Robins Tharakan thara...@gmail.com wrote: Hi, Please find attached a patch to take code-coverage of CREATE OPERATOR (src/backend/commands/operatorcmds.c) from

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-26 Thread Szymon Guz
: - with cdecimal installed: ~84ms - without cdecimal installed (standard decimal module): ~511ms 2013/6/26 Szymon Guz mabew...@gmail.com On 26 June 2013 01:40, Steve Singer st...@ssinger.info wrote: On 06/25/2013 06:42 AM, Szymon Guz wrote: Hi, I've attached a new patch. I've fixed

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-26 Thread Szymon Guz
You had a great idea, the time with cdecimal is really great, the difference on my machine is 64 ms vs 430 ms. Szymon

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-26 Thread Szymon Guz
On 26 June 2013 12:04, Ronan Dunklau rdunk...@gmail.com wrote: It seems like you confused me with steve :) Hi Ronan, Oh, yes. I'm sorry for that :) The patch applies cleanly, and the regression tests pass on python2 when cdecimal is not installed. When it is, the type info returned for the

Re: [HACKERS] Add more regression tests for CREATE OPERATOR

2013-06-26 Thread Szymon Guz
On 26 June 2013 20:55, Josh Berkus j...@agliodbs.com wrote: On 06/26/2013 12:29 AM, Szymon Guz wrote: OK, so I think this patch can be committed, I will change the status. Can we have a full review before you mark it ready for committer? How did you test it? What kinds of review have you

Re: [HACKERS] Add more regression tests for CREATE OPERATOR

2013-06-26 Thread Szymon Guz
On 26 June 2013 20:57, Szymon Guz mabew...@gmail.com wrote: On 26 June 2013 20:55, Josh Berkus j...@agliodbs.com wrote: On 06/26/2013 12:29 AM, Szymon Guz wrote: OK, so I think this patch can be committed, I will change the status. Can we have a full review before you mark it ready

Re: [HACKERS] Add more regression tests for CREATE OPERATOR

2013-06-26 Thread Szymon Guz
On 26 June 2013 21:10, Josh Berkus j...@agliodbs.com wrote: Is it enough to provide the description in the commitfest app, or is that better to send an email and provide link in commitfest? Better to do it here, on the list. This is a patch only with regression tests, is that enough to

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-26 Thread Szymon Guz
On 26 June 2013 21:59, Peter Eisentraut pete...@gmx.net wrote: On 6/26/13 7:03 AM, Szymon Guz wrote: I've checked the patch, everything looks great. I've attached it to this email with changed name, just for consistent naming in commitfest app. Could the setup of the decimal.Decimal

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-26 Thread Szymon Guz
On 26 June 2013 22:08, Szymon Guz mabew...@gmail.com wrote: On 26 June 2013 21:59, Peter Eisentraut pete...@gmx.net wrote: On 6/26/13 7:03 AM, Szymon Guz wrote: I've checked the patch, everything looks great. I've attached it to this email with changed name, just for consistent naming

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-27 Thread Szymon Guz
On 27 June 2013 05:21, Steve Singer st...@ssinger.info wrote: On 06/26/2013 04:47 PM, Szymon Guz wrote: Attached patch has all changes against trunk code. There is added a function for conversion from Postgres numeric to Python Decimal. The Decimal type is taken from cdecimal.Decimal

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-06-28 Thread Szymon Guz
On 28 June 2013 22:14, Steve Singer st...@ssinger.info wrote: I think the value is more important than the name, I want to the tests to make sure that the conversion is actually converting properly. With your method of getting the class name without the module we can have both. The

[HACKERS] plpython implementation

2013-06-30 Thread Szymon Guz
I'm reading through plperl and plpython implementations and I don't understand the way they work. Comments for plperl say that there are two interpreters (trusted and untrusted) for each user session, and they are stored in a hash. Plpython version looks quite different, there is no such global

Re: [HACKERS] plpython implementation

2013-06-30 Thread Szymon Guz
On 30 June 2013 14:13, Andrew Dunstan and...@dunslane.net wrote: On 06/30/2013 07:49 AM, Szymon Guz wrote: I'm reading through plperl and plpython implementations and I don't understand the way they work. Comments for plperl say that there are two interpreters (trusted and untrusted

Re: [HACKERS] plpython implementation

2013-06-30 Thread Szymon Guz
On 30 June 2013 14:31, Martijn van Oosterhout klep...@svana.org wrote: On Sun, Jun 30, 2013 at 02:18:07PM +0200, Szymon Guz wrote: python does not any any sort of reliable sandbox, so there is no plpython, only plpythonu - hence only one interpreter per backend is needed

Re: [HACKERS] plpython implementation

2013-06-30 Thread Szymon Guz
On 30 June 2013 14:45, Andres Freund and...@2ndquadrant.com wrote: On 2013-06-30 14:42:24 +0200, Szymon Guz wrote: On 30 June 2013 14:31, Martijn van Oosterhout klep...@svana.org wrote: On Sun, Jun 30, 2013 at 02:18:07PM +0200, Szymon Guz wrote: python does not any any sort

Re: [HACKERS] [PATCH] Fix conversion for Decimal arguments in plpython functions

2013-07-06 Thread Szymon Guz
On 28 June 2013 22:29, Claudio Freire klaussfre...@gmail.com wrote: On Fri, Jun 28, 2013 at 5:14 PM, Steve Singer st...@ssinger.info wrote: On 06/27/2013 05:04 AM, Szymon Guz wrote: On 27 June 2013 05:21, Steve Singer st...@ssinger.info mailto:st...@ssinger.info wrote: On 06/26

Re: [HACKERS] [COMMITTERS] pgsql: PL/Python: Convert numeric to Decimal

2013-07-06 Thread Szymon Guz
On 6 July 2013 17:58, Claudio Freire klaussfre...@gmail.com wrote: Look at that: return x $$ LANGUAGE plpythonu; SELECT * FROM test_type_conversion_numeric(100); ! INFO: (Decimal('100'), 'Decimal') CONTEXT: PL/Python function test_type_conversion_numeric

Re: [HACKERS] [COMMITTERS] pgsql: PL/Python: Convert numeric to Decimal

2013-07-07 Thread Szymon Guz
On 7 July 2013 21:35, Peter Eisentraut pete...@gmx.net wrote: On Sun, 2013-07-07 at 17:21 +0200, Szymon Guz wrote: I think that these tests are much better, so they should go into trunk. As for Python 2.5 I think we could modify the code and makefile (with additional documentation info

[HACKERS] potential bug in error message in with clause

2013-07-29 Thread Szymon Guz
Hi, today on IRC there was a strange problem shown. The small working example looks like this: x=# with x as (insert into a(t) values('1') returning *) select * from x; t --- 1 (1 row) x=# with x (insert into a(t) values('1') returning *) select * from x; ERROR: syntax error at or near into

Re: [HACKERS] ToDo: possible more rights to database owners

2013-07-29 Thread Szymon Guz
On 29 July 2013 11:25, Pavel Stehule pavel.steh...@gmail.com wrote: Hello In 9.3 super user can cancel all queries or user can cancel own sessions. Is possible enhance this possibility to database owners? So owner can cancel or can terminate sessions related to owned databases? But this

Re: [HACKERS] ToDo: possible more rights to database owners

2013-07-29 Thread Szymon Guz
On 29 July 2013 13:20, Pavel Stehule pavel.steh...@gmail.com wrote: 2013/7/29 Szymon Guz mabew...@gmail.com: On 29 July 2013 11:25, Pavel Stehule pavel.steh...@gmail.com wrote: Hello In 9.3 super user can cancel all queries or user can cancel own sessions. Is possible enhance

[HACKERS] question about HTTP API

2013-08-08 Thread Szymon Guz
Do we have any attempts of implementation the HTTP server described at http://wiki.postgresql.org/wiki/HTTP_API? It seems like there are design ideas only. Are there any ideas about implementation like using some existing http servers or writing everything from scratch? regards Szymon

Re: [HACKERS] question about HTTP API

2013-08-12 Thread Szymon Guz
On 12 August 2013 18:37, Peter Eisentraut pete...@gmx.net wrote: On 8/8/13 3:44 PM, Josh Berkus wrote: Other than that, no. I was thinking of creating a general tool as a custom background worker, which would take stored procedure calls and pass them through to PostgreSQL, returning

Re: [HACKERS] How to create read-only view on 9.3

2013-08-13 Thread Szymon Guz
On 13 August 2013 11:43, Tomonari Katsumata katsumata.tomon...@po.ntts.co.jp wrote: Hi, Could anyone tell me how to create read-only view on PostgreSQL 9.3 ? I've been testing updatable views and noticed that all simple views are updatable. When I use pg_dump for upgrading from

[HACKERS] Clang support

2013-11-19 Thread Szymon Guz
Hi, is clang supported for compiling Postgres? I found some websites with information that some people compiled Postgres succesfully, but I got plenty of errors even with running ./configure. So I'm wondering if it's my fault, however gcc works properly. thanks, Szymon

Re: [HACKERS] Clang support

2013-11-19 Thread Szymon Guz
On 19 November 2013 22:54, Kevin Grittner kgri...@ymail.com wrote: Szymon Guz mabew...@gmail.com wrote: is clang supported for compiling Postgres? I found some websites with information that some people compiled Postgres succesfully, but I got plenty of errors even with running

Re: [HACKERS] Clang support

2013-11-19 Thread Szymon Guz
On 19 November 2013 23:02, Szymon Guz mabew...@gmail.com wrote: On 19 November 2013 22:54, Kevin Grittner kgri...@ymail.com wrote: Szymon Guz mabew...@gmail.com wrote: is clang supported for compiling Postgres? I found some websites with information that some people compiled Postgres

Re: [HACKERS] new unicode table border styles for psql

2013-11-21 Thread Szymon Guz
On 21 November 2013 08:09, Pavel Stehule pavel.steh...@gmail.com wrote: Hello I wrote new styles for psql table borders. http://postgres.cz/wiki/Pretty_borders_in_psql This patch is simply and I am think so some styles can be interesting for final presentation. Do you think so this

Re: [HACKERS] new unicode table border styles for psql

2013-11-21 Thread Szymon Guz
On 21 November 2013 20:20, Pavel Stehule pavel.steh...@gmail.com wrote: So here is patch for 9.4 7 new line styles, 2 new border styles, \pset border autocomplete Regards Pavel 2013/11/21 Szymon Guz mabew...@gmail.com On 21 November 2013 08:09, Pavel Stehule pavel.steh...@gmail.com

Re: [HACKERS] new unicode table border styles for psql

2013-11-21 Thread Szymon Guz
On 21 November 2013 21:15, Szymon Guz mabew...@gmail.com wrote: On 21 November 2013 20:20, Pavel Stehule pavel.steh...@gmail.com wrote: So here is patch for 9.4 7 new line styles, 2 new border styles, \pset border autocomplete Regards Pavel 2013/11/21 Szymon Guz mabew

Re: [HACKERS] Storing the password in .pgpass file in an encrypted format

2014-02-21 Thread Szymon Guz
On 21 February 2014 13:49, firoz e v firoz...@huawei.com wrote: Hi, Is there a way to store the password in “.pgpass” file in an encrypted format (for example, to be used by pg_dump). Even though, there are ways to set the permissions on .pgpass, to disallow any access to world or

[HACKERS] potential bug in psql

2014-08-22 Thread Szymon Guz
Hi, when I run `\s` in psql, I get the nice list of queries with an error at the end: \s could not save history to file /dev/tty: No such file or directory Newest ubuntu from trunk PostgreSQL 9.5devel on x86_64-unknown-linux-gnu, compiled by Ubuntu clang version 3.4-1ubuntu3

Re: [HACKERS] potential bug in psql

2014-08-22 Thread Szymon Guz
On 22 August 2014 17:06, Tom Lane t...@sss.pgh.pa.us wrote: Szymon Guz mabew...@gmail.com writes: when I run `\s` in psql, I get the nice list of queries with an error at the end: \s could not save history to file /dev/tty: No such file or directory Well, that's interesting ... what

Re: [HACKERS] PL/pgSQL 2

2014-09-03 Thread Szymon Guz
On 3 September 2014 01:08, Jan Wieck j...@wi3ck.info wrote: On 09/02/2014 06:56 PM, Andrew Dunstan wrote: People are free to do what they want, but to my mind that would be a massive waste of resources, and probably imposing a substantial extra maintenance burden on the core committers. I

[HACKERS] printing table in asciidoc with psql

2014-09-16 Thread Szymon Guz
Hi, I've been working a little bit on a patch for printing tables in asciidoc with psql. It's not finished yet, I'm not sure it there is any sense in supporting border types etc. The code is not cleared so far, but any remarks on the style not playing well with the normal postgres style of code

Re: [HACKERS] printing table in asciidoc with psql

2014-09-17 Thread Szymon Guz
On 17 September 2014 19:30, Peter Eisentraut pete...@gmx.net wrote: On 9/16/14 3:52 PM, Szymon Guz wrote: It's not finished yet, I'm not sure it there is any sense in supporting border types etc. AFAICT, Asciidoc doesn't support border types, so (if so) you should just ignore that setting

Re: [HACKERS] printing table in asciidoc with psql

2014-09-17 Thread Szymon Guz
On 17 September 2014 19:55, Szymon Guz mabew...@gmail.com wrote: On 17 September 2014 19:30, Peter Eisentraut pete...@gmx.net wrote: On 9/16/14 3:52 PM, Szymon Guz wrote: It's not finished yet, I'm not sure it there is any sense in supporting border types etc. AFAICT, Asciidoc doesn't

Re: [HACKERS] printing table in asciidoc with psql

2014-10-29 Thread Szymon Guz
On 17 October 2014 09:01, Pavel Stehule pavel.steh...@gmail.com wrote: Hi Szymon I found a small bug - it doesn't escape | well postgres=# select * from mytab ; a | numeric_b | c --+---+ Ahoj |10 | 2014-10-17 Hello|20 |

Re: [HACKERS] printing table in asciidoc with psql

2014-10-30 Thread Szymon Guz
On 30 October 2014 09:04, Pavel Stehule pavel.steh...@gmail.com wrote: 2014-10-29 12:23 GMT+01:00 Szymon Guz mabew...@gmail.com: On 17 October 2014 09:01, Pavel Stehule pavel.steh...@gmail.com wrote: Hi Szymon I found a small bug - it doesn't escape | well postgres=# select * from

Re: [HACKERS] printing table in asciidoc with psql

2014-11-14 Thread Szymon Guz
On 14 November 2014 20:57, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Is anyone going to submit a new version of this patch? Hi Alvaro, due to family issues I will not be able to work on it for the next 10 days. regards, Szymon

Re: [HACKERS] Help needed for PL/Ruby

2015-05-01 Thread Szymon Guz
On 29 April 2015 at 21:45, Szymon Guz mabew...@gmail.com wrote: Hi Devrim, I will take a look at this. regards, Szymon On 29 April 2015 at 18:24, Devrim Gündüz dev...@gunduz.org wrote: Hi, Anyone? :) Regards, Devrim On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote: Hi