On 29 April 2015 at 21:45, Szymon Guz wrote:
> Hi Devrim,
> I will take a look at this.
>
> regards,
> Szymon
>
> On 29 April 2015 at 18:24, Devrim Gündüz wrote:
>
>>
>> Hi,
>>
>> Anyone? :)
>>
>> Regards, Devrim
>>
Hi Devrim,
I will take a look at this.
regards,
Szymon
On 29 April 2015 at 18:24, Devrim Gündüz wrote:
>
> Hi,
>
> Anyone? :)
>
> Regards, Devrim
>
> On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote:
> > Hi,
> >
> > Background info first: PL/Ruby was originally maintained by Guy Decoux,
>
On 14 November 2014 20:57, Alvaro Herrera 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 wrote:
>
>
> 2014-10-29 12:23 GMT+01:00 Szymon Guz :
>
>>
>>
>> On 17 October 2014 09:01, Pavel Stehule wrote:
>>
>>> Hi Szymon
>>>
>>> I found a small bug - it doesn't escape "|
On 17 October 2014 09:01, Pavel Stehule 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 | 2014-10-18
> H
On 17 September 2014 19:55, Szymon Guz wrote:
>
>
> On 17 September 2014 19:30, Peter Eisentraut 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.
On 17 September 2014 19:30, Peter Eisentraut 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) y
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 ar
On 3 September 2014 01:08, Jan Wieck 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 hea
On 22 August 2014 17:06, Tom Lane wrote:
> Szymon Guz 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"
>
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 (tags/RELEASE_
On 21 February 2014 13:49, firoz e v 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 group, the s
On 21 November 2013 21:15, Szymon Guz wrote:
>
>
>
> On 21 November 2013 20:20, Pavel Stehule wrote:
>
>> So here is patch for 9.4
>>
>> 7 new line styles, 2 new border styles, \pset border autocomplete
>>
>> Regards
>>
>> Pavel
>>
On 21 November 2013 20:20, Pavel Stehule 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
>
>> On 21 November 2013 08:09, Pavel Stehule w
On 21 November 2013 08:09, Pavel Stehule 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 feature is genera
On 19 November 2013 23:02, Szymon Guz wrote:
> On 19 November 2013 22:54, Kevin Grittner wrote:
>
>> Szymon Guz wrote:
>>
>> > is clang supported for compiling Postgres? I found some websites
>> > with information that some people compiled Postgres succesfu
On 19 November 2013 22:54, Kevin Grittner wrote:
> Szymon Guz 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 ./configure.
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 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 fro
On 12 August 2013 18:37, Peter Eisentraut 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 results as JSO
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
On 29 July 2013 13:20, Pavel Stehule wrote:
> 2013/7/29 Szymon Guz :
> > On 29 July 2013 11:25, Pavel Stehule wrote:
> >>
> >> Hello
> >>
> >> In 9.3 super user can cancel all queries or user can cancel own
> sessions.
> >>
> >>
On 29 July 2013 11:25, Pavel Stehule 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 means that a db o
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 7 July 2013 21:35, Peter Eisentraut 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
On 6 July 2013 17:58, Claudio Freire 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"
>test_type_conversion_numeric
> -
On 28 June 2013 22:29, Claudio Freire wrote:
> On Fri, Jun 28, 2013 at 5:14 PM, Steve Singer wrote:
> > On 06/27/2013 05:04 AM, Szymon Guz wrote:
> >>
> >> On 27 June 2013 05:21, Steve Singer >> <mailto:st...@ssinger.info>> wrote:
> >>
On 30 June 2013 14:45, Andres Freund wrote:
> On 2013-06-30 14:42:24 +0200, Szymon Guz wrote:
> > On 30 June 2013 14:31, Martijn van Oosterhout wrote:
> >
> > > On Sun, Jun 30, 2013 at 02:18:07PM +0200, Szymon Guz wrote:
> > > > > python does not any any s
On 30 June 2013 14:31, Martijn van Oosterhout 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:13, Andrew Dunstan 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 inter
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 h
On 28 June 2013 22:14, Steve Singer 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 attached patch shoul
On 27 June 2013 05:21, Steve Singer 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
>> De
On 26 June 2013 22:08, Szymon Guz wrote:
> On 26 June 2013 21:59, Peter Eisentraut 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
On 26 June 2013 21:59, Peter Eisentraut 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.
>
> C
On 26 June 2013 21:10, Josh Berkus 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 write
>
On 26 June 2013 20:57, Szymon Guz wrote:
> On 26 June 2013 20:55, Josh Berkus 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 &
On 26 June 2013 20:55, Josh Berkus 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 k
On 26 June 2013 12:04, Ronan Dunklau 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
> converted n
You had a great idea, the time with cdecimal is really great, the
difference on my machine is 64 ms vs 430 ms.
Szymon
the performance test from steve, on my machine:
>
> - with cdecimal installed: ~84ms
> - without cdecimal installed (standard decimal module): ~511ms
>
>
> 2013/6/26 Szymon Guz
>
>> On 26 June 2013 01:40, Steve Singer wrote:
>>
>>> On 06/25/2013 06:42 AM, Szymo
t;
>> I'll try to install a VM on a make-shift laptop and get something going
>> to respond as soon as is possible.
>>
>> Thanks
>> --
>> Robins Tharakan
>>
>> --
>> Robins Tharakan
>>
>>
>> On 17 June 2013 05:19,
On 26 June 2013 01:40, Steve Singer 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 prev
/2.2
>
> It may 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
>
>> On 25 June 2013 05:16, Steve Singer wrote:
>>
>>> On 0
On 25 June 2013 05:16, Steve Singer 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/To
On 25 June 2013 05:16, Steve Singer 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 x(a numeri
On 25 June 2013 08:51, Pavel Stehule wrote:
> Hello
>
> 2013/6/25 Szymon Guz :
> > Hi,
> > I've got a couple of questions.
> >
> > I was using numeric_out like this:
> >
> > DatumGetCString(DirectFunctionCall1(numeric_out, d));
> >
> &g
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 n
On 14 March 2013 03:45, Peter Eisentraut 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 detected some y
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 tweaks.
On 18 June 2013 17:29, Kevin Grittner wrote:
> Szymon Guz 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 hi
On 18 June 2013 13:10, Michael Paquier wrote:
> On Tue, Jun 18, 2013 at 7:01 PM, Szymon Guz 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 to the commitfest app, t
On 18 June 2013 02:33, Robins Tharakan 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 wrote:
>
>> On 26 May 2013 19:56, Robins Tha
On 26 May 2013 19:56, Robins Tharakan 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
>
>
> --
> Sen
On 23 May 2013 00:34, Robins Tharakan 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 (pgsql-h
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 f
On 28 May 2013 17:53, Josh Berkus 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
> > ab
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 14:15, Jan Urbański 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,
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 l
On 28 May 2013 12:07, Pavel Stehule wrote:
> Hello
>
> 2013/5/28 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
>
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 wa
On 28 May 2013 01:55, Peter Eisentraut wrote:
> On Mon, 2013-05-27 at 20:43 -0300, Claudio Freire wrote:
> > On Mon, May 27, 2013 at 8:13 PM, Peter Eisentraut
> wrote:
> > > On Fri, 2013-05-24 at 16:46 -0300, Claudio Freire wrote:
> > >> Well, it's easy.
> > >>
> > >> Instead of PLyFloat_FromNum
On 24 May 2013 21:46, Claudio Freire wrote:
> On Fri, May 24, 2013 at 4:22 PM, Szymon Guz 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 24 May 2013 21:14, Claudio Freire wrote:
> On Fri, May 24, 2013 at 4:10 PM, Szymon Guz 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
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 p
On 7 May 2013 21:23, Pavel Stehule 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 := new;
> return
On 27 February 2013 10:20, Miroslav Šimulčík wrote:
> 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
regards
Szymon
On 31 October 2012 14:52, Pavel Stehule wrote:
> tested on 9.3
>
> Pavel
>
> 2012/10/31 Pavel Stehule :
> > Hello
> >
> > it is expected behave?
> >
> > 1.session
> >
> > postgres=# begin;
> > BEGIN
> > postgres=# lock oo IN ACCESS EXCLUSIVE MODE;
> > LOCK TABLE
> >
> > 2. session
> >
> > postgre
On 18 November 2011 23:26, Kevin Grittner wrote:
> 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 creating a "normal" view, and t
On 4 November 2011 10:20, Miroslav Šimulčík 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 operation on it.
> Both o
On 11 May 2011 12:06, Andres Freund 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 some info on t
On 11 May 2011 11:01, Andreas Joseph Krogh wrote:
> På onsdag 11. mai 2011 kl 10:56:19 skrev :
> > > 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 TAB
On 11 May 2011 10:56, 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 $$
>
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 t
On 13 December 2010 23:52, Marko Tiikkaja wrote:
> 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 the state "it
> looks lik
On 5 November 2010 20:36, Alvaro Herrera 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 end, just like a t
On 21 September 2010 23:02, Pei He 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"?
78 matches
Mail list logo