At 11:06 AM 11/29/2004, Nando Dessena wrote:

>AWH> REL_permanent 2
>AWH> REL_view 4
>AWH> REL_external 8
>AWH> REL_temporary 16
>AWH> REL_preserve_on_commit 32
>AWH> REL_local 64
>
>AWH> Let's make it easy on ourselves and use the existing
>AWH> space.
>
>if you also introduce BIT_AND and BIT_OR as internal (not UDF)
>functions then it's OK. [system?] views could be defined to turn the
>bitmasks into something more readable if and when the need arises.
>
>If BIT_AND and BIT_OR are not available, on the other hand, it's
>gonna make the life of catalog-exploring tools like FlameRobin
>tougher.

OK, lets do it this way

REL_permanent_GDML = 2
REL_permanent_SQL = 3
REL_view_GDML = 4
REL_view_SQL = 5
REL_external_GDML = 8
REL_external_SQL = 9
REL_global_temporary_GDML_delete_on_commit = 16
REL_global_temporary_SQL_delete_on_commit = 17
REL_global_temporary_GDML_preserve_on_commit = 48
REL_global_temporary_SQL_preserve_on_commit = 49
REL_local_temporary_GDML_delete_on_commit = 80
REL_local_temporary_SQL_delete_on_commit = 81
REL_local_temporary_GDML_preserve_on_commit = 122
REL_local_temporary_SQL_preserve_on_commit = 123

Cheers,


Ann