Re: pg_start_backup question

Below is what I did:
I opened a super user connection to creat a super user statement. Then use the super user statement to execute "SELECT pg_start_backup('label')".

try
{
        superuserCont = java.sql.DriverManager.getConnection(URL, su, suPassword);
        suStatement = superuserCont.createStatement();
        boolean ret = suStatement.execute("SELECT pg_start_backup('label')");                                       //LINE1
}
catch(SQLException e)
{
         System.out.println("exception");                                                                                              //LINE2
}
finally
{
        System.out.println("ret:" + ret);                                                                                                //LINE3
}

After LINE1 is executed, LINE3 is run and the output is: ret:false. LINE2 is not executed.

Thanks.


Jack