The following bug has been logged online:
Bug reference: 3823
Logged by: Josh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: windows server 2003
Description:Installing Permissions set still says there not
Details:
I tried installing pos
Josh wrote:
The following bug has been logged online:
Bug reference: 3823
Logged by: Josh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: windows server 2003
Description:Installing Permissions set still says there not
Details:
I tried
The bug message was cannot edit file permissions not set or something
along those lines.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
The following bug has been logged online:
Bug reference: 3824
Logged by: Gregor Roessle
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux - Kernel 2.4.33
Description:Query hangs when result set empty using sort and limit
Details:
The
"Gregor Roessle" <[EMAIL PROTECTED]> writes:
> The Server hangs when executing a query like this:
> select * from messwerte where pknr = 28315178 and isproducing = 't' order by
> timestamp desc limit 1;
I seriously doubt that it's hung. Takes a long time, maybe so. Is it
trying to use an indexs
Zdenek Kotala wrote:
alex wrote:
WARNING: relation "transaktion" TID 1240631/12: OID is invalid
ERROR: invalid page header in block 1240632 of relation "transaktion"
7. 2007/12/10 : We started the export of the data ( which runs every
morning ) for the last days again. These exports use the
Zdenek Kotala wrote:
Zdenek Kotala wrote:
I got dump of affected two blocks from Alex and it seems that both
blocks were overwritten together with some 128bytes length structure
(there some pattern) and complete damaged size is 9728bytes (first block
is overwritten completely and second one
"Tom Lane" <[EMAIL PROTECTED]> writes:
> "Gregor Roessle" <[EMAIL PROTECTED]> writes:
>> The Server hangs when executing a query like this:
>
>> select * from messwerte where pknr = 28315178 and isproducing = 't' order by
>> timestamp desc limit 1;
>
> I seriously doubt that it's hung. Takes a lo
"Zdenek Kotala" <[EMAIL PROTECTED]> writes:
> I got dump of affected two blocks from Alex and it seems that both blocks were
> overwritten together with some 128bytes length structure (there some pattern)
> and complete damaged size is 9728bytes (first block is overwritten completely
> and second
Gregory Stark <[EMAIL PROTECTED]> writes:
> I don't understand this 9728 bytes. Postgres blocks are 8192 bytes. Are you
> saying one whole block is trashed and then part, but not all, of the next
> block?
> What's the block size of the ZFS filesystem? And what exactly does the trash
> data look li
The following bug has been logged online:
Bug reference: 3826
Logged by: Alexander Steffens
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3b4
Operating system: Win2003R2x64
Description:Very Slow Execution of examplequery (wrong plan?)
Details:
Hello, I have
"Alexander Steffens" <[EMAIL PROTECTED]> writes:
> Hello, I have found an Query (with data)
> that need to execute on MS-SQL 2005 < 9sec,
> on Postgresql I will stop it now after more than 30 mins:
> insert into t1
> select distinct (t1.a + t2.a)*2
> from t1,t2
> where not exists (
> select * fr
Gregory Stark <[EMAIL PROTECTED]> writes:
>> insert into t1
>> select distinct (t1.a + t2.a)*2
>> from t1,t2
>> where not exists (
>> select * from t1 tt where tt.a = (t1.a + t2.a)*2
>> )
> What plan does MS-SQL use to complete this? I wonder whether it's producing
> the same answer Postgres is.
"Tom Lane" <[EMAIL PROTECTED]> writes:
> It's possible that MS-SQL is doing something analogous to the
> hashed-subplan approach (hopefully with suitable tweaking for the NULL
> case) but even then it's hard to see how it could take only 9 sec.
> The cartesian product is too big.
Fwiw it seems MS
Hi all,
I've got a fatal error when i try to start postgresql service.
I debugged my scripts and the error came up right after i ran the followed
ltree installation script.
It was an attempt to install ltree on my postgresql-8.2.4
Here it's the bash commmand script:
# Install ltree
su - postgres
"Iuri Sampaio" <[EMAIL PROTECTED]> writes:
> I've got a fatal error when i try to start postgresql service.
> I debugged my scripts and the error came up right after i ran the followed
> ltree installation script.
There's nothing in what you show that seems to have anything to do with
ltree. Are
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>> It's possible that MS-SQL is doing something analogous to the
>> hashed-subplan approach (hopefully with suitable tweaking for the NULL
>> case) but even then it's hard to see how it could take only 9 sec.
>> The
No, I´m not sure.
Assuming i´ve got a locale problem, how do i get rid of it?
re-installing postgres??
I already tried that a couple of times and it didn´t succeed
is it an option to re-install my OS (debian etch)?
or just apt-get the respective locale support?
iuri
On Wed, 2007-12-19 at 00:29
18 matches
Mail list logo
