[BUGS] Bug in libpq large-object interface

2000-05-29 Thread Ian Grant
Hi PostgreSQL people in general and Tatsuo in particular, I'm using V 7.0 on a Linux machine and I believe I have found a bug in the large object interface provided by libpq. The code below will reproduce it, I hope. Basically it creates a large object, writes six 'a' characters to it, then

[BUGS] Bug in libpq large-object interface

2000-05-29 Thread Ian Grant
Uh ... I forgot to send the code I referred to. Here it is again: Hi PostgreSQL people in general and Tatsuo in particular, I'm using V 7.0 on a Linux machine and I believe I have found a bug in the large object interface provided by libpq. The code below will reproduce it, I hope. Basicall

Re: [BUGS] Postgresql 7.0 bug

2000-05-29 Thread Karl DeBisschop
root wrote: > > When I execute from psql: > SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp; > > I get: > ?column? > -- > 23:00 > (1 row) > > Why april 2nd, 2000 don't last 1 day (or 24 hours) ? Because April 2nd was the beginning of d

Re: [BUGS] pg_dumpall's output not totally usable

2000-05-29 Thread Tom Lane
Olivier Jeannet <[EMAIL PROTECTED]> writes: > The problem is that the output of pg_dumpall doesn't totally work, and I > found that some statements are not in the proper order. So I edited the > output, made some cuts and pastes, and was able to successfully restore the > database. The few stateme

[BUGS] pg_dumpall's output not totally usable

2000-05-29 Thread Olivier Jeannet
Your name : Olivier Jeannet Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.13 ELF PostgreSQL version (