Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

2005-10-11 Thread Jean-Pierre Pelletier
The antivirus is CA eTrust EZ v 7.0.6.7. I cannot put back the antivirus on that server because it is now in production mode. Jean-Pierre Pelletier - Original Message - From: "Qingqing Zhou" <[EMAIL PROTECTED]> To: Sent: Friday, October 07, 2005 3:08 PM Subject: Re: [BUGS] Possibly c

[BUGS] BUG #1955: trigger action on delete

2005-10-11 Thread incheol yang
The following bug has been logged online: Bug reference: 1955 Logged by: incheol yang Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: fedora core 4 Description:trigger action on delete Details: kernel : version 2.6.13-1.1526_FC4 CPU:

Re: [BUGS] BUG #1955: trigger action on delete

2005-10-11 Thread Tom Lane
"incheol yang" <[EMAIL PROTECTED]> writes: > => DELETE FROM ttest; > INFO: trigf (fired before): there are 2 rows in ttest INFO: trigf (fired > before): there are 1 rows in ttest INFO: trigf (fired after ): there are 0 > rows in ttest INFO: trigf (fired after ): there are 0 rows in ttest > fired

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-11 Thread Bruce Momjian
Klint Gore wrote: > On Mon, 10 Oct 2005 23:45:03 -0400 (EDT), Bruce Momjian > wrote: > > Oracle has a tendency to keep things around forever, which is nice, but > > over the years it produces a system with lots of strange features that > > make the system hard to use. PostgreSQL has a tendency t

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-11 Thread Tom Lane
Bruce Momjian writes: >> Where does textcat fit into things? > textcat is the internal function mapped to ||. It isn't documented > anywhere for general use. It does show up in psql \df though. I > suppose the bug reporter could use that, but it isn't portable to other > database systems. tex

[BUGS] BUG #1953: trigger action on delete

2005-10-11 Thread incheol yang
The following bug has been logged online: Bug reference: 1953 Logged by: incheol yang Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: fedora core 4 Description:trigger action on delete Details: kernel version 2.6.13-1.1526_FC4 CPU AMD A

[BUGS] BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')

2005-10-11 Thread Antonio Molina
The following bug has been logged online: Bug reference: 1954 Logged by: Antonio Molina Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: Linux Description:Bug in to_date('09-10-2005', 'dd-mm-') Details: We did have a error using TO_DATE

[BUGS] .pgpass does not work for createlang

2005-10-11 Thread John Shin
It seems that for v8.0.4 the createlang will not take .pgpass inputs and always prompts for password.  Is this broken for the new version?  Well, now I have to type in the password for my database script.   -bash-3.00$ createdb test -h localhost -U postgres CREATE DATABASE -bash-3.00$ c

[BUGS] BUG #1952: Doc 32.4 example

2005-10-11 Thread incheol yang
The following bug has been logged online: Bug reference: 1952 Logged by: incheol yang Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3, 8.0.4 Operating system: linux Description:Doc 32.4 example Details: You said like this => DELETE FROM ttest; INFO: tr

[BUGS] BUG #1951: Multiple instances of postgres.exe running

2005-10-11 Thread Terry Leffler
The following bug has been logged online: Bug reference: 1951 Logged by: Terry Leffler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.04 Operating system: windows 2000 Description:Multiple instances of postgres.exe running Details: Hi, I have seen multiple

Re: [BUGS] BUG #1951: Multiple instances of postgres.exe running

2005-10-11 Thread Magnus Hagander
> Bug reference: 1951 > Logged by: Terry Leffler > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.04 > Operating system: windows 2000 > Description:Multiple instances of postgres.exe running > Details: > > Hi, > > I have seen multiple instances of postgres

Re: [BUGS] BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')

2005-10-11 Thread Richard Huxton
Antonio Molina wrote: The following bug has been logged online: Bug reference: 1954 Logged by: Antonio Molina Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: Linux Description:Bug in to_date('09-10-2005', 'dd-mm-') Details: We did ha

Re: [BUGS] .pgpass does not work for createlang

2005-10-11 Thread Michael Fuhr
On Mon, Oct 10, 2005 at 06:25:59PM -0700, John Shin wrote: > It seems that for v8.0.4 the createlang will not take .pgpass inputs and > always prompts for password. Is this broken for the new version? Well, > now I have to type in the password for my database script. > > -bash-3.00$ createdb tes

[BUGS] My investigations of the postmaster Bus error

2005-10-11 Thread Martin Pitt
Hi PostgreSQL developers! There have already been some reports about the mysterious Bus error that postmaster dies with on some architectures. Since that bites pretty hard, I did some investigations and tests on various architectures with various configurations. As background, Debian currently bu

Re: [BUGS] .pgpass does not work for createlang

2005-10-11 Thread Michael Fuhr
[Please copy the mailing list on replies so others can participate in and learn from the discussion.] On Tue, Oct 11, 2005 at 11:16:40AM -0700, John Shin wrote: > Tried many diffent ways but nothing seems to stick for createlang. > .pgpass works for all others (createdb, dropdb, createuser, dropus

Re: [BUGS] .pgpass does not work for createlang

2005-10-11 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Tue, Oct 11, 2005 at 11:16:40AM -0700, John Shin wrote: >> Tried many diffent ways but nothing seems to stick for createlang. >> .pgpass works for all others (createdb, dropdb, createuser, dropuser, >> etc.) >> -bash-3.00$ createdb test -h localhost -U

Re: [BUGS] My investigations of the postmaster Bus error

2005-10-11 Thread Jim C. Nasby
gerbil started failing with bus errors some time ago. We were finally able to 'fix it' by clearing out the CVS checkout, but the first failure could have been legitimate. See http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=gerbil&dt=2005-08-26%2009:18:41 Hope this helps... On Tue, Oct 11, 2005 at 0