Subject: when inserting to table, text type parameter become NULL (after big assignment to this parameter)
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 10/16/2007 12:50:15 PM
"Sofer, Yuval" <Yuval_Sofer@bmc.com> writes:
> I am trying to get server parameters (pg_settings) using a cursor and
> insert them to one column table.
> The problem is that the string (the parameter value) is not inserted to
> the table.
> When selecting, this column shows NULL value.
Hm, your example works fine for me in every current 8.x release.
What PG version is this exactly?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|