Re: [pgadmin-support] default parameters

2012-07-24 Thread Maximilian Tyrtania
Am 24.07.2012 um 10:37 schrieb Michal Kozusznik: >>> Actually I do have 2 releases. After I noticed that problem in 14.2 > > For windows version this bug appeared in 14.3 for postgresql versions lower > than 9. > 14.2 works fine. Ah, yes, sorry. It's working fine on Mac OS in 14.2 but not in 14

Re: [pgadmin-support] default parameters

2012-07-24 Thread Michal Kozusznik
Actually I do have 2 releases. After I noticed that problem in 14.2 For windows version this bug appeared in 14.3 for postgresql versions lower than 9. 14.2 works fine. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.p

Re: [pgadmin-support] default parameters

2012-07-24 Thread Guillaume Lelarge
On Tue, 2012-07-24 at 06:37 +0200, Maximilian Tyrtania wrote: > Am 23.07.2012 um 18:49 schrieb Guillaume Lelarge: > > > Well, I have the same details for my own function. I don't know what to > > tell you. Are you sure you don't have two releases of pgAdmin on your > > machine? > > Actually I do

Re: [pgadmin-support] default parameters

2012-07-23 Thread Maximilian Tyrtania
Am 23.07.2012 um 18:49 schrieb Guillaume Lelarge: > Well, I have the same details for my own function. I don't know what to > tell you. Are you sure you don't have two releases of pgAdmin on your > machine? Actually I do have 2 releases. After I noticed that problem in 14.2 I installed 1.16 beta

Re: [pgadmin-support] default parameters

2012-07-23 Thread Guillaume Lelarge
On Mon, 2012-07-23 at 09:35 +0200, Maximilian Tyrtania wrote: > Ah, no problem, here you go. > > test=# SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, > test-# typns.nspname AS typnsp, lanname, proargnames, > test-# pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regcla

Re: [pgadmin-support] default parameters

2012-07-21 Thread Guillaume Lelarge
On Fri, 2012-07-20 at 20:25 +0200, Maximilian Tyrtania wrote: > Am 20.07.2012 um 18:36 schrieb Guillaume Lelarge: > > > Nope. I'm quite puzzled. Can you give me the result of these queries? > > Sure. > > > SELECT count(*) FROM pg_attribute > > WHERE attrelid = 'pg_catalog.pg_proc'::regclass > >

Re: [pgadmin-support] default parameters

2012-07-20 Thread Guillaume Lelarge
On Fri, 2012-07-20 at 15:38 +0200, Maximilian Tyrtania wrote: > Hi Guillaume, > > strange…please take a look at > > > Is there something you're doing differently? > Nope. I'm quite puzzled. Can you give me the result of these queri

Re: [pgadmin-support] default parameters

2012-07-20 Thread Maximilian Tyrtania
Hi Guillaume, strange…please take a look at Is there something you're doing differently? Maximilian Tyrtania http://www.contactking.de > Still works for me on PostgreSQL 9.0.8, and pgAdmin 1.16 and 1.17. > Doesn't work on 1.14 but,

Re: [pgadmin-support] default parameters

2012-07-18 Thread Guillaume Lelarge
On Wed, 2012-07-18 at 16:22 +0200, Maximilian Tyrtania wrote: > Am 02.07.2012 um 22:46 schrieb Guillaume Lelarge: > > > On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote: > >> Hi, > >> > >> There is a function with the default parameter: > >> > >> CREATE OR REPLACE FUNCTION test(p_int i

Re: [pgadmin-support] default parameters

2012-07-18 Thread Maximilian Tyrtania
Am 02.07.2012 um 22:46 schrieb Guillaume Lelarge: > On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote: >> Hi, >> >> There is a function with the default parameter: >> >> CREATE OR REPLACE FUNCTION test(p_int integer *default 1*) >> RETURNS void AS >> $BODY$declare >> begin >> --foo; >>

Re: [pgadmin-support] default parameters

2012-07-03 Thread Kozusznik Michal
I repored this bug already. try 1.14.2 MK 2. 7. 2012 v 13:09, "Andrey Vinogradov" mailto:octo...@gmail.com>>: Hi, There is a function with the default parameter: CREATE OR REPLACE FUNCTION test(p_int integer default 1) RETURNS void AS $BODY$declare begin --foo; end;$BODY$ LANGUAGE plpgsql

Re: [pgadmin-support] default parameters

2012-07-02 Thread Guillaume Lelarge
On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote: > Hi, > > There is a function with the default parameter: > > CREATE OR REPLACE FUNCTION test(p_int integer *default 1*) > RETURNS void AS > $BODY$declare > begin > --foo; > end;$BODY$ > LANGUAGE plpgsql VOLATILE > COST 100; > >

[pgadmin-support] default parameters

2012-07-02 Thread Andrey Vinogradov
Hi, There is a function with the default parameter: CREATE OR REPLACE FUNCTION test(p_int integer *default 1*) RETURNS void AS $BODY$declare begin --foo; end;$BODY$ LANGUAGE plpgsql VOLATILE COST 100; The object browser of the pgAdmin III has been refreshed more than once. The SQL query o