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@gmx.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?
_ | _
(_()(|('.|)('||.|()|`|(