Andrew - Supernews <[EMAIL PROTECTED]> writes:
> The problem is that the semantics of the &< and &> operators for the box
> type are not what rtree needs for the "OverLeft" and "OverRight" slots of
> the operator class.
This was observed nearly a year ago, see this thread:
http://archives.postgres
Martin Pitt <[EMAIL PROTECTED]> writes:
> Used in build, fixed for Debian (see attached patch):
> postgresql-7.4.6/src/backend/catalog/genbki.sh
> postgresql-7.4.6/src/test/bench/perquery
AFAICS these were fixed some time ago in our CVS.
regards, tom lane
Summary: "epoch" does not produce a consistent behavior when cast as
TIMESTAMP WITHOUT TIMEZONE
Severity: Annoyance
Tested On: 7.4.6, 8.0b4
Example:
test=> select extract(epoch from '2004-12-01 00:00'::TIMESTAMP WITHOUT TIME
ZONE);
date_part
1101888000
this value is actually l
On Mon, 2005-01-24 at 23:50 +0100, Pavel Stehule wrote:
> FOR EACH STATEMENT trigger with plperl crash backaned. FOR EACH ROW
> trigger works well.
I believe this is fixed in 8.0.0
-Neil
---(end of broadcast)---
TIP 7: don't forget to increase y
Pavel Stehule <[EMAIL PROTECTED]> writes:
> FOR EACH STATEMENT trigger with plperl crash backaned.
This is fixed in 8.0 final.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
Edmund Bacon <[EMAIL PROTECTED]> writes:
> njamd says:
> NJAMD/free: Double free of address 0x41454ff4
> #4 0x40021e87 in free () from /usr/lib/libnjamd.so
> #5 0x0805755f in remove_typedefs (brace_level=1073902784) at variable.c:271
> #6 0x08049e02 in yyparse () at preproc.y:610
> #7 0x08055d
>The following bug has been logged online:
>
>Bug reference: 1428
>Logged by: Hendrik Mueller
>Email address: [EMAIL PROTECTED]
>PostgreSQL version: 8.0.0.0
>Operating system: Windows NT 4.0 + SP4
>Description:SHGetSpecialFolderPath not found in SHELL32.dll
>Details:
>
Hello,
FOR EACH STATEMENT trigger with plperl crash backaned. FOR EACH ROW
trigger works well.
Regards
Pavel Stehule
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Testcase:
create table boxtest (a box);
create index boxtest_idx on boxtest using rtree (a);
create function gen_data() returns void as '
begin for i in 1..200 loop
insert into boxtest
values (box(point((i*2-1)::float,0),point((i*2)::float,1)));
end loop;
return;
end;' language pl
Hi PostgreSQL developers!
Debian's security audit team recently reviewed PostgreSQL for insecure
temporary file usage and found that a lot of the developer tools and
also some build tools are vulnerable against symlink attacks.
Please see
http://bugs.debian.org/291962
for the detailled repor
"Yary Hluchan" <[EMAIL PROTECTED]> writes:
> My reading of it is that the optimizer isn't applying a distributive rule:
> condition(a union b) == condition(a) union condition(b).
No, the correct reading is that a UNION subquery is planned
independently of the surrounding query. This is not likely
"craig perras" <[EMAIL PROTECTED]> writes:
> add domain 'string' of base type text with non-null constraint
> add column of type 'string' to table with existing rows
> works; all rows have new column's value set to null
Fixed for 8.0.1.
regards, tom lane
-
You know, I should have been able to think of that:
njamd says:
(gdb) set env LD_PRELOAD=libnjamd.so
(gdb) set env NJAMD_CHK_FREE=error
(gdb) r test_bad.pgc
Starting program:
/var/lib/pgsql/src/postgresql-8.0.0/src/interfaces/ecpg/preproc/ecpg
test_bad.pgc
NJAMD/free: Double free of address 0x414
Edmund Bacon <[EMAIL PROTECTED]> writes:
> According to the backtrace, it appears to be dieing in malloc.
That's consistent with the idea that the multiple free is the source of
trouble --- multiple free() could corrupt malloc's private data
structures to the point of causing a crash in a later ma
According to the backtrace, it appears to be dieing in malloc.
(gdb) bt
#0 0x40149f9c in _int_malloc () from /lib/i686/libc.so.6
#1 0x40149201 in malloc () from /lib/i686/libc.so.6
#2 0x080547c3 in mm_alloc (size=3) at type.c:13
#3 0x080493a0 in make_str (str=0x4020c400 "\001") at preproc.y:129
"craig perras" <[EMAIL PROTECTED]> writes:
> Domain check constraint not checked when adding new column.
Hmm. It does work for cases like
regression=# create domain posint int check (value > 0);
CREATE DOMAIN
regression=# alter table foo add column f5 posint default 0;
ERROR: value for domain p
On Mon, Jan 24, 2005 at 12:08:36PM -0700, Michael Fuhr wrote:
> ecpg in free(): warning: chunk is already free
>
> If you have a core dump then maybe you can do a backtrace and see
> where that's happening.
This assumes, perhaps prematurely, that the free() problem is causing
the core dump on yo
On Mon, Jan 24, 2005 at 06:50:48PM +, Edmund Bacon wrote:
> Both source files pass with ecpg v 3.1.1 (Posgtresql 7.4.2) on RedHat Linux
> 9 (x86), and (interstingly) withe ecpg v 3.2.0 (Postgres 8.0.) under HPUX
> 11i - ia64
On both FreeBSD 4.11-STABLE and Solaris 9, ecpg 3.2.0 (8.0.0) runs
a
The following bug has been logged online:
Bug reference: 1440
Logged by: Edmund Bacon
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.0
Operating system: Linux Redhat 9 Pentium-4
Description:ecpg seg faults
Details:
I have here a shortish source file that
Tom Lane wrote:
> John Heasman <[EMAIL PROTECTED]> writes:
> > It appears that low privileged users can invoke the LOAD extension
> > to load arbitrary libraries into the postgres process space.
>
> Hmm. Creating C functions is restricted to superusers, but I guess
> no one ever noticed that LOAD
Tom Lane wrote:
Jeff Ross <[EMAIL PROTECTED]> writes:
Rather than post it in the e-mail, I've put the postmaster.log at
http://www.openvistas.net/postmaster.log
I see multiple occurrences of
LOG: could not fork new process for connection: Resource temporarily
unavailable
so indeed your p
Jeff Ross <[EMAIL PROTECTED]> writes:
> Rather than post it in the e-mail, I've put the postmaster.log at
> http://www.openvistas.net/postmaster.log
I see multiple occurrences of
LOG: could not fork new process for connection: Resource temporarily
unavailable
so indeed your process limit
John Heasman <[EMAIL PROTECTED]> writes:
> It appears that low privileged users can invoke the LOAD extension to load
> arbitrary libraries into the postgres process space.
Hmm. Creating C functions is restricted to superusers, but I guess no
one ever noticed that LOAD isn't. On a platform wher
Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
On Fri, Jan 21, 2005 at 05:03:08PM -0700, Jeff Ross wrote:
If I put the same source code up on a ram disk, configure and compile it
the same way, all 96 tests pass.
Interesting. Is this behavior consistent? What's different 'twixt
the RAI
"Estagus" <[EMAIL PROTECTED]> writes:
> # CREATE TABLE onoff(id BIGSERIAL UNIQUE NOT NULL, user_id BIGINT NOT NULL,
> made_id BIGINT NOT NULL, progress BOOL NOT NULL, is_on BOOL NOT NULL,
> tarif_id INTEGER NOT NULL, date_ins DATE NOT NULL, date_todo DATE NOT
> NULL);
> ERROR: ignoring unconvertib
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Jan 21, 2005 at 05:03:08PM -0700, Jeff Ross wrote:
>> If I put the same source code up on a ram disk, configure and compile it
>> the same way, all 96 tests pass.
> Interesting. Is this behavior consistent? What's different 'twixt
> the RAID di
"Hendrik Mueller" <[EMAIL PROTECTED]> writes:
> The stats-test execute after make (with make check) fails.
That means the statistics collector subprocess didn't start. Check the
postmaster log to find out why not. (In my experience the most common
reason why not is that your DNS configuration is
On Sat, Jan 22, 2005 at 10:28:16PM +, Brad Snobar wrote:
> The column was a primary key bigint.
>
> ALTER TABLE "public"."CategoryBuildingRankSchemas"
> ALTER COLUMN "IDCategoryBuildingRankSchema" TYPE BIGSERIAL;
>
> ERROR: type "bigserial" does not exist
Bigserial is not a type. Rather
On Fri, Jan 21, 2005 at 05:03:08PM -0700, Jeff Ross wrote:
> If I put the source for 8.0.0 on disk (RAID 1) , configure, compile and
> run gmake check, it fails with 33 errors, 30 of which are
>
> ! psql: could not send startup packet: Broken pipe
Somebody else using OpenBSD reported a similar
On Sun, Jan 23, 2005 at 05:39:05PM +, Florin Borsa wrote:
> I ceate a table with some integer fields in this way:
>
> create table homes ( nr int not null, name char(4))
>
> I can insert in this table zero and null values for nr field.
Zero isn't null, so a NOT NULL constraint wouldn't proh
On Sat, Jan 22, 2005 at 02:25:27AM +, Sam Hahn wrote:
> A database command error occured whilst executing
> "E:\Program Files\PostgreSQL\8.0\share\contrib\earthdistance.sql":
> ERROR: type "cube" does not exist
README.earthdistance mentions that contrib/cube must be installed.
--
Michael Fu
31 matches
Mail list logo
