Re: [BUGS] BUG in pg_autovacuum - with patch

2005-04-02 Thread Matthew T. O'Connor
Karl Denninger wrote: I have a process which does backups by mounting a disk into a RAID array, allowing it to sync, then it must stop the database before detaching it so as to insure that the DBMS is consistent on the backup disk. Once detached, Postgres must be restarted, of course.. This pro

Re: [BUGS] BUG in pg_autovacuum - with patch

2005-04-02 Thread Karl Denninger
On Sat, Apr 02, 2005 at 12:16:00PM -0500, Matthew T. O'Connor wrote: > Karl Denninger wrote: > > >I have a process which does backups by mounting a disk into a RAID array, > >allowing it to sync, then it must stop the database before detaching it so > >as to insure that the DBMS is consistent on t

[BUGS] On line manual pages need easy access to TOC

2005-04-02 Thread Karl O. Pinc
Hi, It's a real pain to have to go to the bottom of the on-line manual pages to get back to the table of contents (I seem to want to do this all the time.) A link at the top would be nice. You could either add a "Home" link like at the bottom, or simply make the manual version number hot. Regards

[BUGS] BUG #1575: plpgsql

2005-04-02 Thread rajkumar
The following bug has been logged online: Bug reference: 1575 Logged by: rajkumar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux and windows Description:plpgsql Details: hello, we have a postgres in windows and linux operating sy

[BUGS] BUG #1576: Function UPPER does not give back the awaited results

2005-04-02 Thread Sergio Luis Sánchez
The following bug has been logged online: Bug reference: 1576 Logged by: Sergio Luis Sánchez Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 and 8.0.1 Operating system: linux (7.4.3) and WinXP (8.0.1) Description:Function UPPER does not give back the awaite

[BUGS] windows installation

2005-04-02 Thread raymond
hi. this is not really an installation issue, but i read the instruction atop of the list, so here we are. ok. i succesfully installed postgresql 8 on my windows xp sp2 machine, few weeks ago. i am a newbie to sql generally, as well as to postrges i configured my server to run on localhost, every

[BUGS] BUG #1574: plpgsql

2005-04-02 Thread rajkumar
The following bug has been logged online: Bug reference: 1574 Logged by: rajkumar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux and windows Description:plpgsql Details: hello, we have a postgres in windows and linux operating sy

[BUGS] Help

2005-04-02 Thread Dinesh Pandey
Hi,   I have installed PostgreSQL 8.0.1 on Solaris 9.   I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language.   In Oracle we can get error message from "SQLERRM" keyword and inserting it into table.   How can I get error message/code in PostgreSQL after an E

[BUGS] BUG #1570: Double quotes in all field/table names must be optional!

2005-04-02 Thread Christopher Brian Jurado
The following bug has been logged online: Bug reference: 1570 Logged by: Christopher Brian Jurado Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:Double quotes in all field/table names must be optional! Details: Th

[BUGS] FW: Help

2005-04-02 Thread Dinesh Pandey
  From: Dinesh Pandey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 2:45 PMTo: pgsql-bugs@postgresql.orgSubject: HelpImportance: High Hi,   I have installed PostgreSQL 8.0.1 on Solaris 9.   I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language.  

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-04-02 Thread Olivier Thauvin
Le Tuesday 29 March 2005 00:40, vous avez écrit : > The typical way to do this is to use .pgpass in the user's home > directory. Does that help? Yes it help, but: - please notice the issue about ps into the README - the .pgpass doesn't work on my configuration: [EMAIL PROTECTED] pgsql]$ pg_autov

[BUGS] BUG #1573: plpgsql

2005-04-02 Thread rajkumar
The following bug has been logged online: Bug reference: 1573 Logged by: rajkumar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux and windows Description:plpgsql Details: hello, we have a postgres in windows and linux operating sy

[BUGS] BUG #1572: plpgsql in linux os

2005-04-02 Thread rajkumar
The following bug has been logged online: Bug reference: 1572 Logged by: rajkumar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux Description:plpgsql in linux os Details: hello, we have a postgres in windows and linux operating s

[BUGS] BUG #1569: Threads don't see ecpg default connection

2005-04-02 Thread Gavin Scott
The following bug has been logged online: Bug reference: 1569 Logged by: Gavin Scott Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Fedora Core 3 Description:Threads don't see ecpg default connection Details: When using postgresql 8.0 c

[BUGS] error pgsql

2005-04-02 Thread endang darusman
can u'll help me ? i use debian woody 3 in debian install postgresql can't find zlib how to activity zlib on debian ? and on debian can't use gmake i always use make and make install and pgsql can't running thank's all ---(end of broadcast)

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-02 Thread John Smith
I re-installed postgresql as a service and CREATE TYPE AS works. So I then re-installed postgresql as a program (as I had originally done) and CREATE TYPE AS doesn't work. Perhaps you could check this on your system. John Smith -- From: Michael

[BUGS] BUG #1568: concat

2005-04-02 Thread helman
The following bug has been logged online: Bug reference: 1568 Logged by: helman Email address: 123@123.com PostgreSQL version: 8.0 Operating system: linux Description:concat Details: concat no accept null ---(end of broadcast)---

[BUGS] plpgsql

2005-04-02 Thread raj kumar
hello,we have a postgres in windows and linux operating systems, then the problemis in plpgsql functions, which is i created a function with exceptionhandling in postgres 8.0.1 (windows operating system) which handle theexceptions very well, but i created the same function in (postgres8.0.1)linux o

Re: [BUGS] BUG #1558: memory leak in libpq connectDBStart()

2005-04-02 Thread Cade Cairns
I will post a patch in a few days. I am extremely busy and don't have adequate time. I apologize for not having posted more in the first place. On 27-Mar-05, at 1:12 AM, Tom Lane wrote: "Cade Cairns" <[EMAIL PROTECTED]> writes: The leak occurs when libpq can not establish a connection to the da

Re: [BUGS] BUG in pg_autovacuum - with patch

2005-04-02 Thread Tom Lane
Karl Denninger <[EMAIL PROTECTED]> writes: > On Sat, Apr 02, 2005 at 12:16:00PM -0500, Matthew T. O'Connor wrote: >> Anyway, if pg_autovacuum is causing problems for cron I'm sure we would >> still benefit from this patch. However, while I claim no expertise >> related to detaching from the cons

Re: [BUGS] BUG #1568: concat

2005-04-02 Thread Bruce Momjian
helman wrote: > > The following bug has been logged online: > > Bug reference: 1568 > Logged by: helman > Email address: 123@123.com > PostgreSQL version: 8.0 > Operating system: linux > Description:concat > Details: > > concat no accept null Concatting a NULL retu

Re: [BUGS] BUG #1570: Double quotes in all field/table names must be

2005-04-02 Thread Bruce Momjian
Christopher Brian Jurado wrote: > > The following bug has been logged online: > > Bug reference: 1570 > Logged by: Christopher Brian Jurado > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: Windows 2000 > Description:Double quotes in all

Re: [BUGS] BUG #1572: plpgsql in linux os

2005-04-02 Thread Bruce Momjian
rajkumar wrote: > > The following bug has been logged online: > > Bug reference: 1572 > Logged by: rajkumar > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.1 > Operating system: linux > Description:plpgsql in linux os > Details: > > hello, > > we have

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-02 Thread Michael Fuhr
On Mon, Mar 28, 2005 at 12:51:42AM +, John Smith wrote: > I re-installed postgresql as a service and CREATE TYPE AS works. So I then > re-installed postgresql as a program (as I had originally done) and CREATE > TYPE AS doesn't work. > Perhaps you could check this on your system. Can't help