You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Chris Custine <ch...@gmail.com> on 2004/10/17 20:34:07 UTC

is_mapping_only column data type

The new IS_MAPPING_ONLY column in SECURITY_PRINCIPAL is mapped to a
bool data type when used with Postgres.  Obviously the population
scripts gag when trying to insert a 0 into the column.  As a
workaround I am generating this column type locally as a BOOLEANINT
which comes out to an int2 in Postgres.  This works just fine as far
as I can tell, but how about changing this to a simple boolean type
for the long term?  An alternative is to see if there is a way to
coerce Torque to create a BIT(1) or something like that but I could
not find a way to easily modify the way Torque maps data types.

I work exclusively with Postgres and I normally keep updated from CVS
daily, if someone wants me to create these Postgres related items as
Jira issues let me know, I would be happy to do it.

Chris

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org