hello!
I'm using Postgresql database from IIS/ASP with ODBC driver (
psqlodbc-08_0=
2_0500 , also used previous versions)
When I run some scripts, everything works fine. But the problem is that
all=
users are using the same connection to database, and the queries are
being=
queued. It doesn't depend on the=20
queries - for example, different uses run SELECTs from different tables,
th=
ere are no transactions, no deadlocks. no updates.
I can see it also from pgadmin - there's only one connection from
web-serve=
r -=20
and from ODBC logs:
[0.015]conn=3D026435D0, PGAPI_DriverConnect(out)=3D'DRIVER=3D{PostgreSQL
Un=
icode};DATABASE=3D***;SERVER=3D***;****T=3D5432;UID=3D***;PWD=3D;SSLmode=3Dd=
isable;ReadOnly=3D0;Protocol=3D7.4-1;FakeOidIndex=3D0;ShowOidColumn=3D0;Row=
Versioning=3D0;ShowSystemTables=3D0;ConnSettings=3D;Fetch=3D100;Socket=3D40=
96;UnknownSizes=3D0;MaxVarcharSize=3D255;MaxLongVarcharSize=3D8190;Debug=3D=
0;CommLog=3D1;Optimizer=3D1;Ksqo=3D1;UseDeclareFetch=3D0;TextAsLongVarchar=
=3D1;UnknownsAsLongVarchar=3D0;BoolsAsChar=3D1;Parse=3D0;CancelAsFreeStmt=
=3D0;ExtraSysTablePrefixes=3Ddd_;LFConversion=3D1;UpdatableCursors=3D1;Disa=
llowPremature=3D0;TrueIsMinus1=3D0;BI=3D0;ByteaAsLongVarBinary=3D0;UseServe=
rSidePrepare=3D0;LowerCaseIdentifier=3D0;XaOpt=3D1;AB=3D10;'
[24.687]conn=3D026435D0, query=3D'select prar_cbo.uuid,
substring(prar_cbo.=
identifier_ from 4 for 1) || '.' || substring(prar_cbo.identifier_ from 9
f=
or 1) as prar from tbl_ccam_program_action prar join tbl_ccam_corebo
prar_c=
bo on prar.uuid=3Dprar_cbo.uuid order by prar_cbo.identifier_'
[24.703] [ fetched 22 rows ]
[24.703]conn=3D026435D0, query=3D'select n.nspname, c.relname, a.attname,
a=
..atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull,
c.relh=
asrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner
join=
pg_catalog.pg_namespace n on n.oid =3D c.relnamespace and c.oid =3D
89971)=
inner join pg_catalog.pg_attribute a on (not a.attisdropped) and
a.attnum>=
0 and a.attrelid =3D c.oid) inner join pg_catalog.pg_type t on t.oid =3D
a=
..atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid =3D
a.=
attrelid and d.adnum =3D a.attnum order by n.nspname, c.relname, attnum'
[24.718] [ fetched 7 rows ]
conn=3D026435D0 =96 the same connection ID
If I open two or more connections from my script, they open normally, but
w=
hen users run it simultaneously, they still use the same connection.
I also use MS SQL Server - a new connection is opened for every user, so I
=
expect the same from Postgres.
Below is my ODBC settings:
[ODBC]
DRIVER=3DPostgreSQL Unicode
UID=3D***
AB=3D10
XaOpt=3D1
LowerCaseIdentifier=3D0
UseServerSidePrepare=3D0
ByteaAsLongVarBinary=3D0
BI=3D0
TrueIsMinus1=3D0
DisallowPremature=3D0
UpdatableCursors=3D1
LFConversion=3D1
ExtraSysTablePrefixes=3Ddd_
CancelAsFreeStmt=3D0
Parse=3D0
BoolsAsChar=3D1
UnknownsAsLongVarchar=3D0
TextAsLongVarchar=3D1
UseDeclareFetch=3D0
Ksqo=3D1
Optimizer=3D0
CommLog=3D0
Debug=3D0
MaxLongVarcharSize=3D8190
MaxVarcharSize=3D255
UnknownSizes=3D0
Socket=3D4096
Fetch=3D100
ConnSettings=3D
ShowSystemTables=3D0
RowVersioning=3D0
ShowOidColumn=3D0
FakeOidIndex=3D0
Protocol=3D7.4-1
ReadOnly=3D0
SSLmode=3Ddisable
****T=3D5432
SERVER=3D***
DATABASE=3D***
_________________________________________________________________
The best games are on Xbox 360. Click here for a special offer on an Xbox
=
360 Console.
http://www.xbox.com/en-US/hardware/wheretobuy/
---------------------------(end of broadcast)---------------------------
TIP 7: You can help sup****t the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
|
