Re: pg admin bug - view data

> Yes, you're right, that's a bug; fixed in cvs.
> Though I consider a table without PK or OID buggy too... :-)
> We might expand pgAdmin3 to use a unique key as PK replacement.

phpPgAdmin does the following in order to find a unique row identifier:

1. Looks for a PK

2. Looks for a Unique index.  If one is found, editing rows is possible 
unless the entry in the index for the row is NULL (because there can be 
multiple NULLs in a unique index)

3. Looks for an OID column.  If one exists, editing is possible BUT the 
update or delete of the row is performed in a transaction and if more 
than one row is modified then the alteration is rolled back.  This is 
important as OID columns can contain duplicate entries in the case of 
OID wraparound.

You know, phpPgAdmin and pgAdmin really should share a lot more :)

I think I'll look at the pgAdmin3 column type alteration code.  You 
might be interested in phpPgAdmin's Find Object code...

Actually, are you guys BSD licensed or GPL'd? phpPgAdmin is GPL'd.

Chris