Postgres Pro
Downloads
Home   >   mailing lists

Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter) - Mailing list pgsql-admin

From Tom Lane
Subject Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)
Date
Msg-id 19363.1192553415@sss.pgh.pa.us
Whole thread Raw
In response to when inserting to table, text type parameter become NULL (after big assignment to this parameter)  ("Sofer, Yuval" <Yuval_Sofer@bmc.com>)
Responses Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)  ("Moiz Kothari" <moizpostgres@gmail.com>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list?
Next
From: "Martial Elise KIBA"
Date:
Subject: Re: Distributed DataBases