Thanks for your reply.
if timeout setting doesn't be supported, How to solve this question that the
client is hung for long time when executing time-comsuming query or query a
locked table.
2011-12-09
feng.zhou
发件人： Craig Ringer
发送时间： 2011-12-09 10:05:44
收件人： feng.zhou
抄送： pgsql-sql
On 12/09/2011 09:44 AM, feng.zhou wrote:
Hi
I set query timeout in code by using SQLSetStmtAttr ODBC API .
SQLSetStmtAttr( StatementHandle, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)timeout, 0 )
;
SQLExecute(StatementHandle);
But I find this setting has no effect.Before adding timeout setting,
SQLEx
sorry, timeout is 15 seconds
2011-12-09
feng.zhou
发件人： feng.zhou
发送时间： 2011-12-09 09:25:49
收件人： pgsql-sql
抄送：
主题： [SQL] Query Timeout Question
Hi
I set query timeout in code by using SQLSetStmtAttr ODBC API .
SQLSetStmtAttr( StatementHandle, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)ti
Hi
I set query timeout in code by using SQLSetStmtAttr ODBC API .
SQLSetStmtAttr( StatementHandle, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)timeout, 0
) ;
SQLExecute(StatementHandle);
But I find this setting has no effect.Before adding timeout setting, SQLExecute
costs 47 seconds.After adding timeou
On 12/08/2011 10:26 PM, chester c young wrote:
have an db with about 15 tables that will handle many companies. no data
overlap between companies. is it more efficient run-time to use one database
and index each row by company id, and one database and partition each table by
company id, or t
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Pavel Stehule
Sent: Thursday, December 08, 2011 2:40 AM
To: Vad N
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] prepared statements
Hello
2011/12/8 Vad N :
>
> Hi.
>
> How can i
have an db with about 15 tables that will handle many companies. no data
overlap between companies. is it more efficient run-time to use one database
and index each row by company id, and one database and partition each table by
company id, or to create a database for each company?
it is a we
Am 08.12.2011 09:39, schrieb Emre Hasegeli:
On Thu, 08 Dec 2011 08:48:51 +0200, Andreas wrote:
How is the easiest way to to find the customer.id of the new
customers so I can insert the projectinfos?
It is easy to select rows not related with another table. One of the
following queries ca
On Thu, 08 Dec 2011 08:48:51 +0200, Andreas wrote:
Hi,
suppose you need to import a csv with standard ciolums like name,
adress, phone, ... and some additional text columns that need to be
split off into referenced tables.
Those lookup-tables will only be needed for a project with limite
