Hello,
maybe some known issues regarding subj. in version 7.4.5? I have a web
application which is gathering date from postgre DB. And with a bach of
row the problem starts appearing. As i have mentioned it's happening appriximately
once a day. Everything's ok in v7.4.2. My DB is indexed.
Thanks
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> IMHO vacuumdb and vacuumlo should disable statement_timeout before vacuuming
> the database.
IMHO this request suggests that you are not setting statement_timeout in
sane places. One reasonable setup is to attach it to userids other than
the o
PostgreSQL Bugs List wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1302
> Logged by: Alex Koh
>
> Email address: [EMAIL PROTECTED]
>
> PostgreSQL version: 7.3.2
>
> Operating system: Linux Redhat 8
>
> Description:Vacuumdb and vacuumlo sh
The following bug has been logged online:
Bug reference: 1302
Logged by: Alex Koh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.2
Operating system: Linux Redhat 8
Description:Vacuumdb and vacuumlo should disable statement_timeout
Details:
IMHO vacuum
Tom,
> Please. Also, what nondefault configuration or postgresql.conf settings
> are you using?
Sorry for delay. Attached.
And --with-perl --with-odbc
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
gentoobug.gz
Description: GNU Zip compressed data
--
Andrea D. wrote:
Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community.
I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases to a
file in plain text form and then trend to restore using 'psql -f'.
But there was an error: a function needed in a constraint of a ta
On Sun, Oct 31, 2004 at 03:37:26PM +, Ralph Heinkel wrote:
>
> I think this is a bug (I hope not a feature).
It's a feature.
> For each insert into table 'tmp' the serial counter is increased
> twice, once to create the entry in 'tmp', once for 'log'. The problem
> is that the rule does not
Ralph Heinkel wrote:
Hi,
I think this is a bug (I hope not a feature).
Description:
The table 'tmp' gets records added, and uses a serial to fill
the attribute 'strorage_id'. The table has a rule which logs
all inserts into the table 'log'.
Problem:
For
Hi,
I just got the following on 7.4:
oocms=# delete from objects where object_id = 3993;
ERROR: update or delete on "objects" violates foreign key constraint "$1" on
"object_as_xml"
DETAIL: Key (object_id)=(3993) is still referenced from table "object_as_xml".
So, there you go:
oocms=# delet
Hi Magnus,
thanks for the answer.
On Mon, 1 Nov 2004 12:24:07 +0100, you wrote:
>
>Not sure if we want to add a workaround for that? It'd be needed for
>every single command, so I personally don't think it's a good idea.
>
Maybe discarding semicolons in database's names passing the command to
> Hi !
>
> I discovered this particular feature in "createdb" tool
> 8.0.0beta4 running on Win32 Platform:
> c:\windows> createdb testdb;
> CREATE DATABASE
> testdb;=# \l
> List of databases
>Name| Owner | Encoding
> ---+--+---
> template0 | postgr
Hi !
I discovered this particular feature in "createdb" tool 8.0.0beta4
running on Win32 Platform:
Cut And Paste ---
c:\windows> createdb testdb;
CREATE DATABASE
c:\windows> psql testdb
psql: FATAL: database "testdb" does not exist
c:\windows> psql
(Sorry if you get thise message twice; the first time I accidentially
used my @debian.org address, which is not subscribed).
Hi Neil!
Neil Conway [2004-11-01 14:06 +1100]:
> BTW, the information in postgresql-7.4.6/debian/copyright is out of date
> (old download URL, old PostgreSQL copyright date
Hi again!
Martin Pitt [2004-11-01 9:04 +0100]:
> Neil Conway [2004-11-01 14:06 +1100]:
> > 20pg_dump_datestyle seems redundant (we already set DateStyle to ISO in
> > pg_dump).
I will look at this and remove it if appropriate. Thanks for the hint.
> > ISTM the right fix is to use xml2-config.
>
14 matches
Mail list logo
