On Mon, Jan 18, 2010 at 5:13 AM, heyong wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5285
> Logged by: heyong
> Email address: hewy...@126.com
> PostgreSQL version: postgresql-8.3
> Operating system: solarias
> Description:contrib\xml2 packag
Tom Lane wrote:
> Wild Wezyr writes:
>> 2010/1/19 Tom Lane
>>> What locale setting and database encoding are you using?
>
>> Here are my settings:
>
>> CREATE DATABASE spb
>> WITH OWNER = wwspb
>>ENCODING = 'UTF8'
>>LC_COLLATE = 'Polish_Poland.1250'
>>LC_CTYPE = 'Polis
2010/1/20 Tom Lane
>
> I tried the test case on Linux (Fedora 11) with locale pl_PL.utf8,
> and unsurprisingly failed to reproduce the problem. So it's something
> specific to Windows. Can anyone else reproduce it?
>
>regards, tom lane
>
If it is of any help: changing
Wild Wezyr writes:
> 2010/1/19 Tom Lane
>> What locale setting and database encoding are you using?
> Here are my settings:
> CREATE DATABASE spb
> WITH OWNER = wwspb
>ENCODING = 'UTF8'
>LC_COLLATE = 'Polish_Poland.1250'
>LC_CTYPE = 'Polish_Poland.1250'
>CONNEC
Kevin Grittner wrote:
"Richard Neill" wrote:
date_trunc('day', timestamp '2010-01-20 10:16:55')
What happens with a "timestamp with time zone" literal?
-Kevin
Good call!
This query is fast:
SELECT count(1) FROM tbl_tracker WHERE ((srep_timestamp >=
date_trunc('day', timestamp wi
Richard Neill wrote:
> #fast
> WHERE column < '2010-010-20 00:00:00'
>
> #fast
> WHERE column < date_trunc('day', timestamp with time zone
> '2010-01-20 10:16:55')
>
> #slow
> WHERE column < date_trunc('day', timestamp
> '2010-01-2
"Adam Rakowski" wrote:
> Both one-click installer and zip archive from postgresql.org are
> corrupted.
Where did you get them (e.g., a URL)?
Any chance of download problems?
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http:
"Richard Neill" wrote:
> date_trunc('day', timestamp '2010-01-20 10:16:55')
What happens with a "timestamp with time zone" literal?
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
2010/1/19 Tom Lane
>
> What that sounds like is a locale/encoding conflict. Postgres depends
> on strcoll() or local equivalent to produce consistent sort results,
> and sometimes if strcoll is presented with data that it thinks is
> invalidly encoded, it doesn't behave sanely.
>
> What locale s
The following bug has been logged online:
Bug reference: 5292
Logged by: Adam Rakowski
Email address: foo-scr...@o2.pl
PostgreSQL version: 8.3
Operating system: Windows
Description:Corrupted installer
Details:
Both one-click installer and zip archive from postgresql
The following bug has been logged online:
Bug reference: 5293
Logged by: Richard Neill
Email address: rn...@cam.ac.uk
PostgreSQL version: 8.4.2
Operating system: Linux
Description:constant function (date_trunc) is repeatedly evaluated
inside loop
Details:
SUMMARY
--
beulah prasanthi wrote:
> Can i insert all the data into all the tables(multiple tables) with
> a single trip to the database,by creating rules/triggers
This is not a bug. Please repost to another list; perhaps
pgsql-general.
When you re-post, you may want to provide more detail about the
p
Helo
Can i insert all the data into all the tables(multiple tables) with a
single trip to the database,by creating rules/triggers
using postgres 8.4 if possible please help me how can i insert the data
and your answer is valuable to me
13 matches
Mail list logo
