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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)
Date: 2007-10-16 16:50:15
Message-ID: 19363.1192553415@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Martial Elise KIBA 2007-10-16 19:57:07 Re: Distributed DataBases
Previous Message Jonah H. Harris 2007-10-16 13:05:48 Re: Is there a way to kill a connection from the pg_stat_activitly list?