Re: [pgadmin-hackers] New committer: Akshay Joshi

[Guillaume Lelarge]

Le 6 mai 2016 10:25 AM, "Dave Page"  a écrit :
>
> All,
>
> I'm pleased to announce that Akshay Joshi has been added to the
> pgAdmin 4 project as our newest committer. Akshay has been working on
> pgAdmin 3 for a number of years now, and has done some excellent work
> on pgAdmin 4, being primarily responsible for the Query Tool amongst
> other work.
>
> Congratulations Akshay!
>

Congrats Akshay! That's well deserved.

[pgadmin-hackers] pgAdmin III commit: Update german translation

[Guillaume Lelarge]

Update german translation

Branch
--
REL-1_22_0_PATCHES

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=1dcba67dd3d5c07d5bce34b316b78dca0dd1d982
Author: Julian Schauder 

Modified Files
--
i18n/de_DE/pgadmin3.mo |   Bin 272932 -> 272947 bytes
i18n/de_DE/pgadmin3.po | 60694 +++
2 files changed, 30347 insertions(+), 30347 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Update german translation

[Guillaume Lelarge]

Update german translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=d00526e4b717ffcd3d981259b5534b27e43b5ed2
Author: Julian Schauder 

Modified Files
--
i18n/de_DE/pgadmin3.mo |   Bin 272932 -> 272947 bytes
i18n/de_DE/pgadmin3.po | 60694 +++
2 files changed, 30347 insertions(+), 30347 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] ]GTK 3

[Guillaume Lelarge]

2016-01-05 23:54 GMT+01:00 Björn Harrtell :

> Found the theme color issue.
>
> Server node color is customizable and new server nodes are created with
> background from window and saved in .pgadmin3.
>
> I don't see the usefulness of this feature so I've attached patch that
> removes it.
>
>
-1

I didn't see either when it was commited, but I know many users who are
really fond of the feature. It helps them track which kind of servers
they're connected to (production, testing, dev, etc).


> I see there is alot of work to be done to modernize the usage of wxWidgets
> to take advantage of new widgets for trees, lists and toolbar and perhaps
> even the grid. Any interest in contributions towards this?
>
>
I would say yes, but be aware that the next major release of pgAdmin (as in
pgAdmin IV) won't use wxwidgets.


> /Björn
>
> PS. Dug alot into the code base to finally discover the above and noticed
> there is *alot* of work to do to properly go to wxWidgets 3.0+.
>
>
Sure as well.


> 2015-12-18 14:35 GMT+01:00 Björn Harrtell :
>
>> Thanks,
>>
>> I'm on Debian testing and have just managed to compile wxWindows 3.0.2
>> against GTK 3.18, then pgadmin3 against that.
>>
>> I'm surprised to report that it compiles and runs fine! I'm impressed by
>> the API compatibility of wxWindows.
>>
>> However, my initial reason for exploring this was that the standard
>> pgadmin3 compiled against GTK 2 wasn't themed to my GNOME 3 desktop which I
>> thought would be resolved by using GTK 3 but it does not. Some elements
>> works as expected, like for instance the GTK 3 file browser is opened, but
>> other issues remain. The most glaring example is that the browser tree
>> items have a white background regardless of theme (applies to both GTK 2
>> and 3), and will be unreadable if using dark themes (that have light
>> colored text).
>>
>> /Björn
>>
>> 2015-12-18 14:04 GMT+01:00 Timon :
>>
>>> I've tried to build under fedora 23
>>>
>>> ./configure CXXFLAGS="-W./configure --with-wx-version=3.0
>>> CXXFLAGS="-Wno-deprecated-declarations -Wl,-z,lazy -fPIC -pie"
>>> CFLAGS="-fPIC -pie"
>>> make -j 10
>>>
>>> but it failed on linking stage with errors like
>>>
>>> pgAdmin3.o: In function `wxCreateApp()':
>>> pgAdmin3.cpp:(.text+0x16): undefined reference to
>>> `wxAppConsole::CheckBuildOptions(char const*, char const*)'
>>> pgAdmin3.o: In function `frmDlgTest::frmDlgTest()':
>>> pgAdmin3.cpp:(.text+0x381): undefined reference to `wxDir::~wxDir()'
>>> pgAdmin3.cpp:(.text+0x423): undefined reference to `wxDir::~wxDir()'
>>> pgAdmin3.o: In function `pgAdmin3::OnInit()':
>>> .
>>>
>>> 2015-12-18 14:35 GMT+03:00 Björn Harrtell :
>>>
 Hi devs,

 Have anyone investigated compiling pgadmin using wxWidgets > 2.9.4 and
 GTK+ 3 which can be enabled with configure option --with-gtk=3?

 I'm putting an effort into it now and will share results here, but will
 appreciate information from anyone with existing experience.

 /Björn

>>>
>>>
>>>
>>> --
>>> All bugs reserved
>>>
>>
>>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>
>


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] pgAdmin III commit: Update polish translation

[Guillaume Lelarge]

Hi,

My bad. I though you pushed on another translation. I should have checked.
My apologies to Begina, and you.

2015-11-18 20:14 GMT+01:00 Begina Felicysym <begina.felicy...@wp.pl>:

> Hi,
>
> I would suggest - the one containing
>
> "Query returned successfully: one row affected, %s execution time."
>
> is more adequate for the "HEAD" revision of ".pot" file.
>
> Although I could be wrong.
>

Meaning yours, I guess? (current HEAD doesn't have this sentence in the
polish PO file.)

The translation I got from Slawek Sudnik was sent a few days before you
sent yours. But I have no idea which one is better.

Strictly on the number of transactions, HEAD is at 4375 translated
messages, 2 fuzzy translations. Yours is at 4401 translated messages, 1
fuzzy translation. Sounds like yours is more uptodate.

Slawek, what's your opinion on this matter?


> Cheers
>
>
>
>
>
> Dnia Środa, 18 Listopada 2015 10:32 Dave Page <dp...@pgadmin.org>
> napisał(a)
>
> HI
>
>
>
> I updated that that translation just a couple of days ago. Do you know
>
> which is the most complete?
>
>
>
> On Mon, Nov 16, 2015 at 9:51 PM, Guillaume Lelarge
>
> <guilla...@lelarge.info> wrote:
>
> > Update polish translation
>
> >
>
> > Branch
>
> > --
>
> > master
>
> >
>
> > Details
>
> > ---
>
> >
> http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=bb39d717478de4a6d8e24df4f1551a37fa9fdd41
>
> > Author: Slawek Sudnik <slaw...@inbox.com>
>
> >
>
> > Modified Files
>
> > --
>
> > i18n/pl_PL/pgadmin3.mo |  Bin 337247 -> 334230 bytes
>
> > i18n/pl_PL/pgadmin3.po | 3887
> +++-
>
> > 2 files changed, 1854 insertions(+), 2033 deletions(-)
>
> >
>
> >
>
> > --
>
> > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
>
> > To make changes to your subscription:
>
> > http://www.postgresql.org/mailpref/pgadmin-hackers
>
>
>
>
>
>
>
> --
>
> Dave Page
>
> Blog: http://pgsnake.blogspot.com
>
> Twitter: @pgsnake
>
>
>
> EnterpriseDB UK: http://www.enterprisedb.com
>
> The Enterprise PostgreSQL Company
>
>
>
>
>
> --
>
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgadmin-hackers
>
>
>
>
>
>


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update polish translation

[Guillaume Lelarge]

Update polish translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=bb39d717478de4a6d8e24df4f1551a37fa9fdd41
Author: Slawek Sudnik 

Modified Files
--
i18n/pl_PL/pgadmin3.mo |  Bin 337247 -> 334230 bytes
i18n/pl_PL/pgadmin3.po | 3887 +++-
2 files changed, 1854 insertions(+), 2033 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] New translation for pgAdmin

[Guillaume Lelarge]

Hi,

Sorry for answering this late.

I just commited your translation.

Regards.


2015-10-23 23:46 GMT+02:00 Slawek Sudnik :

> Hi,
>
> I send new polish translation.
>
> Regards
> Slawek
> --
> Free Online Photosharing - Share your photos online with your friends and
> family!
> Visit http://www.inbox.com/photosharing to find out more!
>



-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] bug tracker should be listed on Development page

[Guillaume Lelarge]

2015-05-03 16:37 GMT+02:00 Adam Dingle a...@medovina.org:

 pgAdmin apparently has a Redmine project that tracks known bugs, listed at

 https://redmine.postgresql.org/projects/pgadmin3/issues

 That's great.  It doesn't seem to be too active, though - only three
 issues were updated in 2014, and none so far in 2015.  I bet that's because
 it's hard to find: the bug tracker is not mentioned on the pgAdmin
 Development page at

 http://www.pgadmin.org/development/

 Could a link be added there?  Thanks -


It's more an internal bugtracker than something else. I used to use it
quite frequently when I was working on pgAdmin's code, but I'm pretty sure
I was the only one.

In any case, it's quite obsolete, unused, and would better be dropped
rather than publicized.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] bug tracker should be listed on Development page

[Guillaume Lelarge]

2015-05-03 16:48 GMT+02:00 Adam Dingle a...@medovina.org:

 On Sun, May 3, 2015 at 10:42 AM, Guillaume Lelarge guilla...@lelarge.info
 wrote:

 2015-05-03 16:37 GMT+02:00 Adam Dingle a...@medovina.org:

 pgAdmin apparently has a Redmine project that tracks known bugs, listed at

 https://redmine.postgresql.org/projects/pgadmin3/issues

 That's great.  It doesn't seem to be too active, though - only three
 issues were updated in 2014, and none so far in 2015.  I bet that's because
 it's hard to find: the bug tracker is not mentioned on the pgAdmin
 Development page at

 http://www.pgadmin.org/development/

 Could a link be added there?  Thanks -


 It's more an internal bugtracker than something else. I used to use it
 quite frequently when I was working on pgAdmin's code, but I'm pretty sure
 I was the only one.

 In any case, it's quite obsolete, unused, and would better be dropped
 rather than publicized.


 That's too bad - I think every free software project should have a bug
 tracker.  Why not publicize it and encourage everyone to use it actively?


Well, I guess you should ask the current devs on this. The first reason
would be that having a bug tracker has a cost. You need time to make sure
the tickets are not obsolete. And seeing how some projects are overcrowded
by obsolete bug reports, I'm glad we don't have an official bug tracker.

I prefer how PostgreSQL handles it. Declaration of bugs happens on any
mailing list. Sure, there is a specific list for bugs but you can declare
and talk about them on any list. There's no buttracker, and still bugs are
fixed. Much simpler to my point of view.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] TODO list

[Guillaume Lelarge]

2015-03-11 8:40 GMT+01:00 Prasad prasa...@mail.com:

 Hi,

 How up to date is this list ?


Let's say it could use some updates :)


 http://www.pgadmin.org/development/todo.php

 Had cursory glance, and second item in Essentials appear to be already
 done.




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] Translator

[Guillaume Lelarge]

Hi,

Le 13 janv. 2015 15:20, Mads Jensen m...@inducks.org a écrit :

 On 01/13/2015 02:38 PM, Gregori Bedin wrote:
  Hello, i wish to participate in the pgadmin translation for pt_BR
  (portuguese - Brazilian).
  How can i help?

 #: pgadmin/dlg/dlgTable.cpp:1804 pgadmin/dlg/dlgTable.cpp:1775
 msgid All type's columns will be dropped. Are you sure you want to do
 this?
 msgstr 

 Translate strings like this, and send back a patch for the differences
 between your working file, and the one in the repository.


Please do not send patches. Send the whole file. And read
http://pgadmin.org/translation/howto.php for more details.

Re: [pgadmin-hackers] pgAdmin GA Build

[Guillaume Lelarge]

Thanks, but I don't have anything left to commit.

2014-12-15 9:56 GMT+01:00 Dave Page dp...@pgadmin.org:

 I'll be cutting the GA tarball at around 3PM UK time today. Please ensure
 all final translation updates etc. are committed by then.

 Thanks!

 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company



-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] pgAdmin III commit: Fix the query editor behaviour with COPY

[Guillaume Lelarge]

Hi,

2014-12-05 10:46 GMT+01:00 José Pino p...@getyourguide.com:

 Hi Guillaume,

 Is it not possible to change this limit? As a user, why I can't define
 this row limit in 200 or 1000?


Most likely because nobody bothered to write a patch for this. Actually,
that's the first time I hear someone complaining about this. Note that it
wouldn't be complex to do, but I don't really see the point: you're not
supposed to use COPY in the query editor. That's the wrong tool for it.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin website commit: Update website czech translation

[Guillaume Lelarge]

Update website czech translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=882348088edeab29a0cc124f203d2b70c10c129d
Author: Marek Cernocky ma...@manet.cz

Modified Files
--
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.mo |  Bin 171932 - 173792 bytes
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.po |  199 --
2 files changed, 184 insertions(+), 15 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Update .pot file

[Guillaume Lelarge]

Update .pot file

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=7e2ca16e9a5be1fa511d05b05bb3d07007ed746f

Modified Files
--
locale/pgadmin3_website.pot |  232 ---
1 file changed, 197 insertions(+), 35 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Automatic stringmerge using merge script.

[Guillaume Lelarge]

Automatic stringmerge using merge script.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=4802864d1836787cdbc57ac76a60cf3946063f79

Modified Files
--
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.mo |  Bin 127084 - 127084 bytes
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.po |  256 +
locale/es_SV/LC_MESSAGES/pgadmin3_website.mo |  Bin 125625 - 125625 bytes
locale/es_SV/LC_MESSAGES/pgadmin3_website.po |  275 ++-
locale/fr_FR/LC_MESSAGES/pgadmin3_website.mo |  Bin 181796 - 179606 bytes
locale/fr_FR/LC_MESSAGES/pgadmin3_website.po |  312 --
locale/pl_PL/LC_MESSAGES/pgadmin3_website.mo |  Bin 171017 - 170733 bytes
locale/pl_PL/LC_MESSAGES/pgadmin3_website.po |  278 ++-
locale/ru_RU/LC_MESSAGES/pgadmin3_website.mo |  Bin 225261 - 222366 bytes
locale/ru_RU/LC_MESSAGES/pgadmin3_website.po |  299 +++-
locale/zh_CN/LC_MESSAGES/pgadmin3_website.mo |  Bin 151017 - 150795 bytes
locale/zh_CN/LC_MESSAGES/pgadmin3_website.po |  271 ++
12 files changed, 1369 insertions(+), 322 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: More translatable strings

[Guillaume Lelarge]

More translatable strings

1. Button texts Go and Google Search stay untranslated
2. Language names in tables on the translation status page stay untranslated

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=c1c805a1cb23ca4a59a377049550304e06f8b738
Author: Marek Cernocky ma...@manet.cz

Modified Files
--
include/page.php   |4 +--
include/po_status.php  |2 +-
translation/config.php |   88 
3 files changed, 47 insertions(+), 47 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Update czech website translation

[Guillaume Lelarge]

Update czech website translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=0aec418a6171d2637079fd18f600da5a34cc054e
Author: MARVINS sro marv...@manet.cz

Modified Files
--
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.mo |  Bin 127084 - 171932 bytes
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.po |12127 +++---
2 files changed, 4943 insertions(+), 7184 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Bad string from the translation point of view

[Guillaume Lelarge]

2014-11-29 4:46 GMT+01:00 Ashesh Vashi ashesh.va...@enterprisedb.com:


 On 29 Nov 2014 03:09, Guillaume Lelarge guilla...@lelarge.info wrote:
 
  2014-11-28 15:13 GMT+01:00 Ashesh Vashi ashesh.va...@enterprisedb.com:
 
  On Fri, Nov 28, 2014 at 3:48 AM, Marek Černocký ma...@manet.cz wrote:
 
  The construction:
 
  if (wxMessageBox(_(Are you sure you wish to move objects from ) +
  GetQuotedFullIdentifier() + _( to ) + rdo.GetTablespace() + _(?),
  _(Move tablespace?), wxYES_NO) != wxYES)
  return;
 
  in pgadmin/schema/pgTablespace.cpp is bad from the point of view of
  translation. It should be:
 
  if (wxMessageBox(wxString::Format(_(Are you sure you wish to move
  objects from %s to %s?), GetQuotedFullIdentifier(),
  rdo.GetTablespace()), _(Move tablespace?), wxYES_NO) != wxYES)
  return;
 
  Agree.
 
  Dave,
 
  Can we consider this as bug?
 
 
  If you mean for 1.18, no. But 1.20, sure.
 I meant for 1.20 only. :)


If it's 1.20 only, I'd say go ahead. There's no point delaying this.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update czech translation

[Guillaume Lelarge]

Update czech translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=46558f439563d8f57fbb7d1b16867d0f74b328a3
Author: Marek Cernocky ma...@manet.cz

Modified Files
--
i18n/cs_CZ/pgadmin3.mo |  Bin 341825 - 346888 bytes
i18n/cs_CZ/pgadmin3.po |50749 
2 files changed, 25347 insertions(+), 25402 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Bad string from the translation point of view

[Guillaume Lelarge]

2014-11-28 15:13 GMT+01:00 Ashesh Vashi ashesh.va...@enterprisedb.com:

 On Fri, Nov 28, 2014 at 3:48 AM, Marek Černocký ma...@manet.cz wrote:

 The construction:

 if (wxMessageBox(_(Are you sure you wish to move objects from ) +
 GetQuotedFullIdentifier() + _( to ) + rdo.GetTablespace() + _(?),
 _(Move tablespace?), wxYES_NO) != wxYES)
 return;

 in pgadmin/schema/pgTablespace.cpp is bad from the point of view of
 translation. It should be:

 if (wxMessageBox(wxString::Format(_(Are you sure you wish to move
 objects from %s to %s?), GetQuotedFullIdentifier(),
 rdo.GetTablespace()), _(Move tablespace?), wxYES_NO) != wxYES)
 return;

 Agree.

 Dave,

 Can we consider this as bug?


If you mean for 1.18, no. But 1.20, sure.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] tabbed query windows

[Guillaume Lelarge]

Le 29 nov. 2014 00:45, Sean Lavine s...@mirrorx.com a écrit :

 I’ve been using pgAdmin for about 4 years now and one of the biggest
desired features that would make a typical dev’s job easier would be tabbed
query windows. Is there anyone working on this already?


It would be an interesting feature. As far as I know, no one is working on
this yet.

[pgadmin-hackers] pgAdmin III commit: Update latvian translation

[Guillaume Lelarge]

Update latvian translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=1eaa48a655a593c78c8255e0bc64ddd609db9436
Author: Rudolfs Mazurs rudolfs.maz...@gmail.com

Modified Files
--
i18n/lv_LV/pgadmin3.mo |  Bin 332507 - 337017 bytes
i18n/lv_LV/pgadmin3.po |  192 +---
2 files changed, 69 insertions(+), 123 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Add missing nodes to graphical explain plan

[Guillaume Lelarge]

Add missing nodes to graphical explain plan

* Insert
* Update
* Delete
* Foreign Scan
* Index Only Scan
* BitmapAnd
* BitmapOr
* Values Scan (shows up as a Seq Scan)
* LockRows
* Merge Append.

Patch per J.F. Oster

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=ccd7a721c8c27ea0cbafd2399b1851dd8c89aa3d

Modified Files
--
CHANGELOG |1 +
pgadmin/ctl/explainShape.cpp  |   42 +-
pgadmin/include/images/ex_bmp_and.png |  Bin 0 - 1006 bytes
pgadmin/include/images/ex_bmp_heap.png|  Bin 1221 - 1106 bytes
pgadmin/include/images/ex_bmp_index.png   |  Bin 1247 - 1172 bytes
pgadmin/include/images/ex_bmp_or.png  |  Bin 0 - 685 bytes
pgadmin/include/images/ex_delete.png  |  Bin 0 - 1129 bytes
pgadmin/include/images/ex_foreign_scan.png|  Bin 0 - 1607 bytes
pgadmin/include/images/ex_index_only_scan.png |  Bin 0 - 498 bytes
pgadmin/include/images/ex_insert.png  |  Bin 0 - 1065 bytes
pgadmin/include/images/ex_lock_rows.png   |  Bin 0 - 1520 bytes
pgadmin/include/images/ex_merge_append.png|  Bin 0 - 980 bytes
pgadmin/include/images/ex_update.png  |  Bin 0 - 1090 bytes
pgadmin/include/images/ex_values_scan.png |  Bin 0 - 913 bytes
pgadmin/include/images/module.mk  |   10 +
pgadmin/pgAdmin3.vcxproj  |   10 +
pgadmin/pgAdmin3.vcxproj.filters  |   30 +
pgadmin/ui/xrcDialogs.cpp | 6852 -
18 files changed, 3517 insertions(+), 3428 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Update spanish translation

[Guillaume Lelarge]

Update spanish translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=1f12c9e011bf1617b50c141a36b4cd68b7cc158d
Author: Eduardo Higuero eduardohigu...@gmail.com

Modified Files
--
i18n/es_ES/pgadmin3.mo |  Bin 339007 - 343718 bytes
i18n/es_ES/pgadmin3.po |  191 +---
2 files changed, 69 insertions(+), 122 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Update catalan translation

[Guillaume Lelarge]

Update catalan translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=bc1898c308a186ea55e95b302fc80e693992eb32
Author: Carme Cerda Torres carmec...@gmail.com

Modified Files
--
i18n/ca_ES/pgadmin3.mo |  Bin 334202 - 338719 bytes
i18n/ca_ES/pgadmin3.po |  195 ++--
2 files changed, 71 insertions(+), 124 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] PATCH: Add missing nodes to graphical explain plan

[Guillaume Lelarge]

2014-11-20 10:03 GMT+01:00 Dave Page dp...@pgadmin.org:

 On Wed, Nov 19, 2014 at 8:01 PM, Guillaume Lelarge
 guilla...@lelarge.info wrote:
  2014-11-18 17:09 GMT+01:00 Dave Page dp...@pgadmin.org:
 
  If Guillaume is satisfied with the code enough to commit it, it can. I
  consider it a bug fix, albeit minor.
 
 
  I didn't check the code. I just looked at the pics, and they feel right
 to
  me. Pretty sure I won't have time to check the code, and commit it,
 before
  the week-end.

 What about at the weekend? Or Monday? :-)


Will try to get it done this week-end.


  On Tue, Nov 18, 2014 at 3:00 PM, J.F. Oster jinfros...@mail.ru wrote:
   Hello Dave,
  
   I wonder if this patch will get into 1.20...
  
   Wednesday, November 5, 2014, 5:25:10 PM, J.F. Oster wrote:
  
   JFO Hello,
  
   JFO Per recent discussion on pgadmin-support (index only scans are
 not
   JFO shown graphically),
  
   JFO Insert
   JFO Update
   JFO Delete
   JFO Foreign Scan
   JFO Index Only Scan
   JFO BitmapAnd
   JFO BitmapOr
   JFO Values Scan (shows up as a Seq Scan)
   JFO LockRows
   JFO + Merge Append.
  
   JFO Please note, that besides 10 new icons there are two icons for
   JFO existing nodes in the attachment, Bitmap Heap Scan and Bitmap
 Index
   JFO Scan.
   JFO I've changed them for unity with BitmapOr, BitmapAnd, which
   hopefully
   JFO will result in an intuitive understanding of the concept by
 users.
   ...
  
  
  
  
   --
   Best regards,
J.F.
  
 
 
 
  --
  Dave Page
  Blog: http://pgsnake.blogspot.com
  Twitter: @pgsnake
 
  EnterpriseDB UK: http://www.enterprisedb.com
  The Enterprise PostgreSQL Company
 
 
  --
  Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
  To make changes to your subscription:
  http://www.postgresql.org/mailpref/pgadmin-hackers
 
 
 
 
  --
  Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com



 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update pgadmin3.pot

[Guillaume Lelarge]

Update pgadmin3.pot

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=6054eb395b04fcad16d6afa2ab9fb7d5fcb2975c

Modified Files
--
pgadmin3.pot |  717 +-
1 file changed, 362 insertions(+), 355 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Automatic merge using stringmerge script.

[Guillaume Lelarge]

Automatic merge using stringmerge script.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=b0269b91063afc7e267decad03c825451038649c

Modified Files
--
i18n/af_ZA/pgadmin3.po |  718 ++--
i18n/ar_SA/pgadmin3.po |  718 ++--
i18n/bg_BG/pgadmin3.po |  718 ++--
i18n/ca_ES/pgadmin3.po |  718 ++--
i18n/cs_CZ/pgadmin3.po |  718 ++--
i18n/da_DK/pgadmin3.po |  718 ++--
i18n/de_CH/pgadmin3.po |  718 ++--
i18n/de_DE/pgadmin3.po |  718 ++--
i18n/el_GR/pgadmin3.po |  718 ++--
i18n/es_ES/pgadmin3.po | 2908 +++-
i18n/fa_IR/pgadmin3.po |  718 ++--
i18n/fi_FI/pgadmin3.po |  718 ++--
i18n/fr_FR/pgadmin3.po |  719 ++--
i18n/gl_ES/pgadmin3.po |  718 ++--
i18n/gu_IN/pgadmin3.po |  717 ++--
i18n/hi_IN/pgadmin3.po |  717 ++--
i18n/hr_HR/pgadmin3.po |  718 ++--
i18n/hu_HU/pgadmin3.po |  718 ++--
i18n/id_ID/pgadmin3.po |  718 ++--
i18n/is_IS/pgadmin3.po |  717 ++--
i18n/it_IT/pgadmin3.po |  718 ++--
i18n/ja_JP/pgadmin3.po |  718 ++--
i18n/ko_KR/pgadmin3.po |  718 ++--
i18n/lt_LT/pgadmin3.po |  718 ++--
i18n/lv_LV/pgadmin3.po |  718 ++--
i18n/mk_MK/pgadmin3.po |  717 ++--
i18n/nb_NO/pgadmin3.po |  718 ++--
i18n/nl_NL/pgadmin3.po |  718 ++--
i18n/pl_PL/pgadmin3.po |  789 ++---
i18n/pt_BR/pgadmin3.po |  718 ++--
i18n/pt_PT/pgadmin3.po |  718 ++--
i18n/ro_RO/pgadmin3.po |  718 ++--
i18n/ru_RU/pgadmin3.po |  718 ++--
i18n/sk_SK/pgadmin3.po |  718 ++--
i18n/sl_SI/pgadmin3.po |  718 ++--
i18n/sr_RS/pgadmin3.po |  718 ++--
i18n/sv_SE/pgadmin3.po |  718 ++--
i18n/te_IN/pgadmin3.po |  717 ++--
i18n/tl_PH/pgadmin3.po |  718 ++--
i18n/tr_TR/pgadmin3.po |  718 ++--
i18n/uk_UA/pgadmin3.po |  717 ++--
i18n/ur_PK/pgadmin3.po |  718 ++--
i18n/vi_VN/pgadmin3.po |  717 ++--
i18n/zh_CN/pgadmin3.po |  718 ++--
i18n/zh_TW/pgadmin3.po |  718 ++--
45 files changed, 17628 insertions(+), 16937 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] v1.20.0rc1 source code uploaded

[Guillaume Lelarge]

2014-11-18 13:08 GMT+01:00 Dave Page dp...@pgadmin.org:

 Hi,

 I've built the 1.20.0-rc1 tarball and uploaded it to

 http://ftp.pgadmin.org/release/v1.20.0-rc1/src/

 Guillaume - can you please finalise the translation updates as we'll
 be releasing GA soon (hopefully)!


I've just sent an email to our translators, so that they can check if their
translations are uptodate.

(and I did the extract/merge/push steps)

Thanks for the reminder.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update french translation

[Guillaume Lelarge]

Update french translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=fd2f55cee5473fddc0f13a6238077933c0c087df

Modified Files
--
i18n/fr_FR/pgadmin3.mo |  Bin 356753 - 356828 bytes
i18n/fr_FR/pgadmin3.po |5 ++---
2 files changed, 2 insertions(+), 3 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] PATCH: Add missing nodes to graphical explain plan

[Guillaume Lelarge]

2014-11-18 17:09 GMT+01:00 Dave Page dp...@pgadmin.org:

 If Guillaume is satisfied with the code enough to commit it, it can. I
 consider it a bug fix, albeit minor.


I didn't check the code. I just looked at the pics, and they feel right to
me. Pretty sure I won't have time to check the code, and commit it, before
the week-end.

On Tue, Nov 18, 2014 at 3:00 PM, J.F. Oster jinfros...@mail.ru wrote:
  Hello Dave,
 
  I wonder if this patch will get into 1.20...
 
  Wednesday, November 5, 2014, 5:25:10 PM, J.F. Oster wrote:
 
  JFO Hello,
 
  JFO Per recent discussion on pgadmin-support (index only scans are not
  JFO shown graphically),
 
  JFO Insert
  JFO Update
  JFO Delete
  JFO Foreign Scan
  JFO Index Only Scan
  JFO BitmapAnd
  JFO BitmapOr
  JFO Values Scan (shows up as a Seq Scan)
  JFO LockRows
  JFO + Merge Append.
 
  JFO Please note, that besides 10 new icons there are two icons for
  JFO existing nodes in the attachment, Bitmap Heap Scan and Bitmap Index
  JFO Scan.
  JFO I've changed them for unity with BitmapOr, BitmapAnd, which
 hopefully
  JFO will result in an intuitive understanding of the concept by users.
  ...
 
 
 
 
  --
  Best regards,
   J.F.
 



 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company


 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] Create option to hide WITH OIDS=FALSE, if OID is disabled

[Guillaume Lelarge]

2014-11-09 8:52 GMT+01:00 Robins Tharakan thara...@gmail.com:

 Hi,

 This is a ping to check if adding this minor feature is okay.

 When the SQL is generated in the ObjectBrowser-SQLPane (for a table), it
 adds OIDS = FALSE, by default. I think that for a while, this has been
 irrelevant (unless of course the table actually has OIDs enabled).

 Hope its okay to add a Check box in Options-Browser-UI Miscellaneous
 (Show if OIDS = FALSE) that allows a user to disable this part of the SQL.

 To confirm,
 - OIDS = TRUE would also show up, irrespective of the value of this
 check-box
 - For now, the Check-Box would be enabled by default

 Let me know if this isn't a great idea.


It'd be better to not have the checkbox, and rely on the value of the
default_with_oids GUC.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] two dimensional statistics in Postgres

[Guillaume Lelarge]

Hi,

2014-11-06 9:57 GMT+01:00 Katharina Büchse katharina.buec...@uni-jena.de:

  Thank you for your help! I'll try in pgsql-hackers then :-)


Good :)



 On 05.11.2014 18:22, Guillaume Lelarge wrote:

 Hi,

 I'm not sure why you thought a mailing list on an admin tool would be a
 better fit,

 if nothing fits, you just choose anything ;-) My first try was even
 someone from the German mailing list (that's why the subject of the mail
 was still German, sorry for that), but after some mail exchange he just
 suggested to write to a developer mailing list. So I read all the
 descriptions of the mailing lists and it was like no -- no -- no --- 


I understand the feeling :) It's not easy to choose the good one.

  but it definitely is not. Don't worry, this isn't a big issue :-)

 Anyway, pgsql-hackers is the list you're looking for.

 On the patch you'd like to work on, I'd advise you someone else is working
 on this. You should read the WIP: multivariate statistics / proof of
 concept thread on the hackers list. I'm pretty sure you could get some
 help from Tomas.

 Patches on this topic are of high interest. If I can be of any help, let
 me know.

 Regards.
 Le 5 nov. 2014 18:03, Katharina Büchse katharina.buec...@uni-jena.de
 a écrit :

 Hi,

 I was unsure to which mailing list to write, in my opinion psql-hackers
 would fit best, but as it is not recommended to write there directly, I'm
 trying here.
 I'm a phd-student at the university of Jena, Thüringen, Germany, in the
 field of data bases, more accurate query optimization.
 I want to implement a system in PostgreSQL that detects column
 correlations and creates statistical data about correlated columns for the
 optimizer. Therefore I need to store two dimensional statistics (especially
 two dimensional histograms) in PostgreSQL. I would like to know where I
 have to touch the source code and make changes, so that the PostgreSQL
 optimizer will also take into consideration my statistical data? I also
 need a possibility to extract data from query results (tuple counts and,
 speaking a little inaccurately, the where-part of the query itself). Of
 course I tried to have a look at the PostgreSQL source code, but it's
 impossible to understand everything within a few weeks or even months

 I'd be grateful for any advices.
 Regards,

 Katharina

 --
 Dipl.-Math. Katharina Büchse
 Friedrich-Schiller-Universität Jena
 Institut für Informatik
 Lehrstuhl für Datenbanken und Informationssysteme
 Ernst-Abbe-Platz 2
 07743 Jena
 Telefon 03641/946367
 Webseite http://users.minet.uni-jena.de/~re89qen/



 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers





-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] zweidimensionale Statistiken in Postgres

[Guillaume Lelarge]

Hi,

I'm not sure why you thought a mailing list on an admin tool would be a
better fit, but it definitely is not. Don't worry, this isn't a big issue
:-)

Anyway, pgsql-hackers is the list you're looking for.

On the patch you'd like to work on, I'd advise you someone else is working
on this. You should read the WIP: multivariate statistics / proof of
concept thread on the hackers list. I'm pretty sure you could get some
help from Tomas.

Patches on this topic are of high interest. If I can be of any help, let me
know.

Regards.
Le 5 nov. 2014 18:03, Katharina Büchse katharina.buec...@uni-jena.de a
écrit :

 Hi,

 I was unsure to which mailing list to write, in my opinion psql-hackers
 would fit best, but as it is not recommended to write there directly, I'm
 trying here.
 I'm a phd-student at the university of Jena, Thüringen, Germany, in the
 field of data bases, more accurate query optimization.
 I want to implement a system in PostgreSQL that detects column
 correlations and creates statistical data about correlated columns for the
 optimizer. Therefore I need to store two dimensional statistics (especially
 two dimensional histograms) in PostgreSQL. I would like to know where I
 have to touch the source code and make changes, so that the PostgreSQL
 optimizer will also take into consideration my statistical data? I also
 need a possibility to extract data from query results (tuple counts and,
 speaking a little inaccurately, the where-part of the query itself). Of
 course I tried to have a look at the PostgreSQL source code, but it's
 impossible to understand everything within a few weeks or even months

 I'd be grateful for any advices.
 Regards,

 Katharina

 --
 Dipl.-Math. Katharina Büchse
 Friedrich-Schiller-Universität Jena
 Institut für Informatik
 Lehrstuhl für Datenbanken und Informationssysteme
 Ernst-Abbe-Platz 2
 07743 Jena
 Telefon 03641/946367
 Webseite http://users.minet.uni-jena.de/~re89qen/



 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] PATCH: Add missing nodes to graphical explain plan

[Guillaume Lelarge]

2014-11-05 15:25 GMT+01:00 J.F. Oster jinfros...@mail.ru:

 Hello,

 Per recent discussion on pgadmin-support (index only scans are not
 shown graphically),

 JFO Insert
 JFO Update
 JFO Delete
 JFO Foreign Scan
 JFO Index Only Scan
 JFO BitmapAnd
 JFO BitmapOr
 JFO Values Scan (shows up as a Seq Scan)
 JFO LockRows
 + Merge Append.

 Please note, that besides 10 new icons there are two icons for
 existing nodes in the attachment, Bitmap Heap Scan and Bitmap Index
 Scan.
 I've changed them for unity with BitmapOr, BitmapAnd, which hopefully
 will result in an intuitive understanding of the concept by users.
 But I was thinking of bitmap index scans as an analogue for Oracle's
 bitmap indexes. Then I've read explanations by Tom Lane
 http://www.postgresql.org/message-id/12553.1135634...@sss.pgh.pa.us
 and it appears that Postgres doesn't build literally a chain of 0's
 and 1's, but an array of tuple pointers. Nevertheless, if it is
 possible, I'd like these two icons to be committed too. You decide :)


Indeed, they look great. I'm more reserved on the index only scan pic, but
it's way better than what we have now :)


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] Fwd: Auto-complete and Calltips in SQL Editor

[Guillaume Lelarge]

2014-10-09 16:32 GMT+02:00 klo uo klo...@gmail.com:

 Hi list,

 Initially I posted this message in general list, where I was suggested to
 use this list instead.
 This is the link to initial message: message
 http://www.postgresql.org/message-id/caa-8ld8vgna4vrhqbuc72n9pqaeapf2yguxvxpekhu-bc1c...@mail.gmail.com

 It was confirmed that pgAdmin uses Scintilla which has interface for
 calltip and auto-complete functions defined in:

 scintilla\src\CallTip.h
 scintilla\src\AutoComplete.h

 with simple implementation described in

 scintilla\doc\ScintillaUsage.html

 or full in SciTE editor.


 As implemented in SciTE these controls are evoked only if user provides
 calltip and auto-completion definitions (through *.api files) and user
 defines triggers for each action.


 These can be seen as helpers at least in these scenarios:

  - novice user learning SQL or PL/pgSQL
  - user learning PostgreSQL extension, like PostGIS
  - user manages own function


 I attached screenshots of these suggestions as they appear in SciTE.



Sorry, I forgot to follow on this. This seems interesting. I'd love to see
a patch for that :)


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] Update Windows project files to VS 2013?

[Guillaume Lelarge]

Le 9 oct. 2014 21:14, Dave Page dp...@pgadmin.org a écrit :

 Does anyone object if I update the Windows project files to Visual
 Studio 2013 format? That's what is being used for the EDB installer
 builds and my MSI packages of pgAdmin now.


Nope. No objection.

Re: [pgadmin-hackers] restore postgres 8.4, help me

[Guillaume Lelarge]

Hi,

2014-09-10 20:20 GMT+02:00 Mr.Sc.Željko Bračika net...@ka.htnet.hr:

   I use postgres 8.4 on some linux mashines

 one machine has crashed, and i have only .tgz backup (all files from dir:
 /var/lib/pgsql/8.4/data/base/70503486/*.*)

 how to restore this data on new machine with postgres 8.4


You should better ask that on pgsql-admin or pgsql-general.

Anyway, if you only have files from /var/lib/pgsql/8.4/data/base/70503486
directory, there's nothing you can do with only these files. Hope you have
a dump of this database.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin website commit: Update website's russian translation

[Guillaume Lelarge]

Update website's russian translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=b57cff77ed3a96166ce57012d0cdc99fdd4a4c83
Author: Alexander Law exclus...@gmail.com

Modified Files
--
locale/ru_RU/LC_MESSAGES/pgadmin3_website.mo |  Bin 217626 - 225261 bytes
locale/ru_RU/LC_MESSAGES/pgadmin3_website.po |   71 +-
2 files changed, 35 insertions(+), 36 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] pgAdmin Website Russian Translation

[Guillaume Lelarge]

Hi,

2014-09-07 6:32 GMT+02:00 Alexander Law exclus...@gmail.com:

 Hello,
 Please commit updated website translation.


Commited, and pushed.

Thanks a lot.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] Fwd: Russian translation for upcoming release

[Guillaume Lelarge]

Pushed. Thank you a lot.


2014-08-26 12:05 GMT+02:00 Timon timo...@gmail.com:

 translated by Dmitriy Olshevskiy olshevski...@bk.ru

 --
 All bugs reserved


 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update russian translation

[Guillaume Lelarge]

Update russian translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=d0f21f091832df02945d6fc6e61ddaf5291e328e
Author: Timon timo...@gmail.com

Modified Files
--
i18n/ru_RU/pgadmin3.mo |  Bin 423803 - 429968 bytes
i18n/ru_RU/pgadmin3.po |  367 +---
2 files changed, 161 insertions(+), 206 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Missing plpgsql.o Symbols on OS X

[Guillaume Lelarge]

Hey David,

Are you sure you wanted to send this to the PgAdmin hackers list?
Le 26 août 2014 22:34, David E. Wheeler da...@justatheory.com a écrit :

 Hackers,

 I’m trying to build Pavel’s plpgsql_check against the 9.4 beta on OS X
 10.9, but get these errors:

  make
 gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
 -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
 -Wformat-security -fno-strict-aliasing -fwrapv
 -I/usr/local/pgsql/lib/pgxs/src/makefiles/../../src/pl/plpgsql/src -bundle
 -multiply_defined suppress -o plpgsql_check.so plpgsql_check.o
 -L/usr/local/pgsql/lib -L/usr/local/lib  -L/usr/local/lib
 -Wl,-dead_strip_dylibs   -bundle_loader /usr/local/pgsql/bin/postgres
 Undefined symbols for architecture x86_64:
   _exec_get_datum_type, referenced from:
   _check_target in plpgsql_check.o
   _plpgsql_build_datatype, referenced from:
   _check_stmt in plpgsql_check.o
   _plpgsql_compile, referenced from:
   _check_plpgsql_function in plpgsql_check.o
   _plpgsql_parser_setup, referenced from:
   _prepare_expr in plpgsql_check.o
   _plpgsql_stmt_typename, referenced from:
   _put_error in plpgsql_check.o
 ld: symbol(s) not found for architecture x86_64
 clang: error: linker command failed with exit code 1 (use -v to see
 invocation)
 make: *** [plpgsql_check.so] Error 1

 Which is odd, because plpgsql_check.c includes plpgsql.h, and those
 symbols do appear to be in plpgsql.so:

  nm /usr/local/pgsql/lib/plpgsql.so | grep _exec_get_datum_type
 f110 T _exec_get_datum_type
 f380 T _exec_get_datum_type_info

 So, uh, what gives? Do I need to something extra to get it to properly
 find plpgsql.so?

 Thanks,

 David

[pgadmin-hackers] pgAdmin III commit: Update chinese simplified translation

[Guillaume Lelarge]

Update chinese simplified translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=06fb7601567d8e3bafe7cb5038e215078d90cae6
Author: yanhong ma mystic...@live.com

Modified Files
--
i18n/zh_CN/pgadmin3.mo |  Bin 296843 - 309464 bytes
i18n/zh_CN/pgadmin3.po |  505 +---
2 files changed, 215 insertions(+), 290 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] zh_CN Chinese simplified pgadmin3

[Guillaume Lelarge]

Pushed. Thanks for your work.


2014-08-18 4:04 GMT+02:00 yanhong ma mystic...@live.com:






-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Prevent a crash during the update of the macro or f

[Guillaume Lelarge]

Prevent a crash during the update of the macro or favourite list

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=f656072300b3a2736fafff0093223793ca4dd9ad
Author: Dmitriy Olshevskiy olshevski...@bk.ru

Modified Files
--
CHANGELOG|3 ++-
pgadmin/frm/frmQuery.cpp |6 ++
2 files changed, 8 insertions(+), 1 deletion(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] PATCH: prevent a crash during the macro or favourite list updating

[Guillaume Lelarge]

Commited, thanks a lot.


2014-08-07 22:17 GMT+02:00 Dmitriy Olshevskiy olshevski...@bk.ru:

 Hello.
 I would like you to check this patch.
 Frequently there are opened several windows: edit grids and queries. In
 this case, if you try to change macro or favourites list, pgadmin exits
 with error immediately. Though, this isn't happening while all edit grids
 are closed.
 I propose a solution - to check the presence of the macros menu (or
 favourites, if you change the favourites list) and the visibility of the
 query window (to prevent false event when the window is just starts to be
 opened).
 Patch is attached to the letter.
 Thank you.

 --
 Dmitriy Olshevskiy



 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] PATCH: Update russian translation

[Guillaume Lelarge]

Hi,

2014-07-28 22:09 GMT+02:00 Dmitriy Olshevskiy olshevski...@bk.ru:

 Hello.
 I have prepared the files of russian translation (see attached files).
 Please, check them and apply if everything is alright.
 Thank you.


Applying a patch of a .po and a .mo files never works. Could you send me
the full pgadmin3.po file please? thanks.

Regards.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] PATCH: small changes in the russian translation

[Guillaume Lelarge]

Hi,

2014-07-29 19:00 GMT+02:00 Dmitriy Olshevskiy olshevski...@bk.ru:

 Hello again.
 I want you apply another one patch with small changes in the russian
 translation.
 Please, see the file attached to this letter.
 p.s. thanks to Timontimo...@gmail.com for the correction


We can't apply patches to .po and .mo files. Please send the whole .po file.

Thanks.

Regards.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update french translation

[Guillaume Lelarge]

Update french translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=b99b0bfe1edd736aee9a272dc74781b742ee50db

Modified Files
--
i18n/fr_FR/pgadmin3.mo |  Bin 351913 - 356753 bytes
i18n/fr_FR/pgadmin3.po |  188 +---
2 files changed, 67 insertions(+), 121 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Announce 1.20 beta 1

[Guillaume Lelarge]

Announce 1.20 beta 1

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=e32b6fb14503285c578b5d86fb95851da66d5ad3

Modified Files
--
download/source.php |2 ++
index.php   |8 
2 files changed, 10 insertions(+)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Update .pot file

[Guillaume Lelarge]

Update .pot file

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=16f5a3e01d23b1f9e9d17a89a6563f79bbd3855b

Modified Files
--
locale/pgadmin3_website.pot |   72 ++-
1 file changed, 51 insertions(+), 21 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Automatic stringmerge using merge script.

[Guillaume Lelarge]

Automatic stringmerge using merge script.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=80a2c5411d0db50b6c630932dda1b832cdea0302

Modified Files
--
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.mo |  Bin 127084 - 127084 bytes
locale/cs_CZ/LC_MESSAGES/pgadmin3_website.po |   97 +-
locale/es_SV/LC_MESSAGES/pgadmin3_website.mo |  Bin 125625 - 125625 bytes
locale/es_SV/LC_MESSAGES/pgadmin3_website.po |   99 --
locale/fr_FR/LC_MESSAGES/pgadmin3_website.mo |  Bin 180086 - 180471 bytes
locale/fr_FR/LC_MESSAGES/pgadmin3_website.po |  115 ++
locale/pl_PL/LC_MESSAGES/pgadmin3_website.mo |  Bin 170663 - 171017 bytes
locale/pl_PL/LC_MESSAGES/pgadmin3_website.po |  112 ++---
locale/ru_RU/LC_MESSAGES/pgadmin3_website.mo |  Bin 217212 - 217626 bytes
locale/ru_RU/LC_MESSAGES/pgadmin3_website.po |  112 ++---
locale/zh_CN/LC_MESSAGES/pgadmin3_website.mo |  Bin 150729 - 151017 bytes
locale/zh_CN/LC_MESSAGES/pgadmin3_website.po |  104 ---
12 files changed, 359 insertions(+), 280 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin website commit: Update website's french translation

[Guillaume Lelarge]

Update website's french translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=f451d91bf299e1fac9ee6316c7543e550b8f2f50

Modified Files
--
locale/fr_FR/LC_MESSAGES/pgadmin3_website.mo |  Bin 180471 - 181796 bytes
locale/fr_FR/LC_MESSAGES/pgadmin3_website.po |   12 ++--
2 files changed, 6 insertions(+), 6 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Automatic merge using stringmerge script.

[Guillaume Lelarge]

Automatic merge using stringmerge script.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=3bd766c7015c49e4232c7c240f3c1de25f0cb27f

Modified Files
--
i18n/af_ZA/pgadmin3.po | 2935 ++--
i18n/ar_SA/pgadmin3.po | 2983 +++--
i18n/bg_BG/pgadmin3.po | 2876 ++--
i18n/ca_ES/pgadmin3.po | 2842 +--
i18n/cs_CZ/pgadmin3.po | 2861 +--
i18n/da_DK/pgadmin3.po | 3147 +--
i18n/de_CH/pgadmin3.po | 2861 +--
i18n/de_DE/pgadmin3.po | 2931 ++--
i18n/el_GR/pgadmin3.po | 2863 +--
i18n/es_ES/pgadmin3.po | 2708 -
i18n/fa_IR/pgadmin3.po | 2855 +--
i18n/fi_FI/pgadmin3.po | 2841 +--
i18n/fr_FR/pgadmin3.po | 2888 ++--
i18n/gl_ES/pgadmin3.po | 2861 +--
i18n/gu_IN/pgadmin3.po | 2787 --
i18n/hi_IN/pgadmin3.po | 2817 +--
i18n/hr_HR/pgadmin3.po | 3455 +---
i18n/hu_HU/pgadmin3.po | 2880 ++--
i18n/id_ID/pgadmin3.po | 2993 +++--
i18n/is_IS/pgadmin3.po | 2787 --
i18n/it_IT/pgadmin3.po | 2935 ++--
i18n/ja_JP/pgadmin3.po | 2956 +++--
i18n/ko_KR/pgadmin3.po | 2929 ++--
i18n/lt_LT/pgadmin3.po | 2868 ++--
i18n/lv_LV/pgadmin3.po | 2856 +--
i18n/mk_MK/pgadmin3.po | 2787 --
i18n/nb_NO/pgadmin3.po | 2999 +++--
i18n/nl_NL/pgadmin3.po | 2860 +--
i18n/pl_PL/pgadmin3.po | 2888 ++--
i18n/pt_BR/pgadmin3.po | 2955 +++--
i18n/pt_PT/pgadmin3.po | 2949 +++--
i18n/ro_RO/pgadmin3.po | 2984 +++--
i18n/ru_RU/pgadmin3.po | 2951 +++--
i18n/sk_SK/pgadmin3.po | 2860 +--
i18n/sl_SI/pgadmin3.po | 2862 +--
i18n/sr_RS/pgadmin3.po | 2860 +--
i18n/sv_SE/pgadmin3.po | 2865 +--
i18n/te_IN/pgadmin3.po | 2787 --
i18n/tl_PH/pgadmin3.po | 2894 ++--
i18n/tr_TR/pgadmin3.po | 3137 +--
i18n/uk_UA/pgadmin3.po | 2788 --
i18n/ur_PK/pgadmin3.po | 2842 +--
i18n/vi_VN/pgadmin3.po | 2786 --
i18n/zh_CN/pgadmin3.po | 2869 ++--
i18n/zh_TW/pgadmin3.po | 2870 ++--
45 files changed, 73990 insertions(+), 56518 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Update .pot file

[Guillaume Lelarge]

Update .pot file

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=b6856e55dba6acbd382a36233d4b23cbc8004426

Modified Files
--
pgadmin3.pot | 2787 --
1 file changed, 1534 insertions(+), 1253 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin v.1.20.0 Beta 1 now available

[Guillaume Lelarge]

pgAdmin v1.20.0 Beta 1 is now available for testing in source from:

http://www.postgresql.org/ftp/pgadmin3/release/v1.20.0-beta1/

Unfortunately, Windows and Mac OS X distributions aren't yet available.
Nevertheless, you can still have it with the PostgreSQL 9.4 beta 2
one-click installer from:

http://www.postgresql.org/download/snapshots/

We're still working on a visual tour. In the meantime, the list of new
features is available in the changelog (
http://www.pgadmin.org/development/changelog.php).

Please download a copy to test, and report any issues to
pgadmin-support(at)postgresql(dot)org to help us prepare for our upcoming
1.20 final release.

Regards.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] pgAdmin III commit: Update .pot file: update polish translation

[Guillaume Lelarge]

Hi Begina,

Thanks a lot for the update. You know there are still 5 fuzzy strings?

Anyway, commited. Thanks again.

Regards.


2014-07-25 19:55 GMT+02:00 Begina Felicysym begina.felicy...@wp.pl:

 Dnia Piątek, 25 Lipca 2014 09:14 Guillaume Lelarge guilla...@lelarge.info
 napisał(a)

 Update .pot file



 Branch

 --

 master



 Details

 ---


 http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=b6856e55dba6acbd382a36233d4b23cbc8004426



 Modified Files

 --

 pgadmin3.pot | 2787
 --

 1 file changed, 1534 insertions(+), 1253 deletions(-)





 --

 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)

 To make changes to your subscription:

 http://www.postgresql.org/mailpref/pgadmin-hackers










-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Update polish translation

[Guillaume Lelarge]

Update polish translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=0759251d5c094d6dff4bee6d628afd05af018101
Author: Begina Felicysym begina.felicy...@wp.pl

Modified Files
--
i18n/pl_PL/pgadmin3.mo |  Bin 329564 - 334001 bytes
i18n/pl_PL/pgadmin3.po | 2243 ++--
2 files changed, 654 insertions(+), 1589 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Update spanish translation

[Guillaume Lelarge]

Update spanish translation

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=ec97a29268cb13b08f6a7d74c8234b7166a08345
Author: Eduardo Higuero eduardohigu...@gmail.com

Modified Files
--
i18n/es_ES/pgadmin3.mo |  Bin 253287 - 339007 bytes
i18n/es_ES/pgadmin3.po | 2708 +---
2 files changed, 1187 insertions(+), 1521 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Bump version for beta 1 release

[Guillaume Lelarge]

Bump version for beta 1 release

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=7a4276b6c51165dbc5e4e55d59ed1ea652e2ec8c

Modified Files
--
pgadmin/include/version.h |6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] Re: [pgadmin-hackers] Re: 答复: [pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence

[Guillaume Lelarge]

2014-07-15 9:21 GMT+02:00 Dave Page dp...@pgadmin.org:




 On Tue, Jul 15, 2014 at 2:45 AM, liuyuanyuan liuyuanyuang...@gmail.com
 wrote:

 Thanks for your attention to this topic!

 In fact, none pgadmin can be compatible with all  versions of the
 database.


 We've done pretty well so far, supporting right back to 7.3, through we
 don't officially support the much older versions now, but that's mostly due
 to the amount of testing it requires.


 Although earlier versions of PG don't support GRANT ON SEQUENCE,

 but new versions support. So I think this adjustment is necessary .


 Old versions supported GRANT ON TABLE for sequences iirc, (as sequences
 are members of pg_class). This change is only necessary if newer versions
 of PostgreSQL dropped that syntax. It may be desirable, if we no longer
 support any versions of PostgreSQL that needed the old syntax.



It's still better to use the new syntax when it's available (ie, since 8.3).



-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence

[Guillaume Lelarge]

2014-07-15 0:27 GMT+02:00 Dave Page dp...@pgadmin.org:

 Minor brain failure, but I believe the same comment applies.


Yeah, the code checks the version. If less than 8.3, it uses the old syntax
(GRANT ON TABLE). Otherwise, it uses the new syntax (GRANT ON SEQUENCE).


 On 14 Jul 2014, at 22:13, Guillaume Lelarge guilla...@lelarge.info
 wrote:

 2014-07-14 23:09 GMT+02:00 Dave Page dp...@pgadmin.org:

 That syntax was (once) intentional, and was not a bug, as earlier
 versions of PG don't support ALTER SEQUENCE. Did you check the version
 compatibility?


 I'm not sure I understand what you mean. We're not talking about ALTER
 SEQUENCE. We're talking about GRANT ON SEQUENCE.


 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK:http://www.enterprisedb.com
 The Enterprise PostgreSQL Company

 On 14 Jul 2014, at 22:03, Guillaume Lelarge guilla...@lelarge.info
 wrote:

 Fix SQL for GRANT on a sequence

 Report from liuyuanyuan.

 Branch
 --
 REL-1_18_0_PATCHES

 Details
 ---

 http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=5eb8e16348c001708d4b2d511eae988724a84938

 Modified Files
 --
 CHANGELOG |2 ++
 pgadmin/dlg/dlgSequence.cpp   |2 +-
 pgadmin/schema/pgSequence.cpp |2 +-
 3 files changed, 4 insertions(+), 2 deletions(-)


 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers




 --
 Guillaume.
   http://blog.guillaume.lelarge.info
   http://www.dalibo.com




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence

[Guillaume Lelarge]

Fix SQL for GRANT on a sequence

Report from liuyuanyuan.

Branch
--
REL-1_18_0_PATCHES

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=5eb8e16348c001708d4b2d511eae988724a84938

Modified Files
--
CHANGELOG |2 ++
pgadmin/dlg/dlgSequence.cpp   |2 +-
pgadmin/schema/pgSequence.cpp |2 +-
3 files changed, 4 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence

[Guillaume Lelarge]

Fix SQL for GRANT on a sequence

Report from liuyuanyuan.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=2b20c5fff3351a8e4a4066249e49f8731ea9d912

Modified Files
--
CHANGELOG |2 ++
pgadmin/dlg/dlgSequence.cpp   |2 +-
pgadmin/schema/pgSequence.cpp |2 +-
3 files changed, 4 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence

[Guillaume Lelarge]

2014-07-14 23:09 GMT+02:00 Dave Page dp...@pgadmin.org:

 That syntax was (once) intentional, and was not a bug, as earlier versions
 of PG don't support ALTER SEQUENCE. Did you check the version compatibility?


I'm not sure I understand what you mean. We're not talking about ALTER
SEQUENCE. We're talking about GRANT ON SEQUENCE.


 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK:http://www.enterprisedb.com
 The Enterprise PostgreSQL Company

 On 14 Jul 2014, at 22:03, Guillaume Lelarge guilla...@lelarge.info
 wrote:

 Fix SQL for GRANT on a sequence

 Report from liuyuanyuan.

 Branch
 --
 REL-1_18_0_PATCHES

 Details
 ---

 http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=5eb8e16348c001708d4b2d511eae988724a84938

 Modified Files
 --
 CHANGELOG |2 ++
 pgadmin/dlg/dlgSequence.cpp   |2 +-
 pgadmin/schema/pgSequence.cpp |2 +-
 3 files changed, 4 insertions(+), 2 deletions(-)


 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[pgadmin-hackers] pgAdmin III commit: Fix generated DDL for views

[Guillaume Lelarge]

Fix generated DDL for views

I've noticed that views for which I had never specified check_option
or security_barrier (in pgsql 9.3) have got incorrect DDL generated -
the WITH (options) clause is empty.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=f452cbe2dc248cd1f7e08e7593c4628f15bd3e6f
Author: J.F. Oster jinfros...@mail.ru

Modified Files
--
pgadmin/schema/pgView.cpp |3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] pgAdmin III commit: Support the new check_option parameter of views

[Guillaume Lelarge]

Hi,

2014-07-09 17:08 GMT+02:00 J.F. Oster jinfros...@mail.ru:

 Hello Guillaume,

 I've noticed that views for which I had never specified check_option
 or security_barrier (in pgsql 9.3) have got incorrect DDL generated -
 the WITH (options) clause is empty:

 CREATE OR REPLACE VIEW account_v WITH () AS
  SELECT acc.id,
 ...

 Once I set security_barrier on and back off for a view, it starts
 showing WITH (security_barrier=FALSE), not an empty WITH () until
 I recreate a view. Probably that is the reason why the issue went
 unnoticed during development.

 Attached patch should fix it.


You're right. Thanks for the patch, I commited and pushed it.




 Wednesday, July 2, 2014, 7:47:42 PM, you wrote:

 GL Support the new check_option parameter of views

 GL Branch
 GL --
 GL master

 GL Details
 GL ---
 GL
 http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=178f27be48c6c1af970a104d590e4d3abaccdcc4

 GL Modified Files
 GL --
 GL CHANGELOG   |1 +
 GL pgadmin/dlg/dlgView.cpp |   50
 GL +++
 GL pgadmin/include/schema/pgView.h |   11 -
 GL pgadmin/schema/pgView.cpp   |   23 +-
 GL pgadmin/ui/dlgView.xrc  |   23 --
 GL 5 files changed, 99 insertions(+), 9 deletions(-)





 --
 Best regards,
  J.F.




-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

Re: [pgadmin-hackers] pgAdmin III commit: Handle the 9.4 MOVE clause of ALTER TABLESPACE

[Guillaume Lelarge]

2014-07-03 8:54 GMT+02:00 Guillaume Lelarge guilla...@lelarge.info:

 Hi,

 Le 3 juil. 2014 08:40, J.F. Oster jinfros...@mail.ru a écrit :

 
  Hello Guillaume,
 
  Some changes to pgAdmin3.vcxproj are missing.

 Oh yeah, you're right. I completely forgot the visual studio project.

  Please see the attached patch to fix it.
 

 I'll take a look at it. Can't right now because I'll be in my customer's
 office in a few minutes.

 Thanks for noticing and for the patch.


Just did. Seems good to me. So I commited and pushed it.

Thanks a lot.

[pgadmin-hackers] pgAdmin III commit: Fix the VS project

[Guillaume Lelarge]

Fix the VS project

Guillaume forgot to update it with his latest patch

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=58c308bcd30a6ca12423bbdeb42ad55c723d32d0
Author: J.F. Oster jinfros...@mail.ru

Modified Files
--
pgadmin/pgAdmin3.vcxproj  |3 +
pgadmin/ui/xrcDialogs.cpp | 7093 +++--
2 files changed, 3651 insertions(+), 3445 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] pgAdmin III commit: Handle the 9.4 MOVE clause of ALTER TABLESPACE

[Guillaume Lelarge]

Hi,

Le 3 juil. 2014 08:40, J.F. Oster jinfros...@mail.ru a écrit :

 Hello Guillaume,

 Some changes to pgAdmin3.vcxproj are missing.

Oh yeah, you're right. I completely forgot the visual studio project.

 Please see the attached patch to fix it.


I'll take a look at it. Can't right now because I'll be in my customer's
office in a few minutes.

Thanks for noticing and for the patch.

 Wednesday, July 2, 2014, 7:47:42 PM, you wrote:

 GL Handle the 9.4 MOVE clause of ALTER TABLESPACE

 GL Branch
 GL --
 GL master

 GL Details
 GL ---
 GL
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=e22eded8f205070a97bf3866bb55025d4253ba29

 GL Modified Files
 GL --
 GL CHANGELOG   |1 +
 GL pgadmin/dlg/dlgMoveTablespace.cpp   |  119
 GL +++
 GL pgadmin/dlg/module.mk   |1 +
 GL pgadmin/frm/frmMain.cpp |2 +
 GL pgadmin/include/dlg/dlgMoveTablespace.h |   44 
 GL pgadmin/include/dlg/module.mk   |1 +
 GL pgadmin/include/schema/pgTablespace.h   |9 +++
 GL pgadmin/schema/pgTablespace.cpp |   40 +++
 GL pgadmin/ui/dlgMoveTablespace.xrc|   95

 GL pgadmin/ui/module.mk|1 +
 GL 10 files changed, 313 insertions(+)


 --
 Best regards,
  J.F.

[pgadmin-hackers] pgAdmin III commit: Support the new columns in pg_stat_activity (new as

[Guillaume Lelarge]

Support the new columns in pg_stat_activity (new as in 9.4)

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=6e5dd896137def548566914efa4a3dcded26e1e4

Modified Files
--
CHANGELOG |1 +
pgadmin/frm/frmStatus.cpp |   15 +++
2 files changed, 16 insertions(+)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Add a new action menu to refresh a materialized vie

[Guillaume Lelarge]

Add a new action menu to refresh a materialized view

It also displays another action menu with 9.4 cluster to refresh concurrently 
the materialized view.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=a358830ec86aacf5e15cf74f1e74cca3f54d964e

Modified Files
--
CHANGELOG   |1 +
pgadmin/frm/frmMain.cpp |3 ++
pgadmin/include/schema/pgView.h |   18 +++
pgadmin/schema/pgView.cpp   |   67 +++
4 files changed, 89 insertions(+)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Handle the 9.4 MOVE clause of ALTER TABLESPACE

[Guillaume Lelarge]

Handle the 9.4 MOVE clause of ALTER TABLESPACE

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=e22eded8f205070a97bf3866bb55025d4253ba29

Modified Files
--
CHANGELOG   |1 +
pgadmin/dlg/dlgMoveTablespace.cpp   |  119 +++
pgadmin/dlg/module.mk   |1 +
pgadmin/frm/frmMain.cpp |2 +
pgadmin/include/dlg/dlgMoveTablespace.h |   44 
pgadmin/include/dlg/module.mk   |1 +
pgadmin/include/schema/pgTablespace.h   |9 +++
pgadmin/schema/pgTablespace.cpp |   40 +++
pgadmin/ui/dlgMoveTablespace.xrc|   95 
pgadmin/ui/module.mk|1 +
10 files changed, 313 insertions(+)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Support for the 9.4 MOVE clause of ALTER TABLESPACE

[Guillaume Lelarge]

On Fri, 2014-05-09 at 21:31 +0200, Guillaume Lelarge wrote:
 Hi,
 
 Another patch to handle the 9.4 MOVE clause of ALTER TABLESPACE. It
 brings a new dialog to do the move.
 
 Patch attached, comments welcome.
 
 

Commited.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] New refresh action on views

[Guillaume Lelarge]

On Wed, 2014-05-07 at 21:42 +0200, Guillaume Lelarge wrote:
 Hi,
 
 This other other patch adds a new action menu to refresh a
 materialized view. It adds another menu with an 9.2 cluster to refresh a
 materialized view concurrently.
 
 Patch attached, comments welcome.
 
 

Commited.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] New columns in 9.4 pg_stat_activity

[Guillaume Lelarge]

On Wed, 2014-05-07 at 20:10 +0200, Guillaume Lelarge wrote:
 Hi,
 
 I tried to write some patches for pgAdmin on the new features of 9.4.
 First one is to support the two new columns of pg_stat_activity in
 frmStatus.
 
 Patch attached, comments welcome.
 
 

Commited.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] New check_option option in views

[Guillaume Lelarge]

On Wed, 2014-05-07 at 21:08 +0200, Guillaume Lelarge wrote:
 Hi,
 
 This other patch adds support to the new check_option option of views.
 
 Patch attached, comments welcome.
 
 

Commited.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Support the new check_option parameter of views

[Guillaume Lelarge]

Support the new check_option parameter of views

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=178f27be48c6c1af970a104d590e4d3abaccdcc4

Modified Files
--
CHANGELOG   |1 +
pgadmin/dlg/dlgView.cpp |   50 +++
pgadmin/include/schema/pgView.h |   11 -
pgadmin/schema/pgView.cpp   |   23 +-
pgadmin/ui/dlgView.xrc  |   23 --
5 files changed, 99 insertions(+), 9 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] How to use pg_setting.csv ?

[Guillaume Lelarge]

On Thu, 2014-06-12 at 14:03 +0800, liuyuanyuan wrote:
 Hi, Hackers!
 
 I just begin to read code of pgadmin3 , and I found ..\ i18n\
 pg_settings.csv referenced in source code .
 
 But I cannot figure it out, anybody know about pg_settings.csv, please write
 to me!
 

Well, first probably you should tell us what issue you have with it?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] PgAdmin translation do Brazilian Portuguese

[Guillaume Lelarge]

On Wed, 2014-05-21 at 22:07 -0300, Andre Krepsky wrote:
 Dear Marcos,
 
 Please allow me to introduce my self: my name is Andre Krepsky, I am a
 brazilian citizen who openly advocates about open souce paradigm and,
 additionaly, lived in New Zealand for three years.
 
 I have recently realized PgAdmin does not have a working translation to
 Brazilian Portuguese, which would be absolutely great for my students at
 the Database Fundamentals course, currently lectured at Estacio University.
 
 Willing to contribute to this fantastic project, I would like to humbly
 help finishing the pgadmin3.po file.
 
 Please let me now whether I could help you up.
 

You sure can. You just need to grab the .po file
(http://www.pgadmin.org/svnrepo/pgadmin3/i18n/pt_BR/pgadmin3.po) and
start working on it.

Thanks a lot.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] Support for the 9.4 MOVE clause of ALTER TABLESPACE

[Guillaume Lelarge]

Hi,

Another patch to handle the 9.4 MOVE clause of ALTER TABLESPACE. It
brings a new dialog to do the move.

Patch attached, comments welcome.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From e1bd9f1f660f8bef10964b6d566547e2db8fbffb Mon Sep 17 00:00:00 2001
From: Guillaume Lelarge guilla...@lelarge.info
Date: Fri, 9 May 2014 21:29:44 +0200
Subject: [PATCH] Handle the 9.4 MOVE clause of ALTER TABLESPACE

---
 pgadmin/dlg/dlgMoveTablespace.cpp   | 119 
 pgadmin/dlg/module.mk   |   1 +
 pgadmin/frm/frmMain.cpp |   2 +
 pgadmin/include/dlg/dlgMoveTablespace.h |  44 
 pgadmin/include/dlg/module.mk   |   1 +
 pgadmin/include/schema/pgTablespace.h   |   9 +++
 pgadmin/schema/pgTablespace.cpp |  40 +++
 pgadmin/ui/dlgMoveTablespace.xrc|  95 +
 pgadmin/ui/module.mk|   1 +
 9 files changed, 312 insertions(+)
 create mode 100644 pgadmin/dlg/dlgMoveTablespace.cpp
 create mode 100644 pgadmin/include/dlg/dlgMoveTablespace.h
 create mode 100644 pgadmin/ui/dlgMoveTablespace.xrc

diff --git a/pgadmin/dlg/dlgMoveTablespace.cpp b/pgadmin/dlg/dlgMoveTablespace.cpp
new file mode 100644
index 000..90a4472
--- /dev/null
+++ b/pgadmin/dlg/dlgMoveTablespace.cpp
@@ -0,0 +1,119 @@
+//
+//
+// pgAdmin III - PostgreSQL Tools
+//
+// Copyright (C) 2002 - 2014, The pgAdmin Development Team
+// This software is released under the PostgreSQL Licence
+//
+// dlgMoveTablespace.cpp - Reassign or drop owned objects
+//
+//
+
+#include pgAdmin3.h
+
+// wxWindows headers
+#include wx/wx.h
+
+// App headers
+#include pgAdmin3.h
+#include utils/pgDefs.h
+#include frm/frmMain.h
+#include dlg/dlgMoveTablespace.h
+#include utils/misc.h
+#include schema/pgTablespace.h
+
+
+// pointer to controls
+#define cbMoveTo  CTRL_COMBOBOX(cbMoveTo)
+#define cbKindCTRL_COMBOBOX(cbKind)
+#define cbOwner   CTRL_COMBOBOX(cbOwner)
+#define btnOK CTRL_BUTTON(wxID_OK)
+
+
+BEGIN_EVENT_TABLE(dlgMoveTablespace, pgDialog)
+	EVT_BUTTON(wxID_OK,   dlgMoveTablespace::OnOK)
+END_EVENT_TABLE()
+
+
+dlgMoveTablespace::dlgMoveTablespace(frmMain *win, pgConn *conn, pgTablespace *tblspc)
+{
+	wxString query;
+
+	connection = conn;
+	parent = win;
+
+	SetFont(settings-GetSystemFont());
+	LoadResource(win, wxT(dlgMoveTablespace));
+	RestorePosition();
+
+	cbKind-Clear();
+	cbKind-Append(_(All));
+	cbKind-Append(_(Tables));
+	cbKind-Append(_(Indexes));
+	cbKind-Append(_(Materialized views));
+	cbKind-SetSelection(0);
+
+	cbMoveTo-Clear();
+	query = wxT(SELECT spcname FROM pg_tablespace WHERE spcname) + conn-qtDbString(tblspc-GetName()) + wxT( ORDER BY spcname);
+	pgSetIterator tblspcs(connection, query);
+	while (tblspcs.RowsLeft())
+	{
+		cbMoveTo-Append(tblspcs.GetVal(wxT(spcname)));
+	}
+	cbMoveTo-SetSelection(0);
+
+	cbOwner-Clear();
+	cbOwner-Append(wxEmptyString);
+	query = wxT(SELECT rolname FROM pg_roles ORDER BY rolname);
+	pgSetIterator roles(connection, query);
+	while (roles.RowsLeft())
+	{
+		cbOwner-Append(roles.GetVal(wxT(rolname)));
+	}
+	cbOwner-SetSelection(0);
+	cbOwner-Enable(cbOwner-GetStrings().Count()  0);
+
+	SetSize(330, 160);
+}
+
+dlgMoveTablespace::~dlgMoveTablespace()
+{
+	SavePosition();
+}
+
+
+void dlgMoveTablespace::OnOK(wxCommandEvent ev)
+{
+	EndModal(wxID_OK);
+}
+
+
+void dlgMoveTablespace::OnCancel(wxCommandEvent ev)
+{
+	EndModal(wxID_CANCEL);
+}
+
+wxString dlgMoveTablespace::GetTablespace()
+{
+	return cbMoveTo-GetValue();
+}
+
+wxString dlgMoveTablespace::GetKind()
+{
+wxString kind;
+
+	if (cbKind-GetValue().Cmp(_(Tables)) == 0)
+return wxT(TABLES);
+	if (cbKind-GetValue().Cmp(_(Indexes)) == 0)
+return wxT(INDEXES);
+	if (cbKind-GetValue().Cmp(_(Materialized views)) == 0)
+return wxT(MATERIALIZED VIEWS);
+
+return wxT(ALL);
+}
+
+wxString dlgMoveTablespace::GetOwner()
+{
+	return cbOwner-GetValue();
+}
+
diff --git a/pgadmin/dlg/module.mk b/pgadmin/dlg/module.mk
index 70d83f5..46f4209 100644
--- a/pgadmin/dlg/module.mk
+++ b/pgadmin/dlg/module.mk
@@ -37,6 +37,7 @@ pgadmin3_SOURCES += \
 	dlg/dlgLanguage.cpp \
 	dlg/dlgMainConfig.cpp \
 	dlg/dlgManageFavourites.cpp \
+	dlg/dlgMoveTablespace.cpp \
 	dlg/dlgOperator.cpp \
 	dlg/dlgPackage.cpp \
 	dlg/dlgPgpassConfig.cpp \
diff --git a/pgadmin/frm/frmMain.cpp b/pgadmin/frm/frmMain.cpp
index b9c7c64..c8d65c0 100644
--- a/pgadmin/frm/frmMain.cpp
+++ b/pgadmin/frm/frmMain.cpp
@@ -79,6 +79,7 @@
 #include schema/pgRole.h
 #include schema/pgRule.h
 #include schema/pgServer.h
+#include schema/pgTablespace.h
 #include slony/slCluster.h
 #include slony/slSet.h
 #include schema/pgForeignKey.h
@@ -382,6 +383,7 @@ void frmMain::CreateMenus()
 	new resetTableStatsFactory(menuFactories

[pgadmin-hackers] New columns in 9.4 pg_stat_activity

[Guillaume Lelarge]

Hi,

I tried to write some patches for pgAdmin on the new features of 9.4.
First one is to support the two new columns of pg_stat_activity in
frmStatus.

Patch attached, comments welcome.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From 86c000d73b2fb4a6a87927a3ab35f9d92309f632 Mon Sep 17 00:00:00 2001
From: Guillaume Lelarge guilla...@lelarge.info
Date: Tue, 6 May 2014 21:40:19 +0200
Subject: [PATCH] Support the new columns in pg_stat_activity (new as in 9.4)

---
 pgadmin/frm/frmStatus.cpp | 15 +++
 1 file changed, 15 insertions(+)

diff --git a/pgadmin/frm/frmStatus.cpp b/pgadmin/frm/frmStatus.cpp
index 2a1c8a6..6c78fe8 100644
--- a/pgadmin/frm/frmStatus.cpp
+++ b/pgadmin/frm/frmStatus.cpp
@@ -587,6 +587,11 @@ void frmStatus::AddStatusPane()
 		statusList-AddColumn(_(State), 35);
 		statusList-AddColumn(_(State change), 35);
 	}
+	if (connection-BackendMinimumVersion(9, 4))
+	{
+		statusList-AddColumn(_(Backend XID), 35);
+		statusList-AddColumn(_(Backend XMin), 35);
+	}
 	statusList-AddColumn(_(Blocked by), 35);
 	statusList-AddColumn(_(Query), 500);
 
@@ -1381,6 +1386,10 @@ void frmStatus::OnRefreshStatusTimer(wxTimerEvent event)
 	if (connection-BackendMinimumVersion(9, 2))
 		q += wxT(state, date_trunc('second', state_change) AS state_change, );
 
+	// Xmin and XID
+	if (connection-BackendMinimumVersion(9, 4))
+		q += wxT(backend_xid::text, backend_xmin::text, );
+
 	// Blocked by...
 	q +=   wxT((SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND ()
 	   wxT(relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=) + pidcol + wxT( AND NOT granted))
@@ -1466,6 +1475,12 @@ void frmStatus::OnRefreshStatusTimer(wxTimerEvent event)
 	statusList-SetItem(row, colpos++, dataSet1-GetVal(wxT(state_change)));
 }
 
+if (connection-BackendMinimumVersion(9, 4))
+{
+	statusList-SetItem(row, colpos++, dataSet1-GetVal(wxT(backend_xid)));
+	statusList-SetItem(row, colpos++, dataSet1-GetVal(wxT(backend_xmin)));
+}
+
 statusList-SetItem(row, colpos++, dataSet1-GetVal(wxT(blockedby)));
 statusList-SetItem(row, colpos, qry);
 
-- 
1.9.0


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] New check_option option in views

[Guillaume Lelarge]

Hi,

This other patch adds support to the new check_option option of views.

Patch attached, comments welcome.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
diff --git a/pgadmin/dlg/dlgView.cpp b/pgadmin/dlg/dlgView.cpp
index ca594b5..54765e3 100644
--- a/pgadmin/dlg/dlgView.cpp
+++ b/pgadmin/dlg/dlgView.cpp
@@ -79,18 +79,21 @@
 #define txtFillFactor CTRL_TEXT(txtFillFactor)
 #define stMatViewWithData CTRL_STATIC(stMatViewWithData)
 #define chkMatViewWithDataCTRL_CHECKBOX(chkMatViewWithData)
+#define stCheckOption CTRL_STATIC(stCheckOption)
+#define cbCheckOption CTRL_COMBOBOX(cbCheckOption)
 
 BEGIN_EVENT_TABLE(dlgView, dlgSecurityProperty)
 	EVT_STC_MODIFIED(XRCID(txtSqlBox),dlgProperty::OnChangeStc)
 	EVT_CHECKBOX(XRCID(chkSecurityBarrier),   dlgProperty::OnChange)
+	EVT_COMBOBOX(XRCID(cbCheckOption),dlgProperty::OnChange)
 
 	/* Materialized view setting */
-	EVT_CHECKBOX(XRCID(chkMaterializedView), dlgView::OnCheckMaterializedView)
-	EVT_TEXT(XRCID(txtFillFactor),   dlgView::OnChangeVacuum)
+	EVT_CHECKBOX(XRCID(chkMaterializedView),  dlgView::OnCheckMaterializedView)
+	EVT_TEXT(XRCID(txtFillFactor),dlgView::OnChangeVacuum)
 
-	EVT_COMBOBOX(XRCID(cboTablespace),   dlgView::OnChangeVacuum)
+	EVT_COMBOBOX(XRCID(cboTablespace),dlgView::OnChangeVacuum)
 
-	EVT_CHECKBOX(XRCID(chkMatViewWithData), dlgProperty::OnChange)
+	EVT_CHECKBOX(XRCID(chkMatViewWithData),   dlgProperty::OnChange)
 
 	/* AutoVacuum Settings */
 	EVT_CHECKBOX(XRCID(chkCustomVac), dlgView::OnChangeVacuum)
@@ -153,6 +156,7 @@ int dlgView::Go(bool modal)
 		seclabelPage-Disable();
 
 	chkSecurityBarrier-Enable(connection-BackendMinimumVersion(9, 2));
+	cbCheckOption-Enable(connection-BackendMinimumVersion(9, 4));
 
 	if (connection-BackendMinimumVersion(9, 3))
 	{
@@ -350,6 +354,13 @@ int dlgView::Go(bool modal)
 // It is not materialized view so disabling all the controls
 DisableMaterializedView();
 			}
+
+			if (view-GetCheckOption().Cmp(wxT(cascaded)) == 0)
+cbCheckOption-SetSelection(2);
+			else if (view-GetCheckOption().Cmp(wxT(local)) == 0)
+cbCheckOption-SetSelection(1);
+			else
+cbCheckOption-SetSelection(0);
 		}
 	}
 	else
@@ -357,6 +368,7 @@ int dlgView::Go(bool modal)
 		// create mode
 		cboTablespace-Insert(_(default tablespace), 0, (void *)0);
 		cboTablespace-SetSelection(0);
+		cbCheckOption-SetSelection(0);
 		wxCommandEvent ev;
 		OnChangeVacuum(ev);
 	}
@@ -428,6 +440,11 @@ void dlgView::CheckChange()
 enable = enable || (chkSecurityBarrier-GetValue());
 			}
 		}
+
+		if (connection-BackendMinimumVersion(9, 4)  view)
+		{
+			enable = enable || cbCheckOption-GetValue().Lower().Cmp(view-GetCheckOption()) != 0;
+		}
 	}
 
 	EnableOK(enable);
@@ -438,6 +455,7 @@ wxString dlgView::GetSql()
 {
 	wxString sql;
 	wxString name;
+	wxString withoptions = wxEmptyString;
 	bool editQuery = false;
 
 	if (view)
@@ -502,7 +520,16 @@ wxString dlgView::GetSql()
 			sql += wxT(CREATE MATERIALIZED VIEW ) + name;
 
 		if (connection-BackendMinimumVersion(9, 2)  chkSecurityBarrier-GetValue())
-			sql += wxT( WITH (security_barrier=true));
+			withoptions += wxT(security_barrier=true);
+		if (connection-BackendMinimumVersion(9, 4))
+		{
+			if (withoptions.Length()  0)
+withoptions += wxT(, );
+			withoptions += wxT(check_option=) + cbCheckOption-GetValue().Lower();
+		}
+
+		if (withoptions.Length()  0)
+			sql += wxT( WITH () + withoptions + wxT());
 
 		// Add the parameter of tablespace and storage parameter to create the materilized view
 		if (connection-BackendMinimumVersion(9, 3)  chkMaterializedView-GetValue())
@@ -711,6 +738,19 @@ wxString dlgView::GetSql()
 sql += wxT(ALTER VIEW ) + name + wxT(\n  SET (security_barrier=false);\n);
 		}
 
+		if (connection-BackendMinimumVersion(9, 4)
+			 cbCheckOption-GetValue().Lower().Cmp(view-GetCheckOption()) != 0)
+		{
+			if (cbCheckOption-GetValue().Cmp(wxT(No)) == 0)
+sql += wxT(ALTER VIEW ) + name + wxT( RESET (check_option);\n);
+			else
+sql += wxT(ALTER VIEW ) + name + wxT(\n  SET (check_option=) + cbCheckOption-GetValue().Lower() + wxT();\n);
+		}
+
+		if (withoptions.Length()  0)
+			sql += wxT( WITH () + withoptions + wxT());
+
+
 		if (connection-BackendMinimumVersion(9, 3)  chkMaterializedView-GetValue())
 		{
 			if (txtFillFactor-GetValue() != view-GetFillFactor())
diff --git a/pgadmin/include/schema/pgView.h b/pgadmin/include/schema/pgView.h
index dac8d67..7ab908a 100644
--- a/pgadmin/include/schema/pgView.h
+++ b/pgadmin/include/schema/pgView.h
@@ -148,6 +148,15 @@ public:
 		isPopulated = s;
 	}
 
+	wxString GetCheckOption()
+	{
+		return check_option;
+	}
+	void iSetCheckOption(const wxString s)
+	{
+		check_option = s;
+	}
+
 	bool GetCustomAutoVacuumEnabled()
 	{
 		return !reloptions.IsEmpty();
@@ -358,7 +367,7 @@ private:
 	  

[pgadmin-hackers] New refresh action on views

[Guillaume Lelarge]

Hi,

This other other patch adds a new action menu to refresh a
materialized view. It adds another menu with an 9.2 cluster to refresh a
materialized view concurrently.

Patch attached, comments welcome.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From 43ef769082f546be8692f0d3d4bf70bb83da28ce Mon Sep 17 00:00:00 2001
From: Guillaume Lelarge guilla...@lelarge.info
Date: Wed, 7 May 2014 21:40:44 +0200
Subject: [PATCH] Add a new action menu to refresh a materialized view

It also displays another action menu with 9.4 cluster to refresh concurrently the materialized view.
---
 pgadmin/frm/frmMain.cpp |  3 ++
 pgadmin/include/schema/pgView.h | 18 +++
 pgadmin/schema/pgView.cpp   | 67 +
 3 files changed, 88 insertions(+)

diff --git a/pgadmin/frm/frmMain.cpp b/pgadmin/frm/frmMain.cpp
index b9c7c64..b3cab59 100644
--- a/pgadmin/frm/frmMain.cpp
+++ b/pgadmin/frm/frmMain.cpp
@@ -73,6 +73,7 @@
 #include dlg/dlgDatabase.h
 #include dlg/dlgSearchObject.h
 #include schema/pgTable.h
+#include schema/pgView.h
 #include schema/pgFunction.h
 #include schema/pgIndex.h
 #include schema/pgTrigger.h
@@ -306,6 +307,8 @@ void frmMain::CreateMenus()
 	viewMenu-AppendSeparator();
 	actionFactory *refFact = new refreshFactory(menuFactories, viewMenu, toolBar);
 	new countRowsFactory(menuFactories, viewMenu, 0);
+	new refreshMatViewFactory(menuFactories, viewMenu, 0);
+	new refreshConcurrentlyMatViewFactory(menuFactories, viewMenu, 0);
 	new executePgstattupleFactory(menuFactories, viewMenu, 0);
 	new executePgstatindexFactory(menuFactories, viewMenu, 0);
 	new enabledisableRuleFactory(menuFactories, toolsMenu, 0);
diff --git a/pgadmin/include/schema/pgView.h b/pgadmin/include/schema/pgView.h
index dac8d67..211023b 100644
--- a/pgadmin/include/schema/pgView.h
+++ b/pgadmin/include/schema/pgView.h
@@ -108,6 +108,7 @@ public:
 	wxString GetInsertSql(ctlTree *browser);
 	wxString GetUpdateSql(ctlTree *browser);
 	pgObject *Refresh(ctlTree *browser, const wxTreeItemId item);
+	void RefreshMatView(bool concurrently);
 
 	bool HasStats()
 	{
@@ -371,4 +372,21 @@ public:
 	wxString GetTranslatedMessage(int kindOfMessage) const;
 };
 
+class refreshMatViewFactory : public contextActionFactory
+{
+public:
+	refreshMatViewFactory(menuFactoryList *list, wxMenu *mnu, ctlMenuToolbar *toolbar);
+	wxWindow *StartDialog(frmMain *form, pgObject *obj);
+	bool CheckEnable(pgObject *obj);
+};
+
+class refreshConcurrentlyMatViewFactory : public contextActionFactory
+{
+public:
+	refreshConcurrentlyMatViewFactory(menuFactoryList *list, wxMenu *mnu, ctlMenuToolbar *toolbar);
+	wxWindow *StartDialog(frmMain *form, pgObject *obj);
+	bool CheckEnable(pgObject *obj);
+};
+
+
 #endif
diff --git a/pgadmin/schema/pgView.cpp b/pgadmin/schema/pgView.cpp
index 5a3e0c5..9e1660f 100644
--- a/pgadmin/schema/pgView.cpp
+++ b/pgadmin/schema/pgView.cpp
@@ -17,6 +17,7 @@
 #include utils/misc.h
 #include schema/pgColumn.h
 #include schema/pgView.h
+#include frm/frmMain.h
 #include frm/frmHint.h
 #include schema/pgTrigger.h
 
@@ -440,6 +441,17 @@ wxString pgView::GetUpdateSql(ctlTree *browser)
 	return sql;
 }
 
+
+void pgView::RefreshMatView(bool concurrently)
+{
+	wxString sql = wxT(REFRESH MATERIALIZED VIEW );
+	if (concurrently)
+		sql += wxT(CONCURRENTLY );
+	sql += GetQuotedFullIdentifier();
+	GetDatabase()-ExecuteVoid(sql);
+}
+
+
 void pgView::ShowTreeDetail(ctlTree *browser, frmMain *form, ctlListView *properties, ctlSQLBox *sqlPane)
 {
 	if (!expandedKids)
@@ -864,3 +876,58 @@ pgCollection *pgViewFactory::CreateCollection(pgObject *obj)
 
 pgViewFactory viewFactory;
 static pgaCollectionFactory cf(viewFactory, __(Views), views_png_img);
+
+refreshMatViewFactory::refreshMatViewFactory(menuFactoryList *list, wxMenu *mnu, ctlMenuToolbar *toolbar) : contextActionFactory(list)
+{
+	mnu-Append(id, _(Refresh data), _(Refresh data for the selected object.));
+}
+
+
+wxWindow *refreshMatViewFactory::StartDialog(frmMain *form, pgObject *obj)
+{
+	form-StartMsg(_(Refreshing data));
+
+	((pgView *)obj)-RefreshMatView(false);
+	wxTreeItemId item = form-GetBrowser()-GetSelection();
+	if (obj == form-GetBrowser()-GetObject(item))
+		obj-ShowTreeDetail(form-GetBrowser(), 0, form-GetProperties());
+
+	form-EndMsg();
+
+	return 0;
+}
+
+
+bool refreshMatViewFactory::CheckEnable(pgObject *obj)
+{
+	return obj  obj-IsCreatedBy(viewFactory)  ((pgView *)obj)-GetMaterializedView();
+}
+
+
+refreshConcurrentlyMatViewFactory::refreshConcurrentlyMatViewFactory(menuFactoryList *list, wxMenu *mnu, ctlMenuToolbar *toolbar) : contextActionFactory(list)
+{
+	mnu-Append(id, _(Refresh data concurrently), _(Refresh data concurrently for the selected object.));
+}
+
+
+wxWindow *refreshConcurrentlyMatViewFactory::StartDialog(frmMain *form, pgObject *obj)
+{
+	form-StartMsg(_(Refreshing data concurrently));
+
+	((pgView *)obj)-RefreshMatView(true);
+	wxTreeItemId item = form-GetBrowser()-GetSelection

[pgadmin-hackers] pgAdmin III commit: Get also the materialized views in GQB

[Guillaume Lelarge]

Get also the materialized views in GQB

Report from Eduard Szöcs.

Branch
--
REL-1_18_0_PATCHES

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=788b75110737a924fe918cdc2fe2daafcde20e3a

Modified Files
--
CHANGELOG |2 ++
pgadmin/gqb/gqbSchema.cpp |4 ++--
2 files changed, 4 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Get also the materialized views in GQB

[Guillaume Lelarge]

Get also the materialized views in GQB

Report from Eduard Szöcs.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=f9764886ca84bb3e5fa39f87cab0c7a622046a61

Modified Files
--
CHANGELOG |2 ++
pgadmin/gqb/gqbSchema.cpp |4 ++--
2 files changed, 4 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] New functionality - Table tree view

[Guillaume Lelarge]

On Thu, 2014-03-13 at 15:25 +0530, Ashesh Vashi wrote:
 I think - that's where schema helps.
 

Yeah, but I don't think that's what the OP wants. Which won't happen any
time soon.

 
 On Thu, Mar 13, 2014 at 3:19 PM, benj@laposte.net wrote:
 
  Hi,
 
  It's been a while I think a possibility of tree view for table will be a
  great improvment for pgadmin.
 
  It's possible to consider tree view in differents way
  - Possibility to create virtual directories for tables and possibility to
  expand or not expand these directories
  - Possibilty to group table by a prefix/suffix/regexp of tables names
  - Possibility to group herited tables
  - other possibilities...
 
  When we have hundreds table, it will be a great help. And I think with a
  little imagination we should be able to find a solution
 
  Thanks.
 
 
  --
  Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
  To make changes to your subscription:
  http://www.postgresql.org/mailpref/pgadmin-hackers
 
 
 
 


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] debugger.c tries to set log_min_messages, why?

[Guillaume Lelarge]

On Tue, 2014-03-11 at 10:11 +0530, Ashesh Vashi wrote:
 Any comment? (anybody)
 

It seems good to me. It fixes the issue my customer ran into.

 
 On Sat, Mar 1, 2014 at 7:42 PM, Ashesh Vashi
 ashesh.va...@enterprisedb.comwrote:
 
  Please find the patch for the issue.
 
  I have changed the SET log_min_messages TO fatal to SET
  client_min_messages TO error in the global listener connection.
  And, removed the same line from the target invoker connection.
 
 
  On Mon, Feb 10, 2014 at 10:14 PM, Guillaume Lelarge 
  guilla...@lelarge.info wrote:
 
  On Mon, 2014-02-10 at 21:59 +0530, Ashesh Vashi wrote:
   On Mon, Feb 10, 2014 at 9:54 PM, Guillaume Lelarge
   guilla...@lelarge.infowrote:
  
On Mon, 2014-02-10 at 21:46 +0530, Ashesh Vashi wrote:
 On Sat, Feb 8, 2014 at 10:49 PM, Guillaume Lelarge
 guilla...@lelarge.infowrote:

  Hi,
 
  Just a quick question. If you try to use the debugger, it
  executes a
  SET log_min_messages TO fatal, which denies any regular user to
  debug
  his own functions. And actually, I don't see any reason why it
  should
  set log_min_messages. If there is, which is it?
 
 When redesigning the debugger, I did not modify the existing
  connection
 settings without much thoughts.
 After reading this mail, I couldn't agree more with you. It
  shouldn't be
 there.

   
Good to know. Are you working on this, or should I provide a patch?
   
   I will do it.
   Thanks
  
 
  OK, thanks, Ashesh :)
 
 
  --
  Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com
 
 
 
 
  --
  --
 
  Thanks  Regards,
 
  Ashesh Vashi
  EnterpriseDB INDIA: Enterprise PostgreSQL 
  Companyhttp://www.enterprisedb.com
 
 
 
  *http://www.linkedin.com/in/asheshvashi*http://www.linkedin.com/in/asheshvashi
 
 
 
 


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] debugger.c tries to set log_min_messages, why?

[Guillaume Lelarge]

On Wed, 2014-03-12 at 13:13 +0530, Ashesh Vashi wrote:
 Pushed.
 Thanks.
 

Thank you, Ashesh.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Give more options with the plain format

[Guillaume Lelarge]

Give more options with the plain format

Previously, we denied schema/data only, no owner, no tablespace, etc with the
plain format.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=8b0f7500e2af68e32f94021c071aab971175bee9

Modified Files
--
CHANGELOG |1 +
pgadmin/frm/frmBackup.cpp |   13 +++--
2 files changed, 4 insertions(+), 10 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Where is the generic plan stored when using PREPARE statement?

[Guillaume Lelarge]

On Tue, 2014-02-11 at 10:55 -0500, Zhan Li wrote:
 Hi All,
 
 According to the document, if a prepared statement is executed enough
 times, the server may eventually decide to save and re-use a generic plan
 rather than re-planning each time. My question is where the generic plan is
 saved?

In memory. There's actually no reason to put them on disk.

  Is it stored in a file in disk? If yes, where is it located and what
 is the file name?
 
 Thanks,
 Zhan


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] debugger.c tries to set log_min_messages, why?

[Guillaume Lelarge]

On Mon, 2014-02-10 at 21:46 +0530, Ashesh Vashi wrote:
 On Sat, Feb 8, 2014 at 10:49 PM, Guillaume Lelarge
 guilla...@lelarge.infowrote:
 
  Hi,
 
  Just a quick question. If you try to use the debugger, it executes a
  SET log_min_messages TO fatal, which denies any regular user to debug
  his own functions. And actually, I don't see any reason why it should
  set log_min_messages. If there is, which is it?
 
 When redesigning the debugger, I did not modify the existing connection
 settings without much thoughts.
 After reading this mail, I couldn't agree more with you. It shouldn't be
 there.
 

Good to know. Are you working on this, or should I provide a patch?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] debugger.c tries to set log_min_messages, why?

[Guillaume Lelarge]

On Mon, 2014-02-10 at 21:59 +0530, Ashesh Vashi wrote:
 On Mon, Feb 10, 2014 at 9:54 PM, Guillaume Lelarge
 guilla...@lelarge.infowrote:
 
  On Mon, 2014-02-10 at 21:46 +0530, Ashesh Vashi wrote:
   On Sat, Feb 8, 2014 at 10:49 PM, Guillaume Lelarge
   guilla...@lelarge.infowrote:
  
Hi,
   
Just a quick question. If you try to use the debugger, it executes a
SET log_min_messages TO fatal, which denies any regular user to debug
his own functions. And actually, I don't see any reason why it should
set log_min_messages. If there is, which is it?
   
   When redesigning the debugger, I did not modify the existing connection
   settings without much thoughts.
   After reading this mail, I couldn't agree more with you. It shouldn't be
   there.
  
 
  Good to know. Are you working on this, or should I provide a patch?
 
 I will do it.
 Thanks
 

OK, thanks, Ashesh :)


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] debugger.c tries to set log_min_messages, why?

[Guillaume Lelarge]

Hi,

Just a quick question. If you try to use the debugger, it executes a
SET log_min_messages TO fatal, which denies any regular user to debug
his own functions. And actually, I don't see any reason why it should
set log_min_messages. If there is, which is it?

Thanks.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

[Guillaume Lelarge]

On Wed, 2014-02-05 at 22:37 -0800, suhas_bt022 wrote:
 We are trying to migrate a huge oracle database to postgresql.. I am finally
 stuck with conversion of a huge database with around 250 stored procedures
 .Its very painful procedure to convert plsql to plpgsql manually..
 Anyone worked out a better solution for this ?

ora2pg can help you on this. Probably your best bet. Alas, no tool will
offer you an automatic conversion of every function/procedure/package.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] [PATCH] Add a menu option for disabling restoration of previous environment on reconnect

[Guillaume Lelarge]

On Mon, 2014-01-06 at 09:59 +0530, Ashesh Vashi wrote:
 Did you forget to attach the patch?
 

And isn't this already handled in the server's property?

 
 On Mon, Jan 6, 2014 at 3:49 AM, Kaarel Moppel kaarel.mop...@gmail.comwrote:
 
  Checkbox resides under Options- Browser - UI misc.
 
  NB! didn't add the embed-xrc generated xrcDialogs.cpp class due to
  verbosity, so it needs to executed by the code maintainer.
 
 
 
 

-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Fix if test

[Guillaume Lelarge]

Fix if test

Issue found by David Binderman with cppcheck.

Branch
--
REL-1_18_0_PATCHES

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=bf525a5563c73c33e8b63f7f54a5928ee0b172cc

Modified Files
--
pgadmin/dd/ddmodel/ddDBReverseEnginering.cpp |4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] pgAdmin III commit: Fix if test

[Guillaume Lelarge]

Fix if test

Issue found by David Binderman with cppcheck.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=531f8c4f42907b1edf1a6984cdee7323ddaa

Modified Files
--
pgadmin/dd/ddmodel/ddDBReverseEnginering.cpp |4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers