[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

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

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] 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] 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] 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] 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] 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] 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-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] 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-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] 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-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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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: 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
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] 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] 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] 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] 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
. > > 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-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-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-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-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-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-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] 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] 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] 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] [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] 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] 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] 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] 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] 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-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-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] 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] 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] 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] 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] 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] 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] 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