Re: [BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by RPM

2005-10-24 Thread Bruce Momjian
Mark Gibson wrote: > > The following bug has been logged online: > > Bug reference: 1970 > Logged by: Mark Gibson > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.4 > Operating system: Redhat Enterprise Linux 4 > Description:Existing /etc/pam.d/postgresql

Re: [BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by

2005-10-24 Thread Devrim GUNDUZ
Hi, On Mon, 24 Oct 2005, Bruce Momjian wrote: Please report this to the RPM maintainer. We do not create the RPMs. I thought we do? Our RPMs are marked as PGDG RPMs... -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gun

[BUGS] access postgresql from GTK+ GUI

2005-10-24 Thread somesh
Hi, Somesh here from Aerospace Systems Pvt Ltd., I am facing some problem in accessing postgresql database in GTK GUI with Linux environment. Please can u guide me how to set path for GTK and PostgreSQL to insert and retrive data from the database, and what are the settings i have to do for th

[BUGS] BUG #1992: ODBC error with PostgreSQL Win32 Clients

2005-10-24 Thread Paul Anderson
The following bug has been logged online: Bug reference: 1992 Logged by: Paul Anderson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Microsoft Windows XP Professional version 5.1.2600 Service Pack 1 Build 2600 Description:ODBC error with

[BUGS] BUG #1995: problem in createuser's french traduction

2005-10-24 Thread Jean-Claude Caty
The following bug has been logged online: Bug reference: 1995 Logged by: Jean-Claude Caty Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: linux debian unstable Description:problem in createuser's french traduction Details: while creating

[BUGS] BUG #1993: Adding/subtracting negative time intervals changes time zone of result

2005-10-24 Thread Nicholas
The following bug has been logged online: Bug reference: 1993 Logged by: Nicholas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3,8.0.4,8.1 Operating system: Gentoo Linux Description:Adding/subtracting negative time intervals changes time zone of result Det

Re: [BUGS] BUG #1988: keygen not implemented

2005-10-24 Thread Mike Clements
Thanks for the info. I found a workaround by selecting the current value of the sequence after doing the insert. This however is not desirable since it requires another round trip call to the DB, and it requires PostGRE SQL specific code in my "generic" JDBC client. If the driver supported getG

[BUGS] BUG #1990: Installer bug fails to make C:\program files..global

2005-10-24 Thread Gregory Bronner
The following bug has been logged online: Bug reference: 1990 Logged by: Gregory Bronner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Win2k professional Description:Installer bug fails to make C:\program files..global Details: The fil

[BUGS] BUG #1991: UPPER problem on special characters

2005-10-24 Thread Guillaume Smet
The following bug has been logged online: Bug reference: 1991 Logged by: Guillaume Smet Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1b3 Operating system: RHEL 3 Description:UPPER problem on special characters Details: Hi, I'm currently testing 8.1b3 to p

Re: [BUGS] BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz

2005-10-24 Thread Jari Aalto
| > > This ONE BIG file will help loading it off-line to a web=20 | > browser (or=20 | > > editor *.txt), and to make quick searches on backward and forward. | >=20 | > This wouldn't be hard to implement. Are others interested in this? | | The original bug talked about Windows - I'd just like to

[BUGS] BUG #1994: Ignore the last bug report; this is a confusing time zone feature, not a bug

2005-10-24 Thread Nicholas
The following bug has been logged online: Bug reference: 1994 Logged by: Nicholas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3,8.0.4,8.1 Operating system: Gentoo Linux Description:Ignore the last bug report; this is a confusing time zone feature, not a b

Re: [BUGS] BUG #1990: Installer bug fails to make C:\program files..global

2005-10-24 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1990 > Logged by: Gregory Bronner > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.4 > Operating system: Win2k professional > Description:Installer bug fails to make C:\program > files..global

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Russell Smith
Nicholas wrote: The following bug has been logged online: Bug reference: 1993 Logged by: Nicholas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3,8.0.4,8.1 Operating system: Gentoo Linux Description:Adding/subtracting negative time intervals changes time z

Re: [BUGS] BUG #1985: cannot insert Chinese character into a table encoded

2005-10-24 Thread Bruce Momjian
Jeff Tong wrote: > > The following bug has been logged online: > > Bug reference: 1985 > Logged by: Jeff Tong > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1beta3 > Operating system: Windows XP > Description:cannot insert Chinese character into a table en

[BUGS] BUG #1996: DISTINCT fails with national character varying

2005-10-24 Thread Ludmil Tinkov
The following bug has been logged online: Bug reference: 1996 Logged by: Ludmil Tinkov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: RedHat 9.0 Description:DISTINCT fails with national character varying Details: create table depression

Re: [BUGS] BUG #1996: DISTINCT fails with national character varying

2005-10-24 Thread Tom Lane
"Ludmil Tinkov" <[EMAIL PROTECTED]> writes: > select distinct name from depression > --the last statement returns only a single row > --namely: Ана > --it should return 4 rows! This has been seen to happen when you select a database encoding that does not match the encoding expected by the pos

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Klint Gore
On Tue, 25 Oct 2005 08:51:59 +1000, Russell Smith <[EMAIL PROTECTED]> wrote: > Nicholas wrote: > > postgres=# SELECT NOW()-interval '1 week'; > >?column? > > --- > > 2005-10-17 08:52:37.355219+10 > > (1 row) > > > > postgres=# SELECT NOW()-interval '-1 week

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: > That's changed since v7.4.7 Yup. '1 week' = '7 days' which is no longer the same as 7*24 hours. In particular, as of 8.1 local noon plus one day is still local noon, even if there was a DST change in between. Adding 24 hours, on the other hand, might give

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Michael Fuhr
On Tue, Oct 25, 2005 at 12:48:10PM +1000, Klint Gore wrote: > On Tue, 25 Oct 2005 08:51:59 +1000, Russell Smith <[EMAIL PROTECTED]> wrote: > > Looks to mee like Daylight Savings has conveniently started. > > But the elapsed time for those results is only 6 days, 23 hours. > > That's changed since

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Michael Fuhr
On Mon, Oct 24, 2005 at 11:21:52PM -0400, Tom Lane wrote: > Klint Gore <[EMAIL PROTECTED]> writes: > > That's changed since v7.4.7 > > Yup. '1 week' = '7 days' which is no longer the same as 7*24 hours. > In particular, as of 8.1 local noon plus one day is still local noon, > even if there was a

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > Should 24 hours be the same as 1 * 24 hours? Yes, I would think so. > The latter appears to be equal to 1 day, not 24 hours: Urgh. I think this is a serious thinko in Michael Glaesemann's rewrite of interval_mul. The application of interval_justify_ho

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Bruce Momjian
Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > Should 24 hours be the same as 1 * 24 hours? > > Yes, I would think so. > > > The latter appears to be equal to 1 day, not 24 hours: > > Urgh. I think this is a serious thinko in Michael Glaesemann's rewrite > of interval_mul. The

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-24 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> Urgh. I think this is a serious thinko in Michael Glaesemann's rewrite >> of interval_mul. > The reason interval_justify_hours is called by interval multiplication > is so multipling an interval '2 days, 4 hours' by 10 doesn't return > values like 20 da

Re: [BUGS] BUG #1943: Lock A row with the option NoWait

2005-10-24 Thread Bruno Wolff III
On Thu, Oct 06, 2005 at 17:42:25 +0100, Mathias Laurent <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1943 > Logged by: Mathias Laurent > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: windows > D