TEXT data type in postgresql

--===============4885027718155095519==
Content-Type: multipart/alternative; boundary="000000000000d6633f06436f7d2f"

--000000000000d6633f06436f7d2f
Content-Type: text/plain; charset="UTF-8"

Dear Mike, please consider the following table in postgresql

table t_text (
  old_data text,
  new_data text
)

compiling this following program (p_text.4gl):

DATABASE testdb
MAIN
    DEFINE  wt_text RECORD LIKE t_text.*

    LET wt_text.old_data = 'A';
    LET wt_text.new_data = 'B';

    DISPLAY wt_text.old_data, " => ", wt_text.new_data

END MAIN

returns:

Err:Program p_text.4ge stopped at 'p_text.4gl', line number 6.
Error status number -30414.
Unable to create blobfile.

4gl function call stack :
    MAIN

how to overcome this?

Is it possible to convert TEXT data type in postgresql into STRING instead
of BLOB?

Thanks,

Iwan

--000000000000d6633f06436f7d2f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Dear Mike, please consider the following table in postgres=
ql<br>=C2=A0<br>table t_text (<br>=C2=A0 old_data text,<br>=C2=A0 new_data =
text<br>)<br><br>compiling this following program (p_text.4gl):<br><br>DATA=
BASE testdb<br>MAIN<br>=C2=A0 =C2=A0 DEFINE =C2=A0wt_text RECORD LIKE t_tex=
t.*<br><br>=C2=A0 =C2=A0 LET wt_text.old_data =3D &#39;A&#39;;<br>=C2=A0 =
=C2=A0 LET wt_text.new_data =3D &#39;B&#39;;<br><br>=C2=A0 =C2=A0 DISPLAY w=
t_text.old_data, &quot; =3D&gt; &quot;, wt_text.new_data<br><br>END MAIN<br=
><br>returns:<br><br>Err:Program p_text.4ge stopped at &#39;p_text.4gl&#39;=
, line number 6.<br>Error status number -30414.<br>Unable to create blobfil=
e.<br><br>4gl function call stack :<br>=C2=A0 =C2=A0 MAIN<br>=C2=A0 =C2=A0 =
<br>how to overcome this? =C2=A0 =C2=A0<br><br>Is it possible to convert TE=
XT data type in postgresql into STRING instead of BLOB?<br><br>Thanks,<br><=
br>Iwan</div>

--000000000000d6633f06436f7d2f--


--===============4885027718155095519==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============4885027718155095519==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss

--===============4885027718155095519==--