Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8B2EE9FBBB4 for ; Wed, 17 Oct 2007 07:36:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47789-08 for ; Wed, 17 Oct 2007 07:36:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by postgresql.org (Postfix) with ESMTP id 145D29FBA52 for ; Wed, 17 Oct 2007 07:36:12 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so1500489rvb for ; Wed, 17 Oct 2007 03:36:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=otugLJe6gELeC8yE7LchfaEI+PthdSG3fdAL3+9N0rY=; b=aTYyhFsIoXTV3BPlmdyXeV3jBqBWCcRlXG0cuLQOoVixXfAccaQKzHfJUlgQE1ns6CKChKsPXsxhqpMx1rDI12iH4xHkFS2Tjn3pAnVezpfUUR+wAXZme2zAV01DFOduLgSpToxinqNyReBvxMoZgvQBBPMTRCQuKVNf0xatpZM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Y46TyzMpz/s5eieOP46LtgNUCLLo0Hb+ueJFzcCVnWZlz9O31/TRvkZww281NcqNOpO0Tz7Z3RQHIqPh7yKxtTiJjUVNnrPEoc0dCpZv47W+eLrxA09xYneibSyItWC9rJdGQf/OiGLJd+/oySpZqMIlRmaGN/d7uc2T/W2ecAw= Received: by 10.141.35.21 with SMTP id n21mr4081272rvj.1192617371395; Wed, 17 Oct 2007 03:36:11 -0700 (PDT) Received: by 10.141.90.15 with HTTP; Wed, 17 Oct 2007 03:36:11 -0700 (PDT) Message-ID: <82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com> Date: Wed, 17 Oct 2007 16:06:11 +0530 From: "Moiz Kothari" To: "Sofer, Yuval" Subject: Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter) Cc: pgsql-admin@postgresql.org, "Tom Lane" In-Reply-To: <19363.1192553415@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25290_10639633.1192617371394" References: <19363.1192553415@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/147 X-Sequence-Number: 27061 ------=_Part_25290_10639633.1192617371394 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline It worked fine for me too. Regards, Moiz Kothari On 10/16/07, Tom Lane wrote: > > "Sofer, Yuval" 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 ------=_Part_25290_10639633.1192617371394 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_25290_10639633.1192617371394--