On Wed, Jan 15, 2014 at 3:11 PM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
On 15 Jan 2014, at 20:58, Matt Zagrabelny <mzagrabe@d.umn.edu> wrote:
Greetings,
Looking at the file raddb/mods-config/sql/main/postgresql/schema.sql in the git repo, I see:
CREATE TABLE radcheck ( id serial PRIMARY KEY, UserName text NOT NULL DEFAULT '', Attribute text NOT NULL DEFAULT '', op VARCHAR(2) NOT NULL DEFAULT '==', Value text NOT NULL DEFAULT '' );
Is the "id" field used by FR? Or does it exist for administration of the table in case someone enters two records with identical (UserName, Attribute, op, Values) values?
Administration. Some tools (like pgAdmin) won't operate on a table unless there's a primary key.
Primary key could be UserName, Attribute, Op, Value, but there are some cases (using -=, or += for example) where two or more identical rows could exist.
Thanks for the timely and informative reply, Arran! Cheers, -mz