[pgadmin-support] Query Editor: Size of last column can't be increased

2017-05-22 Thread mammoth.power
Some sql statements returns enough columns, that they fill the visual width of "Data Output" grid. At the moment the only way to change column width is: D&D it at the end of column (separator). When I try to increase the width of the last column, then it don't work, because I need to move m

[pgadmin-support] Query panel: Right-click popup menu

2017-02-11 Thread microsys.gr microsys.gr
OS Windows 10 64-bit Version 1.2 Python Version 2.7.11 Flask Version 0.11.1 Application Mode Desktop ​On ​ Query panel ​ the right-click popup menu items are Back / Forward / Reload ​ instead of ​Select All / Copy / Paste. Click on Reload freeze the application.

Re: [pgadmin-support] Query Tool: No rows shown for columns containing range types

2016-09-05 Thread Dave Page
On Mon, Sep 5, 2016 at 8:36 AM, wrote: > Windows 7 > Installer postgresql-9.6.0-rc1-windows-x64.exe from EnterpriseDB > pgAdmin 4 , Version 1.0-rc1 > > If there is a column with type numrange or daterange, the Query Tool won’t > show any data (though the green bottom right tooltip box says “3 row

[pgadmin-support] Query Tool: No rows shown for columns containing range types

2016-09-05 Thread Franz-Josef.Faerber
Windows 7 Installer postgresql-9.6.0-rc1-windows-x64.exe from EnterpriseDB pgAdmin 4 , Version 1.0-rc1 If there is a column with type numrange or daterange, the Query Tool won't show any data (though the green bottom right tooltip box says "3 rows retrieved").

Re: [pgadmin-support] query tool no longer working

2014-07-26 Thread genawaffle
Thank you so much. This simple "Default View" solved the problem for me! -- View this message in context: http://postgresql.1045698.n5.nabble.com/query-tool-no-longer-working-tp5802320p5812937.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pga

[pgadmin-support] Query tool dialog buttons not displaying and text window not accepting text

2014-07-25 Thread Pittman, Todd
The query tool is coming up unusable: System: pgAdmin 1.14.3 (though I have the same problem with both later versions) OS: Windows 7, Enterprise, sp1, 64-bit OS Steps to recreate: - Open pgAdmin - Select a database & table from the Object Browser - Click on the Quer

Re: [pgadmin-support] query tool no longer working

2014-05-04 Thread Guillaume Lelarge
ur servers once again). PS: please reply to the list. > > On Sun, 5/4/14, Guillaume Lelarge wrote: > > Subject: Re: [pgadmin-support] query tool no longer working > To: "Jim Bryan" > Cc: pgadmin-support@postgresq

Re: [pgadmin-support] query tool no longer working

2014-05-04 Thread Guillaume Lelarge
On Sat, 2014-05-03 at 15:34 -0700, Jim Bryan wrote: > Hi! Have been using PG 9.1 with the sql query tool for months, perfectly. > Now the query tool window is suddenly blanked-out. > Ubuntu 12.04 LTS. Can connect and still access data in tables. And can > connect via perl ide and then update,

Re: [pgadmin-support] query saved during crash

2013-02-23 Thread Guillaume Lelarge
On Thu, 2013-02-14 at 14:50 -0600, Little, Douglas wrote: > Pgadmin crashes on me a lot because the connection to the db has been severed > by the network for inactivity. > Often, I've been working on a query and have not yet saved the query. > > Is there any place the active queries are cached

[pgadmin-support] query saved during crash

2013-02-14 Thread Little, Douglas
Pgadmin crashes on me a lot because the connection to the db has been severed by the network for inactivity. Often, I've been working on a query and have not yet saved the query. Is there any place the active queries are cached on disk that I might be able to recover from? Thanks Doug Little

Re: [pgadmin-support] Query output is misleading due to grid cell size

2012-08-25 Thread Guillaume Lelarge
On Thu, 2012-08-16 at 12:56 +1000, Evan Martin wrote: > Running the latest trunk build (g7ac0c60) > > When pgAdmin displays the query output in a grid each column seems to be > sized based on the header size and the value is truncated as needed. > There is no indication that it's been truncated.

Re: [pgadmin-support] Query history

2012-08-25 Thread Guillaume Lelarge
On Thu, 2012-07-26 at 09:26 +0200, Guillaume Lelarge wrote: > On Thu, 2012-07-26 at 09:14 +0200, Guillaume Lelarge wrote: > > On Wed, 2012-07-25 at 22:57 +, Kozusznik Michal wrote: > > > > By query history, you mean the 4th tab in the query tool? or the > > > > combobox? > > > > > > I meant th

[pgadmin-support] Query output is misleading due to grid cell size

2012-08-15 Thread Evan Martin
Running the latest trunk build (g7ac0c60) When pgAdmin displays the query output in a grid each column seems to be sized based on the header size and the value is truncated as needed. There is no indication that it's been truncated. This sometimes makes the result highly misleading and I've ju

Re: [pgadmin-support] Query history

2012-07-26 Thread Guillaume Lelarge
On Thu, 2012-07-26 at 09:14 +0200, Guillaume Lelarge wrote: > On Wed, 2012-07-25 at 22:57 +, Kozusznik Michal wrote: > > > By query history, you mean the 4th tab in the query tool? or the > > > combobox? > > > > I meant the combobox. > > > > If you meant the combobox, it's a complete differe

Re: [pgadmin-support] Query history

2012-07-26 Thread Guillaume Lelarge
On Wed, 2012-07-25 at 22:57 +, Kozusznik Michal wrote: > > By query history, you mean the 4th tab in the query tool? or the > > combobox? > > I meant the combobox. > If you meant the combobox, it's a complete different story. The combobox doesn't get the whole query. It gets truncated at 10

Re: [pgadmin-support] Query history

2012-07-25 Thread Kozusznik Michal
> By query history, you mean the 4th tab in the query tool? or the > combobox? I meant the combobox. > Well, this would be a lot of work, something not reasonable to do. The > probably hardest part of it would be to find individual queries; Good > luck with that. > > Right now, we send to the s

Re: [pgadmin-support] Query history

2012-07-25 Thread Guillaume Lelarge
On Wed, 2012-07-25 at 18:15 +0200, Michal Kozusznik wrote: > While trying to use query history, I found 2 issue limiting the power > of this feature: > By query history, you mean the 4th tab in the query tool? or the combobox? > A) > query history is filled by whole script, not only but queri

[pgadmin-support] Query history

2012-07-25 Thread Michal Kozusznik
While trying to use query history, I found 2 issue limiting the power of this feature: A) query history is filled by whole script, not only but queries run. It fills query history by the same script multiple times even if script is not changing. How to reproduce: 1. Use following script SEL

Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Aren Cambre
Thanks! Yes, I am using Windows. Aren On Sun, Feb 19, 2012 at 5:12 AM, Guillaume Lelarge wrote: > On Sun, 2012-02-19 at 10:23 +0100, Guillaume Lelarge wrote: > > On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre wrote: > > > In the Server Status program, long queries get truncated. > > > > > > Pres

Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Guillaume Lelarge
On Sun, 2012-02-19 at 10:23 +0100, Guillaume Lelarge wrote: > On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre wrote: > > In the Server Status program, long queries get truncated. > > > > Pressing Ctrl-C or the *Copy* button on a recent query put this in the > > clipboard: > > *9368 de 34132 postgre

Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Guillaume Lelarge
On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre wrote: > In the Server Status program, long queries get truncated. > > Pressing Ctrl-C or the *Copy* button on a recent query put this in the > clipboard: > *9368 de 34132 postgres 6/528 AccessShareLock Yes 2012-02-18 > 18:46:14.759-06 select > distin

Re: [pgadmin-support] Query truncated in Server Status

2012-02-18 Thread Aren Cambre
Hmm, the magical number is not 250 characters. This query got truncated at character 374: *8640 Quantum GIS de postgres ::1:60281 2012-02-18 18:56:15.869-06 2012-02-18 18:56:15.893-06 2012-02-18 18:56:15.893-06 select distinct case when upper(geometrytype("the_geom")) IN ('POINT','MULTIPOINT') THEN

[pgadmin-support] Query truncated in Server Status

2012-02-18 Thread Aren Cambre
In the Server Status program, long queries get truncated. Pressing Ctrl-C or the *Copy* button on a recent query put this in the clipboard: *9368 de 34132 postgres 6/528 AccessShareLock Yes 2012-02-18 18:46:14.759-06 select distinct case when upper(geometrytype("the_geom")) IN ('POINT','MULTIPOINT

Re: [pgadmin-support] Query tool not open

2011-10-24 Thread Guillaume Lelarge
Hi, On Mon, 2011-10-24 at 01:34 -0700, sito-ito wrote: > I find a solution: > > I deleted folder: C:\Documents and Settings\Administrador\Datos de > programa\postgresql > > and query tool open again > I guess that the main issue was the .pgadmin_histoqueries file. Next time, just remove this

Re: [pgadmin-support] Query tool not open

2011-10-24 Thread sito-ito
I find a solution: I deleted folder: C:\Documents and Settings\Administrador\Datos de programa\postgresql and query tool open again -- View this message in context: http://postgresql.1045698.n5.nabble.com/Query-tool-not-open-tp4925093p4931739.html Sent from the PostgreSQL - pgadmin support mai

[pgadmin-support] Query tool not open

2011-10-23 Thread sito-ito
Hi!! I have a problem with my Query Tool of pgAdmin 1.12 Today not want to open de windows of querys and if push the button the program off I try to instal version 1.14 but not fix de problem. What can i do?? thanks a loot -- View this message in context: http://postgresql.1045698.n5.nabble.

Re: [pgadmin-support] query interminable

2011-08-18 Thread Guillaume Lelarge
On Thu, 2011-08-18 at 12:39 +0100, Pedro Costa wrote: > Hello to all, > > This is my first mail to the list. Sorry for the bad english. I need > your help. > I import 8 shapefiles to a database of pgadmin, (4 stretes and 4 rides). > I want to determinate the street of each ride by the distance s

[pgadmin-support] query interminable

2011-08-18 Thread Pedro Costa
Hello to all, This is my first mail to the list. Sorry for the bad english. I need your help. I import 8 shapefiles to a database of pgadmin, (4 stretes and 4 rides). I want to determinate the street of each ride by the distance so i write a query but in some cases, when i run one spatial quer

Re: [pgadmin-support] Query regarding Infinite Cache

2011-08-05 Thread Mamatha_Kagathi_Chan
Thanks Peter. It works . -Original Message- From: Peter Geoghegan [mailto:pe...@2ndquadrant.com] Sent: Friday, August 05, 2011 4:54 PM To: Chan, Mamatha Kagathi Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Query regarding Infinite Cache Hi Mamatha, On 4 August 2011

Re: [pgadmin-support] Query regarding Infinite Cache

2011-08-05 Thread Peter Geoghegan
Hi Mamatha, On 4 August 2011 13:11, wrote: > I am basically an Oracle user and now I am exploring PostgreSQL. I have > successfully configured the server. Now if I want to access that server from > my machine, what is the process?? Is it like Oracle where I will have to > install the client or t

Re: [pgadmin-support] Query regarding Infinite Cache

2011-08-05 Thread Guillaume Lelarge
On Thu, 2011-08-04 at 12:11 +, mamatha_kagathi_c...@dell.com wrote: > Hi, > > I am basically an Oracle user and now I am exploring PostgreSQL. I have > successfully configured the server. Now if I want to access that server from > my machine, what is the process?? Is it like Oracle where I w

Re: [pgadmin-support] Query regarding Infinite Cache

2011-08-04 Thread Mamatha_Kagathi_Chan
Hi, I am basically an Oracle user and now I am exploring PostgreSQL. I have successfully configured the server. Now if I want to access that server from my machine, what is the process?? Is it like Oracle where I will have to install the client or the concept is entirely different? Please help

Re: [pgadmin-support] Query regarding Infinite Cache

2011-07-19 Thread Guillaume Lelarge
On Tue, 2011-07-19 at 06:03 +, mamatha_kagathi_c...@dell.com wrote: > [...] > Should I buy license to install Infinite Cache? As of now I do not > see a parameter callededb_icache_warm_tablesin thepostgresql.conf as > mentioned in ‘Breaking Scalability Barrier Infinite Cache.pdf’. Please > gu

[pgadmin-support] Query regarding Infinite Cache

2011-07-19 Thread Mamatha_Kagathi_Chan
Hi, Should I buy license to install Infinite Cache? As of now I do not see a parameter called edb_icache_warm_tables in the postgresql.conf as mentioned in 'Breaking Scalability Barrier Infinite Cache.pdf'. Please guide me. Thanks, Mamatha

Re: [pgadmin-support] Query history mystery box

2010-09-23 Thread Guillaume Lelarge
Le 21/09/2010 22:44, Thom Brown a écrit : > On 21 September 2010 21:40, Guillaume Lelarge wrote: >> Le 21/09/2010 22:05, Guillaume Lelarge a écrit : >>> Le 21/09/2010 14:37, Thom Brown a écrit : On 21 September 2010 13:31, Guillaume Lelarge wrote: > Le 21/09/2010 14:25, Thom Brown

Re: [pgadmin-support] Query history mystery box

2010-09-21 Thread Thom Brown
On 21 September 2010 21:40, Guillaume Lelarge wrote: > Le 21/09/2010 22:05, Guillaume Lelarge a écrit : >> Le 21/09/2010 14:37, Thom Brown a écrit : >>> On 21 September 2010 13:31, Guillaume Lelarge >>> wrote: Le 21/09/2010 14:25, Thom Brown a écrit : > Hi all, > > I think the q

Re: [pgadmin-support] Query history mystery box

2010-09-21 Thread Guillaume Lelarge
Le 21/09/2010 14:37, Thom Brown a écrit : > On 21 September 2010 13:31, Guillaume Lelarge wrote: >> Le 21/09/2010 14:25, Thom Brown a écrit : >>> Hi all, >>> >>> I think the query history box should be labelled, or at least have a >>> tooltip. A colleague of mine was confused by the presence of t

Re: [pgadmin-support] Query history mystery box

2010-09-21 Thread Thom Brown
On 21 September 2010 13:31, Guillaume Lelarge wrote: > Le 21/09/2010 14:25, Thom Brown a écrit : >> Hi all, >> >> I think the query history box should be labelled, or at least have a >> tooltip.  A colleague of mine was confused by the presence of the new >> drop-down box with no indication as to

Re: [pgadmin-support] Query history mystery box

2010-09-21 Thread Guillaume Lelarge
Le 21/09/2010 14:25, Thom Brown a écrit : > Hi all, > > I think the query history box should be labelled, or at least have a > tooltip. A colleague of mine was confused by the presence of the new > drop-down box with no indication as to what this was. And to make > matters worse, when he went to

[pgadmin-support] Query history mystery box

2010-09-21 Thread Thom Brown
Hi all, I think the query history box should be labelled, or at least have a tooltip. A colleague of mine was confused by the presence of the new drop-down box with no indication as to what this was. And to make matters worse, when he went to the help guide, the screenshot doesn't show this drop

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

2010-09-20 Thread Guillaume Lelarge
Le 20/09/2010 11:46, Thor Michael Støre a écrit : > Hi, > > On 13. sep.. 2010, at 23.06, Guillaume Lelarge wrote: > >> Hi, >> [...] >> I've added a ticket (#234) for that. I can't check if it's a real bug as >> my Mac OS X box just doesn't me to compile pgAdmin. So it will probably >> take some t

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

2010-09-20 Thread Thor Michael Støre
Hi, On 13. sep.. 2010, at 23.06, Guillaume Lelarge wrote: Hi, [...] I've added a ticket (#234) for that. I can't check if it's a real bug as my Mac OS X box just doesn't me to compile pgAdmin. So it will probably take some time before I can work on this. Anyway, it's recorded. So I'll get

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

2010-09-13 Thread Guillaume Lelarge
Hi, Le 10/09/2010 11:03, Thor Michael Støre a écrit : > [...] > I'm using pgAdmin III 1.10.5 on OS X, and I can't disable "analyze" in > the query editor when the focus is on the "SQL Editor" pane. It's > checked in Query->Explain Options->Analyze, and after I select it and > check it again it's s

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

2010-09-10 Thread Thor Michael Støre
Hey, I'm using pgAdmin III 1.10.5 on OS X, and I can't disable "analyze" in the query editor when the focus is on the "SQL Editor" pane. It's checked in Query->Explain Options->Analyze, and after I select it and check it again it's still checked. An EXPLAIN ANALYZE is preformed no matter

Re: [pgadmin-support] Query Tool history makes the Query Tool unusable after BIG query had been executed

2010-09-06 Thread Guillaume Lelarge
Le 06/09/2010 14:00, Valentine Gogichashvili a écrit : > [...] > I just executed a query that was 30MB big and that made Query Tool not > usable as pgAdmin was hanging when trying to open a Query Tool window > (probably trying to read the humongous history XML file). > > Probably a limit should be

[pgadmin-support] Query Tool history makes the Query Tool unusable after BIG query had been executed

2010-09-06 Thread Valentine Gogichashvili
Hi, I just executed a query that was 30MB big and that made Query Tool not usable as pgAdmin was hanging when trying to open a Query Tool window (probably trying to read the humongous history XML file). Probably a limit should be set (or settable in parameters) for the size of the queries to be s

Re: [pgadmin-support] Query results grid copy header

2010-05-19 Thread Guillaume Lelarge
Le 19/05/2010 16:34, Little, Douglas a écrit : > Hi, > > When I copy/paste to excel the query results grid I'm not getting the column > headers. Is there any option to have the headers copied? > I don't think we have that. Didn't find it anyway. So I added a ticket (http://code.pgadmin.org/tra

[pgadmin-support] Query results grid copy header

2010-05-19 Thread Little, Douglas
Hi, When I copy/paste to excel the query results grid I'm not getting the column headers. Is there any option to have the headers copied? Thanks Doug Little Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.2

Re: [pgadmin-support] Query Tool - single frame

2009-11-18 Thread Guillaume Lelarge
Le lundi 16 novembre 2009 à 18:36:01, Vladimir Koković a écrit : > Hi, > > pgAdmin is something I use every day and not thinking about another > DB-manager, but one thing bothers me, as pgAdmin for each new query > opens a new frame. > > I am interested in whether there is consideration of a 'sin

[pgadmin-support] Query Tool - single frame

2009-11-16 Thread Vladimir Koković
Hi, pgAdmin is something I use every day and not thinking about another DB-manager, but one thing bothers me, as pgAdmin for each new query opens a new frame. I am interested in whether there is consideration of a 'single tabbed frame' option for 'Query Tool'? Best regards, Vladimi

Re: [pgadmin-support] Query window and non-english text

2009-11-11 Thread Dave Page
On Wed, Nov 11, 2009 at 2:31 PM, Eugene Lisitsky wrote: > Hi! > Thank you for the program! > I found one strange bug in Query window. > If you type Russian letters in it and then use cursor movement key - arrows > or backspace or delete, after you cannot type in Russian any more. You can > press l

[pgadmin-support] Query window and non-english text

2009-11-11 Thread Eugene Lisitsky
Hi! Thank you for the program! I found one strange bug in Query window. If you type Russian letters in it and then use cursor movement key - arrows or backspace or delete, after you cannot type in Russian any more. You can press letters on keyboard but nothing happens in the window. If you press

Re: [pgadmin-support] Query

2009-09-11 Thread Fernando Hevia
On Fri, Sep 11, 2009 at 4:16 AM, andre.wasserman telkom < andre.wasser...@telkomsa.net> wrote: > Dear PG Admin > > I downloaded Win AllinOne and seperate Client/Server/Postgre installation. > Tried Allin in one on a clean PC, but still can't get things going. > > On the clean PC everytime, when e

[pgadmin-support] Query

2009-09-11 Thread andre.wasserman telkom
Dear PG Admin I downloaded Win AllinOne and seperate Client/Server/Postgre installation. Tried Allin in one on a clean PC, but still can't get things going. On the clean PC everytime, when entering "createuser.exe --createdb --username postgres --no-createrole --pwprompt openuser" systems acce

Re: [pgadmin-support] query result set displaying data types in output window..

2008-04-09 Thread Dave Page
On Wed, Apr 9, 2008 at 1:23 AM, David Wheeler <[EMAIL PROTECTED]> wrote: > > Hello, > > In pgAdmin 1.8.2 – is there a way to *not display the data types in the > query data output window? Below the selected field name? Eg: > > > Fieldname1 Fieldname2 > > Biginit double precisio

[pgadmin-support] query result set displaying data types in output window..

2008-04-09 Thread David Wheeler
Hello, In pgAdmin 1.8.2 - is there a way to *not display the data types in the query data output window? Below the selected field name? Eg: Fieldname1 Fieldname2 Biginit double precision,etc,,etc,,, Your help in this would be greatly appreciated. Thanks Da

[pgadmin-support] query result set displaying data types in output window..

2008-04-08 Thread David Wheeler
Hello, In pgAdmin 1.8.2 - is there a way to *not display the data types in the query data output window? Below the selected field names? Eg: Fieldname1 Fieldname2 Biginit double precision,etc,,etc,,, Your help in this would be greatly appreciated. Thanks d

Re: [pgadmin-support] Query Window: keep going after error

2008-02-09 Thread Raymond O'Donnell
On 07/02/2008 15:30, Laurent Duperval wrote: I am currently testing some SQL scripts and I want to run the entire script, even if there is an error in it. Currently, it stops when there is an error and does not execute any of the commands in the SQL file. At a guess, I'd say that this is becau

[pgadmin-support] Query Window: keep going after error

2008-02-07 Thread Laurent Duperval
Hi, I am currently testing some SQL scripts and I want to run the entire script, even if there is an error in it. Currently, it stops when there is an error and does not execute any of the commands in the SQL file. How can I do this? Thanks, L -- Prenez la parole en public en étant Sp

Re: [pgadmin-support] Query tool greyed out

2007-09-17 Thread Dave Page
> --- Original Message --- > From: Erwin Brandstetter <[EMAIL PROTECTED]> > To: Dave Page <[EMAIL PROTECTED]> > Sent: 17/09/07, 17:29:37 > Subject: Re: [pgadmin-support] Query tool greyed out > > > Of course, the maintenance DB! > I am afraid you

Re: [pgadmin-support] Query tool greyed out

2007-09-17 Thread Erwin Brandstetter
Dave Page wrote: Erwin Brandstetter wrote: In a future release we could default to database "postgres" for global objects, which is there for purposes like this one, isn't it? It would be convenient to to open the SQL window directly from a role. As long as we work on global objects like roles, t

Re: [pgadmin-support] Query tool greyed out

2007-09-17 Thread Dave Page
Erwin Brandstetter wrote: > On Sep 15, 10:28 am, [EMAIL PROTECTED] (Dave Page) wrote: >> Rob McDonell wrote: >>> In both version 1.6 and 1.8 (can't remember earlier) the SQL button and >>> Query Tool menu item are inactive/greyed out when a Role is selected in >>> the Object Browser. This tool shou

Re: [pgadmin-support] Query tool greyed out

2007-09-17 Thread Erwin Brandstetter
On Sep 15, 10:28 am, [EMAIL PROTECTED] (Dave Page) wrote: > Rob McDonell wrote: > > In both version 1.6 and 1.8 (can't remember earlier) the SQL button and > > Query Tool menu item are inactive/greyed out when a Role is selected in > > the Object Browser. This tool should always be available: regar

Re: [pgadmin-support] Query tool greyed out

2007-09-15 Thread Dave Page
Rob McDonell wrote: > In both version 1.6 and 1.8 (can't remember earlier) the SQL button and > Query Tool menu item are inactive/greyed out when a Role is selected in > the Object Browser. This tool should always be available: regardless of > what you're browsing, you might want to write a query.

[pgadmin-support] Query tool greyed out

2007-09-15 Thread Rob McDonell
In both version 1.6 and 1.8 (can't remember earlier) the SQL button and Query Tool menu item are inactive/greyed out when a Role is selected in the Object Browser. This tool should always be available: regardless of what you're browsing, you might want to write a query. Thanks, Rob. -

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Raymond O'Donnell
Art Fore wrote: Sure would be nice and helpful for postgres if there was an Access like application for postgres that worked as well as Access it does, although There is - it's called pgAdmin! :) Seriously, Access tries to be both a GUI and a database; PostgreSQL is a database only, and does

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Art Fore
On Mon, 2007-02-12 at 12:00 +0100, Joris Dobbelsteen wrote: > >-Original Message- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore > >Sent: maandag 12 februari 2007 11:40 > >To: Pgadmin-Support > >Subject: [pgadmin-suppor

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Joris Dobbelsteen
>-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore >Sent: maandag 12 februari 2007 11:40 >To: Pgadmin-Support >Subject: [pgadmin-support] Query (view) question > [snip] >I tried this as a view with pgadmin with slight mods

[pgadmin-support] Query (view) question

2007-02-12 Thread Art Fore
I have been trying to get a query going in a postgres database, a simple on at that, and have had no success expcept using Access. Here is the query that works in Access. SELECT remote_ALL_PARTS.PARTNUM, public_datasheet_address.Datasheet & remote_ALL_PARTS.Datasheet AS Expr1, public_datasheet_ad

Re: [pgadmin-support] Query tool database selection (was: Beta 3 crashing reproducably)

2006-10-17 Thread Dave Page
> -Original Message- > From: Erwin Brandstetter [mailto:[EMAIL PROTECTED] > Sent: 17 October 2006 16:15 > To: pgadmin-support@postgresql.org > Cc: Dave Page > Subject: Re: [pgadmin-support] Beta 3 crashing reproducably > > > [EMAIL PROTECTED] wrote: > > >>> Also, there is no way to p

Re: [pgadmin-support] query tool save problem

2006-04-28 Thread Dave Page
> -Original Message- > From: Jan Zach [mailto:[EMAIL PROTECTED] > Sent: 28 April 2006 10:35 > To: [EMAIL PROTECTED]; Dave Page; > pgadmin-support@postgresql.org > Cc: Andreas Pflug > Subject: Re: [pgadmin-support] query tool save problem > > > Hi, >

Re: [pgadmin-support] query tool save problem

2006-04-28 Thread Jan Zach
__ > Od: [EMAIL PROTECTED] > Komu: "Dave Page" ,"Jan Zach" <[EMAIL PROTECTED]>, > > CC: "Andreas Pflug" <[EMAIL PROTECTED]> > Datum: 21.04.2006 17:26 > Předmět: Re: [pgadmin-support] query tool save

Re: [pgadmin-support] query tool save problem

2006-04-21 Thread Hirodhi Saito
Hi I cannot find a problem. Although or is not surely known by the reason I do not know the LATIN character... Regards, Hitroshi Saito From: "Dave Page" > The problem is with saving the query itself. > See the attachment. It's char 0xf8 (\u0159). It is latin_test1.png Description: PNG image

Re: [pgadmin-support] query tool save problem

2006-04-21 Thread Dave Page
> -Original Message- > From: Jan Zach [mailto:[EMAIL PROTECTED] > Sent: 21 April 2006 11:49 > To: Dave Page; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] query tool save problem > > > The problem is with  saving the query itself. > Se

Re: [pgadmin-support] query tool save problem

2006-04-21 Thread Jan Zach
__ > Od: dpage@vale-housing.co.uk > Komu: "Jan Zach" <[EMAIL PROTECTED]>, > CC: > Datum: 21.04.2006 12:19 > Předmět: Re: [pgadmin-support] query tool save problem > > > > > -Or

Re: [pgadmin-support] query tool save problem

2006-04-21 Thread Dave Page
> -Original Message- > From: Jan Zach [mailto:[EMAIL PROTECTED] > Sent: 21 April 2006 11:13 > To: Dave Page; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] query tool save problem > > > > -Original Message- > > > From: [E

Re: [pgadmin-support] query tool save problem

2006-04-21 Thread Jan Zach
> Od: dpage@vale-housing.co.uk > Komu: "Jan Zach" <[EMAIL PROTECTED]>, > CC: > Datum: 21.04.2006 09:15 > Předmět: Re: [pgadmin-support] query tool save problem > > > > > -Or

Re: [pgadmin-support] query tool save problem

2006-04-21 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jan Zach > Sent: 20 April 2006 22:53 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] query tool save problem > > Hi everybody, > > when saving some

[pgadmin-support] query tool save problem

2006-04-20 Thread Jan Zach
Hi everybody, when saving some national chars (see e.g. char with code 248 in table http://biega.com/ISO-8859-2.gif) everything seems ok but the result file on the disk is of size 0. I'm running version 1.4.1 (Feb 11 2006) build from ports on FreeBSD 6.0-RELEASE-p3, widgets wxgtk2u-2.6. Regar

Re: [pgadmin-support] Query tool not working

2006-03-03 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan DobbsSent: 03 March 2006 03:20To: pgadmin-support@postgresql.orgSubject: [pgadmin-support] Query tool not working Hi,I am new to postgeSQL and have recently installed version 8.1 on my local

[pgadmin-support] Query tool not working

2006-03-02 Thread Ryan Dobbs
Hi,I am new to postgeSQL and have recently installed version 8.1 on my local machine.I am running Windows XP Pro and am using pgAdmin III version 1.4.1I created a database with all the required tables and columns.  I have also created all the primary keys and foreign keys and can view/ created colu

[pgadmin-support] Query editor broken feature in 1.4.1

2006-01-06 Thread Laurent Yaish
On Windows, in the query editor the drop down with the active connection no longer brings up the dialog window to select a different database when selecting . Thanks, Laurent ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [pgadmin-support] Query regarding Bulk Import

2005-04-18 Thread James Prichard
The Postgres equivalent of the Microsoft command Microsoft T-SQL === BULK INSERT 'database_name.owner.table_name' FROM 'data_file' WITH (FIRSTROW=2) I like to store the column header names in row 1 Postgres COPY tablename [ ( column [, ...] ) ] FROM 'filename' Both of the

Re: [pgadmin-support] Query regarding Bulk Import

2005-04-18 Thread Dheeman - Web Spiders India
ss is not about winning every battle, it is about winning the war" -Original Message- From: James Prichard [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 6:14 PM To: pgadmin-support@postgresql.org Cc: Sim Zacks; [EMAIL PROTECTED] Subject: RE: [pgadmin-support] Query regarding Bu

Re: [pgadmin-support] Query regarding Bulk Import

2005-04-18 Thread Sim Zacks
b Spiders India Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Query regarding Bulk Import I'd use DTS Thank You Sim Zacks CIO CompuLab 04-829-0145 - Office 04-832-5251 - Fax Hi, I'

Re: [pgadmin-support] Query regarding Bulk Import

2005-04-18 Thread James Prichard
:26 To: Dheeman - Web Spiders India Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Query regarding Bulk Import I'd use DTS Thank You Sim Zacks CIO CompuLab 04-829-0145 - Office 04-832-5251 - Fax _

Re: [pgadmin-support] Query regarding Bulk Import

2005-04-18 Thread Sim Zacks
I'd use DTS Thank You Sim Zacks CIO CompuLab 04-829-0145 - Office 04-832-5251 - Fax Hi, I'm a new user of postgres. Earlier my database was sqlserver . now i want to perform BULK IMPORT of data from Sqlserver to P

[pgadmin-support] Query regarding Bulk Import

2005-04-18 Thread Dheeman - Web Spiders India
  Hi,   I'm a new user of postgres. Earlier my database was sqlserver . now i want to perform BULK IMPORT of data from Sqlserver to Postgres. Can you please suggest what are the tools that might be used in this purpose. Just to note that the data size in Sqlserver is of size more than 10GB.

[pgadmin-support] Query

2005-04-14 Thread Mario M. Yllescas J.
Hi, i'm a peruvian developer. I try to use the PgAdmin 1.3.0 April 1th in the window "View Data" when i do double click in a cell i can edit the data but when i press F2 key the content of the cell is replaced with a special caracter loosing the data :S   I hope that this issue can be solv

Re: [pgadmin-support] Query timing question

2005-03-28 Thread Andreas Pflug
Lou O'Quin wrote: If this is the case, then I would assume that pgAdmin uses the time sent, the time of first data arrival, and the time of query completion to calculate and display the times on the status line. We can't know that, because this is hidden in the underlying libpq library. Is anyo

[pgadmin-support] Query timing question

2005-03-11 Thread Lou O'Quin
Ref:   http://archives.postgresql.org/pgsql-performance/2005-03/msg00190.php     In the above referenced thread, I bring up an observation re the timing of pgAdmin results.   Essentially I observed that the query execution times as reported by pgAdmin "inflate" much more than the data retrieval t

[pgadmin-support] Query window

2004-10-19 Thread Sídar LC
1, Maybe add some flexibility to pgAdmin Query Window to allow view or not the column type when execute a query. 2. Let me navigate throw query result as i do in spreadsheet to easy count the columns involved in the result. This is basically when develop applications and i need to count the colu

Re: [pgadmin-support] Query tool and SSL connections

2003-11-17 Thread Keith C. Perry
Quoting Andreas Pflug <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > > > > My current solution is to install Slackware 9.1. :) > > > > Well, > I'm hesitating to require all pgAdmin3 users to install Slackware or > SuSE... ;-) > > Regards, > Andreas I don't see a problem with that :)

Re: [pgadmin-support] Query tool and SSL connections

2003-11-17 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: My current solution is to install Slackware 9.1. :) Well, I'm hesitating to require all pgAdmin3 users to install Slackware or SuSE... ;-) Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your fr

Re: [pgadmin-support] Query tool and SSL connections

2003-11-17 Thread timothy . r . morley
My current solution is to install Slackware 9.1. :) Tim Andreas Pflug <[EMAIL PROTECTED]> 11/17/2003 12:18 PM                 To:        [EMAIL PROTECTED]         cc:        [EMAIL PROTECTED]         Subject:        Re: [pgadmin-support] Query tool and SSL connections [EMAIL PRO

Re: [pgadmin-support] Query tool and SSL connections

2003-11-17 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: I was browsing through the pgadmin-hackers list today and noticed someone had built pgAdminIII for Fedora Core 1. I downloaded and installed it without a hitch. That build, however, suffers from the same problem as the builds for RedHat9 and Mandrake 9.1. The problem

[pgadmin-support] Query tool and SSL connections

2003-11-17 Thread timothy . r . morley
I was browsing through the pgadmin-hackers list today and noticed someone had built pgAdminIII for Fedora Core 1.  I downloaded and installed it without a hitch.  That build, however, suffers from the same problem as the builds for RedHat9 and Mandrake 9.1.  The problem being that when you try to

Re: [pgadmin-support] Query Tool (not Builder) and SSL

2003-10-30 Thread Andreas Pflug
Network Administrator wrote: Ok, that is problem my fault. I'm using the slackware package Version 1.1.0 Devel (Oct 29 2003). On the original post the problem use the visual query builder (unless I missed the jist of that post) using ssl. When I tested this, pgAdmin crashes for both ssl and non