The following bug has been logged online:
Bug reference: 5054
Logged by: Yujin
Email address: aloudno...@mail.ru
PostgreSQL version: 8.3
Operating system: windows XP SP3
Description:PDO - Query returns from Boolean type field, if it
has false value.
Details:
When
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Andrew Gierth and...@tao11.riddles.org.uk writes:
Domain NOT NULL constraints (and probably other constraints too) aren't
being enforced in some code paths. e.g.
The example you give seems to tie really closely into the
On Wed, Sep 9, 2009 at 5:42 AM, mahmoud badr alien_...@yahoo.com wrote:
The following bug has been logged online:
Bug reference: 5046
Logged by: mahmoud badr
Email address: alien_...@yahoo.com
PostgreSQL version: 8.4
Operating system: windows
Description: java
hi,
i got following error while selecting from my db
ERROR: invalid page header in block 502758 of relation base/16388/16403
i've found some solution in this thread
http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html
but my problem is, that there are multiple files with
i forgot the system informations
postgresql-server-8.4.0-1PGDG.rhel5
linux kernel 2.6.18-128.4.1.el5xen x86_64
centos release 5.3 (final)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Robert Haas robertmh...@gmail.com writes:
It seems like regardless of this discussion you oughtn't to be able to
store a NULL into that table column. But maybe I'm just confused.
The system is relying on the not-unreasonable assumption that if it
extracts a column of type X from someplace,
Yujin aloudno...@mail.ru writes:
When i get query from table with bolean type fields, that have false value ,
function PDO - fetch return that fields with not 0 value , but empty
string.
Are you sure the field is actually false, and not null?
If so, this is a PDO bug, not a Postgres bug.
fous velkej honza...@gmail.com writes:
i got following error while selecting from my db
ERROR: invalid page header in block 502758 of relation base/16388/16403
i've found some solution in this thread
http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html
but my problem
On Mon, Sep 14, 2009 at 11:16:23AM -0400, Robert Haas wrote:
I haven't read the code in this area, but for what it's worth, I guess
I lean toward the view that treating a row of NULLs as being the same
thing as an undecorated NULL does not make very much sense.
I agree; when compared to most
Sam Mason s...@samason.me.uk wrote:
the deeper problem seems to be that the table was created as:
create table test (a tstdom);
and not as:
create table test (a tstdom not null);
Given that tstdom is declared as NOT NULL, is this difference
considered a *feature* or is it an
On Mon, Sep 14, 2009 at 10:22 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
It seems like regardless of this discussion you oughtn't to be able to
store a NULL into that table column. But maybe I'm just confused.
The system is relying on the
On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
Sam Mason s...@samason.me.uk wrote:
the deeper problem seems to be that the table was created as:
create table test (a tstdom);
and not as:
create table test (a tstdom not null);
Given that tstdom is declared
On Mon, Sep 14, 2009 at 10:22:34AM -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
It seems like regardless of this discussion you oughtn't to be able to
store a NULL into that table column. But maybe I'm just confused.
The system is relying on the not-unreasonable
On Thu, Sep 10, 2009 at 7:17 AM, Rohan jamadagni
rohan.jamada...@tcs.com wrote:
The following bug has been logged online:
Bug reference: 5047
Logged by: Rohan jamadagni
Email address: rohan.jamada...@tcs.com
PostgreSQL version: 8.3.7
Operating system: Linux Rhel 5.0
In recovery of GIN operations using CVS HEAD I see consistently
TRAP: FailedAssertion(!(((bool) ((spcNode) != ((Oid) 0, File:
tablespace.c, Line: 116)
Looking at code, new list page WAL record is a GIN record type and at
line 115 in gin/ginfast.c I see that the value of the node is unset.
The following bug has been logged online:
Bug reference: 5056
Logged by: the6campbells
Email address: the6campbe...@gmail.com
PostgreSQL version: 8.4.1
Operating system: windows
Description:SQLDescribeColW for function returning a result set
incorrectly setting
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells the6campbe...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5056
Logged by: the6campbells
Email address: the6campbe...@gmail.com
PostgreSQL version: 8.4.1
Operating system: windows
The following bug has been logged online:
Bug reference: 5055
Logged by: john martin
Email address: postgres_...@live.com
PostgreSQL version: 8.3.6
Operating system: Centos 5.2 32 bit
Description:Invalid page header error
Details:
All of a sudden we started seeing
On Mon, 2009-09-14 at 23:17 +, john martin wrote:
All of a sudden we started seeing page header errors in certain queries.
Was there any particular event that marked the onset of these issues?
Anything in the system logs (dmesg / syslog etc) around that time?
[for SATA disks]: does
Craig Ringer wrote:
[for SATA disks]: does smartctl from the smartmontools package indicate
anything interesting about the disk(s)? (Ignore the health status,
it's a foul lie, and rely on the error log plus the vendor attributes:
reallocated sector count, pending sector, uncorrectable sector
20 matches
Mail list logo