Re: [pgadmin-support] Issues restoring tables

2016-12-03 Thread Guillaume Lelarge
2016-11-28 16:53 GMT+01:00 Jordan Woodhead : > Hi, > > > > I’m having issues restoring tables. > > I was able to do this just fine on PGAdmin 3 using Postgres 9.3. I’ve > upgraded to Postgres 9.5 and I want to be able to restore the tables just > like I did in PGAdmin 3 but I get the following err

Re: [pgadmin-support] Future of pgAdmin3 after release of 4?

2016-08-11 Thread Guillaume Lelarge
Hi, 2016-08-11 7:51 GMT+02:00 Patrick Headley : > Anthony makes a good point, especially while pgAdmin 4 is still in > development. There is a serious issue where pgAdmin 3 silently closes when > you right-click on menu items to connect to a database or to open a table, > for instance. I've seen

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Guillaume Lelarge
Le 16 déc. 2015 2:11 PM, "Nikolai Zhubr" a écrit : > > Hello, > 16.12.2015 14:32, Владимир Янченко: > >> Adam, >> >> yes, you're right. I can connect via PSQL, but get error in PSQL, when I >> try to list databases. >> >> That's what I need, because I don't want show all users and all >> databases

Re: [pgadmin-support] save location for queries

2015-07-22 Thread Guillaume Lelarge
Hi, 2015-07-22 20:52 GMT+02:00 Joseph Montibello < joseph.montibe...@dartmouth.edu>: > Hi, > > Thanks for the reply! I think I’m missing something, though. In looking > at the “favourites file path” in the documentation, it looks like it’s a > place to store bits and pieces of SQL queries that

Re: [pgadmin-support] Retore database on win xp from back up created with win 7 64 bit gets unsupported version

2015-06-30 Thread Guillaume Lelarge
2015-06-30 13:44 GMT+02:00 Ron Gregor : > I only did the plain text as it was a suggested test. > That's a good test as long as you don't use pgAdmin to restore it :) > I still have the situation that the same version of pgadmin makes a back > up on a win 7 64 bit machine can not be restored u

Re: [pgadmin-support] Retore database on win xp from back up created with win 7 64 bit gets unsupported version

2015-06-29 Thread Guillaume Lelarge
Le 29 juin 2015 11:25 PM, "Ron Gregor" a écrit : > > 32/64 bit problem - That is what I am trying to find out if there is a problem with running the on 32 bit versus 64 bit machines. I did not find any place to download a windows 64 bit version. > > I created a backup using the PLAIN option (close

Re: [pgadmin-support] load a database structure from a file

2015-06-09 Thread Guillaume Lelarge
Le 9 juin 2015 8:36 AM, "ofezzaz" a écrit : > > Hello everyone it's me again. I have finally managed to connect to a server > and create one enmpty database. I have to load the structure for this > database from a specific file. > So i opened the PLSQL terminal but apparently i can't load the file

Re: [pgadmin-support] Running explain analyze in a transaction

2015-04-11 Thread Guillaume Lelarge
ime on his hands. > Thanks. > > On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge wrote: >> >> Hi, >> >> 2015-04-10 1:13 GMT+02:00 Tim Uckun : >>> >>> I want to to do the following. >>> >>> begin; >>> explain analyze

Re: [pgadmin-support] Table DDL scripts generated by pgAdmin incorrectly show the constraint name using the implicit index name (on Greenplum).

2015-03-08 Thread Guillaume Lelarge
2015-03-08 12:51 GMT+01:00 Danilo Fortunato : > Thanks Guillaume. > On which version of PostegreSQL have you done the test ? > > 9.4. Kinda like a reflex to always use the latest :) Should have tried the 8.2, sorry. > If your test, as I suppose, has been done on a version of PostgreSQL more >

Re: [pgadmin-support] Can somebody UNSUBSCRIBE me from this group?

2015-03-08 Thread Guillaume Lelarge
2015-03-08 10:51 GMT+01:00 Dave Page : > I don't check regularly, but I did just take a look and the instructions > are there and do take you to a page with options to unsubscribe. > > Works for me too. > Further, both the PostgreSQL (http://www.postgresql.org/list/) and > pgAdmin websites (http

Re: [pgadmin-support] Table DDL scripts generated by pgAdmin incorrectly show the constraint name using the implicit index name (on Greenplum).

2015-03-08 Thread Guillaume Lelarge
Hi, 2015-03-07 22:01 GMT+01:00 Danilo Fortunato : > I use pgAdmin III 1.20.0 on a Greenplum database 4.2.6.3, which is based > on PostgreSQL 8.2.15. > I'm aware that this version of PostgreSQL is no more supported by pgAdmin. > > I noticed that the DDL scripts generated by pgAdmin for the tables,

Re: [pgadmin-support] Web acces to pgAdminIII?

2015-02-23 Thread Guillaume Lelarge
Le 23 févr. 2015 15:46, "Devrim Gündüz" a écrit : > > > Hi, > > On Mon, 2015-02-23 at 08:30 +0100, Deshogues Arnaud wrote: > > There is a ticket name : Web acces to pgAdminIII? > > > > From the : Date: 2003-09-09 03:13:47 > > > > with the ID > > Message-ID:000e01c37680$62cd77b0$3301a8c0@Dennis > >

Re: [pgadmin-support] Web acces to pgAdminIII?

2015-02-23 Thread Guillaume Lelarge
Hi, 2015-02-23 8:30 GMT+01:00 Deshogues Arnaud : > There is a ticket name : Web acces to pgAdminIII? > > From the : Date: 2003-09-09 03:13:47 > > with the ID > Message-ID:000e01c37680$62cd77b0$3301a8c0@Dennis > > without answer from pgadmin support. > > > > Is there a way to acces all the functio

Re: [pgadmin-support] How do I edit a Composite Type for Postgres in pgAdmin

2015-02-19 Thread Guillaume Lelarge
Le 19 févr. 2015 19:52, "mpiaser" a écrit : > > I figured it out. Apparently there is an option you have to check on in order for Composite Types to show up in pgAdmin. > > Yeah, only some objects kinds are displayed on pgAdmin by default. You need to ask pgAdmin to display the others.

Re: [pgadmin-support] How do I edit a Composite Type for Postgres in pgAdmin

2015-02-19 Thread Guillaume Lelarge
Hi, Le 19 févr. 2015 16:30, "mpiaser" a écrit : > > I need to modify a Composite Type in Postgres but I can't figure out how to > do this in pgAdmin. > Why? What's the issue you have?

Re: [pgadmin-support] Results messages in "results output" window

2015-02-13 Thread Guillaume Lelarge
2015-02-13 19:09 GMT+01:00 J.F. Oster : > Hello Edson, > > Friday, February 13, 2015, 8:54:58 PM, you wrote: > > ER> On 13-02-2015 15:46, Guillaume Lelarge wrote: > > ER> Le 13 fevr. 2015 18:39, "Edson Richter" > ER> a ecrit : > >

Re: [pgadmin-support] Results messages in "results output" window

2015-02-13 Thread Guillaume Lelarge
Le 13 févr. 2015 18:39, "Edson Richter" a écrit : > > Dear friends, > > I've been using PgAdmin 12.0.0 released on Jan 6, 2015, compiled in my Ubuntu 14.04 x64. > Nothing noticiable in terms of use (actually, there are few known bugs, but they don't bug me anyway). > > I would like to know if ther

Re: [pgadmin-support] How to turn on pgScript in pgAdmin

2015-02-09 Thread Guillaume Lelarge
Hi, 2015-02-09 22:25 GMT+01:00 slavrenz : > I have been using pgAdmin for a while, and I am looking for a way to > declare > variables within the program (on the SQL Editor side, not the Graphical > Query side). pgScript appears to be the answer, but I cannot get it to > work. > > When I try a si

Re: [pgadmin-support] Is the "x ms" info reliable?

2015-01-19 Thread Guillaume Lelarge
2015-01-19 16:26 GMT+01:00 Richard D Levine : > When I have pgAdmin, my app, and PG all running on the same machine, > pgAdmin reported query times are one or two orders of magnitude slower than > times for the same query reported by turning on statement logging. > > Yeah, I agree with the OP. I'm

Re: [pgadmin-support] pg_proc?

2014-12-17 Thread Guillaume Lelarge
2014-12-17 8:55 GMT+01:00 David G Johnston : > > Guillaume Lelarge-3 wrote > > Hi, > > > > Le 8 déc. 2014 20:53, "Wim Bertels" < > > > wim.bertels@ > > > > a écrit : > >> > >> Hallo, > >> > >> pg

Re: [pgadmin-support] pg_proc?

2014-12-16 Thread Guillaume Lelarge
Hi, Le 8 déc. 2014 20:53, "Wim Bertels" a écrit : > > Hallo, > > pg_admin needs access to pg_proc of a database to work, > it fails without having this access, (wanting to read out the metadata) > while eg psql succeeds > > use case: > > revoke all on pg_catalog.pg_proc from public; > > then try

Re: [pgadmin-support] RSS feed?

2014-11-25 Thread Guillaume Lelarge
Hi, Le 25 nov. 2014 11:07, a écrit : > > It's getting old to visit the pgAdmin website every single day to check for new releases. Why is there no RSS feed for new stable releases? AFAIK, the program itself doesn't check for new versions either. For the website, no real reason to do so. Announce

Re: [pgadmin-support] "There is no binary release yet for Windows and Mac OS X, but that should come in the next few days."

2014-11-20 Thread Guillaume Lelarge
Hi, Le 21 nov. 2014 02:03, a écrit : > > "2014-10-09 - pgAdmin v1.20 beta2 available" > > Today is 2014-11-21. "Next few days" indeed... > > Is this new release going to go stable anytime soon, BTW? I can't wait for it because while pgAdmin has been useful, and is certainly no easy task to code,

Re: [pgadmin-support] OSX UI Crashes

2014-11-06 Thread Guillaume Lelarge
Hey, Please, keep the thread on the mailing list. 2014-11-06 9:50 GMT+01:00 Dave Barter : > > > > Case 2 we can live with. case 1 is causing no end of heartache and I bet > is down to a problem with the WX control not PGAdmin. Is there anything we > can do to help or proactively fix this, bearin

Re: [pgadmin-support] OSX UI Crashes

2014-11-05 Thread Guillaume Lelarge
Le 5 nov. 2014 10:46, "Dave Barter" a écrit : > > We’ve developed a 20,000 line+ workflow in PL/PGSQL pgadmin is by far the best tool for developing and debugging the PL/PGSQL scripts > > > But we use OSX as our office platform and are seeing continuing UI crashes in two cases. > > > Case 1, we ha

Re: [pgadmin-support] index only scans are not shown graphically

2014-11-03 Thread Guillaume Lelarge
2014-11-03 19:07 GMT+01:00 J.F. Oster : > Hello, > > Monday, November 3, 2014, 9:40:24 AM, Guillaume Lelarge wrote: > > GL> The question mark is used when we don't have a specific icon. > GL> The last new nodes don't have that. We'll need to find someone to

Re: [pgadmin-support] index only scans are not shown graphically

2014-11-02 Thread Guillaume Lelarge
Hi, Le 30 oct. 2014 21:43, "Марк Коренберг" a écrit : > > Linux Mint 17 > > pdAdminIII 1.18.1 Jan 21 2014 > > > select id from incremental where id in (-10, 1,20,3) > > > "Index Only Scan using incremental_pkey on public.incremental > (cost=0.29..21.23 rows=4 width=4) (actual time=0.016..

Re: [pgadmin-support] SSH Tunnel port

2014-10-04 Thread Guillaume Lelarge
Hi, 2014-10-04 15:04 GMT+02:00 Eric Wadsworth : > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Guillaume, > > No, you can tunnel already. I do it all the time to connect pgadmin to > our production machines. > > Connect to the remote machine from your os, with the ssh command. You > can us

Re: [pgadmin-support] SSH Tunnel port

2014-10-04 Thread Guillaume Lelarge
Le 4 oct. 2014 13:42, "Stephen Cook" a écrit : > > I need to tunnel through one server to my database server (which only allows connections from that server), but SSH is on a non-standard port. > > According to the internet, there is an update that would add a "Port" field to the settings window f

Re: [pgadmin-support] log_error_verbosity

2014-10-01 Thread Guillaume Lelarge
Hi, Le 24 sept. 2014 10:06, "Dave Barter" a écrit : > > Is there a way I can set log_error_verbosity to be terse in the pgadmin client? > > I tried this in the query window:- > > SET log_error_verbosity to terse; > > But it has no effect, I suspect it needs to be done in the clinet config somewhe

Re: [pgadmin-support] No high resolution support in Windows

2014-10-01 Thread Guillaume Lelarge
Hi, Le 26 sept. 2014 16:33, a écrit : > > pgAdmin Version: 1.18.1 > > OS: Microsoft Windows [Version 6.3.9600] (8.1 Pro 64 bit) > > 1. Use Control Panel\Appearance and Personalisation\Display to set a high dpi: > > http://i.imgur.com/WQJmlWe.png > > 2. Logout/login again to make sure the changes

Re: [pgadmin-support] New line for stored procedure parameters?

2014-08-08 Thread Guillaume Lelarge
2014-08-08 23:19 GMT+02:00 David G Johnston : > inspector morse wrote > > I have a stored procedure with several input/output parameters (about 50 > > of > > them). Everytime I go to edit the stored procedure in pgAdmin3, it prints > > all of the parameters in the same line...even if I last saved

Re: [pgadmin-support] Behavior of the "Explain query" button with multiple queries in the window

2014-07-27 Thread Guillaume Lelarge
Le 23 juil. 2014 10:17, "Nicolas Anonyme" a écrit : > > 2014-07-22 23:24 UTC+02:00, Guillaume Lelarge : > > Though I wonder what your colleague expects launching an EXPLAIN on a number of > > queries? we won't draw all query plans, that has not much sense to me

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

2014-07-25 Thread 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: h

Re: [pgadmin-support] Behavior of the "Explain query" button with multiple queries in the window

2014-07-22 Thread Guillaume Lelarge
Le 23 juil. 2014 00:33, "Julien Rouhaud" a écrit : > > On Tue, Jul 22, 2014 at 11:24 PM, Guillaume Lelarge < guilla...@lelarge.info> wrote: >> >> Hi, >> >> 2014-07-22 20:33 GMT+02:00 Nicolas Anonyme : >>> >>> Hello, >>>

Re: [pgadmin-support] Behavior of the "Explain query" button with multiple queries in the window

2014-07-22 Thread Guillaume Lelarge
Hi, 2014-07-22 20:33 GMT+02:00 Nicolas Anonyme : > Hello, > > Today, one of my coworker was preparing several "update" and "insert" > queries, in a query window, and he pressed the "Explain query" button > to check the query plan, expecting it to be inoffensive. > He then sent me the requests to

Re: [pgadmin-support] wxWidgets versioning

2014-07-21 Thread Guillaume Lelarge
2014-07-21 20:53 GMT+02:00 Scott Furry : > Is there work underway to update pgAdmin to use the 3.0 branch of > wxWidgets? > > AFAICT, this work is already done. I didn't check lately though. > The INSTALL file and build-wxgtk make mention of the need for the > wxWidgets 'contrib' directory. > My

Re: [pgadmin-support] Exporting Table-Specified BLOBs Only?

2014-07-21 Thread Guillaume Lelarge
2014-07-21 18:47 GMT+02:00 Braunstein, Alan : > Is any Developer looking at this issue? > AFAICT, you want a new feature for pg_dump, not from pgAdmin. So you should ask on pgsql-hackers, not pgadmin-support. And I don't think anyone is working on this. > > > *From:* pgadmin-support-ow...@post

Re: [pgadmin-support] pg_hba.conf editing question

2014-07-21 Thread Guillaume Lelarge
Le 21 juil. 2014 17:34, "Scott Furry" a écrit : > > > On 21/07/14 08:58 AM, Christoph Berg wrote: >> >> That split conf-data setup is supported by PostgreSQL, so it's not >> Debian to blame. I think it is a bug (or missing feature) that >> pg_read_file doesn't let you read files in the conf direct

Re: [pgadmin-support] pg_hba.conf editing question

2014-07-20 Thread Guillaume Lelarge
2014-07-20 23:15 GMT+02:00 Scott Furry : > > On 20/07/14 02:45 PM, Guillaume Lelarge wrote: > >> 2014-07-19 18:11 GMT+02:00 Scott Furry > scott.wl.fu...@gmail.com>>: >> >> >> I am working with the pgAdmin git source and I am having trouble >>

Re: [pgadmin-support] pg_hba.conf editing question

2014-07-20 Thread Guillaume Lelarge
2014-07-19 18:11 GMT+02:00 Scott Furry : > I am working with the pgAdmin git source and I am having trouble > understanding the adminpack functions being used. > > In the file pgadmin/frm/frmHbaConfig.cpp, the pg_hba.conf edit form > constructor appears to get the absolute path to the configuratio

Re: [pgadmin-support] generating all reports

2014-07-18 Thread Guillaume Lelarge
Le 17 juil. 2014 17:17, "Seb" a écrit : > > Hi, > > I am trying to document my databases, and AFAICS there's no way to > automatically generate all reports of all tables and fields. You're right. > I could > manually do this in each table and its fields, but this could be very > tedious with num

Re: [pgadmin-support] Updateable View wizard

2014-07-03 Thread Guillaume Lelarge
Hi, 2014-07-03 15:52 GMT+02:00 Pavel Veselský : [...] > > > I am a DBA whose database relies heavily on updateable views, so I would > like to ask on the state of "Updateable View wizard" listed in your TODO > list. Are there any preliminary results? Does anyone develop it? Are there > any prospec

Re: [pgadmin-support] External Editor Support

2014-07-02 Thread Guillaume Lelarge
2014-07-02 10:12 GMT+02:00 Dave Barter : > We are using pgAdmin a lot for day to day database development and > support. JSON is increasingly important to us as the features in 9.3/9.4 > make this a dream for DB development. > > Editing json fields in pgAdmin is almost unworkable (Mac OSX) and we

Re: [pgadmin-support] Sudenly unable to backup from database

2014-06-19 Thread Guillaume Lelarge
So either someone changed the password, or the pgpass got corrupted some way. But I can't reproduce this. > On Jun 18, 2014, at 7:36 AM, Guillaume Lelarge-3 [via PostgreSQL] > wrote: > > > On Tue, 2014-06-03 at 11:31 -0700, jackrg wrote: > > > > > Using

Re: [pgadmin-support] Sudenly unable to backup from database

2014-06-18 Thread Guillaume Lelarge
On Tue, 2014-06-03 at 11:31 -0700, jackrg wrote: > Using pgAdmin 1.14.1, earlier this morning I did a backup of a single table > from my database in plain format, which completed successfully. I now try to > repeat that operation and it fails. Here are the messages from the attempt: > > /Applicati

Re: [pgadmin-support] In next version, add PostgreSQL 9.4.x support or release "beta"version....

2014-05-26 Thread Guillaume Lelarge
On Sun, 2014-05-25 at 01:48 -0700, Dutch Glory wrote: > > In next version of PGAdmin, please add PostgreSQL 9.4.x support or release > "beta" version > Work is on-going to support 9.4 PostgreSQL release. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent vi

Re: [pgadmin-support] improvement suggestions

2014-05-10 Thread Guillaume Lelarge
On Sat, 2014-05-10 at 07:32 +0400, J.F. Oster wrote: > Hello Aaron, > > Saturday, May 10, 2014, 5:11:55 AM, you wrote: > > AZ> Screenshot is available here.═ > AZ> > https://dl.dropboxusercontent.com/u/779054/Screen%20Shot%202014-05-09%20at%206.09.57%20PM.png > > AZ> I put my cursor in the midd

Re: [pgadmin-support] improvement suggestions

2014-05-09 Thread Guillaume Lelarge
Please, keep your answers on the mailing list. On Fri, 2014-05-09 at 13:29 -0700, Aaron Zinman wrote: > But what about the delete->drop in textfield bug, specifically? What is > required to fix that? That’s my biggest motivation in terms of practical > everyday usage being jarring. > Well, to

Re: [pgadmin-support] improvement suggestions

2014-05-09 Thread Guillaume Lelarge
On Fri, 2014-05-09 at 13:19 -0700, Aaron Zinman wrote: > So I have a startup of my own so basically I have zero time. I understand that. > If some of these are trivial to do (which means I don’t have to understand > any global nature of how pgadmin works), and you can point me in the right > way

Re: [pgadmin-support] improvement suggestions

2014-05-09 Thread Guillaume Lelarge
On Fri, 2014-05-09 at 22:02 +0400, J.F. Oster wrote: > Hello, > > Friday, May 9, 2014, 7:23:17 PM, Al Chou wrote: > > AC> Hear, hear! to all of these points. ═Are the text navigation > AC> keys correctly supported on other OS's? ═Is that why no one has > AC> complained until now (that I know of)?

Re: [pgadmin-support] Materialized views in pgadmin

2014-05-09 Thread Guillaume Lelarge
there's so much to change in the code to get that little icon that I would rather not write that for a minor release. Could be interesting to get it for 1.20 though. > Cheers, > > Eduard > > > On 04/05/14 11:15, Guillaume Lelarge wrote: > > Hi, > >

Re: [pgadmin-support] improvement suggestions

2014-05-09 Thread Guillaume Lelarge
On Tue, 2014-05-06 at 18:45 -0700, Aaron Zinman wrote: > Hi PgAdmin team, > > I’ve been a faithful user of your product on os x for many years now. I’ve > tried many other clients but in the end they all lack some aspect of my > workflow that I get out of pgadmin. There have been a few things th

Re: [pgadmin-support] Not connecting to the postgresql server

2014-05-09 Thread Guillaume Lelarge
On Thu, 2014-05-08 at 07:53 -0500, espe...@oreillyauto.com wrote: > I need help with why my server is having issues. There is nothing in the > logs showing any errors on startup. This is the command and error I get > from a remote server when testing. > > > > psql -h 172.16.36.231 -p -l >

Re: [pgadmin-support] query tool no longer working

2014-05-04 Thread Guillaume Lelarge
ur servers once again). PS: please reply to the list. > > On Sun, 5/4/14, Guillaume Lelarge wrote: > > Subject: Re: [pgadmin-support] query tool no longer working > To: "Jim Bryan" > Cc: pgadmin-support@postgresq

Re: [pgadmin-support] query tool no longer working

2014-05-04 Thread Guillaume Lelarge
On Sat, 2014-05-03 at 15:34 -0700, Jim Bryan wrote: > Hi! Have been using PG 9.1 with the sql query tool for months, perfectly. > Now the query tool window is suddenly blanked-out. > Ubuntu 12.04 LTS. Can connect and still access data in tables. And can > connect via perl ide and then update,

Re: [pgadmin-support] Materialized views in pgadmin

2014-05-04 Thread Guillaume Lelarge
Hi, On Tue, 2014-04-29 at 13:54 +0200, Eduard Szöcs wrote: > Hai, > > Using the Graphical Query Builder in pgadmin 1.18.1 materialized views > do not show up in the left pane. > > Is this intended? Not implemented? How can I fix this? > I think the developer who added support for materialized

Re: [pgadmin-support] v1.18.x release schedule

2014-04-03 Thread Guillaume Lelarge
On Thu, 2014-04-03 at 12:05 -0400, David Elbert wrote: > Hi- > > Apologies if I missed this somewhere online, but I am wondering: when will > pgadmin version 1.18.2 or higher be released? I made a bug report in > February and Dinesh Kumar kindly let me know it had been fixed, but I still > hav

Re: [pgadmin-support] No pgadmin3 x86_64 for CentOS 5 on pgdg93 yum repo

2014-04-03 Thread Guillaume Lelarge
On Thu, 2014-04-03 at 10:31 -0700, l...@fastmail.us wrote: > Thanks for your response. pkgs.org is good to know about, but the > version of pgadmin available there (1.8.4) seems to be incompatible with > PostgreSQL 9.3. I will stick with the command line until our next server > upgrade. Thank you a

Re: [pgadmin-support] Search feature request

2014-03-05 Thread Guillaume Lelarge
On Wed, 2014-03-05 at 07:40 -0600, Michael Shapiro wrote: > I know that PgAdmin has the ability to find a pattern in various object > names. > > Can PgAdmin search the actual text of procedures to find a pattern as well. > > For example, if I have a procedure named get_login, and it has a select

Re: [pgadmin-support] pgAdmin III does not display Default Privileges for schemas

2014-02-13 Thread Guillaume Lelarge
On Thu, 2014-02-13 at 14:10 -0800, Shira Bezalel wrote: > On Thu, Feb 13, 2014 at 1:56 PM, Guillaume Lelarge > wrote: > > > On Thu, 2014-02-13 at 13:26 -0800, Shira Bezalel wrote: > > > Okay, you're right. Sorry about that -- that exact test case is working,

Re: [pgadmin-support] pgAdmin III does not display Default Privileges for schemas

2014-02-13 Thread Guillaume Lelarge
a login > role. Default privilege changes for login roles don't seem to show up in > pgAdmin III -- are they supposed to? > Yes. Did you allow showing login roles in the options dialog? And please, don't top-post, it makes it hard to read and follow. > Shira > > &

Re: [pgadmin-support] pgAdmin III does not display Default Privileges for schemas

2014-02-13 Thread Guillaume Lelarge
On Thu, 2014-02-13 at 12:40 -0800, Shira Bezalel wrote: > Hello, > > I found this thread from 2012 concerning a problem where pgAdmin III > doesn't display default privileges for schemas: > > http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain > > The thread says

Re: [pgadmin-support] Why doesn't PGAdmin support backing up of schema only or data only?

2014-02-12 Thread Guillaume Lelarge
On Sun, 2014-02-09 at 11:18 +0100, Guillaume Lelarge wrote: > On Sat, 2014-02-08 at 18:28 +0100, Guillaume Lelarge wrote: > > On Fri, 2014-02-07 at 14:32 +, Rob Richardson wrote: > > > Greetings! > > > > > > I have been curious for several years: Why do

Re: [pgadmin-support] Why doesn't PGAdmin support backing up of schema only or data only?

2014-02-09 Thread Guillaume Lelarge
On Sat, 2014-02-08 at 18:28 +0100, Guillaume Lelarge wrote: > On Fri, 2014-02-07 at 14:32 +, Rob Richardson wrote: > > Greetings! > > > > I have been curious for several years: Why doesn't PGAdmin's backup screen > > allow me to save data

Re: [pgadmin-support] Why doesn't PGAdmin support backing up of schema only or data only?

2014-02-08 Thread Guillaume Lelarge
On Fri, 2014-02-07 at 14:32 +, Rob Richardson wrote: > Greetings! > > I have been curious for several years: Why doesn't PGAdmin's backup screen > allow me to save data only or schema only in custom format? > > > I am trying to test a long-running application that uses a PostgreSQL > data

Re: [pgadmin-support] Format SQL (external tool)

2014-02-06 Thread Guillaume Lelarge
On Thu, 2014-02-06 at 20:34 +0800, Craig Ringer wrote: > On 02/06/2014 06:25 PM, Michal Kozusznik wrote: > > We are using SQL Assistant for a lot of tasks like code formatting, > > Autocomplete, code searching etc. Really powerful tool. > > Unfortunately pgAdmin developers has been rejected my requ

Re: [pgadmin-support] pgadmin3-1.18.1//pgadmin/dd/ddmodel/ddDBReverseEnginering.cpp: 2 * bad if test ?

2013-12-21 Thread Guillaume Lelarge
On Fri, 2013-12-06 at 20:32 +, Dave Page wrote: > Thanks David. Guillaume, any chance you can take a look at this > please? I'm not at all familiar with that code, and I'm not entirely > sure what it's supposed to be doing. > Sorry for the late answer. It's fixed. Thanks for the report. > Th

Re: [pgadmin-support] Parallel Jobs option feature for backup

2013-10-13 Thread Guillaume Lelarge
On Sun, 2013-09-29 at 20:53 +0200, Guillaume Lelarge wrote: > On Mon, 2013-09-09 at 09:00 +0100, Dave Page wrote: > > On Sat, Sep 7, 2013 at 7:06 PM, Paragon Corporation wrote: > > > Now that PostgreSQL 9.3 has the parallel backup feature in pg_dump, would > > > it >

Re: [pgadmin-support] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

2013-09-29 Thread Guillaume Lelarge
On Sun, 2013-09-29 at 22:29 +0200, Sven Meirsman wrote: > Sorry, My mistake. > > 'Binary Paths' is the section you choose at the left of the screen. It > contains several paths, one 'PG Bin Path' is directing to my postgres BIN > folder like you suggest. It is the Slony-I path that contains the pa

Re: [pgadmin-support] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

2013-09-29 Thread Guillaume Lelarge
On Sun, 2013-09-29 at 21:13 +0200, Sven Meirsman wrote: > Hello, > > I am having difficulties getting the slony-i scripts recognized and found > by pgAdmin, > > I am running > - Windows Server 2003. > - Postgres 9.3 + PostGIS 2.1.0 > - pgAdmin 1.18.0 > - slony-I 2.2.0 > > I installed slony-i 2.2

Re: [pgadmin-support] Parallel Jobs option feature for backup

2013-09-29 Thread Guillaume Lelarge
On Mon, 2013-09-09 at 09:00 +0100, Dave Page wrote: > On Sat, Sep 7, 2013 at 7:06 PM, Paragon Corporation wrote: > > Now that PostgreSQL 9.3 has the parallel backup feature in pg_dump, would it > > be possible to have that option on the pgAdmin Backup menu panel? > > > > I didn't see it on 1.18.0

Re: [pgadmin-support] PGADMIN III: backup bug report

2013-09-29 Thread Guillaume Lelarge
On Thu, 2013-09-05 at 11:19 +, Marta Mihoff wrote: > I would like to post this bug: > Using the backup option (right click on an object) and then selecting the > Objects tab: Not all objects appears in the list. This is true for versions > 1.14.3 and the most recent version 1.16.1 downloaded

Re: [pgadmin-support] PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.

2013-09-29 Thread Guillaume Lelarge
On Mon, 2013-09-16 at 12:59 +, Yuri Levinsky wrote: > Dear support, > Affected version: any version. > Distribution type: any type. > Detected on OS: Win 7 > > Anonymous code block can't be executed by pressing "Execute PG script" > button, getting the following error: [ERROR] 1.0: synta

Re: [pgadmin-support] Pg Admin Libraries

2013-09-29 Thread Guillaume Lelarge
On Sun, 2013-09-29 at 18:46 +0200, Sascha Schertler wrote: > Hello PostgreSQL Support, > Actually, this is pgAdmin support mailing list. > I got a question about using Pg admin libraries in my program. I am a > student from the Fh Regensburg and I want to develop a program. > > Is it allowed to

[pgadmin-support] Translation updates

2013-09-29 Thread Guillaume Lelarge
Hi, With the thread on the spanish translation, I took some time to look at our status on translations. We currently have 10 uptodate translations (ie, more than 85% translated strings). It would be great to have more than 10 translations. Some translations are mostly done: * Farsi, 79% * Chine

Re: [pgadmin-support] Spanish language missing in pgadmin 1.8.3

2013-09-29 Thread Guillaume Lelarge
On Sun, 2013-09-29 at 13:35 +, Dave Page wrote: > On Sun, Sep 29, 2013 at 1:16 PM, jbru wrote: > > Dear Guillaume > > > > As a 10 years PostgreSQL/pgAdmin user at different levels, I am completely > > disappointed with this situation. > > > > Most of people has not the knowledge for patching.

Re: [pgadmin-support] Spanish language missing in pgadmin 1.8.3

2013-09-29 Thread Guillaume Lelarge
On Sat, 2013-09-28 at 11:43 -0700, jbru wrote: > Anyways, > > Is there a delivery date for the fixed release??? > No. 1.18.1 will be available at the same time than the next PostgreSQL minor releases. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmi

Re: [pgadmin-support] Spanish language missing in pgadmin 1.8.3

2013-09-28 Thread Guillaume Lelarge
On Fri, 2013-09-27 at 15:40 -0700, jbru wrote: > This is just imposible for me to believe that this is just a mistake. > Which means? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make cha

Re: [pgadmin-support] Spanish language missing in pgadmin 1.8.3

2013-09-28 Thread Guillaume Lelarge
Please keep the replies on the mailing list. On Sat, 2013-09-28 at 15:45 +0200, Juan Bru wrote: > It means exactly what it means. > I do think I was quite clear. > Actually, no, you aren't clear on what you're impliying. Seeing how it goes, I'm not sure I give a damn though. This was a mistak

Re: [pgadmin-support] Spanish language missing in pgadmin 1.8.3

2013-09-27 Thread Guillaume Lelarge
On Fri, 2013-09-27 at 19:17 +0200, David Carlos Manuelda wrote: > I upgraded to version 1.8.3, with spanish selected as always, but now, > spanish language have dissappeared completelly, being replaced by > catalonian language. > > My system's locale is: > LANG=es_ES > LC_CTYPE="es_ES.utf8" > LC_N

Re: [pgadmin-support] connection lost related issues are still *painful*

2013-09-20 Thread Guillaume Lelarge
On Fri, 2013-09-20 at 18:10 +0200, Michal Kozusznik wrote: > A can confirm. > A lot of unwanted behaviour in case of broken connection (including > pgadmin crash). > As far as I remember it has been reported multiple times, and answered > that it is not possible to fix it due to ammount of work n

Re: [pgadmin-support] Feature: Object Browser Open Quickly

2013-07-18 Thread Guillaume Lelarge
On Sat, 2013-06-29 at 00:17 +0200, Eike Dierks wrote: > HI everyone reading pg-admin-support > > I'd like to suggest a new feature to improve the usability of pgAdmin. > > Some of you might know XCode, the IDE from Apple. > They have a feature called "Open Quickly" > I believe such a feature woul

Re: [pgadmin-support] comparison schema/data

2013-07-17 Thread Guillaume Lelarge
On Wed, 2013-07-17 at 12:00 -0300, Javier Urbano Contreras wrote: > Does anyone any tool in command line for comparison schema/data? check_postgres.pl -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.o

Re: [pgadmin-support] [BUG] Wrong colors on SQL table result

2013-06-19 Thread Guillaume Lelarge
On Wed, 2013-06-19 at 16:07 -0300, Luiz Angelo Daros de Luca wrote: > Hello, > > I'm using pgadmin3 1.14.3 on OpenSUSE 12.3. I'm facing problems with > pgadmin3 color on SQL query result table when using "OpenSUSE Dark theme" > on KDE. pgadmin3 uses: > > non selected cell background color = View

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-19 Thread Guillaume Lelarge
On Wed, 2013-06-19 at 18:44 +0100, Marc Cooper wrote: > On 19/06/13 18:33, Guillaume Lelarge wrote: > > On Wed, 2013-06-19 at 10:39 +0100, Marc Cooper wrote: > >> On 18/06/13 22:33, Guillaume Lelarge wrote: > >>> On Tue, 2013-06-18 at 22:19 +0100, Marc Cooper w

Re: [pgadmin-support] (Bug) Numeric fault calculation

2013-06-19 Thread Guillaume Lelarge
On Tue, 2013-06-18 at 15:30 -0700, David Johnston wrote: > Guillaume Lelarge-3 wrote > > If you use a floating > > point datatype (which is what happens when you don't specificy the > > type), > > I covered this in my prior post but per the documentatio

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-19 Thread Guillaume Lelarge
On Wed, 2013-06-19 at 10:39 +0100, Marc Cooper wrote: > On 18/06/13 22:33, Guillaume Lelarge wrote: > > On Tue, 2013-06-18 at 22:19 +0100, Marc Cooper wrote: > >> On 18/06/13 22:12, Guillaume Lelarge wrote: > >>> On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote:

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-19 Thread Guillaume Lelarge
On Wed, 2013-06-19 at 12:20 -0500, Michael Shapiro wrote: > One more thought. Is he on a file-system that imposes additional access > control. /afs does this, for example. > That's one possibility. The other one is that his libxml is buggy. > On Wed, Jun 19, 2013 at 12:03 PM,

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-19 Thread Guillaume Lelarge
On Tue, 2013-06-18 at 16:54 -0500, Michael Shapiro wrote: > Maybe he doesn't have a Favourites file path set in the Query Tool options? > That was an interesting thought, but even without a favourites file path, the menu is still enabled. It fails later though. -- Guillaume http://blog.guillau

Re: [pgadmin-support] pgAdmin with a driver to run Sql statements over multiple databases

2013-06-18 Thread Guillaume Lelarge
Hi, On Tue, 2013-06-04 at 13:57 -0700, Matthieu Labour wrote: > [...] > Is it possible for pgAdmin to execute SQL statements over multiple > databases? > > As an example, if one has done horizontal sharding with Databas01, > Database02...DatabaseN having the same schema and the data spread over t

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Guillaume Lelarge
On Tue, 2013-06-18 at 22:19 +0100, Marc Cooper wrote: > On 18/06/13 22:12, Guillaume Lelarge wrote: > > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: > >> Hi, > >> > >> When in the SQL editor, I can no longer add queries to my favourites. > >>

Re: [pgadmin-support] Trucate Cascaded YES

2013-06-18 Thread Guillaume Lelarge
On Tue, 2013-06-04 at 11:36 -0300, Humberto Cereser Ibanez wrote: > Hello list, > > There was a sinister in all data on a table. > > Explaining > > My right button mouse started a defect that was doing multiples clicks > when pressed. > > I did wish to backup a table. Then I clicked with a righ

Re: [pgadmin-support] SQL editor view, Add favourite disabled

2013-06-18 Thread Guillaume Lelarge
On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: > Hi, > > When in the SQL editor, I can no longer add queries to my favourites. > > I have added entries in the past, and I can see these and access them, > but I can no longer add new entries as the menu item "Add favourite..." > is greyed ou

Re: [pgadmin-support] (Bug) Numeric fault calculation

2013-06-18 Thread Guillaume Lelarge
On Sun, 2013-06-16 at 04:59 -0700, Chirag Mittal wrote: > Dear Kanitchet, > > Please try this > > SELECT (260739.94 * (1.00/365.00))::numeric(20,7) > > I am a beginner but I think we need to explicitly mention the "output" > format required to get accuracy. > Nope, you simply need to use the

Re: [pgadmin-support] PGAdmin 1.18.0 alpha compile

2013-06-01 Thread Guillaume Lelarge
On Fri, 2013-05-31 at 19:47 +0200, Pieter du Plooy wrote: > Guys > > Was planning to use 1.16.1 with Postgres 9.3 beta, but got an > incompatibility error: > > Warning: > > The server you are connecting to is not a version that is supported by this > release of pgAdmin III. > > pgAdmin III may

Re: [pgadmin-support] SQL window in 1.16.1

2013-06-01 Thread Guillaume Lelarge
On Thu, 2013-05-30 at 16:30 +0200, Milan Perovic wrote: > Hi all, > > I'm using PgAdmin 1.16.1 i it was working fine till couple a days ago. > > Now when I try to open SQL window, I get following error: > http://i.imgur.com/opgpNGa.jpg?1 > > (buttons are not visible, and some of them gain visib

Re: [pgadmin-support] [pgadmin-hackers] Remove dialogue "Apply" buttons?

2013-05-18 Thread Guillaume Lelarge
On Sat, 2013-05-18 at 14:26 +0100, Dave Page wrote: > On Sat, May 18, 2013 at 1:30 PM, Guillaume Lelarge > wrote: > > On Wed, 2013-05-15 at 16:57 +0100, Dave Page wrote: > >> The Function, Trigger and View dialogues (and the Package dialogue for > >> Postgres Plus

Re: [pgadmin-support] [pgadmin-hackers] Browser fixes

2013-05-18 Thread Guillaume Lelarge
On Thu, 2013-05-16 at 20:20 +0100, Dave Page wrote: > [CCing to -support as people there have been waiting for some of these fixes] > > The attached patch (against master) cleans up a number of issues in > the browser code: > > - It fixes the collapsing tree issue by reverting patch 1 which > att

Re: [pgadmin-support] [pgadmin-hackers] Remove dialogue "Apply" buttons?

2013-05-18 Thread Guillaume Lelarge
On Wed, 2013-05-15 at 16:57 +0100, Dave Page wrote: > The Function, Trigger and View dialogues (and the Package dialogue for > Postgres Plus Advanced Server users) are the only properties dialogues > in pgAdmin which have Apply buttons. > > They have these because those dialogues can be used to wr

  1   2   3   4   5   6   7   8   9   10   >