The following bug has been logged online:
Bug reference: 5662
Logged by:
Email address: saer...@hotmail.com
PostgreSQL version: 8.4
Operating system: Windows Vista
Description:Incomplete view
Details:
The Sequence view in the information schema is incomplete. It do
On sön, 2010-09-19 at 09:41 +, saer...@hotmail.com wrote:
> The Sequence view in the information schema is incomplete. It does not
> return a Sequence's maximum_value, minimum_value or increment. Please
> complete the view.
This is known and documented:
http://www.postgresql.org/docs/8.4/stati
Peter Eisentraut writes:
> On sön, 2010-09-19 at 09:41 +, saer...@hotmail.com wrote:
>> The Sequence view in the information schema is incomplete. It does not
>> return a Sequence's maximum_value, minimum_value or increment. Please
>> complete the view.
> This is known and documented:
> http
Craig Ringer writes:
> Yes, the mismatched encodings in the data are clear and obvious.
> Given that the messages are coming purely from postgresql, not client
> code, I'm now wondering if what we're dealing with is mismatched
> encodings in the translation files, where some messages were trans
Hi guys,
I found a weird behaviour in sorting character varying columns, I think
it could really be a bug.
Table definition:
CREATE TABLE dummy (string character varying(255));
Test dataset:
INSERT INTO dummy VALUES ('10.');
INSERT INTO dummy VALUES ('100');
If I query the table sorting
Edoardo Serra wrote:
> SELECT * FROM dummy ORDER BY string ASC;
> string
>
> 100%
> 10.1
> (2 rows)
>
> I would expect the order of the results to be '100%', '10.1'.
> Moreover, if I use the following dataset, I get the correct sorting
>
> SELECT string, ascii(substr(string, 3, 1))
The following bug has been logged online:
Bug reference: 5664
Logged by: simon
Email address: xuboc...@163.com
PostgreSQL version: 8.3.11
Operating system: suse 10 Linux omu 2.6.16.60-0.54.5-bigsmp #1 SMP Fri Sep
Description:index "idx000_mytable19" contains unexpecte
"simon" writes:
> Description:index "idx000_mytable19" contains unexpected zero page
> ...
> 4. After the concurrent execution is complete, the system powers off.
> ...
> The following solutions are provided in almost all forums:
> 1. Set fsync to on (The parameter is set to on in the
