newline in varchar causing funny behavior?

Hello All!

Using VB6 / ODBC. When there's a varchar containing text and a CRLF, and
I try to change that field - even if it's not a key, not indexed, and not
in any way interesting [other than containing a CRLF] - I get an error
about how "some of the fields have changed and the record can no longer be
located.

Any suggestions?


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: newline in varchar causing funny behavior?

> Using VB6 / ODBC. When there's a varchar containing text and a CRLF, and
> I try to change that field - even if it's not a key, not indexed, and not
> in any way interesting [other than containing a CRLF] - I get an error
> about how "some of the fields have changed and the record can no longer be
> located.

What PgSQL, psqlodbc version are you using? Are you using ANSI or UNICODE
psqlODBC? What OS?
You wrote too few informations.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: newline in varchar causing funny behavior?

Johann wrote:
> Hello All!
>
> Using VB6 / ODBC. When there's a varchar containing text and a CRLF,
> and I try to change that field - even if it's not a key, not indexed,
> and not in any way interesting [other than containing a CRLF] - I get an
> error about how "some of the fields have changed and the record can no
> longer be located.
>
> Any suggestions?

Please try to turn off the *LF<->CR/LF conversion* option.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend