|
Hello, Laurenz I'm sorry for replying you so late.. Thank you for your advice below. Finally we decide to port it as a shell
using the copy command. Actually, now I'm
confused with another problem, that is: Oracle: for
update wait 10 PostgreSQL: no
support for the parameter "wait" What should I do when I'm doing porting on
this point? If I get rid of the parameter "wait",
there would be a dead lock in my program... Is there any
support like "for update wait N" in PostgreSQL? I’m waiting for your reply. Thank you so much any way. ############################################################################ Following is my porting method,
although it avoid the dead-lock problem, but it affect the functionality. SELECT DOMAIN_ID, DOMAIN_NAME...FOR UPDATE WAIT 10 ORDER BY … -> SELECT DOMAIN_ID, DOMAIN_NAME...ORDER BY … FOR UPDATE return (List)
queryBean.getQueryRun().query(queryBean.getConn(), strSql, new String[]{domain_nm,server_flag},
srHandler); -> Connection conn = queryBean.getConn(); QueryRunner queryRunner =
queryBean.getQueryRun(); queryRunner.update(conn, "set statement_timeout = 10000"); return (List) queryRunner.query(conn,
strSql, new String[]{domain_nm,server_flag}, srHandler); ############################################################################ Following is the
exception when run my program… 11/12/06 15:18:17 ***: APL: INFO : … ….***SqlException: ERROR: canceling statement due to statement timeout
Query: SELECT… ORDER BY … FOR UPDATE Parameters:
[yun_SF_18, 0] … … 11/12/06 15:18:17 ***: APL: ERROR:
[ID:flj777] … : !! Exception [class ….***SqlException … … ] ############################################################################ Best Regards! -----Original Message----- From: Albe Laurenz [mailto:laurenz.albe@xxxxxxxxxx] Sent: Monday, October 10, 2011 10:26 PM To: Albe Laurenz; fanlijing *EXTERN*;
pgsql-admin@xxxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx Subject: RE: [GENERAL] how to save a bytea value into
a file? I wrote: [fanlijing wants to write bytea to file] > A simple > COPY (SELECT byteacol WROM
mytab WHERE ...) TO 'filename' (FORMAT binary) > should do the trick. Corrections: a) "binary" must be surrounded by single
quotes. b) that won't dump just the binary data - you would
have to remove the first 25 bytes and the last
2 bytes... So maybe using the functions I mentioned would be the best way after all. You could also write your own user defined function in
C. Yours, Laurenz Albe |
