| From: | "Moiz Kothari" <moizpostgres(at)gmail(dot)com> |
|---|---|
| To: | "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: when inserting to table, text type parameter become NULL (after big assignment to this parameter) |
| Date: | 2007-10-17 10:36:11 |
| Message-ID: | 82e1a9bd0710170336q2179412au1330b38f0bcd7b2d@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
It worked fine for me too.
Regards,
Moiz Kothari
On 10/16/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Hobby Site : http://dailyhealthtips.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Moiz Kothari | 2007-10-17 11:16:05 | Re: Is there a way to kill a connection from the pg_stat_activitly list? |
| Previous Message | Alexis Beuraud | 2007-10-17 09:05:22 | running a SQL command at startup time |