[pgadmin-support] bug?: open new sql window during running query

2004-12-16 Thread Matt Doggett
ndow it is correctly displayed. Does this make any sense? It looks like a bug to me and I'm wondering if anyone else can reproduce this. -Matt Pgadmin1.2.0 (Nov 29 2004), Win2k, postgres7.4 Matt Doggett Spatial Climate Analysis Service Oregon State University 316 Strand Ag Hall Corvallis, OR 9733

[pgadmin-support] SQL error

2004-05-19 Thread Matt Doggett
Whenever I am editing SQL statements in the query window and I either submit erroneous SQL or cancel an SQL transaction, any subsequent attempts to submit the SQL results in the following error message: ERROR: current transaction is aborted, commands ignored until end of transaction block The on

[pgadmin-support] pgadmin not responding

2004-03-18 Thread Matt Doggett
'd thought I'd let you developer wizards know about this behavior on BIG tables. -Matt ps. On my system it takes about 2.5 minutes to get table information on a table with nearly 21 million rows. Matt Doggett Spatial Climate Analysis Service Oregon State University 316 Strand Ag Hall

Re: [pgadmin-support] mixed case database name

2004-03-05 Thread Matt Doggett
Sorry. Forgot to mention that I'm using PgAdminIII 1.1.0 Developer's version (Feb 11 2004) on Win2K. >-Original Message- >From: [EMAIL PROTECTED] [mailto:pgadmin-support- >[EMAIL PROTECTED] On Behalf Of Matt Doggett >Sent: Friday, March 05, 2004 9:00 AM >To: [

[pgadmin-support] mixed case database name

2004-03-05 Thread Matt Doggett
Hi- I have a database with a mixed upper/lower case name (eg. "testA"). When I try to create a new database using this database as a template, pgAdmin responds with "ERROR! Template database testa does not exist." I can create a new database using the command line :> createdb -T "testA" newdb.

Re: [pgadmin-support] inserting new records without OIDs

2004-02-17 Thread Matt Doggett
gt;Cc: [pgADMIN] >Subject: Re: [pgadmin-support] inserting new records without OIDs > >Matt Doggett wrote: > >>Ooops. I sent this yesterday to the wrong maillist address. Sorry. I'll >>repost here. >> >>MD >>-Original Message- >>When I

[pgadmin-support] inserting new records without OIDs

2004-02-17 Thread Matt Doggett
using the Edit Data window. There is no blank row (with an asterisk *) in which to enter new data. In other words, I've discovered that you MUST use OIDs to be able to insert new records with the Edit window. Is this normal/expected behavior or a bug or a feature? Matt Matt Doggett

[pgadmin-support] Subset edit data view

2004-02-10 Thread Matt Doggett
I've been using pgaccess for a while and decided to give pgadmin a try and see how it compares, so I'm new here. One thing I'd like to do is be able to interactively edit data in the database. I notice that pgadmin offers a "view data" where you can do this, and that's great. However, I have som