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
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
'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
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: [
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.
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
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
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