[pgadmin-support] pgAdmin3 shows duplicate columns in a table

2011-10-17 Thread Michael
Hi, everyone. I think I've discovered a bug with pgAdmin3: pgAdmin3 is showing four duplicate 'id' columns for one of my tables. The column named 'id' happens to be a primary key for the table. I have tried deleting and recreating both the individual table and the entire database, but neither solv

pgAdmin under wine - how??

2001-12-21 Thread Michael Hauser
How do you get pgAdmin installed to run under wine, given that it requires Windows Installer? Were you able to get Windows Installer to work under wine? Thanks. Michael Hauser [EMAIL PROTECTED]

[pgadmin-support] pgadminII and odbc version 7.02.0001

2002-04-22 Thread Michael Moehle
Bordesholm [EMAIL PROTECTED] BEGIN:VCARD VERSION:2.1 N:Möhle;Michael;;Herr FN:Michael Möhle ORG:Möhle und Braker Datenverarbeitungstechnik TEL;WORK;VOICE:+49 (04322) 691505 TEL;CELL;VOICE:+49 (0173) 9554875 TEL;WORK;FAX:+49 (04322) 691506 ADR;WORK:;;Bahnhofstrasse 41;Bordesholm;;24582;Deutschland

Re: [pgadmin-support] pgadminII and odbc version 7.02.0001

2002-04-24 Thread Michael Moehle
Download the newest cvs snapshot. It works great. Greetings Michael > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:pgadmin-support-owner@postg > resql.org]Im Auftrag von Henshall, > Stuart - WCP > Gesendet: Mittwoch, 24. April 2002 17:06 >

[pgadmin-support] clustering

2002-06-04 Thread Vergoz Michael
MessageIt is possible de make a cluster with postgresql ? michael ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to

Fw: [pgadmin-support] infinite loop

2002-06-05 Thread Vergoz Michael
- Original Message - From: "Vergoz Michael" <[EMAIL PROTECTED]> To: "Robert" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 9:27 AM Subject: Re: [pgadmin-support] infinite loop > DATABASE=template0;SERVER=192.168.254.22;PORT=5432;UID=postgres;PWD=

[pgadmin-support] Fw: important question

2002-06-10 Thread Vergoz Michael
  - Original Message - From: Vergoz Michael To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 5:53 PM Subject: important question hello,   I'v an : 8 * Pentium !!! XEON 900Mhz 2Mo Level2 16 Go RAM ECC Harddisk ultra-lvd 160 [...]   with linux   Can i support 4096 user in the

[pgadmin-support] No tables and most all options are greyed out

2002-10-12 Thread Michael Sheldon
Okay guys. I am using a windows XP machine and I am connecting to my database on my linux box. I can see the databases, templates, users and groups and that is all i can see or even manage. What is wrong with this picture? What am I overlooking? ---(end of broadcast)-

[pgadmin-support]

2003-05-29 Thread Michael Vodep
your comment: I tryed to connect to an invalid IP: "192.168.134" -> It was my fault - right version "192.168.1.34" Michael -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage! -

[pgadmin-support] running error

2003-06-27 Thread Michael Tang
Hi , I cannot run pgadminIII in my notebook! Show windows system error "application error". it cannot read the memory. It seems "msvcrt.dll" error in VC6.0 debugging. My notebook model is DELL inspiron 1100. Please help me. Best R

[pgadmin-support] Bug in pgadmin III displaying/exporting data from query window(tr uncating)

2003-10-02 Thread Godshall Michael
d closing out pgadminIII and re-opening but the data is still truncated. Michael GodshallGMAC Global Relocation Services[EMAIL PROTECTED]  

Re: [pgadmin-support] Bug in pgadmin III displaying/exporting dat

2003-10-02 Thread Godshall Michael
ybe I downloaded the wrong version of pgadminIII. Thanks for the response. Mike -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 02, 2003 4:04 PM To: Godshall Michael Cc: '[EMAIL PROTECTED]' Subject: Re: [pgadmin-support] Bug in pgadmin

[pgadmin-support] PGAdmin III - string literal parse error entering functions

2003-10-30 Thread Michael Foy
All,   Thanks for the great product.     When entering functions to create a trigger using the create trigger dialog like the one below.  You have to use three single quotes instead of two to enclose string literals.  Either this should be documented if it is the correct way to do this,

[pgadmin-support] pgAdmin bug? creating functions

2003-11-14 Thread Michael Shapiro
but when it tries to create the trigger, the following error occurs: ERROR: CreateTrigger: function doit() does not exist. I think it might be a search path issue that the GUI isn't handling properly. Any help would be appreciated. --- Michael ---

[pgadmin-support] pg admin bug - view data

2003-11-21 Thread Michael Shapiro
ASC 2003-11-21 08:24:36 QUERY : Thread Query SELECT * FROM data_tbl ORDER BY ASC 2003-11-21 08:24:36 QUERY : DEBUG: StartTransactionCommand 2003-11-21 08:24:36 QUERY : DEBUG: AbortCurrentTransaction --- Michael ---(end of broadcast)--- TIP 6

[pgadmin-support] pgadmin III bug - schema prefix missing in return type

2003-11-24 Thread Michael Shapiro
nge following the RETURNS) = CREATE OR REPLACE FUNCTION xxx.packet_data(pg_catalog.numeric, pg_catalog.text) RETURNS setof data_tbl AS ' select * from axxx.data_view where packet_rec_id = $1 and tag = $2; ' LAN

[pgadmin-support] database properties don't pop up

2003-12-09 Thread Michael Shapiro
I downloaded the latest snapshot (20031209) for win32. When you right click on a database and ask for the properties, the dialog that normally appears (that would allow you to edit variable and security) does not appear. --- Michael ---(end of broadcast

Re: [pgadmin-support] database properties don't pop up

2003-12-11 Thread Michael Shapiro
I'll wait. Upgrading to 7.4 isn't an option at this time. This used to work in previous versions of PgAdmin even with 7.3 At 11:15 PM 12/11/2003 +0100, Andreas Pflug wrote: Michael Shapiro wrote: Andeas, the new snapshot is an improvement, but there are still problems. I can n

[pgadmin-support] PgAdmin 3 startup

2003-12-29 Thread Michael Shapiro
I have downloaded the latest snapshot of pgadmin3 (pgadmin3-20031228-Win32.zip) and connected to a database. PgAmin takes 150 seconds to complete its startup. (I have reported this problem previously, but just wanted to let you know that it remains with this snapshot) --- Michael 2003-12-29

Re: [pgadmin-support] Crash

2003-12-30 Thread Michael Shapiro
your time. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match --- Michael ---(end of broadcast)---

Re: [pgadmin-support] PgAdmin 3 startup

2003-12-30 Thread Michael Shapiro
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote: Michael, Michael Shapiro wrote: The only clue that I might be able to offer you is that we have dropped and recreated the schemas in the database many many times without dropping and recreating the database. Might that cause this query to run

Re: [pgadmin-support] PgAdmin 3 startup

2004-01-05 Thread Michael Shapiro
How do I cut and paste the results (in the Data Output window) so I can send them to you. The normal highlight / cut/paste doesn't seem to work. At 03:09 PM 12/31/2003 +0100, Andreas Pflug wrote: Michael Shapiro wrote: At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote: Michael, Mi

Re: [pgadmin-support] PgAdmin 3 startup

2004-01-05 Thread Michael Shapiro
At 03:09 PM 12/31/2003 +0100, Andreas Pflug wrote: Michael Shapiro wrote: At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote: Michael, Michael Shapiro wrote: The only clue that I might be able to offer you is that we have dropped and recreated the schemas in the database many many times

[pgadmin-support] Need improved support for connection timeouts

2004-01-05 Thread Michael Serdar
When I use pgadmin to connect remotely to a server that automatically logs you out after a certain idle period, it becomes very difficult to get any work done. Specifically, pgadmin hangs the next time you request a view or enter a query, and then you have to right-click the server's name and

[pgadmin-support] Compiling pgadmin on SuSE 9.1

2004-08-01 Thread Michael Eschweiler
or-messages. Is there somebody who knows which exactly is the pgsql-directory on SuSE 9.1 and how is the correct syntax to hand over it to configure? Thanks in advance, Michael ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [pgadmin-support] Compiling pgadmin on SuSE 9.1

2004-08-02 Thread Michael Eschweiler
Am Montag, 2. August 2004 14:17 schrieben Sie: > On Aug 1, 2004, at 7:26 AM, Michael Eschweiler wrote: > > Hello, > > > > I'm trying to compile pgadmin3-1.0.2 on SuSE 9.1. When I run > > ./configure I got > > the error message: "configure: error: you

Re: [pgadmin-support] Compiling pgadmin on SuSE 9.1

2004-08-04 Thread Michael Eschweiler
Hi Adam Am Mittwoch, 4. August 2004 14:39 schrieben Sie: > On Aug 2, 2004, at 4:27 PM, Michael Eschweiler wrote: > > Am Montag, 2. August 2004 14:17 schrieben Sie: > >> On Aug 1, 2004, at 7:26 AM, Michael Eschweiler wrote: > >>> Hello, > >>> > >>

Fwd: Re: [pgadmin-support] Compiling pgadmin on SuSE 9.1

2004-08-05 Thread Michael Eschweiler
--- Begin Message --- Am Donnerstag, 5. August 2004 01:39 schrieben Sie: > On Aug 4, 2004, at 3:52 PM, Michael Eschweiler wrote: > > I could not find the answer. Attached once more the config.log. > > There wasn't anything attached to this e-mail. Strange: my mail-client te

Re: [pgadmin-support] Compiling pgadmin on SuSE 9.1

2004-08-08 Thread Michael Eschweiler
Am Donnerstag, 5. August 2004 23:33 schrieben Sie: > On Aug 5, 2004, at 3:18 PM, Michael Eschweiler wrote: > > configure:4634: gcc -o conftest -g -O2 -DSSL -I/usr/include/pgsql > > -L/var/lib/pgsql/lib conftest.c -lpq -lssl -lcrypto -lpq >&5 > > /usr/lib/g

[pgadmin-support] boolean field default value

2005-08-28 Thread Michael Schmidt
, where the field is correctly set to true.  So, this appears to be unique to pgAdmin and not a problem with PostgreSQL.   Thanks, Michael Schmidt

[pgadmin-support] ERROR: column reference "proname" is ambiguous

2005-10-14 Thread Michael Nagel
PC with all patches. Best wishes Michael Nagel ---(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

[pgadmin-support] Backup problem

2005-10-21 Thread Michael Schmidt
est.backup" npcat_db' failed (error 2: the system cannot find the file specified.)   I know that libpq.dll and libintl-2.dll have been changed and tried the backup in two ways:  with version 8.0.4 and with version 8.1 in Windows/System32 directory.  Both methods resulted in the same erro

Re: [pgadmin-support] Backup problem

2005-10-23 Thread Michael Schmidt
t find the file specified.)"   Michael Schmidt - Original Message - From: Andreas Pflug To: Michael Schmidt Cc: [EMAIL PROTECTED] Sent: Sunday, October 23, 2005 4:08 AM Subject: Re: [pgadmin-support] Backup problem Michael Schmidt wrote:> I installed pgAdmi

[pgadmin-support] Connecting error

2006-03-21 Thread Shulman, Michael
fore I got this error. Now it become permanent. I try to connect from deferent PC and have same result. I reinstall PostgreSQL but it goes not help. Local pgAdmin work normally. Any idea. Michael ---(end of broadcast)--- TIP 9: In versions belo

[pgadmin-support] About debugging trigger

2006-11-07 Thread Michael Su
sert standard output statement in trigger is using dbms_output.put_line() method, but it doesn't seem to work in pgadmin. I have already checked the frequently asked questions list as well as the pgAdmin documentation for a solution and I also have tried searching Google, however I can not find a solution for it. Please help when you get a chance! Thank you in advance,   Michael

[pgadmin-support] bug: Bit String Types / question: edit view

2007-01-10 Thread Pfuetz, Michael
d the rules: ON UPDATE TO, ON INSERT TO, ON DELETE TO My Pgadmin Version: 1.6.2 (Jan 6 2007, rev: 5837), Windows XP, SP2 1.6.2 (Dec 14 2006, rev: 5784), SuSE Linux 10.0 I hope you can help my. Best regards Michael Pfütz Disclaimer : The information contained in this e-mail is intended only for

Re: [pgadmin-support] PgAdmin Wishlist: export to clipboard

2007-01-17 Thread Michael Möhle
Hello, if I can wish something, it would be an Export in the Format pg_dump is using (as a Script). This would be very helpfull. Greetings Michael Möhle -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Dave Page Gesendet: Mittwoch, 17. Januar 2007

Re: [pgadmin-support] pgadmin as main postgresql GUI interface

2007-02-24 Thread Michael Eschweiler
stage (2 or 3 years ago) but as the layout of texts in the different widgets on the screen wasn't that good, and as I wanted to work with larger texts I changed to knoda. Now rekall seems to have improved considerably and comes with a detailed manual. Michael ---(en

[pgadmin-support] pgqdmin3 1.6.3 on Ubuntu Dapper Drake

2007-06-28 Thread Michael Scheepers
file available for Dapper? -- Michael Scheepers Suite 48 Private Bag X1005 Claremont, 7735 South Africa Tel: +27 (0)21 713 3817 Cell: +27 (0)82 322 7008 Fax: +27 (0)86 617 8335 Mailto:[EMAIL PROTECTED]

Re: [pgadmin-support] pgqdmin3 1.6.3 on Ubuntu Dapper Drake

2007-07-02 Thread Michael Scheepers
Hi Raphael, Dave On 7/1/07, Raphaël Enrici <[EMAIL PROTECTED]> wrote: Hi Dave, Michael, Dave Page wrote: > >> --- Original Message --- >> From: "Michael Scheepers" <[EMAIL PROTECTED]> >> To: pgadmin-support@postgresql.org >> Sent

Re: [pgadmin-support] pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default

2007-09-13 Thread Michael Shapiro
This is definitely a change from PgAdmin 1.6. 1.6 had the blank pull down. In fact 1.6 offered three options: blank, pg_default, pg_global. 1.8 only offers one: pg_default On 9/13/07, Harald Armin Massa <[EMAIL PROTECTED]> wrote: > > Hello, > > it may or may not be considered as a pgadmin error: >

[pgadmin-support] Export the explain diagram?

2007-09-13 Thread Michael Shapiro
I would love to be be able to capture the diagram created by explain into an image file (e.g. jpg). I don't see any way to do that in PgAdmin. I could use an external tool, but none of the tools I have found can handle scrolling in the horizontal direction (which occurs often in the diagrams). Are

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

2007-11-06 Thread Michael Shapiro
I found these error messages in the pgadmin.log file. I am running 1.8.0 (rev 6766:6767) 2007-11-03 08:51:00 ERROR : Can't create window of class wxWindowClass (error 14: not enough storage is available to complete this operation.) 2007-11-03 08:51:00 ERROR : Can't create window of class wxWindo

Re: [pgadmin-support] Show NULL values AS not working

2008-01-14 Thread Michael Shapiro
One more thing. If the value is the empty string, then in the View Data shows it as '' On Jan 14, 2008 4:49 PM, Andy Shellam <[EMAIL PROTECTED]> wrote: > Hi guys, > > A bit more info. > > If I write a query manually (i.e. SELECT * FROM table) then the column > shows up as "" which is what I expec

[pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-07 Thread Michael Eschweiler
0003 03:09 67708 /usr/lib/libcroco-0.6.so.3.0.1 b35c6000-b35f3000 r-xp 03:09 76277 /usr/lib/libgsfAborted I must confess that don't have any idea what this means. Therefore I would be very grateful for any hint about how to make pgadmin work. Thanks in advance, Michael

Re: [pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-07 Thread Michael Eschweiler
s it helps to determine the problem... Michael This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. It was created by pgadmin3 configure 1.8.2, which was generated by GNU Autoconf 2.59. Invocation command line was $ ./con

Fwd: Re: [pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-08 Thread Michael Eschweiler
rocess). The error message was: checking for C compiler default output file name... configure: error: C compiler cannot create executables See `config.log' for more details. Attached you find the config.log. Perhaps it helps to determine

Re: [pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-08 Thread Michael Eschweiler
wx-GTK? Sorry for this larger explanation. I am only a 'normal' user without greater programming skills... Michael > -- > Dave Page > EnterpriseDB UK Ltd: http://www.enterprisedb.com > PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk -- Sent via pgadmin-support ma

Re: [pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-11 Thread Michael Eschweiler
her distributions because of lack of time. Michael -- 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] Removing Context Messages

2008-04-07 Thread Michael Shapiro
I'd like to know the answer to this as well. I don't think it is PgAdmin doing it, but the server On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote: > Hi list, > > How do I remove CONTEXT messages from being displayed in pgadmin? > Those messages clutter my functions ou

Re: [pgadmin-support] sudden program termination: no warning, error, or crash

2008-06-04 Thread Michael Shapiro
The PgAdmin download page offers 1.8.4 -- even though the main page says 1.8.2 is the current release. Is 1.8.4 a good release? If not, is 1.8.3? On Wed, Jun 4, 2008 at 5:11 PM, Erwin Brandstetter <[EMAIL PROTECTED]> wrote: > Hi Kev! > > On May 28, 2:27 pm, Kev <[EMAIL PROTECTED]> wrote: > > Hi

Re: [pgadmin-support] 1.8.4 bug DB Restriction field

2008-06-05 Thread Michael Shapiro
I think there is a problem with the syntax -- highlighted below It seems that datname NOT in (datname='blah') should just be datname NOT in ('blah') SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding, p

Re: [pgadmin-support] question on graphical explain

2008-08-20 Thread Michael Shapiro
print-screen doesn't cut it when the diagram is too tall or too wide for window and the image has scrollbars. The EXPORT to image for the explain diagram would preserve all of the image. 2008/8/20 Mark Steben <[EMAIL PROTECTED]> > No rush Magnus, Dave's alt-printscreen suggestion works just fine.

[pgadmin-support] bug: Bit String Types

2008-10-09 Thread Pfuetz, Michael
type bit(8) Insert with psql: INSERT INTO test_bit (id,byte) VALUES ('hello', B'10101010'); INSERT 0 1 My Pgadmin Version: 1.8.4, Windows XP, SP2 1.9.0-dev, Windows XP, SP2 1.8.4, Linux SuSE 11.0 PostgreSQL Version: 8.2.4, SuSE 10.0 8.3.1, SuSE 11.0 Thanks a lot in adv

Re: [pgadmin-support] Error editing table WITH primary key

2009-01-18 Thread Michael Shapiro
One thing to consider (at least in my experience) is that if a table is altered outside PgAdmins interfaces, PgAdmin does not notice the changes until you refresh the object within PgAdmin. If you added the primary key outside PgAdmin while PgAdmin had already obtained the ddl, it would not see the

[pgadmin-support] default data sort

2009-06-21 Thread Michael Fraley
How can I change the default data sort for a table? When I view the data in the selected table, it always opens a spreadsheet view sorted by the primary key. In this case, the primary key is a one-up number and a more useful sort is the name column. How can I have it default to sort by name rat

[pgadmin-support] default data sort

2009-06-21 Thread Michael Fraley
How can I change the default data sort for a table in pgAdmin? When I view the data in the selected table, it always opens a spreadsheet view sorted by the primary key. In this case, the primary key is a one-up number and a more useful sort is the name column. How can I have it default to sort

Re: [pgadmin-support] Segmentation fault

2009-07-03 Thread Michael Shapiro
It failed for me as well: ERROR: could not access file "$libdir/admin81": No such file or directory" However, it did not crash PgAdmin and the server Status window stayed up and show records in the Activity portion I am running pgAdmin3 ver.1.10.0 (Jun 29 2009, rev.7942:7943M) under windows XP O

Re: [pgadmin-support] Segmentation fault

2009-07-07 Thread Michael Shapiro
I have no idea. Would this be part of the postgres server or part of PgAdmin? On Tue, Jul 7, 2009 at 4:02 PM, Guillaume Lelarge wrote: > Le vendredi 3 juillet 2009 à 20:29:50, Michael Shapiro a écrit : > > It failed for me as well: > > ERROR: could not access file "$libdir/ad

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Michael Shapiro
The query select count(*) from pg_proc where proname='pg_file_write'; returns 1 On Wed, Jul 8, 2009 at 1:42 AM, Guillaume Lelarge wrote: > Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit : > > I have no idea. Would this be part of the postgres server or

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Michael Shapiro
t browsable: No such file or directory the scroll bar on the logile file pane works fine and has a log entry in it: redirect_stderr not enabled or log_filename misconfigured On Wed, Jul 8, 2009 at 3:04 PM, Guillaume Lelarge wrote: > Le mercredi 8 juillet 2009 à 16:09:15, Micha

Re: [pgadmin-support] Segmentation fault

2009-07-08 Thread Michael Shapiro
VOLATILE STRICT; So there is some interaction between the C function and the system involving $libdir/admin81. Since I don't understand where this function came from (if it isn't part of the server), or why it is looking for admin81 I will ask the admin of the server to look into this ... On

Re: [pgadmin-support] Segmentation fault

2009-07-13 Thread Michael Shapiro
No, I don't. I think they figure this isn't worth their time to investigate On Mon, Jul 13, 2009 at 10:15 AM, Guillaume Lelarge wrote: > Le mercredi 8 juillet 2009 à 22:59:27, Michael Shapiro a écrit : > > I don't think this is really a PgAdmin problem. PgAdmin is

[pgadmin-support] shared_preload_libraries error message

2009-07-20 Thread Michael Shapiro
This is a new error message. I have been using 1.10.0 (jun 29 2009, rev: 7942:7934M) for a number of weeks now, and I am just now seeing this error message. It only occurs the first time I ask the see a function. After that (even for other functions) it does not happen. The server is Postgres 8.1.

[pgadmin-support] lost connection, pgadmin crashes

2009-08-07 Thread Michael Shapiro
If the SQL window loses the connection and I try to rerun the query that is in the window, PgAdmin dies. How hard would it be to modify the SQL window to reconnect if it has lost the connection?

Re: [pgadmin-support] Viewing TEXT objects

2009-09-30 Thread Michael Shapiro
What is wrong with these results? COL1 has the text value "88352" On Wed, Sep 30, 2009 at 2:52 PM, Dave Page wrote: > [Please keep the list CC'd] > > On Wed, Sep 30, 2009 at 8:49 PM, mad rug wrote: > > Hi > > > > This is the definition: > > > > CREATE TABLE "TBL" > > ( > > "ID" bigint NOT NUL

Re: [pgadmin-support] Viewing TEXT objects

2009-09-30 Thread Michael Shapiro
or filling the screen with data that most of the time is not essential), and > so it was only a matter of calling some function or changing some pgAdmin > preference, but none of you seem to have experienced this before. > > Any ideas? > > Thanks again! > > On Wed, Sep 30, 200

Re: [pgadmin-support] dropping connection

2009-10-13 Thread Michael Shapiro
The connection to the database is dropped occasionally (as far as I can tell, independently of internet connectivity issues). I have experienced this quite a lot. I do not think it is PgAdmin that drops the connection. Could be postgres itself is dropping the connection. There have been a number

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
It happens to me quite a lot, as well. I will lose the contents of the SQL window as well when it happens. It would be good if PgAdmin would automatically try to reconnect (at least once) before giving up. On Wed, Nov 11, 2009 at 8:08 AM, Eugene Lisitsky wrote: > > I see such problem when remot

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
ifferent tool that can connect to the same Postgres database. On Wed, Nov 11, 2009 at 8:32 AM, Michael Shapiro wrote: > It happens to me quite a lot, as well. I will lose the contents of the SQL > window as well when it happens. > > It would be good if PgAdmin would automatically try to

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
server does automatic timeouts for idle connections. On Wed, Nov 11, 2009 at 9:20 AM, Michael Shapiro wrote: > It just happened again. I ran a query in a window and after it completed I > waited 10-15 minutes and ran it again. > I got a connection error. I ran the query again (by hitting

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
or the network did it (I suspect the network). This seems to imply that we are at the mercy of either the network admins or the server admins. In either case, it is problematic since a lost connection is not handled well in PgAdmin. On Wed, Nov 11, 2009 at 5:11 PM, Michael Shapiro wrote: > I

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
can determine the settings for a server by running the following: select * from pg_settings where name like 'tcp%' On Wed, Nov 11, 2009 at 9:21 PM, Michael Shapiro wrote: > I checked the server logs and found messages like this: > > 2009-11-11 15:08:36 PSTLOG: could not recei

Re: [pgadmin-support] [SOLVED] pgAdmin ver 1.10 freezing all too frequently

2009-11-12 Thread Michael Shapiro
My server's setting are: 'tcp_keepalives_count','9' 'tcp_keepalives_idle','7200' 'tcp_keepalives_interval','75' and I still get the problem. I just have to wait 20 minutes or so. (I don't really know how to predict how long it takes to lose a connection, even knowing these settings) Note that i

Re: [pgadmin-support] [SOLVED] pgAdmin ver 1.10 freezing all too frequently

2009-11-12 Thread Michael Shapiro
Yes, I am using Windows. I wouldn't describe what I see as hanging or freezing, just losing the connection and then crashing if I try to run the query again On Thu, Nov 12, 2009 at 7:11 AM, Dave Page wrote: > On Thu, Nov 12, 2009 at 1:08 PM, Michael Shapiro > wrote: > &g

Re: [pgadmin-support] Re: PgAdmin browses all tables, even those not allowed

2010-01-20 Thread Michael Shapiro
I don't think the assumption that CREATE implies SELECT is a good one. It is probably true in most cases, but there might be folks that have set it up otherwise. It seems that the Dependents tab on a role under the Login Roles might be the place to look for tables, etc, that the login has access t

Re: [pgadmin-support] Feature request: context menu column sorting

2010-02-03 Thread Michael Shapiro
It looks like you can. ctrl-c will copy what is highlighted On Wed, Feb 3, 2010 at 7:47 AM, Thom Brown wrote: > > And going back to the greyed out copy/paste/delete options, why can't > we copy a column or a range of cells? For example, if I select the > equivalent of B4 through C10, upon right

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

2010-02-09 Thread Michael Shapiro
I'd like to revive a feature request I made about 2 years ago ... On Thu, Sep 13, 2007 at 7:01 AM, Michael Shapiro wrote: > I would love to be be able to capture the diagram created by explain into > an image file (e.g. jpg). I don't see any way to do that in PgAdmin. I could &

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

2010-02-09 Thread Michael Shapiro
wrote: > Le 09/02/2010 14:30, Michael Shapiro a écrit : > > I don't think this is what I was asking for. I want the image from the > > "normal" (as opposed to "Analyze" or "Verbose"). The "Analyze" and > > "Verbose" do not

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

2010-02-09 Thread Michael Shapiro
:09, Michael Shapiro a écrit : > > We are talking about EXPLAIN, not VACUUM, since this is from the Query > tool. > > > > Sorry, I meant EXPLAIN when I said VACUUM. Should sleep more :) > > > Is there a lot more information in the EXPLAIN diagram with ANALYZE than > >

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

2010-02-09 Thread Michael Shapiro
On Tue, Feb 9, 2010 at 9:03 AM, Guillaume Lelarge wrote: > > > I have a another request for a mod to the diagram. The text box > disappears > > as soon as I move the mouse. It would be helpful if it would stay up > longer > > (eg, until the mouse is clicked in the text box). In order to compare >

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

2010-02-09 Thread Michael Shapiro
owsers. > > 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, February 9, 2010 3:48 pm, Michael Shapiro wrote: > > The diagram looks pretty

Re: [pgadmin-support] Graphical Query Builder - usage stats?

2010-02-21 Thread Michael Shapiro
I don't use it. I think it might be useful for a user that is not familiar with the database. I would use auto-complete more if it would complete column names, but it only seems to complete schemas/tables/views. So in the end, I just type it all in. On Sun, Feb 21, 2010 at 6:48 AM, Mario Splival

[pgadmin-support] Feature request -- export as select into stmts

2010-02-24 Thread Michael Shapiro
It would be very useful to be able to export the results of a query as select into statements, at least in the case when there is only one table in the from clause.

[pgadmin-support] Can't access entire window in Graphical Query Builder (Windows platform)

2010-03-16 Thread Michael Haltrecht
Even when I rotate my monitor (so it's taller than wider), I can't scroll to access past the 55th field. The window scroll bars don't seem to take into account the actual size of the table. This is still an issue in 1.10.2 Thanks, Michael -- Sent via pgadmin-support mailin

Re: [pgadmin-support] pgAdmin Graphical Query Tool Crashes on Mac

2010-03-19 Thread Michael Shapiro
It doesn't crash under Windows, but deleting the join in the canvas does leave the join in the join tab in the bottom portion. Adding the join back in the canvas give 2 joins in the bottom portion On Fri, Mar 19, 2010 at 6:59 AM, Gary Carter wrote: > Mac OS X v10.5.8 > > pgAdmin v1.10.2 > > 1. Op

Re: [pgadmin-support] dropping connection

2010-07-23 Thread Michael Shapiro
I am using PgAdmin 1.10.2 on Windows XP. PgAdmin has crashed on me three times in the last two hours. This happens when it loses the connection to the database. The Object Browser reports a problem (I can't recall the exact message) and after I click OK (for each message) PgAdmin crashes.

Re: [pgadmin-support] dropping connection

2010-07-23 Thread Michael Shapiro
The visualtour page seems to imply that this works with 9.0, but it doesn't say if it works with previous versions. Will the reconnect work with 8.x (eg, 8.1)? On Fri, Jul 23, 2010 at 3:47 PM, Guillaume Lelarge wrote: > Le 23/07/2010 22:26, Michael Shapiro a écrit : > > Do you h

Re: [pgadmin-support] dropping connection

2010-07-26 Thread Michael Shapiro
I tested 1/12 beta. It has exactly the same problem. When the SQL editor loses the connection, rerunning the query causes PgAdmin to crash. On Fri, Jul 23, 2010 at 4:03 PM, Guillaume Lelarge wrote: > Le 23/07/2010 22:57, Michael Shapiro a écrit : > > The visualtour page seems to imply

Re: [pgadmin-support] dropping connection

2010-07-26 Thread Michael Shapiro
The IIRC patch works. Any chance of the SQL editor getting such a patch? On Mon, Jul 26, 2010 at 11:48 AM, Guillaume Lelarge wrote: > Le 26/07/2010 18:41, Michael Shapiro a écrit : > > I tested 1/12 beta. It has exactly the same problem. When the SQL editor > > loses the connec

Re: [pgadmin-support] dropping connection

2010-07-26 Thread Michael Shapiro
What happens is that the first time it does give an error. But the editor is not useable. If I rerun the query a couple times, it can crash. On Mon, Jul 26, 2010 at 1:58 PM, Dave Page wrote: > On Mon, Jul 26, 2010 at 5:41 PM, Michael Shapiro > wrote: > > I tested 1/12 beta. It has

Re: [pgadmin-support] dropping connection

2010-07-26 Thread Michael Shapiro
What do you mean: Can I select a different database after I get the error; or do I get the error using a different database? On Mon, Jul 26, 2010 at 2:05 PM, Dave Page wrote: > On Mon, Jul 26, 2010 at 8:03 PM, Michael Shapiro > wrote: > > What happens is that the first time it

Re: [pgadmin-support] dropping connection

2010-07-26 Thread Michael Shapiro
r did not happen from a problem with SQL editor. Those windows were still operating OK. On Mon, Jul 26, 2010 at 2:30 PM, Dave Page wrote: > The former. > > On Monday, July 26, 2010, Michael Shapiro wrote: > > What do you mean: Can I select a different database after I get the

Re: [pgadmin-support] dropping connection

2010-07-26 Thread Michael Shapiro
error, but no crash. The first error just said: ** Error *** The second said: ** Error *** no connection to server. On Mon, Jul 26, 2010 at 2:30 PM, Dave Page wrote: > The former. > > On Monday, July 26, 2010, Michael Shapiro wrote:

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Michael Shapiro
It looks blank, but its contents are actually there. ctrl-a, ctrl-c in the column selects what you''d expect to see. The behavior happens a 65536 in the lpad select lpad('test', 65535, 't')-- looks OK select lpad('test', 65536, 't')-- looks empty (but really isn't) On Tue, Jul 27, 2010

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Michael Shapiro
I think changing the background but leaving the current value "as is" is better than changing the value. That way you indicate that the value is there (and can be retrieved with copy/paste) but that you can't show it (and perhaps add a pop-up hint when the mouse is moved over the cell) On Wed, Jul

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Michael Shapiro
t's drawn to the screen, > not the value actually "in" the cell. And right now there isn't anything > rendered at all. > > On Wed, Jul 28, 2010 at 9:28 AM, Michael Shapiro wrote: > >> I think changing the background but leaving the current value "as is&quo

Re: [pgadmin-support] dropping connection

2010-09-24 Thread Michael Shapiro
, Jul 26, 2010 at 3:45 PM, Michael Shapiro wrote: > I was able to connect to a different database after I got the error. > However, now I could not get PgAdmin to crash. > After the first error, I connected to a different database with no problem. > Then I ran the query again, and go

Re: [pgadmin-support] dropping connection

2010-09-27 Thread Michael Shapiro
appen, you would have something useful to work with ... On Mon, Sep 27, 2010 at 10:19 AM, Dave Page wrote: > On Sat, Sep 25, 2010 at 8:32 AM, Dave Page wrote: > > On Sat, Sep 25, 2010 at 8:22 AM, Guillaume Lelarge > > wrote: > >> Le 24/09/2010 18:17, Michael Shapiro a é

Re: [pgadmin-support] dropping connection

2010-09-27 Thread Michael Shapiro
y yet again, I get the error again (no prompt to reconnect) and occasionally, (but not every time), PgAdmin then crashes. On Mon, Sep 27, 2010 at 11:09 AM, Guillaume Lelarge wrote: > Le 27/09/2010 17:27, Michael Shapiro a écrit : > > It is frustrating, it is not reproducible by me either.

  1   2   >