Thread: Problem with tables that have more than 1 field a pkey

Hi!

I have the following problem with pgAdmin, if a table has a primary key
comprised of more than 1 field, pgAdmin cannot identify specific rows. So
when I try to do an update or delete a row, pgAdmin updates or deletes ALL
of the rows in the table.  If the table has no primary key or a key with 1
field, it works OK.  I'm using pgAdmin 1.4.12, and postgresql 7.2.2.


Thanks in advance for any help,

Andres

_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
http://photos.msn.es/support/worldwide.aspx

Hi Andres,

Yes, this is a problem I'm aware of. I will look into the problem some more when I can get some time.

Regards, Dave.

> -----Original Message-----
> From: Andres Olarte [mailto:az9az@hotmail.com]
> Sent: 26 December 2002 16:35
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Problem with tables that have more
> than 1 field a pkey
>
>
>
> Hi!
>
> I have the following problem with pgAdmin, if a table has a
> primary key
> comprised of more than 1 field, pgAdmin cannot identify
> specific rows. So
> when I try to do an update or delete a row, pgAdmin updates
> or deletes ALL
> of the rows in the table.  If the table has no primary key or
> a key with 1
> field, it works OK.  I'm using pgAdmin 1.4.12, and postgresql 7.2.2.
>
>
> Thanks in advance for any help,
>
> Andres
>
> _________________________________________________________________
> MSN Fotos: la forma más fácil de compartir e imprimir fotos.
> http://photos.msn.es/support/worldwide.aspx
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>