Re: [BUGS] two minor issues with date time types

2003-08-15 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Thu, 14 Aug 2003, scott.marlowe wrote: >> insert into test values ('20021131'); >> invalid input syntax for timestamp: "20021131" >> >> SQL92 and 99 say it should be: >> data exception-datetime field overflow > I don't think that's intended to be the

Re: [BUGS] DBD::Pg 'lo_read' fails on >= 32768 byte large objects

2003-08-15 Thread Tom Lane
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

Re: [BUGS] DBD::Pg 'lo_read' fails on >= 32768 byte large objects

2003-08-15 Thread Tom Lane
Kevin Houle <[EMAIL PROTECTED]> writes: >> Can you get us a gdb stack trace from the segfault cases? > #36 0x40421712 in pqsecure_read () from /usr/lib/libpq.so.3 > #37 0x40421712 in pqsecure_read () from /usr/lib/libpq.so.3 > #38 0x40421712 in pqsecure_read () from /usr/lib/libpq.so.3 > #39 0x404

Re: [BUGS] DBD::Pg 'lo_read' fails on >= 32768 byte large objects

2003-08-15 Thread Tom Lane
Kevin Houle <[EMAIL PROTECTED]> writes: > Is it just me, or are both sides reading waiting for the other > side to send data? Sure looks like it. Could it be an OpenSSL bug? regards, tom lane ---(end of broadcast)--- TIP 9:

[BUGS] JDBC getImortedKeys() getExportedKeys() incorrect ON DELETE property

2003-08-15 Thread Richard Froud
POSTGRESQL BUG REPORT TEMPLATE Your name : Richard Froud Your email address : [EMAIL PROTECTED] S

Re: [BUGS] DBD::Pg 'lo_read' fails on >= 32768 byte large objects

2003-08-15 Thread Kevin Houle
--On Friday, August 15, 2003 08:43:23 AM -0400 Tom Lane <[EMAIL PROTECTED]> wrote: 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-l

Re: [BUGS] DBD::Pg 'lo_read' fails on >= 32768 byte large objects

2003-08-15 Thread Kevin Houle
--On Friday, August 15, 2003 02:09:32 PM -0400 Tom Lane <[EMAIL PROTECTED]> wrote: In 7.3.2 pqsecure_read will recurse to self when SSL_read returns SSL_ERROR_WANT_READ. I changed the recursion to a loop in 7.3.4. Evidently, in 7.3.2 it's possible for the recursion to overflow your alloted stack

[BUGS] 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could not be used in REVOKE in 7.3.4

2003-08-15 Thread Christoph Becker
The following table was created in PostgreSQL 7.3.4 create table dummy_groupmember_is_admin (bemerkung varchar(20)); GRANT SELECT, UPDATE, INSERT ON dummy_groupmember_is_admin TO GROUP admin; REVOKE ALL ON dummy_groupmember_is_admin FROM cb,postgres; If I read in the dumpall from the PostgreSQL