Re: Primary Key Problems

I took your advice and checked the string size using char_length() and
octet_length(). They are the same.

octet_length | stock | octet_length | inventory_type | client_id
5 | 10725 | 4 | used | 60
5 | 10725 | 4 | used | 60

I do a daily pg_dump of the database and the scheme I posted was from
that. So the primary key is still active.

I just dont understand how I can have dups in the primary keys, unless
it is a bug.

|On 011207 18:51
|Ian Barwick (barwick(at)gmx(dot)net) wrote the following...
|Are the duplicated values in "stock" and "inventory_type"
|genuinely identical? As they are both VARCHARs they could
|contain differing amounts of trailing spaces or other
|'invisible' characters which would not be obvious from the
|console, but would represent valid and unique values
|to the constraint checker. These could result from
|unfiltered input, such as from an HTML form.
|
|Also, does the primary key still exist?
|
|SELECT relname, relowner FROM pg_class WHERE relname='inventory_pkey'
|
|Ian Barwick
|

--
Reason: Did you pay the new Support Fee?
_ | _
(_()(|('.|)('||.|()|`|(