--- 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
"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
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
* 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
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
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:
>
>
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
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
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
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
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
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
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
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
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_
[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
16 matches
Mail list logo