Re: [pgadmin-support] Fwd: PgAdmin3 Crash on Server Reset: Segmentation Fault

2016-12-15 Thread Andreas
Am 13.12.2016 um 14:28 schrieb Badrul Chowdhury: I am running into this issue: PgAdmin3 crashes when my postgres-9.5.5 server is reset (dropped and created again). *Platform*: Windows Server 2012 R2, Ubuntu 16.04LTS *Distribution*: source tarball *Version*: 3-1.22.2 Any pointers as to how I can

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-03 Thread Andreas
Am 03.12.2016 um 05:06 schrieb Dave Page: On Sat, Dec 3, 2016 at 2:44 AM, Andreas wrote: Am 03.12.2016 um 03:13 schrieb Dave Page: Where can I get the 1.2? An editor without search&replace is a wee bit suboptimal. It's not out yet, but you can get the code from the GIT re

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-02 Thread Andreas
Am 03.12.2016 um 03:13 schrieb Dave Page: On Sat, Dec 3, 2016 at 1:41 AM, Andreas wrote: Am 03.12.2016 um 02:00 schrieb Dave Page: On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: yes, but there is this V1.23 LTS of BigSQL. That is nothing to do with us. Their Installer is on the

Re: [pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-02 Thread Andreas
Am 03.12.2016 um 02:00 schrieb Dave Page: > On Sat, Dec 3, 2016 at 12:35 AM, Andreas wrote: >> Hi, >> there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I >> Drag&Drop a script into the editor. > > pgAdmin 3 is no longer supported I'm afraid.

[pgadmin-support] Drag&Drop SQL scripts into pgAdmin 4 ?

2016-12-02 Thread Andreas
Hi how can I Drag&Drop SQL scripts into pgAdmin 4 v1.1? At least after a basic install it refuses to do this. Is ther an option that allows this? regards Andreas -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription:

[pgadmin-support] Bug in pgAdmin 3 1.23.0a LTS

2016-12-02 Thread Andreas
regards Andreas -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Sortable statistics columns not sorted according to type

2016-11-18 Thread Andreas Kinzler
Hello, sortable columns like "tuples inserted" should be sorted according to their type (=integer) not as string. Regards Andreas -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpr

[pgadmin-support] How to set option for search & replace

2014-06-25 Thread Andreas
ber where I could define those options. regards Andreas

[pgadmin-support] pgadmin 1.14.0 Ubuntu12.04 "Failed to write to history file!" AND "KATASTROPHE, kann die Logdatei nicht öffnen!"

2013-03-15 Thread Andreas Laggner
le .pgadmin3 and this file seems to accessable. cu Andi -- Dipl. Geoökologe Andreas Laggner Thünen-Institut für Agrarklimaschutz (AK) Arbeitsgruppe Emissionsinventare Johann Heinrich von Thünen-Institut (vTI), Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei Thünen Institute of Climat

Re: [pgadmin-support] column "tgconstraint" doest not exist

2012-11-15 Thread Andreas 'ads' Scherbaum
ieve any of the > regular pgAdmin devs have a Greenplum system to test with. Thanks for forwarding this. I created a ticket in the Greenplum ticket system and included all the provided information. Regards, -- Andreas 'ads' Scherbaum German

[pgadmin-support] Drag & Drop in SQL editor ?

2012-05-27 Thread Andreas
Hi, we lost Drag & Drop within the SQL editor a couple of versions ago. Are there plans to get it back? I like to be able to move or copy SQL lines just with the mouse without the clipboard. regards Andreas -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To

[pgadmin-support] wrong encoding in pg log

2011-09-06 Thread Andreas
Hi, PG produces messages in UTF8 in pg_log. pgAdmin shows wrong signes for national characters. Where can I tell pgAdmin to use UTF8. too? I tried to switch to "Arial" but this was as bad as before. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to yo

Re: [pgadmin-support] little bug in the editor of 1.14 rc1

2011-09-04 Thread Andreas
Am 04.09.2011 08:52, schrieb Guillaume Lelarge: On Sun, 2011-09-04 at 00:26 +0200, Andreas wrote: But if I click behind a second ) it highlights the corresponding ( too but lets the highlighting of the first pair still on. So if one feels like it, one could highlight every () in the editor

[pgadmin-support] little bug in the editor of 1.14 rc1

2011-09-03 Thread Andreas
There is a bug in the highlighting of corresponding brackets. If I click behind a ) it highlights the corresponding ( which is OK. But if I click behind a second ) it highlights the corresponding ( too but lets the highlighting of the first pair still on. So if one feels like it, one could hig

Re: [pgadmin-support] 1.14.x What about drag&drop in the editor?

2011-09-02 Thread Andreas
Am 02.09.2011 19:37, schrieb Guillaume Lelarge: On Wed, 2011-08-31 at 05:38 +0200, Andreas wrote: Nope. I didn't find a way to get it back there. Still need to work on that. ah ok, at last it's still on the list :) It's already available in 1.14. Go in the options/preferenc

[pgadmin-support] 1.14.x What about drag&drop in the editor?

2011-08-30 Thread Andreas
Hi, the editor lost the ability to copy or move text by drag&drop. I hoped we get this feature back with the next release as we discussed after 1.12. Another cute feature would be an editor command that switches all sql keywords in uppercase. pgadmin does this when it shows the sql commands co

Re: [pgadmin-support] Timing out.

2011-08-09 Thread Andreas Neumann
ive so it can be shared between different machines. Just create a regular windows environment variable named PGSYSCONFDIR (either on a user or system level) and point it to the path where you want to place the pg_service.conf file. Hope this helps, Andreas -BEGIN PGP SIGNATURE- Version:

Re: [pgadmin-support] Timing out.

2011-08-09 Thread Andreas Neumann
mes or IP-addresses and having to find/replace connection infos in multiple project files. Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJOQVwBAAoJELiCsGDopvBCOuEH/jVQr3e2a54fArhP8G

Re: [pgadmin-support] Ubuntu natty and SSL connections

2011-05-16 Thread Andreas Neumann
-lssl -lcrypto -lz -lreadline -lcrypt -ldl - -lm VERSION = PostgreSQL 9.0.4 - - Do you have any other ideas what may have gone wrong with my compile? Thanks, Andreas On 05/16/2011 09:50 AM, Guillaume Lelarge wrote: > Hi, > > Le 05/15/2011 11:35

[pgadmin-support] Ubuntu natty and SSL connections

2011-05-15 Thread Andreas Neumann
lxslt -lxml2 -lssl -lcrypto -lz -lreadline -lcrypt -ldl -lm $LD_LIBRARY_PATH is also set to /usr/local/pgsql/lib Thank you if you have any additional idea what I could try, Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Usi

Re: [pgadmin-support] Feature request: ability to set hostaddr

2011-03-01 Thread Andreas Neumann
Hi, Yes, I would also appreciate if one could connect to a service defined in pg_service.conf I just recently discovered the possibility to define postgres services - though I have been told it had been around for years ... Andreas On Tue, 1 Mar 2011 22:45:44 -0800, Christopher Head wrote

[pgadmin-support] Bug in V1.12.1

2010-12-08 Thread Andreas
Hi, there is a bug in V1.12.1 that crashes the application whenever I do : 10design some utterly clever query stuff 20click the export-to-csv button in the icon bar --> dialog opens 30decide that the select should be still utterly cleverer and click CANCEL 40pgAdmin goes ZAPP

[pgadmin-support] pgadmin3 packages for ubuntu 64bit (Lucid and Meerkat)

2010-10-20 Thread Andreas Neumann
packages with pgadmin3 1.12? Thanks for any hints, Andreas -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ -- 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] automatic sql formating ?

2010-10-15 Thread Andreas
.12.1 binary release or are there binary nightlies somewhere? Regards Andreas -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] what are those colors in the server-status ?

2010-10-12 Thread Andreas
Hi what are those colors in the "activity" frame (upper left) in the server-status window? There mostly blue lines some orange and occasionally bright green. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgres

[pgadmin-support] There is an error showing in PG's log

2010-10-05 Thread Andreas
Hi, since I'm using pgAdmin 1.12.0 I find an error in the log of my 8.4 server, when I login: FATAL: unknown configuration parameter "applkication_name" Besides that nothing bad happens. Can I do something about it to make PG happy again? -- Sent via pgadmin-support mailing list (pgadmin-

Re: [pgadmin-support] pgAdmin 1.12.0 / Win / no drag&drop in SQL-Editor ???

2010-10-02 Thread Andreas
Am 02.10.2010 08:57, schrieb Dave Page: On Fri, Oct 1, 2010 at 11:39 PM, Andreas wrote: Well, but if you test pgAdmin III 1.10.3 you see that there all works as intended. Not as intended - purely by accident. Then lets say the sql-editor at least up until 1.10.3 is accidently as I intend

Re: [pgadmin-support] pgAdmin 1.12.0 / Win / no drag&drop in SQL-Editor ???

2010-10-01 Thread Andreas
Am 02.10.2010 01:01, schrieb Guillaume Lelarge: Le 02/10/2010 00:39, Andreas a écrit : [...] Well, but if you test pgAdmin III 1.10.3 you see that there all works as intended. Tried it and indeed it worked. I suppose that when I added the support of drag-and-drop files, it kind of stopped

[pgadmin-support] automatic sql formating ?

2010-10-01 Thread Andreas
Hi, just a thought ... Is there a way to extend the syntax highlighting to setting sql commands in upper ? E.g. you type " select * from mytable; " and the editor reformats it to SELECT * FROM mytable; -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make change

Re: [pgadmin-support] pgAdmin 1.12.0 / Win / no drag&drop in SQL-Editor ???

2010-10-01 Thread Andreas
Am 01.10.2010 23:24, schrieb Guillaume Lelarge: Le 01/10/2010 20:38, Andreas a écrit : Hi, I recently updated my PG 8.4 to 9.0 and therefore I've got pgAdmin 1.12.0. Why can't one use drag&drop in SQL-Editor ? E.g. mark some portion of sql and drag it somewhere else while pre

[pgadmin-support] pgAdmin 1.12.0 / Win / Combobox in Query-Tool ?

2010-10-01 Thread Andreas
Hi, there is a new combo box in Query-Tool of pgAdmin 1.12.0. It's directly above the sql area and was allways empty as of now. There is a "clear" as well as a "clear all" button to it's right so I figure it is intended to display stuff. What is it good for ? The documentation shows a picture

[pgadmin-support] pgAdmin 1.12.0 / Win / no drag&drop in SQL-Editor ???

2010-10-01 Thread Andreas
Hi, I recently updated my PG 8.4 to 9.0 and therefore I've got pgAdmin 1.12.0. Why can't one use drag&drop in SQL-Editor ? E.g. mark some portion of sql and drag it somewhere else while pressing the ctrl-key to get a copy. Have I missed an option somewhere that was in older pgAdmins activated

[pgadmin-support] Display format of "great" interval-Values in the query-result is not proper

2010-07-16 Thread Andreas Kutschke
______ Dr. Andreas Kutschke e-mail: andreas.kutsc...@edag.de Tel: +49 0661/6000-787 Fax: +49 0661/6000-592(-11-1556) Voice: +49 0661/6000-12-1556 Die nächsten Messeauftritte der EDAG Group: IAA-Nutzfahrzeuge in Hannover vom 22.-30.09.2010 in Halle

[pgadmin-support] sql-files with control characters at the beginning

2010-02-24 Thread Andreas Laggner
files?? cheers Andreas -- Dipl. Geoökologe Andreas Laggner Institut für Agrarrelevante Klimaforschung (AK) des vTI Arbeitsgruppe Emissionsinventare Johann Heinrich von Thünen-Institut (vTI), Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei Institute of Agricultural Climate

[pgadmin-support] Window Size SQL-query

2010-02-24 Thread Andreas Laggner
admin remembers the window size cheers Andreas -- Dipl. Geoökologe Andreas Laggner Institut für Agrarrelevante Klimaforschung (AK) des vTI Arbeitsgruppe Emissionsinventare Johann Heinrich von Thünen-Institut (vTI), Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei Institu

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

2010-02-09 Thread Andreas Neumann
If someone works on exporting the diagram, it would be worth looking at the SVG format, which is supported by modern browsers. This way it can be read into Inkscape as well for further processing. And it could potentially also contain scripting/interactivity for tooltips. Andreas On Tue

[pgadmin-support] Create Table Dialog: Change Column after creation/Reorder Columns

2009-10-15 Thread Andreas Neumann
quot; dialogue for a future PGAdmin version! Andreas PS: I found out that with the stable PGAdmin4 (1.10) the data-type loading is much faster (seems to be better cached now) compared to one of the previous betas. This was another request of mine and seems to be implemented. Creating tables is much

Re: [pgadmin-support] No Server in pgadmin3 after postgresql installation in Ubuntu

2009-08-15 Thread Andreas Neumann
Hi, You have to manually add a new connection (click on the plug icon to add a new connection). If server and client are on the same machine, you can use localhost. Also make sure that the postmaster process or the Postgresql daemon is really running. Andreas Abdul Rahman Riza wrote: Dear

Re: [pgadmin-support] Postgre Network.

2009-08-07 Thread Andreas Neumann
yes - sure. Even on the same machine (if they listen on separate ports). However, this has nothing to do with pgadmin3, rather Postgresql. If you have Postgresql specific questions, please use the correct mailing list. This mailinglist is just about the pgadmin3 client. Best, Andreas

[pgadmin-support] Bug with 1.10.0 Beta 4

2009-06-10 Thread Andreas Nolte
fine. Unhandled Exception 0xC0005 I know this is very less information, but I hope it helps anyway. Beste Gruesse / best regards Andreas Nolte Manz Automation AG Andreas Nolte Entwicklung / Applikation Software HMI & SCADA R & D / Application Softwar

Re: [pgadmin-support] PGAdminIII 1.10, Beta 3: Problem with Comment field in New Column Dialogue

2009-05-11 Thread Andreas Neumann
In this case then there is nothing we can do ... Thanks anyway for getting back about it, Andreas On Mon, May 11, 2009 2:06 pm, Dave Page wrote: > On Mon, May 11, 2009 at 12:43 PM, Andreas Neumann > wrote: >> I see. Thanks for answering. >> >> In the case it is not eas

Re: [pgadmin-support] PGAdminIII 1.10, Beta 3: Problem with Comment field in New Column Dialogue

2009-05-11 Thread Andreas Neumann
dows version it looks like the "Comment" text area field is active and available. It is interesting, that the 1.8.4 release on Ubuntu properly greys this text-area out (disables it), but the Windows vesion 1.8.10 does not. Thanks, Andreas On Mon, May 11, 2009 12:19 pm, Dave Page wrote: >

[pgadmin-support] PGAdminIII 1.10, Beta 3: Problem with Comment field in New Column Dialogue

2009-05-11 Thread Andreas Neumann
eld at this stage. I can only create the column and then add the comment later when editing an individual column. I tested on WinXP, 32bit. Can others reproduced the problem? Thanks, Andreas -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ -- Sent via pgadmin-support mail

[pgadmin-support] Loading Data-Types takes quite long

2009-04-16 Thread Andreas Neumann
new types when the new table dialogue comes up - or adding a button to search for new data types? What do you think? Andreas -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to yo

Re: [pgadmin-support] enable/disable rules

2009-02-27 Thread Andreas Neumann
Perfect! Thanks for checking. Looking forward to 1.10 beta. Andreas On Fri, February 27, 2009 2:34 pm, Guillaume Lelarge wrote: > Andreas Neumann a écrit : >> hm - I have Postgres 8.3.3 - so if it is already in Pgadmin3 1.8.4 - how >> can I find this method? >> > > It

[pgadmin-support] enable/disable rules

2009-02-27 Thread Andreas Neumann
) - but somehow I can't see this functionality in pgadmin3 1.8.4 Do you have any idea when a new version will be available supporting this feature? Thanks a lot, Andreas -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ -- Sent via pgadmin-support mailing list (pg

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

2008-09-10 Thread Andreas Neumann
soundy good - I'd like such a feature as well. We'll have to limit it to a maximum number of queries, though (50,100,200?) so the history doesn't grow infinitely. Andreas > Yeah, that sounds good. It would be great if it stored the history across > sessions too so if you

Re: [pgadmin-support] Feature request: block commenting and uncommenting

2008-07-16 Thread Andreas Neumann
yes - this would be a cool feature I'd like to see as well (if it is easy to implement) Andreas Raymond O'Donnell wrote: Hi Dave & PgAdmin developers, Dunno if this is a good time to ask, but I'd love to see in the SQL editor some way of commenting-out and uncommenting w

[pgadmin-support] HELP

2008-06-06 Thread Anfinn Andreas Kolberg
nsubscribe, but always get the same answer: No e-mail addresses matching Anfinn Andreas Kolberg <[EMAIL PROTECTED]> are subscribed to the pgadmin-support mailing list. Can you please help me out of it? I think I am registered with you as /"Anfinn Andreas Kolb

Re: [pgadmin-support] 2 smaller feature requests

2008-05-29 Thread Andreas Neumann
help being able to change the order of columns during the table setup, before it is created. One can disable those up/down buttons when the user opens the table properties dialogue after the table was created - either make them invisible or gray out/disable the buttons. > >> Thank you for c

[pgadmin-support] 2 smaller feature requests

2008-05-29 Thread Andreas Neumann
blem prior to creation of the table. I would suggest to have "Arrow buttons" to shift a column definition up and down. The user has to select a column definition (one row) and after pressing the "Up" or "Down" button the order would change. Thank you for considering or

[pgadmin-support] Enum input support with drop-down list when editing a table

2008-05-09 Thread Andreas Neumann
ing a great job! Andreas -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: [EMAIL PROTECTED] Web: http://www.carto.net/neumann/ SVG Examples: http://www.carto.net/papers/svg/samples/ SVG.Open: http://www.svgopen.org/ -- Sent via

Re: [pgadmin-support] Editing Views with EditGrid

2008-05-09 Thread Andreas Neumann
ding the views: one could test if the view has at least the insert, update and delete rules present before enabling the editing of the views. What do you think? Andreas Dave Page wrote: On Tue, May 6, 2008 at 9:05 PM, Andreas Neumann <[EMAIL PROTECTED]> wrote: Hi Dave, Thank you for lett

Re: [pgadmin-support] Editing Views with EditGrid

2008-05-06 Thread Andreas Neumann
Hi Dave, Thank you for letting me know about the situation. Can you estimate how much work it would be to implement editable views? Maybe based on the experience with the editable tables? Maybe we can find a few interested parties paying for the development of this feature? Andreas Dave

[pgadmin-support] Editing Views with EditGrid

2008-05-06 Thread Andreas Neumann
t the views in pgadmin3. Is this on the feature list of an upcoming pgadmin3 version, maybe 1.9x? Thank you for any information on the topic, Andreas -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * http://www.carto.net/ (Carto and SVG reso

Re: [pgadmin-support] Bug in PgAdmin III Query

2007-06-04 Thread Andreas Kutschke
racters well! Dave Page <[EMAIL PROTECTED]> schrieb am 01.06.2007 17:58:04: > Guillaume Lelarge wrote: > > Hi, > > > > Andreas Kutschke a écrit : > >> on Linux i cannot open the attached SQL-File in the "PgAdmin III Query". > >> On Windows (XP

[pgadmin-support] Bug in PgAdmin III Query

2007-06-01 Thread Andreas Kutschke
y can be opened! The file was created on Windows. I dos2unix'ed it too - no change. OS Version: openSuse (10.2), 64 bit, Kernel: 2.6.18.2-34-default PgAdmin III Version:1.6.3 Sincerly _______ Dr. Andreas Kutschke e-mail: [EMAIL P

Re: [pgadmin-support] pgagent.sql script

2006-05-19 Thread Andreas Pflug
7.4.7 on a Debian Sarge box. I’m having similar problem when a try to run Slony-I scripts from my pgAdmin client. The $$ escaping was introduced in pgsql 8.0. While pgAgent should be runnable on 7.3+, there might be other good reasons to upgrade to 8.0 or even better 8.1. Regard

Re: [pgadmin-support] Constraint Triggers request

2006-05-10 Thread Andreas Pflug
Donald Fraser wrote: Donald Fraser wrote: Do you think in a later version you can show non-system constraint triggers that have been created by the user via: CREATE CONSTRAINT TRIGGER ? Andreas Pflug wrote: Definitively not. Creating constraint triggers directly is horribly

Re: [pgadmin-support] Constraint Triggers request

2006-05-09 Thread Andreas Pflug
compatibility only. Use contrib/adddepend to fix your database. Regards, Andreas ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes d

Re: [pgadmin-support] Link problem with pgAdmin3 1.4.2 on Linux

2006-05-01 Thread Andreas Pflug
ncatSelf(unsigned, wchar_t const*, unsigned)' Hm, these should come from wx (probably libwx_baseu-2.6). Do wx samples build correctly? Regards, Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgadmin-support] how to create backup copies

2006-04-18 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 18 April 2006 10:50 To: Dave Page Cc: Andrus; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] how to create backup copies Dave Page wrote: :-( Do you mind if I send you a

Re: [pgadmin-support] how to create backup copies

2006-04-18 Thread Andreas Pflug
Dave Page wrote: :-( Do you mind if I send you a custom built pgagent.exe? I want to remove the cleanup code in this particular failure case so it leaves the temporary file/directory behind for examination. How about a debug option for that. Regards, Andreas

Re: [pgadmin-support] how to create backup copies

2006-04-13 Thread Andreas Pflug
hat it runs OK under posgres account. I entered c:\mydir\mycackup.bat to a pgagent script window however, statitics window displays the following error each time I try to run this job: Couldn't execute script C:DOCUME~1\postgres\LOCAL~1TemppgaD591.tmp1_1.bat Try to run CMD expli

Re: [pgadmin-support] 1.4.2 Bug-report

2006-04-12 Thread Andreas Pflug
Andreas Jonsson wrote: Hello! I'm running pgadmin 1.4.2 and i came over a problem, if i got two schemas and two tables with the same name under them eg: schemas(2) -list -pc_752 -wip -pc_752 Then i do a custom backup of list / pc_752. The problem is when i rightclick > rest

[pgadmin-support] 1.4.2 Bug-report

2006-04-12 Thread Andreas Jonsson
ema: wip; Owner: postgres that's not right because the backup was from "list" not "wip". Best Regards Andreas Jonsson! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Andreas Pflug
the option "count rows if est. rowcount < -1" at the moment. I don't see a good final solution, maybe not counting if inherited tables are present regardless of reltuples? Regards, Andreas ---(end of broadcast)--- TIP 5: don&#x

Re: [pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Andreas Pflug
ys return [1-9].[0-9](n)e[1-9](n), i.e. if the decimal point was the problem est. rowcount would be between 1 and 9. Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] pgadmin3 and partitionned tables

2006-04-10 Thread Andreas Pflug
a known problem ? Yes. You clearly ignored the Guru's hint to vacuum. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Pflug Sent: 04 April 2006 15:25 To: Andrus Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] How to use arrow keys to move to other row Andrus wrote: I

Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Andreas Pflug
unsatisfactory, and probably will never do better, which is one reason why I'd like to get rid of this control (and not just me: most developers who once touched that piece of sh^H^Hcode). Regards, Andreas ---(end of broadcast)--- TIP

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

2006-03-24 Thread Andreas Pflug
w about repackaging? Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-support] feature suggestion: sequence wizard

2006-03-22 Thread Andreas Pflug
Bill Eaton wrote: It would be nice to automate the conversion of an integer in a table to a "serial". We can put this on the todo list. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-support] Connecting error

2006-03-22 Thread Andreas Pflug
ost on the correct list pgsql-newbies or -general, and include a server log. This is obviously not a pgadmin problem. Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [pgadmin-support] Support

2006-03-22 Thread Andreas Pflug
steps on pgAdmin and postGIS for cartographic applications. Is it possible that you send me french support, or english, to help me. This list is for answering support questions. You'll have to do the work yourself. Regards, Andreas ---(end of broa

Re: [pgadmin-support] Invalid password for \ and ' characters

2006-03-19 Thread Andreas Pflug
SWORD '\\' Expected CREATE ROLE test LOGIN PASSWORD '\' Postres does NOT require backslashes in password strings. PgAdmin probably uses its qtString for password strings. AFAIR Dave recently changed that. Please check the CHANGELOG and try a newer ve

Re: [pgadmin-support] postgreSQL txt dump restore

2006-03-19 Thread Andreas Pflug
Andrew Madu wrote: OS: Windows XP (Ver 5.1.2600) SP2 pgAmin III: Ver 1.2.2 posgreSQL: Ver 8.0 Hi, I have a previously made postgresql full schema/data dumpo made to a txt file. How can I restore the database schema/data using pgAdmin, As the FAQ states, you can't. Regards, An

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

2006-03-16 Thread Andreas Pflug
tanding on one database. only 1 connection 2nd try: Query window is open. I select "new connection". nothing happens. What is the correct way to use more then one connection, that is: switch between different servers / databases within the query window? Which version/platfor

Re: [pgadmin-support] Not finding users

2006-03-14 Thread Andreas Pflug
Raymond O'Donnell wrote: When tryng to adjust privileges on my system, pgAdmin seems to be unable to populate the drop-down combo box with the list of users/roles - See FAQs. Regards, Andreas ---(end of broadcast)--- TIP 5: don't

Re: [pgadmin-support] regional characters in query tool: save/load

2006-03-04 Thread Andreas Pflug
Tomi NA wrote: platform: linux gentoo, i686 locale: hr_HR (as far as I can tell) script encoding: UTF8 version: can't tell (no "about..."), but it comes with Postgresql 8.1.1 ALL versions of pgadmin3 have the about dialog at the usual place. If it's not under help/about, it's a crippled versio

Re: [pgadmin-support] Unicode characters in query results

2006-03-03 Thread Andreas Pflug
still don't come out right. Any ideas? Data is probably stored in a database with incorrect encoding. Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] Difficulties Connecting on localhost

2006-03-03 Thread Andreas Pflug
8.0.7, will pgAdmin 1.2 work with it? Yes, but I certainly won't recommend downgrading (while pgsql backports fixes, we don't because pgAdmin is always backward compatible). I'd suggest building the latest pgAdmin from source. Regards, Andreas ---(e

Re: [pgadmin-support] Difficulties Connecting on localhost

2006-03-02 Thread Andreas Pflug
what is wrong here, and how to fix (please be very specific) ? Use 1.4.x, it includes additional aid. Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] Error Message: ERROR: invalid page header

2006-02-24 Thread Andreas Pflug
may have been fixed years ago. Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [pgadmin-support] Excessive GDI objects under WIN32

2006-02-13 Thread Andreas Pflug
Zac Bowling wrote: Yeah, I'm debating that it needs GDI objects. Then use psql. Debating the use of GDI objects is extraordinarily silly. Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] Excessive GDI objects under WIN32

2006-02-13 Thread Andreas Pflug
running win98 or so. Regards, Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgadmin-support] Serious bug in edit grid?

2006-01-23 Thread Andreas Pflug
ou when you dropped columns and readded some as PK. Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] Lost instrumentation functions

2006-01-22 Thread Andreas Pflug
;-)) I bet /var/lib/postgresql/8.1/main/pg_log is not a directory... Did you enable redirect_stderr? The function is working as expected in this situation. Please note that pgadmin expects its functions to be existent in the _maintenance_ DB, for 8.1 usually postgres. Regards, Andreas

Re: [pgadmin-support] Lost instrumentation functions

2006-01-22 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 22 January 2006 11:41 To: Dave Page Cc: Joost Kraaijeveld; PgAdmin-support Subject: Re: [pgadmin-support] Lost instrumentation functions That view is for pgadmin 1.2 compatibility only, not

Re: [pgadmin-support] Lost instrumentation functions

2006-01-22 Thread Andreas Pflug
ra/admin81/a dmin81.sql.in?rev=4475&view=markup That should call the function with the correct syntax and prove whether or not it's working. That view is for pgadmin 1.2 compatibility only, not needed for 1.4. SELECT pg_logdir_ls() should work. Regards, Andreas

Re: [pgadmin-support] Pgadmin III not honoring DATESTYLE

2006-01-20 Thread Andreas Pflug
. Regards, Andreas ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [pgadmin-support] Pgadmin III not honoring DATESTYLE

2006-01-20 Thread Andreas Pflug
of a date entry control. Regards, Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgadmin-support] NULL vs empty string in Query Tool

2006-01-06 Thread Andreas Pflug
at if pgAdmin's Query Tool had a setting similar to psql's "\pset NULL" formatting option. It is very easy to confuse the two and most query tools that I know of allow for that. Still on the list, as the original mail. Regards, Andreas -

Re: [pgadmin-support] Pgadmin 1.4.1 and autoindex generation from

2006-01-05 Thread Andreas Pflug
unately, in terms of fixing it is *not* small. Will take a while to implement. If this is not a right place for reporting bugs, please shoot me in the leg, and point me to the right direction. We usually don't shoot. We flame :-) Regards, Andreas ---(end of bro

Re: [pgadmin-support] Problem Adding A PostgreSQL Server in Debian

2006-01-05 Thread Andreas Pflug
I did. I am curious why I didn't recieve a response from the mailing list. Did I violate a rule of ettiquette, or not provide enough information? My next question would be: How do you set up pgAdmin to connect to PostgreSQL via Unix Sockets? How about having a look at pgAdmin&#x

Re: [pgadmin-support] Log entry asking to contact support

2005-12-30 Thread Andreas Pflug
to re-find parent key in "idx_volume_consultant" Please post on pgsql-bugs for proper support. Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [

Re: [pgadmin-support] PgAdmin uses wrong column for primary key

2005-12-26 Thread Andreas Pflug
toklas [PK] bpchar PgAdmin works like vkontoklas column is primary key ! Good catch! The PK detection code in the view tool assumed the column numbering would start with one, without holes. This doesn't always true, esp. in your case. Fixed for HEAD and 1.4.2, thanks for reporting. R

Re: [pgadmin-support] BUG: Wrong Explain diagram

2005-12-26 Thread Andreas Pflug
for you. IMHO best solution move it in 'File' menu for making button panel more short/brief. Even on a 640x480 screen there's enough space. No reason to change it. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-support] bug with fkey-dialog in tables belonging to

2005-12-18 Thread Andreas Pflug
default $user,public. Actually, suppressing the schema name here wouldn't do any harm, because the search_path will automatically add the username here. Regards, Andreas ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner w

Re: [pgadmin-support] Function name string bug pgadmin 1.4.1

2005-12-18 Thread Andreas Pflug
this. Please provide a sample. Regards, Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

  1   2   3   4   5   6   7   8   >