Re: [pgadmin-support] Connecting to a different database while in Query Tool tab

i use this feature a lot in PgAdmin 3 -- when I need to copy a view or function from one database to another. On Thu, Jun 8, 2017 at 11:19 AM, Anthony DeBarros wrote: > OK, thanks. Might be a feature to consider ... > > On Thu, Jun 8, 2017 at 12:11 PM, Murtuza Zabuawala enterprisedb.com> wrote:

Re: [pgadmin-support] making me love pgAdmin III

FWIW -- the final release of PgAdmin 3 fixed an ssl issue which, at least for me, fixed the disconnects from the server.

[pgadmin-support] Difficult start with pgAdmin. First blank window. Then 'acsii' codec can't decode byte ...

apparently I need to create an account first to see the list (which I didn't do, yet) :-/ I'm having a difficult time getting started with pgAdmin. Hope you can help me here. Did I miss anything? If yes, please point me to the corresponding documentation. Best Regards Michael -- Sent vi

Re: [pgadmin-support] PgAdmin4 Bug report - Zoomed too far out

On Thu, Oct 20, 2016 at 6:13 PM, Michael Higgins > wrote: > > The same behavior happens with zoom set to 1. > > > > Please let me know if I can provide logs or anything helpful! > > I have no idea what is causing this then, unless there's another > config file that

Re: [pgadmin-support] PgAdmin4 Bug report - Zoomed too far out

The same behavior happens with zoom set to 1. Please let me know if I can provide logs or anything helpful! Thanks, Mike On Oct 20, 2016 12:25 PM, "Michael Higgins" wrote: It WAS re-created when CLOSING PgAdmin4. However, even with Browser.Zoom set to 0, I still just have a wh

Re: [pgadmin-support] PgAdmin4 Bug report - Zoomed too far out

The value I had was "-8.4618530273". Changing the value didn't work. Removing the plist file did not work. Is there any other information/logs I can provide? On Thu, Oct 20, 2016 at 12:25 PM, Michael Higgins < [email protected]> wrote: > It WAS re-creat

[pgadmin-support] PgAdmin4 Bug report - Zoomed too far out

First, thanks for everyone who contributes to this project. It's the only reliable client. I am running PgAdmin 4 v1.0 on OSX 10.11.6. I accidentally zoomed "too" far out using COMMAND + "Minus" Now, I can not see anything. I cannot zoom back IN with COMMAND + "Plus" I cannot reset the settings

Re: [pgadmin-support] pgadmin doesn't connect to server

:/etc/init.d # ./postgresql status and get back: Checking for PostgreSQL 9.3.10: running Checking for PostgreSQL 9.3.10: running So, the Postgresql-Server seems to work... It seems that I have to try the postgresql-mailing-list. Thanks once more, Michael Am 24.12.2015 um 08:39 schrieb Colin

[pgadmin-support] pgadmin doesn't connect to server

r - I use a German localisation) I looked at ~/data/base and found that the directory 12640 exists, and there I found the files 12391_fsm 12391_vm Has anybody an idea, what I should do? Thanks in advance. Michael -- Sent via pgadmin-support mailing list ([email protected]) To make ch

Re: [pgadmin-support] Memory use

PostgreSQL mailing lists at http://www.postgresql.org/list/. -- Michael Rasmussen Sr. Data Engineer Porch From: mailto:[email protected]>> on behalf of "HEARNE, TIMOTHY S" Date: Tuesday, September 15, 2015 at 8:28 AM To: "[email protected]&l

[pgadmin-support] Adding column default to child inheritance table does not generate DDL for default definition when using Create Script command

TER TABLE public.bar OWNER TO redacted; -- -- Name: the_value; Type: DEFAULT; Schema: public; Owner: redacted -- ALTER TABLE ONLY bar ALTER COLUMN the_value SET DEFAULT true; -- -- PostgreSQL database dump complete -- -- Michael Rasmussen Sr. Data Engineer Porch

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

ng in the icon to differentiate by shape for those that may be color blind. What about: * Table with green plus sign for inserts * Table with blue spinning refresh arrows for updates * Table with red X for deletes -- Michael Rasmussen Sr. Data Engineer Porch From: Guillaume Lelarge mail

Re: [pgadmin-support] PgAdmin 1.20 beta 2 crash on start(OS X 10.10)

SB Device: Internal Memory Card Reader USB Device: Apple Internal Keyboard / Trackpad USB Device: BRCM20702 Hub USB Device: Bluetooth USB Host Controller Thunderbolt Bus: MacBook Pro, Apple Inc., 17.1 -- Michael Rasmussen Sr. Data Engineer Porch From: Ilya Makarov mailto:[email protected]>&g

[pgadmin-support] pgAgent 3.4.0 - unhandled unknown exception

  I’m migrating a database from postgres 9.2 to 9.3, and I’m having persistent problems getting pageant (3.4.0) running. I have no problems running pgagent on my old server (pg 9.2.4, agent 3.2.1). Any assistance you can provide would be appreciated.  I’m able to start a task. However, the task

[pgadmin-support] Is Inherits table property inverted?

"Inherited tables count 0." Shouldn't the parent table show "Inherits tables No" with "Inherited tables count 0" and the child table read as "Inherits tables Yes" with "Inherited tables count 1"? -- Michael Rasmussen Data Engineer Porch.com

[pgadmin-support] Search feature request

I know that PgAdmin has the ability to find a pattern in various object names. Can PgAdmin search the actual text of procedures to find a pattern as well. For example, if I have a procedure named get_login, and it has a select that looks like select person_id from logins and I search fo

[pgadmin-support] LDAP support for 9.3 rpm

Hello, Can anyone confirm that http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm was compiled with LDAP support (option --with-ldap for configure)? Thanks, Mike

Re: [pgadmin-support] [GENERAL] Postgres case insensitive searches

I have a table called jobs with ~17 millions records. Without an index on the queue column, the following query select count(*) from jobs where lower(queue) = 'normal' found ~2.6 millions records in 10160ms With the following index: create index lower_queue on jobs (lower(queue)) th

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

One more thought. Is he on a file-system that imposes additional access control. /afs does this, for example. On Wed, Jun 19, 2013 at 12:03 PM, Guillaume Lelarge wrote: > On Tue, 2013-06-18 at 16:54 -0500, Michael Shapiro wrote: > > Maybe he doesn't have a Favourites file path se

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

Maybe he doesn't have a Favourites file path set in the Query Tool options? On Tue, Jun 18, 2013 at 4:12 PM, Guillaume Lelarge wrote: > On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote: > > Hi, > > > > When in the SQL editor, I can no longer add queries to my favourites. > > > > I have added

Re: [pgadmin-support] Copy and paste in Edit Data

I am running 1.16.1 (Windows 7). I can reproduce this. It makes a difference, though, if you use ctrl-c vs the right-click/Copy. ctrl-c does the whole entry, right-click/Copy gets just what is highlighted. ctrl-c gets the whole entry even if nothing is highlighted. On Fri, May 17, 2013 at 5:34 AM

Re: [pgadmin-support] 1.16.1: many operations cause display tree to collapse

I can confirm this behavior as well. On Sun, Apr 14, 2013 at 8:52 AM, Aren Cambre wrote: > Just FYI, this bug is still present in 1.16.1 (Apr 2, 2013, rev: > REL-1_16_1). > > As for whether it happens when adding columns, my experience on Windows 7 > is that the tree doesn't collapse when when I

Re: [pgadmin-support] Problem with DEBUG messages

;; in the query window before I run the function, I see the messages. So select test_debug(1) doesn't work, but SET client_min_messages to 'DEBUG'; select test_debug(1) does work, On Tue, Apr 9, 2013 at 10:53 AM, Dave Page wrote: > On Tue, Apr 9, 2013 at 4:47

Re: [pgadmin-support] Problem with DEBUG messages

, Dave Page wrote: > Hi > > On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro > wrote: > > Hi Dave, > > > > I reported a problem I am having with PgAdmin and DEBUG messages (April > > 2nd). There has been no repsonse. I am pretty sure it is a PgAdmin > i

[pgadmin-support] Problem with DEBUG messages

Hi Dave, I reported a problem I am having with PgAdmin and DEBUG messages (April 2nd). There has been no repsonse. I am pretty sure it is a PgAdmin issue, as other tools show the DEBUG messages but they do not show in PgAdmin. == Message ID: CAGCvxeb6KStFf95QAcCmo7sc49nvS6usEKV_ntthLr

[pgadmin-support] DEBUG not appearing in PgAdmin

I have procedures which issue RAISE DEBUG stmts. The output from these stmts does not show up in PgAdmin. They do show up in psql. Is there a PgAdmin option to suppress/show the DEBUG statements. I have client_min_messages set to debug1 (and again this works with psql but not PgAdmin) I am runni

[pgadmin-support] object browser collapses

On a lot of operations (adding a column, dropping a FK constraint), after the operation completes, the object browser collapses the tree. I am running PgAdmin 1.16.1 The OS is Windows 7 The PG server is 8.4.13 (redhat). I have another machine running PgAdmin 1.14.0 Beta 2, WIndows XP, connecting

Re: [pgadmin-support] pgAdmin crashing in Windows

I am running Window 7 (64bit), PgAdmin 1.16.1 I can not replicate this problem. It does not cause a crash. On Sat, Feb 23, 2013 at 5:31 PM, Aidan Gill wrote: > I can reliably reproduce this crash, both with pgAdmin 1.14 and pgAdmin > 1.16.1. > > I'm running the latest Windows version. To reprod

Re: [pgadmin-support] ERROR: relative path not allowed for COPY to file

It might be the / Try \ instead On Thu, Feb 14, 2013 at 8:43 PM, Katona, Steve < [email protected]> wrote: > I am using pgAdmin 14.1 and then tried with pgAdmin 16.1 > > ** ** > > I have tried: > > COPY (select * from file) TO '”C:/Dev/test.csv”'; > > ** *

Re: [pgadmin-support] how to disable auto-completion

I would like to request that PgAdmin do a better job at auto-completion as well. I don't use it now since what I really need is help with the columns, more than the tables. The tables are useful, but often I know the table names but can't remember the column names and auto-completion on column name

Re: [pgadmin-support] wish: Data Collapse / Expand Mode looks like phpPgAdmin

Am 31.10.2012 10:03, schrieb Dave Page: On Wed, Oct 31, 2012 at 8:18 AM, Michael Pfütz wrote: my wish: Data Collapse / Expand Mode looks like phpPgAdmin I have no idea what that means. The loading and processing of large tables with a lot of content (text> 1kb) takes otherwise extrem

[pgadmin-support] wish: Data Collapse / Expand Mode looks like phpPgAdmin

my wish: Data Collapse / Expand Mode looks like phpPgAdmin The loading and processing of large tables with a lot of content (text> 1kb) takes otherwise extremely long. Thank you. Michael -- Sent via pgadmin-support mailing list ([email protected]) To make changes to y

Re: [pgadmin-support] SQL pane freezes while editing

How do I determine which version of wxWidgets are being used? On Fri, Jul 27, 2012 at 6:53 AM, Guillaume Lelarge wrote: > On Fri, 2012-07-27 at 07:39 -0400, Colin Beckingham wrote: > > > I suppose Michael isn't using 2.9 release of wxWidgets. Your issue may be > more related

Re: [pgadmin-support] SQL pane freezes while editing

Works fine for me. I am running PgAdmin 1.14.2 Under Window 7 SP 1. On Fri, Jul 27, 2012 at 4:59 AM, Colin Beckingham wrote: > > > On 07/27/2012 05:04 AM, Michael Shapiro wrote: > >> I tried this and could not replicate the behavior >> The SQL is used looked like

Re: [pgadmin-support] SQL pane freezes while editing

I tried this and could not replicate the behavior The SQL is used looked like select * from x where (g = 5 and h =6 and y = 7) without word wrap there is a scroll bar with word wrap there is no scrollbar I was able to remove the left parenthesis and put it back without any problems un

Re: [pgadmin-support] Error opening file without suffix

I can't replicate this problem. It works for me. I am running pgAdmin 1.14.2, Windows 7 On Mon, Jul 23, 2012 at 3:58 AM, Michal Kozusznik < [email protected]> wrote: > Issue found in pgAdmin 1.14.2, Windows 7 > > How to reproduce: > 1. create some text file and save it without suffix -

Re: [pgadmin-support] Edit data on the data output tab

One idea is to provide a dialog that asks for the table and columns to use for the insert stmts. That way the user can define the insert without having to actually export the data and write scripts to produce the inserts And it would allow inserts into different tables than were used in the select.

Re: [pgadmin-support] Search the schema

Of course, makes sense, which is why I made the feature request I did (ie, search). Would you consider adding regex expressions to the search? On Thu, Jul 19, 2012 at 3:13 AM, Guillaume Lelarge wrote: > On Wed, 2012-07-18 at 21:47 -0500, Michael Shapiro wrote: > > What motivated me t

Re: [pgadmin-support] Search the schema

nt of the function is used. For example if there is a function A with two variants: A(int,int) and A(int, text) -- I'd like to be able to see where A(int, text) is used. On Tue, Jul 17, 2012 at 10:59 AM, Michael Shapiro wrote: > No, it doesn't. > > For example, I want to see i

[pgadmin-support] schema diff

I would like to to request a schema diff feature -- see the differences between the schemas of two databases. I realize this could be done with backup and an external diff tool, but it is cumbersome and generic diff tools don't give the necessary browsing capabilities. For example it would be nic

Re: [pgadmin-support] Search the schema

large > wrote: > >> On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro wrote: >> > No, it doesn't. >> > >> > For example, I want to see if a given string is used within a function. >> > I want to be able to see all the uses of a function: in othe

Re: [pgadmin-support] Search the schema

44 -0500, Michael Shapiro wrote: > > I am looking for the ability to search the schema. I'd like to be able to > > see, for example, where a particular string occurs in a function or a > view > > or table (or perhaps other objects). Right now I am forced to dump the > >

[pgadmin-support] Search the schema

I am looking for the ability to search the schema. I'd like to be able to see, for example, where a particular string occurs in a function or a view or table (or perhaps other objects). Right now I am forced to dump the schema and then search outside PgAdmin. So, I guess, I am asking for such a fe

Re: [pgadmin-support] background process?

Thanks. That's what I had thought, but I just wanted to make sure. I'll use psql (or write a perl script). On Sat, Jul 7, 2012 at 11:24 AM, Guillaume Lelarge wrote: > On Sat, 2012-07-07 at 10:45 -0500, Michael Shapiro wrote: > > Is it possible to run an update in the backgroun

[pgadmin-support] background process?

Is it possible to run an update in the background? I have an update to 23+ million records that will very likely take a few hours. Is it possible to issue the update in PgAdmin, and then exit PgAdmin and have the update continue on the server?

Re: [pgadmin-support] saved passwords deleted

exactly why it does it. > > On Thursday, July 5, 2012, Michael Shapiro wrote: > >> I ran into this and the behavior actually make some sense -- PgAdmin >> can't know why the connection was rejected so it has to deal with the >> possibility that the stored might be wron

Re: [pgadmin-support] saved passwords deleted

w one. On Wed, Jul 4, 2012 at 8:13 PM, Rohan Carly wrote: > On 5/07/2012 3:57 AM, Guillaume Lelarge wrote: > >> On Tue, 2012-07-03 at 14:50 +0800, Rohan Carly wrote: >> >>> On 17/02/2012 6:33 AM, Guillaume Lelarge wrote: >>> >>>> On Wed, 2012-02-1

Re: [pgadmin-support] RI_ConstraintTrigger

Thanks. I'll use 1.14.2 until the next release. On Tue, Jun 19, 2012 at 9:06 AM, Guillaume Lelarge wrote: > On Tue, 19 Jun 2012 09:00:16 -0500, Michael Shapiro > wrote: > > Is this in the 1.14.3 which is on the download sites? > > > > Nope. 1.14.3 is already out

Re: [pgadmin-support] RI_ConstraintTrigger

I think it is PgAdmin 1.14.3. I just uninstalled that version and reinstalled 1.14.2 and the RI-Constraints do not show up. On Mon, Jun 18, 2012 at 5:00 AM, Michael Shapiro wrote: > We are running > > PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) > 4.1.2 2

Re: [pgadmin-support] RI_ConstraintTrigger

We are running PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit On Mon, Jun 18, 2012 at 4:23 AM, Guillaume Lelarge wrote: > On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote: > > On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik

Re: [pgadmin-support] RI_ConstraintTrigger

I have exactly this same problem. As best as I can tell, the only thing that changed was I upgraded to 1.14.3. I made no changes to any options. Before 1.14.3 I did not see any RI Constraint triggers appear in object browser. I am running Windows 7 On Mon, Jun 18, 2012 at 3:25 AM, Guillaume Lelarg

[pgadmin-support] RI_ConstraintTriggers

I am now running 1.14.3 (under Windows) and I am seeing the RI_ConstraintTriggers now that I hadn't seen before. How do I prevent PgAdmin from showing these?

Re: [pgadmin-support] saved passwords lost when connection fails

My mistake. It turns out it does keep the password. It was prompting me for the password after the connect failed so I assumed it had forgotten it. But when I quit PgAdmin and restarrted, it used the saved password. So PgAdmin is handling this fine, On Sat, May 26, 2012 at 2:39 PM, Michael

[pgadmin-support] saved passwords lost when connection fails

PgAdmin doesn't retain the saved passwords when a connection to a server fails. I'd like to request that the saved passwords be kept, even in the event of a failure. I realize that if the failure is due to an incorrect password, there needs to be a way to enter a new one, but if the password is c

[pgadmin-support] Re: Bug: Constraint Trigger - created with pgadmin - is not visible and missing in SQL Pane / Create Script

as talking about) have tgisinternal set to false in table pg_trigger. Maybe this helps. Regards, Michael Von: [email protected] [mailto:[email protected]] Im Auftrag von Michael Brux Gesendet: Montag, 30. April 2012 15:03 An: [email protected]

[pgadmin-support] Bug: Constraint Trigger - created with pgadmin - is not visible and missing in SQL Pane / Create Script

(installed via Ubuntu package 9.1.3-0ubuntu0.11.10) pgAdmin 1.14.2 (Feb 24 2012, rev: REL-1_14_2) Regards, Michael

Re: [pgadmin-support] feature request

You're right. That complicates it. On Thu, Mar 8, 2012 at 6:43 AM, Dave Page wrote: > On Thu, Mar 8, 2012 at 12:26 PM, Michael Shapiro > wrote: > > SInce postgres would require a semi-colon between stmts, you could use > that > > fact to determine where a stmt star

Re: [pgadmin-support] feature request

SInce postgres would require a semi-colon between stmts, you could use that fact to determine where a stamt starts and where it ends (even for the case when the last stmt doesn't have one) On Thu, Mar 8, 2012 at 3:42 AM, Guillaume Lelarge wrote: > > On Thu, 2012-03-08 at 09:35 +0100, unterrainer

[pgadmin-support] feature request

Is is possible to have the results from multiple select statements be shown in the SQL Editor? You can run multiple, but only the results of the last one are currently shown.

Re: [pgadmin-support] saved passwords deleted

I have taken to making a copy of the password file so that when the connection fails and PgAdmin removes the password, I can put it back. On Wed, Feb 15, 2012 at 4:27 AM, Vik Reykja wrote: > On Tue, Feb 14, 2012 at 22:45, Guillaume Lelarge > wrote: > >> You can connect without saving the passwo

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

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

Re: [pgadmin-support] Views->Create Script + Regular Expressions

I ran into this warning when we switched from one version of Postgres to another. It complains when the view is created, but it works fine when I select from it. But I don't mix E' and \\ My views have strings like '\\.[0-9]+\\.' Your view has both E' and \\ -- could it be that if you have E' y

Re: [pgadmin-support] Timing out.

I have 1.14.0 Beta 2. Is there a newer version? I am running Windows 7, 64-bit, if that makes any difference. On Thu, Aug 11, 2011 at 4:05 PM, Guillaume Lelarge wrote: > On Tue, 2011-08-09 at 11:20 -0500, Michael Shapiro wrote: > > Thanks. I realize that the broken link wasn'

Re: [pgadmin-support] Missing schema name

If you right click on the database, and select properties, under the variables tab, there is a search_path variable in the Variable Name pulldown. On Thu, Aug 11, 2011 at 4:01 PM, Guillaume Lelarge wrote: > On Thu, 2011-08-11 at 15:26 -0500, Little, Douglas wrote: > > That worked, but I'm confuse

Re: [pgadmin-support] Missing schema name

I have multiple schemas in my database. I do not have a search_path set for the database (so it wouold use the default: $user,public When I look at any table in any of the schemas, the table name has the schema prepended to it. If it isn't PgAdmin doing it, then it must be in the Pg server itself.

Re: [pgadmin-support] Timing out.

large wrote: > On Tue, 2011-08-09 at 11:02 -0500, Michael Shapiro wrote: > > Where is the pg_service.conf file described? I can not find anything > about > > it in the help that comes with PgAdmin. > > Also, while looking in the help, I discovered a broken link (to an >

Re: [pgadmin-support] Timing out.

Where is the pg_service.conf file described? I can not find anything about it in the help that comes with PgAdmin. Also, while looking in the help, I discovered a broken link (to an external page for the pgpass documentation http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22

Re: [pgadmin-support] pgadmin and broken connections

I run a VPN. I did not see this problem with PgAdmin (1.14). I connected to the VPN, then I started PgAdmin and ran a query. Then I disconnected the VPN and ran the query again. No problem. Then I reconnected the VPN and ran the query once again. No problem. I also tested it started PgAdmin first,

Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

My experience with lost connections is other tools also lose the connection (eg, psql, Dbvisualizer). It is either Postgres itself dropping the connection or something between the me and the database, but I am certain it isn't PgAdmin itself. The problem with 1.12 was crashes when connections were

Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

I installed 1.14 beta and replicated the disconnect. 1.14 handled it fine. It asked me if I wanted to reconnect, and then ran the query fine. On Fri, Jun 17, 2011 at 3:11 AM, Michael Shapiro wrote: > My mistake, I am running 1.12. I didn't realize people were taking about > the 1.14

Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

My mistake, I am running 1.12. I didn't realize people were taking about the 1.14 beta. Sorry. On Fri, Jun 17, 2011 at 2:55 AM, Dave Page wrote: > On Fri, Jun 17, 2011 at 12:21 AM, Michael Shapiro > wrote: > > It happens to me on windows as well. If I lose the connection in

Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

It happens to me on windows as well. If I lose the connection in query window and I try to run the query two (maybe three) times without reconnecting via the object browser, PgAdmin crashes. On Wed, Jun 15, 2011 at 7:35 PM, Tim Uckun wrote: > > However, the pgAdmin crash/loss of reliability has

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

. Mike On Tue, Dec 21, 2010 at 4:58 PM, Guillaume Lelarge wrote: > Le 20/12/2010 22:20, Guillaume Lelarge a écrit : > > Le 20/12/2010 16:39, Michael Willekes a écrit : > >> The history file is only 14 MB (4219 lines long) but the PostGIS > geometry > >> columns (a

Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

The history file is only 14 MB (4219 lines long) but the PostGIS geometry columns (auto-generated from a .SHP file) result in individual INSERT statements that are as much as 50 characters long. This file is used by the query tool since 1.12. Do you know which size > it was? > > > -- > Guill

[pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

Hello, I've run into a the same issue described here: "Query Tool history makes the Query Tool unusable after BIG query had been executed " Hardware: - Windows 7 64 bit, 2 GB Ram, 2.8 Ghz Tools: - PostgreSQL 9.0.1, compiled b

Re: [pgadmin-support] fsm and vacuum

Admin sometimes tells me that a table needs vacuuming, so it is already "advising" people in that area ... On Fri, Dec 3, 2010 at 9:19 AM, Guillaume Lelarge wrote: > Le 03/12/2010 15:17, Michael Shapiro a écrit : > > The document http://wiki.postgresql.org/wiki/VACUUM_FULL

Re: [pgadmin-support] fsm and vacuum

The document http://wiki.postgresql.org/wiki/VACUUM_FULL says: VACUUM FULL, unlike VACUUM, tuples data that has not been deleted, moving it into spaces earlier in the file that have been freed. Once it's created a free space at the end of the file, it truncates the file so that the OS knows that s

Re: [pgadmin-support] Foreign key UI bug

Theoretically, you could have the same problem with the primary key -- there could be an index with that name already. But in practice it doesn't happen. You could generate a name for the foreign key based on similar pattern for the pk and if it fails, then it falls on the user to provide a name. S

[pgadmin-support] saved passwords deleted

I noticed that if I have a problem connecting to a server for which I have a saved password, the entry in pgpass.conf is deleted. When I later succeed in connecting, the server then prompts for a password (and the pgpass.conf entry is added back). Is it possible to not delete the entry if the conn

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

:08, Julius Tuskenis wrote: > > 2010.10.27 15:22, Michael Shapiro rašė: > >> > >> Thom Brown has it basically right. I want to be able to take the results > >> of what is in the grid editor and produce insert stmts. > > > > Yes - this kind of tool w

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

Edit Data/Tools? On Wed, Oct 27, 2010 at 5:46 AM, Thom Brown wrote: > On 27 October 2010 11:42, Guillaume Lelarge > wrote: > > Le 27/10/2010 01:12, Dave Page a écrit : > >> On Wed, Oct 27, 2010 at 1:47 AM, Michael Shapiro > wrote: > >>> What is the proper way

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

What is the proper way to make a feature request?

Re: [pgadmin-support] pgAdmin asks me the server's private key

I think this is a postgres question about how it expects ssl to be configured ... I found some source code for Postgres that has this message in it.. http://doxygen.postgresql.org/fe-secure_8c-source.html 01010 if (have_cert && fnbuf[0] != '\0') 01011 { 01012 /* read the client key fr

Re: [pgadmin-support] Crash when cancelling filter window

I got the same behavior (under Windows XP) On Thu, Sep 30, 2010 at 8:47 AM, Herouth Maoz wrote: > Steps taken: > > 1. Connect to database. > 2. Click on a table to choose it. > 3. Click on the appropriate icon to display the content of the table with a > filter. > 4. A dialog box for the filter

Re: [pgadmin-support] dropping connection

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.

Re: [pgadmin-support] dropping connection

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

, 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] Query->Explain Options->Verbose/Analyze unresponsive in 1.10.5 on OS X

's recorded. So I'll get back to it ASAP. Thanks for your report. I've tested it in 1.12.0 and can't reproduce it there. I assume the substantial changes in that area touched whatever might have caused it. Mvh, Thor Michael Støre Systemutvikler IPLink AS -- Sent via pgadm

[pgadmin-support] Query->Explain Options->Verbose/Analyze unresponsive in 1.10.5 on OS X

support/list.php, [email protected] didn't give a response at least. Thanks, Thor Michael Støre System Developer IPLink AS

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

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] Bug with exceptionally long values.

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.

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] dropping connection

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] dropping connection

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

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

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

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

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

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

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.

  1   2   >