[BUGS] Inconsistent description of "postmaster.opts"

2005-10-27 Thread Qingqing Zhou
--- Sample output --- $/bin/data#more postmaster.opts */bin/postgres -D data $/bin/data#cd .. $/bin#pg_ctl -Ddata start postmaster starting $/bin#LOG: database system was shut down at 2005-10-27 03:17:17 EDT LOG: checkpoint record is at 0/33AE4C LOG: redo record is at 0/33AE4C; undo record is at

Re: [BUGS] Inconsistent description of "postmaster.opts"

2005-10-27 Thread Tom Lane
"Qingqing Zhou" <[EMAIL PROTECTED]> writes: > --- PG manual --- > http://www.postgresql.org/docs/8.0/static/storage.html > postmaster.opts | A file recording the command-line options the postmaster > was last started with > So two inconsistences: > (1) not necessarily postmaster; > (2) if I sta

Re: [BUGS] Index name different from constraint name

2005-10-27 Thread Bruce Momjian
Added to TODO: o Have ALTER INDEX update the name of a constraint using that index o Allow ALTER TABLE RENAME CONSTRAINT --- Tom Lane wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > * Tom Lane ([EMAI

Re: [BUGS] Index name different from constraint name

2005-10-27 Thread Stephen Frost
* Bruce Momjian (pgman@candle.pha.pa.us) wrote: > Added to TODO: > > o Have ALTER INDEX update the name of a constraint using that index > o Allow ALTER TABLE RENAME CONSTRAINT More like: Add ALTER TABLE RENAME CONSTRAINT; implicitly rename linked indexes also Is there much depen

Re: [BUGS] Index name different from constraint name

2005-10-27 Thread Bruce Momjian
OK, updated. --- Stephen Frost wrote: -- Start of PGP signed section. > * Bruce Momjian (pgman@candle.pha.pa.us) wrote: > > Added to TODO: > > > > o Have ALTER INDEX update the name of a constraint using that index

Re: [BUGS] BUG #2000: psql does not prompt for password

2005-10-27 Thread Bruce Momjian
Todd wrote: > > The following bug has been logged online: > > Bug reference: 2000 > Logged by: Todd > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 Beta 4 > Operating system: Windows Xp home > Description:psql does not prompt for password > Details: > >

[BUGS] BUG #2002: shows version wronly

2005-10-27 Thread manikandan
The following bug has been logged online: Bug reference: 2002 Logged by: manikandan Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: linux Description:shows version wronly Details: if i am trying to connect psql as a client it's shows the

Re: [BUGS] BUG #2001: Signal 11 after concurrent inserts + updates

2005-10-27 Thread Telin Lin
I have several directories such as 1, 17229, 17230, 333909 under base. but none of them is generated during crash time. Under thsoe directories, there are a bunch of files with (number) filename. Some of them are over size of 6M. I guess i will set the max_stack_depth in postgres.con

[BUGS] BUG #2003: Bug with SQL UPDATE on a NUMERIC

2005-10-27 Thread David Pujol
The following bug has been logged online: Bug reference: 2003 Logged by: David Pujol Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 and 7.4 Operating system: Windows and linux Description:Bug with SQL UPDATE on a NUMERIC Details: Hello, I've noticed a bug

Re: [BUGS] BUG #2001: Signal 11 after concurrent inserts + updates

2005-10-27 Thread Telin Lin
No, haven't done any memory tests lately. Let me get that going. I am doing pg_dump nightly with the whole database including this table. so i guess that says it. I couldn't find any core dump. btw, the core dump filename should be just like 'coredump', right? Let me also get the max_sta

Re: [BUGS] BUG #2002: shows version wronly

2005-10-27 Thread Bruce Momjian
manikandan wrote: > > The following bug has been logged online: > > Bug reference: 2002 > Logged by: manikandan > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.3.2 > Operating system: linux > Description:shows version wronly > Details: > > if i am trying

[BUGS] pg_dump bud with functions

2005-10-27 Thread Ivan
Hello, PostgreSQL 8.0.x, 8.1beta3, WinXP Pro SP2 When I create a function in sql or plpgsql languages, their body text is stored in the database files with 0D 0A line ends (I checked it in a hex editor). If I create plain backup using pg_dump it generates functions with 0D 0D 0A on the end of th

Re: [BUGS] pg_dump bud with functions

2005-10-27 Thread Tom Lane
Ivan <[EMAIL PROTECTED]> writes: > When I create a function in sql or plpgsql languages, > their body text is stored in the database files with > 0D 0A line ends (I checked it in a hex editor). > If I create plain backup using pg_dump > it generates functions with > 0D 0D 0A on the end of the body

Re: [BUGS] BUG #2003: Bug with SQL UPDATE on a NUMERIC

2005-10-27 Thread Stephan Szabo
On Thu, 27 Oct 2005, David Pujol wrote: > Hello, I've noticed a bug when I modify a quantity with an INSERT and a > minus operator. > My request is: > UPDATE products SET pr_stock=pr_stock--1 WHERE pr_code=600; > > I haven't SQL error but 'pr_stock' value (numeric(5,1)) is unchanged : no > increme

Re: [BUGS] pg_dump bud with functions

2005-10-27 Thread Ivan
Hello, Thursday, October 27, 2005, 6:34:36 PM, you wrote: TL> Ivan <[EMAIL PROTECTED]> writes: >> When I create a function in sql or plpgsql languages, >> their body text is stored in the database files with >> 0D 0A line ends (I checked it in a hex editor). >> If I create plain backup using pg_

Re: [BUGS] BUG #2001: Signal 11 after concurrent inserts + updates

2005-10-27 Thread Michael Fuhr
[Please copy the mailing list on replies.] On Thu, Oct 27, 2005 at 10:54:51AM -0400, Telin Lin wrote: > I have just got a 17M coredump. Do you have a preferred way for me to > sent that to you? I can always place it on a ftp site for you > download. Thank you. Please post the stack trace fro