Re: Editing data.

> -----Original Message-----
> From: Kurt Roeckx [mailto:Q(at)ping(dot)be]
> Sent: 03 February 2003 20:00
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Editing data.
>
>
> It seems that while you're editing data, it tries to do an
> update for all the records matching the first field. This is
> not what I want at all. The primary key exists of 3 fields,
> and mostly the first field is the same.

Hi Kurt,

pgAdmin doesn't blindly use the first field, it looks for a primary key,
and if found, uses that, otherwise it builds a query based on the
original values of all usable columns. It doesn't currently handle
multipart primary keys, and in this case will try to use the first field
of the key (not the first field overall).

> Could it be made so that it uses the fields of the primary
> keys instead of just the first field? Or use the old data if
> no primary key is available ...

The fix is on the todo list.

> Also, I'd like to be able to set a record to NULL in it.

This can't easily be done because we have no way to know that the user
wants null as opposed to an empty string. Of course, it cannot be done
for your primary key columns anyway.

Regards, Dave.