[HACKERS] Function sugnature with default parameter

2014-02-26 Thread salah jubeh
Hello, I find default values confusing when a function is overloaded, below is an example. CREATE OR REPLACE FUNCTION default_test (a INT DEFAULT 1, b INT DEFAULT 1, C INT DEFAULT 1) RETURNS INT AS $$     BEGIN         RETURN a+b+c;     END; $$ LANGUAGE 'plpgsql'; CREATE OR REPLACE FUNCTION

Re: [HACKERS] Function sugnature with default parameter

2014-02-26 Thread salah jubeh
the default parameters are defined; but also, they are affecting overloading. May be, a warning message when creating a function like above would be nice. Regards On Wednesday, February 26, 2014 7:51 PM, Josh Berkus j...@agliodbs.com wrote: On 02/26/2014 10:15 AM, salah jubeh wrote: I think

Re: [HACKERS] Add force option to dropdb

2014-01-31 Thread salah jubeh
for doubling your work. I have updated the patch.  Regards On Wednesday, January 29, 2014 8:50 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Jan 29, 2014 at 4:56 AM, salah jubeh s_ju...@yahoo.com wrote: I'm not particularly in favor of implementing this as client-side functionality

Re: [HACKERS] Add force option to dropdb

2014-01-31 Thread salah jubeh
: On Fri, Jan 31, 2014 at 9:09 AM, salah jubeh s_ju...@yahoo.com wrote: $ createdb -U postgres hoge $ psql -d hoge -U postgres hoge=# create table test (col text); hoge=# insert into test select repeat(chr(code),1) from generate_series(1,10) code; Execute dropdb -k while the client

Re: [HACKERS] Add force option to dropdb

2014-01-29 Thread salah jubeh
Hello Robert, I'm not particularly in favor of implementing this as client-side functionality, because then it's only available to people who use that particular client.  Simon Riggs proposed a server-side option to the DROP DATABASE command some time ago, and I think that might be the way to

Re: [HACKERS] Add force option to dropdb

2014-01-28 Thread salah jubeh
wrote: On 2014年1月17日 0:56, salah jubeh s_ju...@yahoo.com wrote: If the user owns objects, that will prevent this from working also.  I have the feeling that adding DROP OWNED BY and/or REASSIGNED OWNED BY calls to this utility would be a bit excessive, but who knows. Please find attached

[HACKERS] bison, flex and ./configure

2014-01-28 Thread salah jubeh
Hello, Today, I have noticed that ./configure does not return an error when bison and flex are missing.  Is this intended ? OS: Ubuntu 13.04 Regards

Re: [HACKERS] bison, flex and ./configure

2014-01-28 Thread salah jubeh
. For curiosity reasons why the differentiation between tar and git. Regards On Tuesday, January 28, 2014 3:18 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 01/28/2014 04:14 PM, salah jubeh wrote: Today, I have noticed that ./configure does not return an error when bison

Re: [HACKERS] bison, flex and ./configure

2014-01-28 Thread salah jubeh
Hello Heikki, Thanks for sharing. Reagrds On Tuesday, January 28, 2014 3:48 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 01/28/2014 04:28 PM, salah jubeh wrote: Yes. Bison and flex are not required when building from a source tarball, because the tarball includes

Re: [HACKERS] Add force option to dropdb

2014-01-16 Thread salah jubeh
an option -k, --kill instead of force since killing client connection does not guarantee -drop force-.  Regards On Tuesday, January 14, 2014 8:06 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: salah jubeh wrote: For the sake of completeness: 1. I think also, I need also to temporary

[HACKERS] Add force option to dropdb

2014-01-14 Thread salah jubeh
Hello, I think adding a force option to dropdb is usefull for many purposes, mainly; scripting. For example, in a test enviroment, I restore a daily backup of production databases. The newly created databases are used as templates for development and also for reading, thus replacing them is