On Sat, 7 Oct 2006, Tom Lane wrote:
"Sergey E. Koposov" <[EMAIL PROTECTED]> writes:
Will it be enough to provide the testcase for just that 'expain UPDATE' ?
Whatever makes it crash ;-)
So, the database schema with little data and a few functions is here
http://lnfm1.sai.msu.ru/~math/public_misc/cas.dump
And the java program crashing the backend is attached. (it is generally
one prepared statement , which i didn't succeded to crash from psql)
(it's possible to rewrite it in C with libpq, but I cannot do that very
easily).
Regards,
Sergey
*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
import java.sql.*;
public class xx
{
public static void main(String args[]) throws Exception
{
Class.forName("org.postgresql.Driver");
Connection conn =
DriverManager.getConnection("jdbc:postgresql://localhost:5432/cas","math","");
// Thread.sleep(10000);
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
stmt.execute("set search_path to cas_metadata_sega, cas_metadata");
String query="UPDATE table_list SET description = ? WHERE " +
" id = cas_get_table_id ( ?,? )";
String desc="\\tag{image SRC=\"/vizier/new2.gif\"}3rd release of DENIS
(2005Sep)";
PreparedStatement pstmt = conn.prepareStatement(query);
String catalog="cas_data_sega";
String table="b_denis_denis5";
pstmt.setString(1,desc);
pstmt.setString(2,catalog);
pstmt.setString(3,table);
pstmt.executeUpdate();
pstmt.close();
conn.rollback();
}
}
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend