On Thu, 08 Dec 2011 08:48:51 +0200, Andreas maps...@gmx.net 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
Am 08.12.2011 09:39, schrieb Emre Hasegeli:
On Thu, 08 Dec 2011 08:48:51 +0200, Andreas maps...@gmx.net 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
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
-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 vadi...@gmail.com:
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
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
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,
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,
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
抄送：
