-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ran into an issue in satCerts.py with the use of empty_blob(), being
used to insert into a table with a blob column which has a not null
constraint.

In PostgreSQL this column becomes a "bytea".

First tried changing it to just '' but this breaks for Oracle as it
evaluates to NULL.

Thought briefly about changing it to nonsense like "nothingyet" but
then decided to try a postgresql compatibility function. 

http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob;f=schema/spacewalk/postgresql/procs/empty_blob.sql;h=4af10bf12c8d483bdc0606395c8e346ef2423d88;hb=ad648496420396db183fa6433628ab17f8d9fd0b

Look ok?

Thanks,

Devan



- -- 
  Devan Goodwin <dgood...@redhat.com>
  Software Engineer     Spacewalk / RHN Satellite
  Halifax, Canada       650.567.9039x79267
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)

iEYEARECAAYFAkmdts0ACgkQAyHWaPV9my4LtwCgzh5bvmMkZJg/VthSJ9uPm/X0
CtUAn2iAj+zPZWkilVB4lgZN8/pgopkw
=ig80
-----END PGP SIGNATURE-----

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to