Re: Posgres Adding braces at beginning and end of text (html) content

On Apr 2, 8:59 am, l...@solumslekt.org ("Leif B. Kristensen") wrote:
> On Thursday 2. April 2009, linnewbie wrote:
>
> >Hi All,
>
> >I'm fairly new to postgres and I'm having this peculiar problem.
>
> >I'm storing raw html in a text field and I want users who know HTML to
> >update the content in a textarea field.
>
> >The problem is postgres is adding braces to the begining and ending of
> >the content.  On creation and every time I update.
>
> I can't reproduce your problem in 8.3.5:
>
> pgslekt=> create table test (i integer, t text);
> CREATE TABLE
> pgslekt=> insert into test values (1, '<p>Hei hei</p>');
> INSERT 0 1
> pgslekt=> select * from test;
>  i |       t
> ---+----------------
>  1 | <p>Hei hei</p>
> (1 row)
>
> Perhaps it's a middleware problem?
> --
> Leif Biberg Kristensen | Registered Linux User #338009
> Me And My Database:http://solumslekt.org/blog/
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
below:

ie I input:

<h1>Hello World </h1>

<p>xyz <p/>
.........

into the text area field, save:

set page_content  [ ncgi::value  textarea_field_name]

database connect dbh $datasource $dbuser $dbpassword

set sql "INSERT INTO profile (page_content) \
        VALUES('$page_content') "

dbh $sql

......................

......................

......................


view:

set sql "SELECT page_content FROM profile \
        WHERE page_id = $page"

set page_content [lindex [ dbh $sql ] 0]

::ncgi::header "text/html

...........................

...........................

...........................


puts "<textarea id='page_content' name='page_content'> $page_content
</
textarea>"

.........................................................

........................................................



 in browser I see:

{<h1>Hello World </h1>

<p>xyz <p/>
.........
}

On a subsequent update I see

{{

<h1>Hello World </h1>

<p>xyz <p/>
.........
}}

On another I see

{{{

<h1>Hello World </h1>

<p>xyz <p/>
.........