Good point. Added to TODO:
o Add -f to pg_dumpall
---
Florian Steinel wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2061
> Logged by: Florian Steinel
> Email address:
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---
Ma
It's interesting to note that *everyone* else using the JDBC driver
doesn't have this problem ?
Dave
On 23-Nov-05, at 2:44 PM, Kris Jurka wrote:
kalisetty manideep wrote:
[Backend reports "too many open connections"]
>
But I am 100% sure that its not the issue with the
code.
Do you know an
Hi Tom,
The problem is solved. I have reinstalled Postgres, and now pg_dump works
fine.
Best regards, and thanks for your help.
Wim
From: Tom Lane <[EMAIL PROTECTED]>
To: "Wim Audenaert" <[EMAIL PROTECTED]>
CC: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #2065: Problem with language
Hello
I have recently installed postgresql-8.0.4 on my
redhat linux 9 machine, the installation was
successfull.
Now whenever i start pgsql, i get the following
message:-
LOG: database was shut down at 2005-11-23 17:12:28 IST
LOG: checkpoint record is at
LOG: redo record is at .
L
Hello Tom,
It's failing on the pg_proc table. This table is not included in the
standard dump.
When I create a new database, this function (oid 17039 and used for utf8
translation) is not defined in the pg_proc table. I tried to create a new
database. The pg_proc table contains several funct
The following bug has been logged online:
Bug reference: 2068
Logged by: Vladimir
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.9 and 8.0.1
Operating system: SPARC Solaris 8
Description:Error compiled OS Solaris
Details:
I have OS Solaris
SunOS XXX 5.8 G
Harald Armin Massa wrote:
> Alvaro,
>
> > How many database-wide vacuums did you run during these 9 months? I'm
> > smelling transaction Id wraparound in pg_class or some other system
> > catalog.
>
> "database wide" vacuums have been very very seldom; I fear the only one was
> at initial db bul
Bruce Momjian writes:
> I see your issue with HH/HH24, but I wanted this to work:
> test=> select to_char('14 hours'::interval, 'HH');
>to_char
> -
>14
> (1 row)
> With the HH/HH24 change that is going to return 2. Do interval folks
> know they would ha
Tom Lane wrote:
> "Nick Addington" <[EMAIL PROTECTED]> writes:
> > The following code works in 8.0.4 but fails in 8.1.0:
> > select to_char('1:00 pm'::time,'HH:MM AM');
>
> I'm inclined to think that disallowing AM/PM for intervals was a mistake
> --- if we allow both HH and HH24 (which we do) the
Hayden James <[EMAIL PROTECTED]> writes:
> If I create a normal table and a normal view that queries that table I get
> incorrect results when I query the view using the AS alias in the select
> statement.
Turns out it depends on the plan used for the view, but in the
particular case you were exer
kalisetty manideep wrote:
[Backend reports "too many open connections"]
>
But I am 100% sure that its not the issue with the
code.
Do you know any Postgresql - JDBC driver, which is not
from Postgresql development group. I think JDBC driver
is not closing the connection even though I am closin
Hayden James <[EMAIL PROTECTED]> writes:
> then I do a SELECT col1 AS something FROM Test2; The column identifier
> comes back as "col1" instead of "something".
Hmm, we fixed a problem just like this last month ... seems we missed
some cases though ...
regards, tom lane
> Having blank lines in -f scripts was causing silent failures. This
> fixes it, for some value of "fixes." If it's OK, please apply to 8.1
> CURRENT and CVS TIP :)
Thanks. I have committed your patches to current and 8.1 stable.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
---(e
Alvaro,How many database-wide vacuums did you run during these 9 months? I'm
smelling transaction Id wraparound in pg_class or some other systemcatalog.This has been known to happen. Please see the archives."database wide" vacuums have been very very seldom; I fear the only one was at initial db
Harald Armin Massa wrote:
> Hello QuingQing,
>
> > What is your file system, NTFS or FAT32? Is that table newly created?
>
> File System is NTFS. That table was created with database installation,
> which was short after after release of PostgreSQL 8.0 - so that database was
> in use for > 9 mont
Hello QuingQing,What is your file system, NTFS or FAT32? Is that table newly created?
File System is NTFS. That table was created with database installation, which was short after after release of PostgreSQL 8.0 - so that database was in use for > 9 months. That table is a central table of the appl
On Wed, 23 Nov 2005, Harald Armin Massa wrote:
>
> no, it is definitely NOT a temp table. I know which table it is,
> because: that "could not open relation ..." error message was exactly
> provokable with "select * from repofeld", which is one of my tables in
> that database.
>
What is your file
18 matches
Mail list logo