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
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
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
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 |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
.
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
:
- 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
You had a great idea, the time with cdecimal is really great, the
difference on my machine is 64 ms vs 430 ms.
Szymon
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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 :=
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
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.
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
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
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
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
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:
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
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
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
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?
77 matches
Mail list logo
