[pgadmin-support] Automating Reports

I like the PGadmin reports and would like to set up something to dump them regularly. is there a way I can generate programmatically? Thank in advance. Doug Little Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide 500 W. Madison, Suite 1000 Chicago IL 6066

[pgadmin-support] query saved during crash

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

[pgadmin-support] External table def not showing data type in 1.14.3

In gpadmin running on win7/32bit against greenplum 4.1.2.4 external tables columns are showing without a data type CREATE EXTERNAL TABLE etl_stage_tbls.ext_dim_sitevisit ( md5hash , visitid , visit1ofacctdayind , visit1ofacctind , visit1oftdayind , intentpurchaseind , intentsearchi

[pgadmin-support] Cut/Paste w/header

Is there a way to include column headers in the query output grid selection that is put on the cut/paster buffer (in windows). I know I can export with headers, but hardly ever do this because of the time it takes. I think I would want cut/paste to always include the headers. Doug Little Sr

[pgadmin-support] psql default directory on windows

Is there a way to have the default directory of the psql console session set? I just upgraded to windows 7 and it's defaulting to windows/system32 I guess this is a dos box default, but though I'd ask. Thanks Doug Little Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbit

[pgadmin-support] script option not showing

Sometimes, the script option is not showing from the table right click dropdown. I don't understand what is controlling the display/ non-display. Often, If I just exit and restart pgadmin the option will appear again. I'm running 1.12.3 on winxp sp3. Thoughts? Doug Little Sr. Data Warehouse

[pgadmin-support] Missing schema name

We're setting up a new machine. >From pgadmin when I look at the old machine tables, the schema name is >displayed in the screen [cid:image001.png@01CC580A.FFB1A050] When looking at the new machine, the schema name is not displayed. [cid:image002.png@01CC580A.FFB1A050] Visually, it's not a p

[pgadmin-support] Enhancement request - Data Grid sort controls

Hi, I'd like to request that the query data grid incorporate the column sort controls often available in data grids. Typically the column header indicates an order. Clicking on the header resorts the grid in the reverse order. Would eliminate the need to rerun the query to change order, or

Re: [pgadmin-support] "Invalid byte sequence" message

We see this a lot with web applications where users cut/paste from MS-Word. In our case, the web app and db (oracle) are the same character set, so no translation or validation is done. Oracle will store the values, even though they aren't valid UTF8 characters. We run into problems when the v

Re: [pgadmin-support] fsm and vacuum

Somehow this moved to the pgadmin list. It was intended for pgsql-admin. My apologies. This is a dba task, I'd never expect pgadmin would do this. From: Michael Shapiro [mailto:mshapir...@gmail.com] Sent: Friday, December 03, 2010 9:26 AM To: Guillaume Lelarge Cc: Little, Douglas; Pg

Re: [pgadmin-support] fsm and vacuum

MB pg_catalog pg_attribute 513871 98646 2135 46.2 96511 3162472448 3016 MB Thanks Doug -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Friday, December 03, 2010 2:55 AM To: Little, Douglas Cc: PgAdmin Support Subject: Re: [pgadmin-support

[pgadmin-support] fsm and vacuum

We're new to Greenplum, based on PG (8.2.13). we weren't advised to increase the max_fsm_relations switch as our db has grown. Currently we're nearly 14k tables/indexes and the switch is set to 1000. We've got it updated now, but wondering about the effect & recovery. We've regularly been reload

[pgadmin-support] copy

Is it possible to have a grid select/copy and paste to excel include the column headers? We're on 1.12.1 win/xp Doug Little Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell

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

I asked for it. I don't know how you all lived without it. Click on the dropdown and it shows the history of submitted statements. Click on a statement and it will be copied into the workspace. (replacing what's there now). Delete/delete all will remove items from the list or all. Doug -O

[pgadmin-support] 1.12.0. bug

In the server status screen. If in the LOCKS section, I click on the user column header I get this error. All of the other columns seem to be working correctly. I do not have superuser credentials. [cid:image001.png@01CB5EDF.3A1F2A30] Thanks for a major upgrade. You guys have put a lot in

[pgadmin-support] Server status

Hi, We're getting to change the status on our Greenplum/Postgres data warehouse to a production environment, As part of that I've lost my superuser privileges. So I'm no longer able to see the details of the workload on the server, But it's very helpful. I want it. 1.What permissions

Re: [pgadmin-support] Unexplained query activity.

325 logon roles, 24 groups Doug -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Tuesday, August 03, 2010 2:49 PM To: Little, Douglas Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Unexplained query activity. Le 03/08/2010 21:38

[pgadmin-support] Unexplained query activity.

Hi, Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4) I'm looking over my pgadmin log and seeing frequent executions of these queries. In this particular instance, the sql was executed 304 times (in 2 seconds), but why is it being executed so often. I had resource_groups

Re: [pgadmin-support] It takes a long time for pgAdmin to retrieve database schema details

We run pgadmin 3 10.0- 10.0.3 on GP 3.3.6 running on 10node solaris x64 10u3 array. Our db has 158 schema, the largest (350 tables, + 350 external tables), 4000+ tables, some tables with 2000+ (not desirable) partitions. Whole db size is ~12.5tb. Pgadmin will take a long time connecting on

[pgadmin-support] Query results grid copy header

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

[pgadmin-support] MS Access 2007 update write conflict problem & resolution

Hi, We've been struggling with an MS Access 2007 app that updates a PG table. It was working, and then it wasn't. It looks like we recreated the table without specifying the precision on the timestamp columns. PG is defaulting to timestamp(6), which doesn't work with MS Access. The finest p

[pgadmin-support] unexpected connection in query window

Hi, I'm seeing behavior that is unexpected. Hopeing to get a better understanding of how PGadmin manages connections I have a query window with 20+sql statements, connected to my fqa database. I'm running sql individually and seeing that sometimes they are directed to my prod database, inste

[pgadmin-support] Enhancement request2 - auto reconnect

Hello, A common complaint I have at my site is that Pgadmin doesn't automatically reconnect if it's not connected.Our networking folks, in their infinite wisdom, force terminate all sessions after 5mins of inactivity. For client/server apps like pgadmin it's a problem, since the session i

[pgadmin-support] Logging filename symbolics

Hi, I see that in the logging option for pgadmin that I can imbed the PID %ID in the log filename. Is it possible to use other symbolics? I'd like to use date. If possible, what would be the symbol? Thanks Doug Little Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwid

[pgadmin-support] Feature request - Log search

Hi, Now that my logs are smaller, It's a lot easier to use the server status feature. However, with 200mb logs, it's still hard to find anything specific. Is there a find/search feature available for searching the log. Other features that would be nice are 1. Highlight/copy 2. save Selection T

Re: [pgadmin-support] Controlling Server status log download

g new to PG. pgadmin helps a lot, since I'm too old to remember syntax. Cheers -Original Message- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: Sunday, February 07, 2010 10:47 AM To: Little, Douglas Cc: Guillaume Lelarge; pgadmin-support@postgresql.org Subject: Re: [pgadm

Re: [pgadmin-support] Controlling Server status log download

looking it's to investigate queries that are poorly performing. The log feature is currently interfering with this use. Thanks doug -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Saturday, February 06, 2010 5:08 PM To: r...@iol.ie Cc: Little, Doug

[pgadmin-support] Controlling Server status log download

Is there a way to turn off the download of the log when using server status. Everytime I open the status module, it downloads the entire log, which right now is over 500meg. Would be nice to cache this data to disk, or download only the last x minutes. Thanks Doug Little Sr. Data Warehouse Arc

Re: [pgadmin-support] feture request

Guillaume, Looks great. I think people will really like it. Thanks for all the hard work. Cheers! Doug -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Sunday, January 31, 2010 10:04 AM To: Dave Page Cc: pgadmin-support; Little, Douglas Subject: Re

[pgadmin-support] FW: pgscript & select

It's not clear to me from the doc that pgscript doesn't work with select statements. I'm trying to run set @databasename='orbitz_hist_schema_hods' ; select * from pg_catalog.pg_namespace n1 where n1.nspname = '@databasename' ; And when executed, I get no results in the data out

[pgadmin-support] enhancement request: Query history

Morning. The tool we're coming from supports a jet based mdb query history. Each submitted query and response/runtime is recorded in the mdb. If I have multiple exe's open, the all record to the same local mdb file. It's a very valuable function. Would be very nice to have something similar

[pgadmin-support] enhancement request. User prompts

Morning, I looked thru the manual for this, but couldn't find it User prompts. The tool we're coming from allows $var in the query and prompts the user for runtime value substituting that value for the variable in the query string. Would provide a lot of value. I've tried the macro's

[pgadmin-support] enhancement request. please enable object details copy

* Platform you're running on * Winxp sp4 * Language * English (US) * Distribution you used (source tarball, or binary) * Win msi, 1.10.0 jun 29,2009 rev:7942:7943M * Version you tested * 1.10.0 * If possible and appropriate, include a backtrace from the crash.

[pgadmin-support] When is a type required?

Hello, I've been working for months trying to implement a scheme for data encryption. Only our pii columns require encryption so it seemed that the manual suggestions implied that we needed to use column level PGP or the Encrypt/decrypt functions. For performance reasons we selected encrypt

[pgadmin-support] feture request

Hi, I'm new to this community and not sure how to submit feature request. Please advise. I'm converting from Teradata to greenplum, and one nice feature in our TD query tool was a query history. Timestamp, completion code, rows affected, and sql statement PGadmin seems to be very unstable in