pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Moiz Kothari <moizpostgres@gmail.com>
To: Sofer, Yuval <Yuval_Sofer@bmc.com>
Cc: pgsql-admin@postgresql.org, "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)
Date: Wed, 17 Oct 2007 16:06:11 +0530
Message-ID: <82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com> (raw)
In-Reply-To: <19363.1192553415@sss.pgh.pa.us>
References: <F8B9B12641FB6B4FAC761BDEF9D63B040EE27A6D@tlv-ex-01.adprod.bmc.com>
	<19363.1192553415@sss.pgh.pa.us>

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

view thread (3+ messages)

Message-ID: <82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com>
Permalink:  ../82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com/
Also on:    postgresql.org/message-id/82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: moizpostgres@gmail.com, Yuval_Sofer@bmc.com, tgl@sss.pgh.pa.us
  Subject: Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter)
  In-Reply-To: <82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox