'\xc3\xa8';
?column?
--
f
The locale it_IT.utf8 shows the same problem too. The result is true for
it_IT.iso-8859-1 locale.
Is it a PostgreSQL related problem or a libc one?
Thank you
--
Daniele Varrazzo - Develer S.r.l.
http://www.develer.com
---(end
The following bug has been logged online:
Bug reference: 5469
Logged by: Daniele Varrazzo
Email address: daniele.varra...@gmail.com
PostgreSQL version: 8.4
Operating system: any
Description:regexp_matches() has poor behaviour and more poor
documentation
Details
On Wed, May 26, 2010 at 4:51 AM, Robert Haas wrote:
> On Mon, May 24, 2010 at 9:16 AM, Daniele Varrazzo
> wrote:
>> regexp_matches() has been recently discussed
>> (http://archives.postgresql.org/pgsql-bugs/2010-04/msg00026.php): it is a
>> setof function and as
#x27;|' pattern (the later suggested by Daniele Varrazzo).
>
> I don't find this part to be something we should include in the
> documentation. If we want to include a workaround, how about defining
> a non-SRF that just calls the SRF and returns the first row?
I think a docu
Hello,
=# select extract(epoch from 'infinity'::timestamp);
date_part
---
0
A better value would be 'infinity'::float8. Ditto for -infinity.
I'm trying to use a box-based index to represent the intervals in a
table containing a pair of fields date_from, date_to (timestamps),
wh
The following bug has been logged on the website:
Bug reference: 6453
Logged by: Daniele Varrazzo
Email address: daniele.varra...@gmail.com
PostgreSQL version: 9.1.2
Operating system: Any
Description:
Bug verified on PG 9.0.5 and 9.1.2.
auto_explain in json format
On Sun, Feb 12, 2012 at 12:30 PM, wrote:
> auto_explain in json format produces an output such as:
>
> [
> "Query Text": "select pg_sleep(2);",
Oh, sorry, I see it's been already discussed, just in the last days...
-- Daniele
--
Sent via pgsql-bugs mailing list (pgsql-bugs@po
Hello,
pg_upgrade fails on missing FTS dictionaries requiring external files.
--check fails to detect the incompatibility.
E.g. after installed italian_fts (http://pgxn.org/dist/italian_fts/)
into a database, the pg_upgrade_dump_db.sql contains the command:
CREATE TEXT SEARCH DICTIONARY italian_
After moving an extension into the pg_catalog schema, it seems
impossible to move it somewhere else:
test=# create extension ltree;
CREATE EXTENSION
test=# alter extension ltree set schema pg_catalog;
ALTER EXTENSION
test=# alter extension ltree set schema public;
ERROR: cannot remove dependency
The following bug has been logged on the website:
Bug reference: 6734
Logged by: Daniele Varrazzo
Email address: daniele.varra...@gmail.com
PostgreSQL version: 9.1.4
Operating system: Linux
Description:
Weird, isn't it? Test case below.
Dropping the comment
On Fri, Jul 13, 2012 at 2:24 PM, Ryan Kelly wrote:
> On Fri, Jul 13, 2012 at 12:00:14PM +, daniele.varra...@gmail.com wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 6734
>> Logged by: Daniele Varrazzo
>>
On Fri, Jul 13, 2012 at 4:11 PM, Tom Lane wrote:
> Daniele Varrazzo writes:
>> Wouldn't it be better to call the indexes NEWTABLE_OLDINDEXNAME?
>
> Then the CREATE LIKE command would fail altogether if that name were
> already taken. Postponing the selection of the index
The following bug has been logged on the website:
Bug reference: 7572
Logged by: Daniele Varrazzo
Email address: daniele.varra...@gmail.com
PostgreSQL version: 9.1.4
Operating system: Linux
Description:
Hello,
when a slave is promoted, the pgwriter keeps holding a
On Mon, Jan 7, 2013 at 5:19 PM, Ryan Kelly wrote:
> '1 month'::interval is the same as '30 days'::interval.
No, it's not.
# select '2012-07-31'::date + '1 month'::interval, '2012-07-31'::date
+ '30 days'::interval;
?column? | ?column?
-+-
On Mon, Jan 7, 2013 at 5:47 PM, Ryan Kelly wrote:
> Alright, now I'm thoroughly confused. What magic makes this true:
"""
Internally interval values are stored as months, days, and seconds.
This is done because the number of days in a month varies, and a day
can have 23 or 25 hours if a daylight
>> Bug reference: 8118
>> Logged by: whiplash
>> Email address: whipl...@bss.org.ua
>> PostgreSQL version: 9.2.2
>> Operating system: Linux (Fedora 11, Fedora 16 and Ubuntu 12.04)
>> Description:
>>
>> I execute query (1):
>>
>> SELECT t.name
>> FROM
>> (
>> SELECT 'AAA AAA
16 matches
Mail list logo
