col_is_unique not working on PostgreSQL 8.3

[guedes]

I'm using pgtap-0.25 and I'm getting this behaviour:

des=# BEGIN ;
BEGIN
des=# \d tb_g00
           Tabela "some.tb_g00"
       Coluna        |            Tipo             | Modificadores 
---------------------+-----------------------------+---------------
 cod                 | numeric(10,0)               | not null
 typ                 | integer                     | not null
 nro                 | character varying(12)       | not null
Indices:
    "pk_g00" PRIMARY KEY, btree (cod, typ)
    "ui_g00" UNIQUE, btree (cod, nro)
Restricoes de chave estrangeira:
    "fk_g11_g00" FOREIGN KEY (cod) REFERENCES tb_g11(cod) ON UPDATE CASCADE

des=# SELECT plan(1);
 plan 
------
 1..1
(1 registro)

des=# SELECT pgtap.col_is_unique('tb_g00', ARRAY['cod', 'nro']);
                                                        col_is_unique                                                         
------------------------------------------------------------------------------------------------------------------------------
 not ok 2 - Columns tb_g00(cod, nro) should have a unique constraint
 # Failed test 2: "Columns tb_g00(cod, nro) should have a unique constraint"
 #         have: 
 #         want: {cod,nro}
(1 registro)

[theory]

Yes, I believe that's because it's a unique index, not a unique constraint. Use this instead:

SELECT pgtap.has_index('tb_g00', 'ui_g00', ARRAY['cod', 'nro']);
SELECT pgtap.index_is_unique('tb_g00', 'ui_g00');

HTH,

David

[guedes]

Hum, I've misunderstood that, thanks!