On 09/15/11 11:23 PM, Jayadevan wrote:
Thank you. We are working on an Oracle to PostgreSQL migration project. BLOB columns got converted to BYTEA in PostgreSQL and we ran into problems. We used this to convert the data type to OID. Thank you.
you probably should detail the problems you ran into. large objects normally aren't used unless you need to store over 1GB objects in the database, and at least speaking for myself, I'd rather not have objects that large in my database at all, I'd as soon use files for things that big.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general