The following bug has been logged online:
Bug reference: 4247
Logged by: J6M
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.13
Operating system: Linux x86-64
Description:(Possible) SQL miscontruct not flagged
Details:
Hi,
This European afternoon, I was
CT .. INTO TEMP TABLE .. FROM .. GROUP BY .., so they are smaller than
their origins).
Adding SET default_with_oids = true to the script seems to solve the
problem.
Also, when run with the former releases, AUTOVACUUMING was off. Now it is
on.
Regards
J6M
- Original Message -
From: &qu
a production table).
- Original Message -
From: "Stefan Kaltenbrunner" <[EMAIL PROTECTED]>
To: "J6M" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Monday, April 07, 2008 8:31 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about re
20eae09295
LABEL:
Set flags in SB:
ATTRIBUTES CLEAN
- Original Message -
From: "J6M" <[EMAIL PROTECTED]>
To: "Gregory Stark" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Monday, April 07, 2008 5:50 PM
Subject: Re: [BUGS
October 2007).
- Original Message -
From: "Gregory Stark" <[EMAIL PROTECTED]>
To: "J6M" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Monday, April 07, 2008 5:40 PM
Subject: Re: BUG #4096: PG 8.3.1. confused about remaining di
OK. So why did this not occur when I was running 8.2.6 ?
To avoid any ambiguity, here we go
estp-intranet:~ # su - postgres
[EMAIL PROTECTED]:~> cd /var/lib/pgsql
[EMAIL PROTECTED]:~> cd data
[EMAIL PROTECTED]:~/data> ls
base pg_hba.confpg_multixact pg_twophase postgresql.conf
global
- Original Message -
From: "Gregory Stark" <[EMAIL PROTECTED]>
To: "Zdenek Kotala" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Sent: Monday, April 07, 2008 1:14 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
Also check "df -i"
This might be an
- Original Message -
From: "Zdenek Kotala" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Monday, April 07, 2008 12:51 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
[EMAIL PROTECTED] napsal(a):
I ran today a legacy application with PG 8.3.1
Hi,
Dis you take a look at the Postgres release notes and at the section of
postgresql.conf on compatibility with previous releases ? (see below)
#---
# VERSION/PLATFORM COMPATIBILITY
#-
Up to SuSE 9.3, the Postgres versions shipped use version 3 of libpq.
Postgres 8.1.x use version 4.
Oddly enough, installing Postgres 8.1 works quite well with packages
requiring Postgres (e.g. snort, php) if you replace in /usr/lib all libpq
version 3 files with links to their version 4 counterpa
ere myfield is not in ('C','F')" would not extract all rows
where myfield is null.
Hope this helps
Regards
J6M
- Original Message -
From: "BogDan Vatra" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 29, 2005 10:38 AM
Subject: [BUGS] BUG #
It appears to be just that.
Great, It works!
*** ./expected/polymorphism.out Wed Dec 1 20:00:56 2004
--- ./results/polymorphism.out Tue Dec 21 19:06:12 2004
***
*** 349,532
select f3, myaggp01a(*) from t group by f3;
f3 | myaggp01a
+---
c | {}
a | {}
Hi,
The regression test fails on 'polymorphism' on three different computers with
various architectures.
(I hope this point was not raised before, but I did not find any relevant mail
about it with '[BUGS]'in the subject line and 'polymorphism' in message body)
Besides the configure options st
Bom Dia,
I ran into that trouble too. But as I used Postgresql since 7.0.2, I returned to
the traditional way of doing things as I thought it was due to a wrong
understanding from my part of this issue).
(I presume your PGDATA directory is in /var/lib/pgsl/data and it is run by a
user named 'post
>9
>9
>9
> (4 rows)
>
> I get the same results using the JDBC driver so it's not a psql problem.
>
> Any thoughts out there?
>
>
It is not a bug (or undocumented feature as some software vendor would say).
Your queri
15 matches
Mail list logo
