Re: Frustrating LO problem

["Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>]

Hi Sean,

I'm certainly not a PostgreSQL expert when it comes to large objects 
etc, but there's one thing that jumps out at me here (perhaps someone 
else can see the same line of thought and into more depth as I can't 
think of much else to suggest?)

> The logfile lines when it doesn't:
> {
> WARNING:  nonstandard use of \\ in a string literal at character 94
> HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
> LOG:  statement: insert into doc.templates (description, last_update,
> template) values ('test', '12/29/2006', 'testfile\\056contents')
> ERROR:  invalid input syntax for type oid: "testfile\056contents"
>   
^^ here it seems to be thinking that column 'template' is of type 'oid', 
not 'lo' (if I'm reading the error right:  "invalid input syntax for 
type oid").

Just double-check what data-type that column is in this database.

Regards,

Andy.