Kevin Houle <[EMAIL PROTECTED]> writes:
> The nature of the bug is that an 'lo_read' operation performed
> with DBD::Pg caused a segfault with postgresql-libs-7.3.2 and
> "hangs" on files >= 32768 bytes with postgresql-libs-7.3.4. The
> hang is actually a read() loop on the socket generating EAGAIN
Brian Lindauer <[EMAIL PROTECTED]> writes:
> In 7.3.4, calls to PQconsumeInput() hang when connecting over SSL, but
> this appears to be fixed at the head of the cvs tree. Is there a patch,
> or set of patches, I can apply to 7.3.4 to fix just the SSL problems? I
> tried applying the patch to fe-
"ir. F.T.M. van Vugt bc." <[EMAIL PROTECTED]> writes:
> free4testing=# select timestamptz '1901/12/13 23:59:59.9';
> timestamptz
> ---
> 1901-12-14 00:19:00+00:19
> (1 row)
> Yes, that's a new timezone on the second case, indeed, probably a kind of
> 'floa
sad <[EMAIL PROTECTED]> writes:
> Dont you find curious a commiting of a DDL ?
Only to someone who's used to inferior databases that cannot roll back
DDL commands.
regards, tom lane
---(end of broadcast)---
TIP 9: the planne
On Thu, 2003-08-21 at 07:55, Annu Panesar wrote:
> hi
> i need help urgently to understand how postgres manages its connection
> pool , how it manages deadlock . we are using postgres
See http://www.postgresql.org/docs/7.3/static/explicit-locking.html
Section 9.3.3 for DeadLocks.
signature.asc
D
Why does a DDL command starts a transaction ?!
try
# set autommit=off;
SET
# create table a (i int);
CREATE TABLE
# create table b (i int);
ERROR: current transaction is aborted, queries ignored until end of
transaction block
# commit;
COMMIT
# create table b (i int);
CREATE TABLE
# \d
Hello,
Annu Panesar wrote:
hi
i need help urgently to understand how postgres manages its connection
pool , how it manages deadlock . we are using postgres for our supply
chain mgmt system and we are facding connectin related problems..
plz cud u direct me to some relevant res ources/urls
> anything I can verify on that one to help?
free4testing=# select timestamptz('1901-12-14 0:0:0');
timestamptz
-
1901-12-13 23:40:32
(1 row)
Frank.
---(end of broadcast)---
TIP 9: the planner will ignore your desire t
> > anything I can verify on that one to help?
>
> "show time zone"?
free4testing=# show time zone;
TimeZone
--
unknown
(1 row)
free4testing=# select now();
now
---
2003-08-22 14:36:17.994049+02
(1 row)
The latter is what I meant by 'it seem
Frank van Vugt <[EMAIL PROTECTED]> writes:
> At this moment, I still have that second server that's still showing the
> problem, anything I can verify on that one to help?
"show time zone"?
regards, tom lane
---(end of broadcast)--
Just verified this on another Slackware machine:
(this one is a HP Netserver LH3)
free4testing=# select version();
version
PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
11 matches
Mail list logo
