Re: [GENERAL] Unique is non unique; no nulls

2007-09-23 Thread Razvan Costea-Barlutiu
ur time. Razvan C..B. Gregory Stark <[EMAIL PROTECTED]> writes: "Razvan Costea-Barlutiu" <[EMAIL PROTECTED]> writes: This has way too many ramifications for me to follow so I do appreciate some guidance. What do the outputs of these queries say?

[GENERAL] Unique is non unique; no nulls

2007-09-22 Thread Razvan Costea-Barlutiu
Hello. Facts: 1. System: Win2003 2. Postgres 8.2 3. Use pgAdmin 1.6.2, rev.5837 to administer the database 3. Table: CREATE TABLE mt ( suid character varying(70) NOT NULL DEFAULT 'suid'::character varying, ris_match_row_idx integer DEFAULT -1, ris_match_rule smallint DEFAULT 999, stulev_matc