[JDBC] cast in JDBC update

2001-08-07 Thread Tony Grant
hello, I am trying to update a field which contains an array of type INT4 via JDBC. ERROR: Attribute 'filmid' is of type '_int4' but expression is of type 'int4' You will need to rewrite or cast the expression How do I cast the expression in an JDBC update statement? The code used is lovingly

Re: [JDBC] cast in JDBC update

2001-08-07 Thread Rene Pijlman
On 07 Aug 2001 13:39:09 +0200, you wrote: I am trying to update a field which contains an array of type INT4 via JDBC. Java source code? UPDATE statement? Table description? Regards, René Pijlman ---(end of broadcast)--- TIP 5: Have you checked

[JDBC] deleting large objects from jdbc

2001-08-07 Thread heatherm
Hi, I've been browsing the newsgroup archives and came across the following: Can you see a scenario where a programmer would forget to delete the data from pg_largeobject and the database becoming very large filled with orphaned large objects? Does this mean that to delete my