Group: pgsql.admin


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