[ADMIN] when inserting to table, text type parameter become NULL (after big assignment to this parameter)

2007-10-16 Thread Sofer, Yuval
Hi, I am trying to get server parameters (pg_settings) using a cursor and insert them to one column table. A stored procedure parameter holds the long string. The insert of this parameter does not fail. The problem is that the string (the parameter value) is not inserted to the tabl

Re: [ADMIN] when inserting to table, text type parameter become NULL (after big assignment to this parameter)

2007-10-16 Thread Tom Lane
"Sofer, Yuval" <[EMAIL PROTECTED]> 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 exam

Re: [ADMIN] when inserting to table, text type parameter become NULL (after big assignment to this parameter)

2007-10-17 Thread Moiz Kothari
It worked fine for me too. Regards, Moiz Kothari On 10/16/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Sofer, Yuval" <[EMAIL PROTECTED]> 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 p