[BUGS] Re: Error in Constraint Checks with PGSQL 7.03

2001-01-10 Thread Justin Clift
Sorry, I somehow missed including the exact error message I get when inserting : Bad (null) varchar() external representation Regards and best wishes, Justin Clift Database Administrator [EMAIL PROTECTED] wrote: > > Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2

[BUGS] Oops... sorry about that

2001-02-28 Thread Justin Clift
Sorry, forgot to put the -request on the end of the username in the email address. + Justin Clift

[BUGS] Irony bug

2001-03-06 Thread Justin Clift
Hi all, There's a spelling mistake on the users-lounge part of the PostgreSQL website... "pgsql-bugs If you find bug, fill " should be : "pgsql-bugs If you find a bug, fill " Yes, it's small. But's it's kind of funny when you think about it. :-) + Justin ---(en

[BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8 INTEL

2001-03-13 Thread Justin Clift
array isbn_issn lo mSQL-interface mac miscutil noupdate oid2name pg_dumplo pg_logger pgbench pgcrypto rserv seg soundex spi string tips unixdate userlock vacuumlo; do \ if [ -e $dir/Makefile ]; then \ make -C $dir clean; \ fi; \ done /bin/sh: test: argument expected make[1]:

Re: [BUGS] Tests randomly failed

2001-03-22 Thread Justin Clift
ange the amount of shared memory segments and semaphores. Whenever I have those problems, I insert the updated (higher) values for shared memory and semaphores, reboot the system, then the tests pass as the backend is able to start fine. Hope this is helpful. Regards and best wishes, Justin Clift

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8 INTEL

2001-03-25 Thread Justin Clift
them know that something may be wrong? They're up to beta2 of their next release so now's probably the time to work things out. Regards and best wishes, Justin Clift Tom Lane wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Justin Clift writes: >

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-25 Thread Justin Clift
ng this now to their developer list) and also work around the problem ourselves? Regards and best wishes, + Justin Clift Peter Eisentraut wrote: > > Justin Clift writes: > > > When --with-openssl= is given to configure > > on Solaris 8 INTEL, the compilation errors in : >

Re: [BUGS] Odd 'except' and 'default' interaction behavior

2001-03-25 Thread Justin Clift
Can you tell me more about this strange behaviour? If it's appropriate, I'll try to get it onto the techdocs website. Regards and best wishes, Justin Clift Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > We noticed a strange behavior involving 'except' an

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-25 Thread Justin Clift
That sounds like The Right Way of doing it; most responsible, technically sound, etc. Regards and best wishes, Justin Clift Larry Rosenman wrote: > I suspect renaming it would be the best way, since we have 2 major > (SUN, SCO) vendors claiming a des_encrypt() function in their li

Re: [BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-06 Thread Justin Clift
Hi Jay, Which OS are you using? Mandrake-Linux 7.2 is known to have bugs in the version of PostgreSQL they supply as RPM's. Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: > > Jay Guerette ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the n

Re: [BUGS] incompatible return type for netmask(inet) function between 7.0.3 and 7.1

2001-04-24 Thread Justin Clift
is was fixed in 7.1. i.e. '192.168.1.1' Depending on how you're doing things, you *might* be able to wrap stuff in a btrim() function for 7.0.x. i.e. btrim() should return '192.168.1.1' Well, you get the idea. Might be a start of a workaround for you anyway. Regard

Re: [BUGS] debug_level 0 does not stop debug messages

2001-04-30 Thread Justin Clift
e. Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: > > JP ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > debug_level 0 does not stop debug messages > > Long Description >

Re: [BUGS] Postmaster 7.1.2 hanging

2001-07-06 Thread Justin Clift
ger to the postmaster process as you've suggested and see what it thinks is going on. :-) Regards and best wishes, Justin Clift Tom Lane wrote: > > Justin Clift <[EMAIL PROTECTED]> writes: > > Just did a : > > pg_ctl stop -m fast > > And the postmaster process won&

Re: [BUGS] Bug #434: Maximun number of connections

2001-08-30 Thread Justin Clift
her than 32, then restart PostgreSQL. This value can also be altered at compile time to whatever you want (32 is the default here and thats what gets passed to the postgresql.conf file). Hope this helps. Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: > > Sergio Muscat ([EMAIL

[BUGS] WAL Log numbering

2001-09-17 Thread Justin Clift
the numbers should be sequential. Just checked the archives and didn't find anything regarding this. Bug or not? Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to tr

Re: [BUGS] WAL Log numbering

2001-09-18 Thread Justin Clift
Tom Lane wrote: > > Justin Clift <[EMAIL PROTECTED]> writes: > > I would have though that after 00FE would be > > 0100, not 0001. > > > Just checked through the Interactive docs (not sure which version of 7.1 > > t

Re: [BUGS] Website, mailing list

2001-09-19 Thread Justin Clift
rner site" which Vince created. Looks pretty nice, new color scheme, better layout, etc. People get to it when clicking on "Developer's Corner" from the main PostgreSQL site. :) Regards and best wishes, Justin Clift > > reg

Re: [BUGS] WAL Log numbering

2001-09-22 Thread Justin Clift
e. Regards and best wishes, Justin Clift > > > Justin Clift <[EMAIL PROTECTED]> writes: > > > I would have though that after 00FE would be > > > 0100, not 0001. > > > > This is the intended behavior, I believe. The

Re: [BUGS] Bug #466: Unable to remove /root/tmp/initdb:xxxx.xxx

2001-09-22 Thread Justin Clift
installed already about 4 prior versions of PostgreSQL, every time working this >same way and never had this problem, every time working on some Mandrake distribution. I strongly feel you already had/have some kind of PostgreSQL installation on your system, and I would point the finger

[BUGS] Clustering error with present CVS

2001-09-22 Thread Justin Clift
and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ---

[BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Justin Clift
server has kept the number of packages on this server to a minimum, so it's possible some needed program is missing. Does anyone have any ideas? Please bear in mind that everything compiles fine without the -DUSE_AUSTRALIAN_FLAGS option. Haven't tried current CVS, but it's an intere

Re: [BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Justin Clift
Hi Bruce, There is ZERO possibility of using 7.2betaX on this server. It's a critical production machine and requirements are such that it's been migrated to RedHat 7.1. Is there no way to get this working? Regards and best wishes, Justin Clift Bruce Momjian wrote: > > Ple

Re: [BUGS] Trying Cygwin version of PostgreSQL

2002-02-21 Thread Justin Clift
Hi Paul, You might like to try the very good installation guide for PostgreSQL on Windows at : http://www.ejip.net/faq/postgresql_win_setup_faq.jsp Added a link to it from the techdocs.postgresql.org website earlier today too. :-) Regards and best wishes, Justin Clift On Thursday 21

Re: [BUGS] Trying Cygwin version of PostgreSQL again

2002-02-21 Thread Justin Clift
Peter wrote: > > Justin Clift suggested: > http://www.ejip.net/faq/postgresql_win_setup_faq.jsp > I started from scratch following the page and adapting it where it is > out of date. I reached the stage of starting postmaster and receiving > the message: > DEBUG: pq_recvb

Re: [BUGS] Postgres with IBM ????????

2002-07-11 Thread Justin Clift
Hi Prison, I've created Web Sphere packages for Solaria 8, and had to install Web Sphere numerous times in the process of getting it right (learning curve thing). For getting Web Sphere to work with PostgreSQL... it doesn't work right out of the box. When you install Web Sphere 4.0x (not sure a

Re: [BUGS] Pg_dump uses up RAM and swap space

2002-11-28 Thread Justin Clift
entire PostgreSQL $PGDATA directory (*with PostgreSQL not running!*). That way, if anything does go wrong, you can always copy this backup into place and um.. try again (but differently of course). :-) Regards and best wishes, Justin Clift > If this is the way to go, please > confirm th

Re: [BUGS] Bug #874: Install pgsql on solaris 8 error

2003-01-14 Thread Justin Clift
Hi Yuxia, Which version of PostgreSQL is this with, and did you compile PostgreSQL yourself? Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: yuxia ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Install

Re: [BUGS] Buggy timestamp generation code in PG 7.4.5 on FreeBSD

2004-10-11 Thread Justin Clift
Tom Lane wrote: I believe there are known problems with BSD kernels sometimes returning wrong clock readings on SMP machines, so that might be a place to look too. Thanks Tom. Just filled out a FreeBSD Bug Report, so we'll see how that goes. :) Regards and best wishes, Justin Clift re

[BUGS] [Fwd: Re: misc/72498: Libc timestamp code on jailed SMP machine generates incorrect results]

2004-10-12 Thread Justin Clift
pool" of it as made available on the host system, but have been under the impression PostgreSQL is coded to not corrupt in this kind of situation. Regards and best wishes, Justin Clift Original Message Subject: Re: misc/72498: Libc timestamp code on jailed SMP machine g

[BUGS] [Fwd: Re: misc/72498: Libc timestamp code on jailed SMP machine generates incorrect results]

2004-10-18 Thread Justin Clift
Hi all, Does anyone have further input on this? Regards and best wishes, Justin Clift Justin Clift wrote: Subject: [Fwd: Re: misc/72498: Libc timestamp code on jailed SMP machine generates incorrect results] From: Justin

Re: [pgsql-www] [BUGS] tsearch2 headline function fails to parse

2005-01-13 Thread Justin Clift
few seconds to load than I was expecting (about 10 seconds in total), but didn't time out. If we get more reports of this, indicating its a continuing problem, then we'll look into it. Otherwise, hopefully the failure was just a once-off. Thanks for letting us know guys. Regard

[BUGS] BUG #1377: Testing the bug submission form

2005-01-13 Thread Justin Clift
The following bug has been logged online: Bug reference: 1377 Logged by: Justin Clift Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Various Description:Testing the bug submission form Details: Tom forwarded an email saying the bug