Re: [pgadmin-support] pgAdmin4-web install issues WAS: PgAdmin4 is not usable when installed from RPMs on Fedora linux

2016-10-10 Thread Magnus Hagander
On Mon, Oct 10, 2016 at 6:57 PM, Josh Berkus wrote: > On 10/10/2016 03:36 AM, Magnus Hagander wrote: > > > > > > On Mon, Oct 10, 2016 at 2:26 AM, Josh Berkus > <mailto:j...@agliodbs.com>> wrote: > > > > On 10/09/2016 04:36 PM, Josh Berkus wr

Re: [pgadmin-support] pgAdmin4-web install issues WAS: PgAdmin4 is not usable when installed from RPMs on Fedora linux

2016-10-10 Thread Magnus Hagander
t to make that "easily modifiable by packagers" so it can be adapter to whatever distro it's being packaged on? Surely it's wrong to store metadata file in /usr/share... -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [pgadmin-support] Massively annoying bug still not fixed in v1.20 :-(

2014-12-19 Thread Magnus Hagander
On Dec 19, 2014 5:02 PM, "Craig Ringer" wrote: > > On 12/19/2014 11:57 PM, Dave Page wrote: > > Right - we'd have to store the entries somewhere based on the target > > server and the SSH config, and dynamically rebuilt the pgpass file > > during the connection process. That seems a) ugly and b) v

Re: [pgadmin-support] Problem with multiple comments

2012-12-07 Thread Magnus Hagander
On Thu, Dec 6, 2012 at 6:39 PM, Dave Page wrote: > On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote: >> Certainly sounds like a very similar problem. If so, the query is >> simply buggy - it's just that a pg_upgrade'd environment is *much* >> more likely to r

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Magnus Hagander
t;> >> > that >> >> >> > have duplicates. >> >> >> >> >> >> The rows with objsubid set to something other than 0 are almost >> >> >> certainly comments on table columns (the sub ID being the column >> >>

Re: [pgadmin-support] Compile Source Code

2012-06-28 Thread Magnus Hagander
ng on debian is to run "apt-get build-dep pgadmin3". That will install *all* the required -devel packages, includein gother things like wxwidgets that are also required. And FWIW, if you just want the latest pgadmin, and don't actually *want* to hack it, check out backports.debian.org

Re: [pgadmin-support] incorrect charset in HTML report

2012-05-28 Thread Magnus Hagander
behaviour is correct. > String is "" > and it should be "". > After modification, Firefox and IE work as expected. That's clearly broken, yes. I've applied a patch for this, will be included in the next releases. Thanks for the report! --  Magnus Hagander  Me:

Re: [pgadmin-support] Calling pgScript from the command line

2011-01-18 Thread Magnus Hagander
On Tue, Jan 18, 2011 at 15:34, Dave Page wrote: > On Tue, Jan 18, 2011 at 2:12 PM, Magnus Hagander wrote: >> From what I can tell, we don't have visual studio project files for >> anything in xtra/ - Dave, correct? That would be a prerequisite. >> >> I'm not

Re: [pgadmin-support] Calling pgScript from the command line

2011-01-18 Thread Magnus Hagander
> > Wow thanks for the patch Magnus - so fast! > > Patch looks great. Is it also possible to update the patch to include the > win32 executable into the packaging? i.e pkg/win32/src/pgadmin3.wxs > > Cheers > Jeremy > > -Original Message- > From: Magnus Hagan

Re: [pgadmin-support] Calling pgScript from the command line

2011-01-17 Thread Magnus Hagander
On Mon, Jan 17, 2011 at 07:46, Magnus Hagander wrote: > On Sun, Jan 16, 2011 at 23:02, Dave Page wrote: >> On Sun, Jan 16, 2011 at 9:50 PM, Jeremy Palmer wrote: >>> It would be really awesome for DBAs admins to be able to run pgscripts from >>> the command line whic

Re: [pgadmin-support] Calling pgScript from the command line

2011-01-16 Thread Magnus Hagander
it, but not right now. (btw, we really should look at making it not compile pgscript twice - once for pgadmin and once for the one in xtra/. But that's something for another day :D) --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pga

Re: [pgadmin-support] Foreign key UI bug

2010-11-20 Thread Magnus Hagander
On Sat, Nov 20, 2010 at 12:37, Guillaume Lelarge wrote: > Le 20/11/2010 12:27, Magnus Hagander a écrit : >> On Sat, Nov 20, 2010 at 12:24, Guillaume Lelarge >> wrote: >>> Le 20/11/2010 04:50, Aren Cambre a écrit : >>>> I found a UI bug when creating a fo

Re: [pgadmin-support] Foreign key UI bug

2010-11-20 Thread Magnus Hagander
't allow (hence the "relation fki_ > already exists). > > I see one main solution to it: disallow the automatic index creation if > there is no name given to the foreign key. I'll write a patch for this, > but if you see a better way to deal with this, tell us. W

Re: [pgadmin-support] Graphical Query Builder -- expanding public requires annoying double click

2010-09-23 Thread Magnus Hagander
hing inside?  And is there that much of a cost of doing the scan >> anyway?  The user will nearly always need to open the schema node >> anyway. >> > > I'm not sure we can do this. The "+" sign appears when the node has > children. And before one double clic

Re: [pgadmin-support] [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !!

2010-04-22 Thread Magnus Hagander
QL commands by psql. > > The two applications are incompatible at that level. FYI, psql in PostgreSQL 9.0 will ignore UTF8 BOMs. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgadmin-support mailing list (pgadmin-support@pos

Re: [pgadmin-support] pgpass

2010-04-07 Thread Magnus Hagander
upported on most (all?) modern platforms. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Magnus Hagander
On Thu, Feb 4, 2010 at 10:16, Dave Page wrote: > On Thu, Feb 4, 2010 at 9:07 AM, Magnus Hagander wrote: >> On Thu, Feb 4, 2010 at 09:06, Guillaume Lelarge >> wrote: >>> Le 04/02/2010 04:23, Greg Smith a écrit : >>>> Problem #3:  Given the general popu

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Magnus Hagander
this.  I personally really need a PG9.0 compatible >> Jaunty build for example. >> > > I can tell you that this "someone" is not me. I don't have the time to > work on this. Yeah. Having a "pgadmin-daily" PPA for Ubuntu would certainly be pretty neat,

Re: [pgadmin-support] FW: question about wmware

2009-10-28 Thread Magnus Hagander
LiveT är mycket mer än din inkorg. > Mer än bara meddelanden <http://www.microsoft.com/windows/windowslive/> > -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Export server list

2009-09-29 Thread Magnus Hagander
Nothing is supposed to be changed around that, it should work fine. It may not work between versions as the parameters stored can vary a bit, but if they are the same version it should work perfectly fine. Just use the registry editor to export them. -- Magnus Hagander Me: http

Re: [pgadmin-hackers] [pgadmin-support] Possible simple enhancement

2009-09-16 Thread Magnus Hagander
On Wed, Sep 16, 2009 at 23:50, Guillaume Lelarge wrote: > Le mercredi 16 septembre 2009 à 09:53:26, Magnus Hagander a écrit : >> On Wed, Sep 16, 2009 at 07:09, Guillaume Lelarge > wrote: >> > Le mardi 15 septembre 2009 à 18:47:24, Guillaume Lelarge a écrit : >> >>

Re: [pgadmin-hackers] [pgadmin-support] Possible simple enhancement

2009-09-16 Thread Magnus Hagander
On Wed, Sep 16, 2009 at 07:09, Guillaume Lelarge wrote: > Le mardi 15 septembre 2009 à 18:47:24, Guillaume Lelarge a écrit : >> Le mardi 15 septembre 2009 à 09:57:55, Magnus Hagander a écrit : >> > On Tue, Sep 15, 2009 at 07:34, Guillaume Lelarge >> >> wrote: >&

Re: [pgadmin-hackers] [pgadmin-support] Possible simple enhancement

2009-09-15 Thread Magnus Hagander
On Tue, Sep 15, 2009 at 07:34, Guillaume Lelarge wrote: > Le mardi 15 septembre 2009 à 06:54:59, Magnus Hagander a écrit : >> On 15 sep 2009, at 00.48, Guillaume Lelarge >> >> wrote: >> > Le samedi 12 septembre 2009 à 14:49:04, Guillaume Lelarge a écrit : >>

Re: [pgadmin-hackers] [pgadmin-support] Possible simple enhancement

2009-09-14 Thread Magnus Hagander
On 15 sep 2009, at 00.48, Guillaume Lelarge wrote: Le samedi 12 septembre 2009 à 14:49:04, Guillaume Lelarge a écrit : Le mercredi 9 septembre 2009 à 20:46:00, Roger Niederland a écrit : First of all thanks for PGAdmin I've been using it for years now. :) : One small enhancement that wou

Re: [pgadmin-support] Savepoints in PgAdmin

2009-09-03 Thread Magnus Hagander
. > > Yeah, that looks how I'd expect. > > I think we should add a TODO to copy all the options that are in the > Query Tool to frmOptions, which can be used to set defaults, to be > overridden on a per-window basis from the window. Thoughts? Yeah, that would be useful. +1. --

Re: [pgadmin-support] Savepoints in PgAdmin

2009-09-03 Thread Magnus Hagander
2009/9/3 Dave Page : > On Thu, Sep 3, 2009 at 12:57 PM, Magnus Hagander wrote: > >> Good question. In general we shouldn't change the default behavior in >> a backpatch, but I think the use-case for the current behavior is >> pretty limited. > > It's no

Re: [pgadmin-support] Savepoints in PgAdmin

2009-09-03 Thread Magnus Hagander
quot;. Negations in options suck. It shuold be "Enable auto rollback", and then whatever the default is can be argued. I'd also find it very useful if this was available as a checkbox on the query menu, not just in the options dialog. Thoughts? -- Magnus Hagander Me: http://www.ha

Re: [pgadmin-support] Small annoyance in pgAdmin 1.10

2009-08-07 Thread Magnus Hagander
when no tables are > put on the graphical query builder. I suppose it means we need to change the > definition of gqbController::generateSQL() method. There's good chance it will > be seen as a "new feature", rather than a debug. > > I'll record a ticket for t

Re: [pgadmin-support] Cannot paste text from eclipse 3.5 to PGAdmin III

2009-08-04 Thread Magnus Hagander
wn custom wxWidgets tarball, I certainly don't want to do RPMs and > DEBs etc. If we have our own, couldn't we just link statically? That said, I bet they have *other* patches in that are specific to their distribution - they often do. And having to somehow end up having to merge these thin

Re: [pgadmin-support] BUG: pgScript NOT thread safe!!

2009-06-25 Thread Magnus Hagander
you if you think it's better to just block. I'm worried about the length of the block leading to UI freezes though... -- Magnus Hagander Self: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To ma

Re: [pgadmin-support] BUG: pgScript NOT thread safe!!

2009-06-25 Thread Magnus Hagander
Mickael Deloison wrote: > 2009/6/25 Magnus Hagander : >> Ashesh Vashi wrote: >>> Hi Dave, >>> >>> This patch does the job. >>> But, it will not be able disable to toolbar buttons on each windows. >>> Introduced a static variable of type wxMut

Re: [pgadmin-support] BUG: pgScript NOT thread safe!!

2009-06-25 Thread Magnus Hagander
up a messagebox informing the user that parallel execution of pgscript is not supported, if this is the route we have to go down. -- Magnus Hagander Self: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.or

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Magnus Hagander
f) Showing my total lack of knowledge about GTK.. :-) Isn't there some way to theme or style GTK to make them smaller? I would assume it's very theme:able in general (again, not knowing), but would it allow something like that? Or would it break everything? -- Magnus Hagander Sel

Re: [pgadmin-support] pgadmin 1.8.4 pgagent schedule issue

2008-10-03 Thread Magnus Hagander
Raymond O'Donnell wrote: > On 03/10/2008 16:01, [EMAIL PROTECTED] wrote: > >> Dave - You are a rock star! > > Dave a rock star? ...hmmyeah, I could picture that! > ;-) In some shady memory, haven't I been told that he used to actually *be* that? :-) //Magnus -- Sent via pgadmin-support ma

Re: [pgadmin-support] Feature Request: query history

2008-09-10 Thread Magnus Hagander
Dave Page wrote: > On Wed, Sep 10, 2008 at 2:15 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: >>> I would like to have the ability the view and edit and run any query that >>> has already been executed in the Query screen. Ideally this would keep >>> track

Re: [pgadmin-support] Feature Request: query history

2008-09-10 Thread Magnus Hagander
> I would like to have the ability the view and edit and run any query that > has already been executed in the Query screen. Ideally this would keep > track of queries persistently and not just for the current session. Are you describing something likevthe "history" feature in a browser? If so

Re: [pgadmin-support] question on graphical explain

2008-08-20 Thread Magnus Hagander
Dave Page wrote: > 2008/8/20 Mark Steben <[EMAIL PROTECTED]>: >> Hi - I just installed PGADMIN 1.8.4 on my machine. >> I would like to save the graphical explain output for printing for later >> >> presentations. It is easy enough to export the 'data output' >> Of the explain to a file but I wi

Re: [pgadmin-support] win32 psql syntax error running any .sql crea ted by the query editor

2008-04-08 Thread Magnus Hagander
Gah, that's what I get for not doublechekcing what that darn word completion on my phone did with what I wrote :-) That looks like it could be a *unicode* BOM. Can you open the file in a *hex* editor and check the first couple of bytes.. //Magnus Magnus Hagander wrote: > Looks like it

Re: [pgadmin-support] win32 psql syntax error running any .sql crea ted by the query editor

2008-04-07 Thread Magnus Hagander
Looks like it could be a knocked BOM. Can you open the file in a bed editor and check the first couple of bytes? /Magnus > --- Original Message --- > From: Kev <[EMAIL PROTECTED]> > To: pgadmin-support@postgresql.org > Sent: 08-04-07, 22:34:42 > Subject: [pgadmin-support] win32 psql synt

Re: [pgadmin-support] bug in pgadmin 1.8.2: missing entry in 'Data Type' list

2008-02-13 Thread Magnus Hagander
Dave Page wrote: On Feb 13, 2008 2:56 PM, Guillaume Lelarge <[EMAIL PROTECTED]> wrote: That's something I already heard at Solutions Linux 2008. I talked with someone who has this kind of issues. This guy has lots of tables, so his type combo box is really huge, and becomes actually unusable. T

Re: [pgadmin-support] bug in pgadmin 1.8.2: missing entry in 'Data Type' list

2008-02-13 Thread Magnus Hagander
Dave Page wrote: On Feb 12, 2008 9:12 PM, Peter Gagarinov <[EMAIL PROTECTED]> wrote: 1) create a simple table with two columns : create test_table(a integer, b integer); 2) go to 'New Table.." menu, type in some table name, 3) go to 'Columns' tab, type some column name, 'a' for

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-18 Thread Magnus Hagander
On Fri, Jan 18, 2008 at 11:07:27AM -0500, Christopher Browne wrote: > >> > > I've had this happen before. Removing the cluster and setting it > >> > up > >> > > again resolves the problem, however once we are in a production > >> > > environment I can't go dropping the whole cluster and replicating

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-18 Thread Magnus Hagander
On Wed, Jan 16, 2008 at 04:55:12AM -0800, Glyn Astill wrote: > Hi Magnus, > > > > How do I remove this set from the subscriber? > > > > I think it's somehow scheduled up behind whatever that thing going > > for > > node -1 is looking. If you can get rid of that one from sl_listen, > > I bet > >

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-15 Thread Magnus Hagander
Glyn Astill wrote: Hi chaps, I've noticed a problem as described below with regards to adding replication sets from within pgAdmin. I originally posted on the slony I general list, and Christopher Browne suggested I ask you guys. I set up a replication cluster using the pgAdmin scripts, and

Re: [pgadmin-support] Support for older servers

2007-11-16 Thread Magnus Hagander
On Fri, Nov 16, 2007 at 12:47:36PM +, Raymond O'Donnell wrote: > On 16/11/2007 12:24, Dave Page wrote: > >Should we consider dropping official support for PostgreSQL 7.x in the > >next major version of pgAdmin? > > I'd be against dropping support before 7.x is officially deprecated. Just to

Re: [pgadmin-hackers] [pgadmin-support] Support for older servers

2007-11-16 Thread Magnus Hagander
Guillaume Lelarge wrote: > Magnus Hagander a écrit : >> On Fri, Nov 16, 2007 at 12:47:36PM +, Raymond O'Donnell wrote: >>> On 16/11/2007 12:24, Dave Page wrote: >>>> Should we consider dropping official support for PostgreSQL 7.x in the >>>> ne

Re: [pgadmin-support] error auto-completing "GRANT SELECT ON"

2007-10-31 Thread Magnus Hagander
Dave Page wrote: > Alejandro Gasca wrote: >> Hi, if i open a sql pane, and put: >> GRANT SELECT ON >> and press [ctrl]+[space] this error rise: >> >> ERROR: syntax error at or near "DATABASE" >> LINE 6: UNION SELECT "DATABASE" UNION SELECT "FUNCTION" UNION S... > > Magnus - can you take a look at

Re: [pgadmin-support] Does query window create a new connection?

2007-10-16 Thread Magnus Hagander
Guy Rouillier wrote: > My development environment is PostgreSQL 8.2.0 on Windows. I've just > started exploring the use of SET and SHOW to store variables that I > define via the custom class feature in postgresql.conf. The default > scope for these variables is session, according to the document

Re: [pgadmin-support] SSL problem in pgAdmin3 1.8.0 beta 5

2007-09-26 Thread Magnus Hagander
On Wed, Sep 26, 2007 at 04:40:53PM +0100, Dave Page wrote: > Dave Page wrote: > > [CCing Magnus as this could be a problem - pgAdmin 1.8 fails to connect > > to an SSL server with a 'real' certificate] > > > > Alejandro Gasca wrote: > >> Well, i download the postgresql-8.2.4-1-binaries-no-install

Re: [pgadmin-support] Export the explain diagram?

2007-09-15 Thread Magnus Hagander
Dave Page wrote: > >> --- Original Message --- >> From: "Michael Shapiro" <[EMAIL PROTECTED]> >> To: "pgAdmin Support" >> Sent: 13/09/07, 14:01:37 >> Subject: [pgadmin-support] Export the explain diagram? >> >> I would love to be be able to capture the diagram created by explain into an >

Re: [pgadmin-support] Problems with SVN win32 build.

2006-06-19 Thread Magnus Hagander
(sorry about the delay) > > 3) When the auto-completion TAB character option is set and you hit > > TAB when there is more than one table option, the auto-complete > > function will always select the first table in the list. It > might be > > better to use the same > > ctrl+space logic with a

Re: [pgadmin-support] pgAdminIII query window: How to use more then 1 connection?

2006-03-24 Thread Magnus Hagander
> > > pgAdmin in its youngest incarnation supports a "connection" > > dropdown > above the query window. > > >Which version/platform? > > Version 1.4.1 on Win32 > > This is fixed in 1.4.2. The current pgsql 8.1.3 installer > still includes 1.4.1. Magnus/Dave, how about repackaging? Hmm. Unle

Re: [pgadmin-support] Extremely slow queries in pgAdminIII

2005-03-19 Thread Magnus Hagander
>> Ok, i checked the dlls. I assume that pgAdmin will use the first >> libpq.dll found in the path. > >Not necessarily - iirc, it'll use one in the working directory, the >system32 directory or the path. It's not quite the same on all versions >of windows either, but I can't find the relevant docs

Re: [pgadmin-support] Language issues in pgAdmin 1.2.0 beta

2004-10-14 Thread Magnus Hagander
> > Hi! > > > > When installing and running 1.2.0 beta (Sep 24 2004), I notice the > > following language/translation related issues: > > > > * PgAdmin comes up in Swedish by default. My Windows XP is english > > version, no languagepacks installed. It's set to use English by > > default in pr

[pgadmin-support] Language issues in pgAdmin 1.2.0 beta

2004-10-14 Thread Magnus Hagander
Hi! When installing and running 1.2.0 beta (Sep 24 2004), I notice the following language/translation related issues: * PgAdmin comes up in Swedish by default. My Windows XP is english version, no languagepacks installed. It's set to use English by default in programs. The only thing that's swedi