| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Mihalidesová Jana" <jana(dot)mihalidesova(at)cetin(dot)cz> |
| Cc: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>,"pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: Oracke BLOB to Postgres BYTEA using ora2pg |
| Date: | 2019-01-15 11:56:05 |
| Message-ID: | fa5311f7-586b-4c60-9a2c-e047f1a47259@manitou-mail.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mihalidesová Jana wrote:
> nipjd=> select distinct encode(serializable_value, 'escape') from
> alf_node_properties_zaloha where serializable_value is not null;
> encode
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> decode(E'aced00057e72002c6f72672e616c66726573636f2e736572766963652e636d722e76657273696f6e2e56657273696f6e5479706500000000000000001200007872000e6a6176612e6c616e672e456e756d000000000000000012000078707400054d494e4f52',
> 'hex')
These contents are code, in the form of function calls, instead of data.
Possibly if you ran these function calls they would output the
original data, but that's a pretty weird form of storage. If the
insert was done by Ora2Pg, you want to report this as a bug.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ROS Didier | 2019-01-15 12:36:33 | RE: repmgr and SSH |
| Previous Message | Ravi Krishna | 2019-01-15 11:54:38 | Re: Read consistency when using synchronous_commit=off |