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 Moiz Kothari
Subject Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)
Date
Msg-id 82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com
Whole thread Raw
In response to Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
It worked fine for me too.

Regards,
Moiz Kothari

On 10/16/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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



--
Hobby Site : http://dailyhealthtips.blogspot.com

pgsql-admin by date:

Previous
From: "Dennis, Allan"
Date:
Subject: Re: pg_ctl start doesn't daemonize properly
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list?