On Sun, 10 Apr 2011, Jesper Krogh wrote:
On 2011-04-10 12:18, Oleg Bartunov wrote:
Wow, custom solution for 2008 still much faster Denali 2011 solution.
Also, what's about not spatial data types ? In our approach, we can provide
knn for any datatype, which has GiST index and distance m
Guys,
before digging deep into the art of comp/decomp world I'd like to know
if you familiar with results of
http://wwwconference.org/www2008/papers/pdf/p387-zhangA.pdf paper and
some newer research ? Do we agree in what we really want ? Basically,
there are three main features: size, compression
Yes, we got temp licence key from them and will provide full report.
On Wed, Dec 25, 2013 at 4:38 PM, Joel Jacobson wrote:
> As reported by Andrey Karpov in his article
> http://www.viva64.com/en/b/0227/, the version number is expressed in
> octal form 070100 should be changed to 70100.
>
> Attac
I moved patch to the January commitfest
(https://commitfest.postgresql.org/action/patch_view?id=1289) .
Oleg
PS.
Kudos to Teodor and his mobile phone, which he used to synchronize
branches on github.
On Fri, Jan 10, 2014 at 2:08 AM, Andrew Dunstan wrote:
>
> On 01/09/2014 02:11 PM, Josh Berku
Thank you, Erik !
Oleg
On Mon, Jan 13, 2014 at 12:25 PM, Erik Rijkers wrote:
> On Mon, January 13, 2014 00:24, Erik Rijkers wrote:
>> On Sat, January 11, 2014 22:47, Andrew Dunstan wrote:
>>>
>>> On 01/11/2014 03:03 PM, Erik Rijkers wrote:
On Sat, January 11, 2014 20:30, Peter Eisentraut wr
Andrew,
did you run perl script ? Actually, I found, that operator table needs
to be fixed.
Oleg
On Mon, Jan 13, 2014 at 7:36 PM, Andrew Dunstan wrote:
>
> On 01/13/2014 03:25 AM, Erik Rijkers wrote:
>
>> There are errors in the example expressions in "Table F-6. hstore
>> Operators".
>>
>> Att
Hi there,
I just bought ISO/IEC 9075-2:2016
http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=63556
to satisfy my interest on json support in SQL. I am not ready to discuss
here implementation details, but there is one problem with the status of
this document, which is
On Tue, Jan 17, 2017 at 6:26 PM, Alvaro Herrera
wrote:
> Oleg Bartunov wrote:
> > Hi there,
> >
> > I just bought ISO/IEC 9075-2:2016
> > http://www.iso.org/iso/home/store/catalogue_tc/catalogue_
> detail.htm?csnumber=63556
> > to satisfy my interest on jso
On Thu, Mar 31, 2016 at 9:14 PM, Alvaro Herrera
wrote:
> What led you to choose the ? operator for the FOLLOWED BY semantics?
> It doesn't seem a terribly natural choice -- most other things seems to
> use ? as some sort of wildcard. What about something like "...", so you
> would do
> SELECT
On Fri, Apr 1, 2016 at 5:24 PM, Tom Lane wrote:
> Alvaro Herrera writes:
> > Teodor Sigaev wrote:
> >> may be <=>? it isn't used anywhere yet.
> >>
> >> select 'fat'::tsquery <=> 'cat';
> >> select 'fat <=> cat'::tsquery;
> >> select 'fat <3> cat'::tsqyery; -- for non-default distance.
>
> > Dun
On Tue, Apr 12, 2016 at 9:25 PM, Josh berkus wrote:
> On 04/12/2016 10:43 AM, Robert Haas wrote:
> > 1. Large backward compatibility breaks are bad. Therefore, if any of
> > these things are absolutely impossible to do without major
> > compatibility breaks, we shouldn't do them at all.
>
> +1
>
On Tue, Apr 19, 2016 at 1:49 PM, Simon Riggs wrote:
> On 12 April 2016 at 06:51, Tom Lane wrote:
>
>> Craig Ringer writes:
>> > The other area where there's room for extension without throwing out the
>> > whole thing and rebuilding is handling of new top-level statements. We
>> can
>> > probab
On Fri, Apr 29, 2016 at 7:40 PM, Joshua D. Drake
wrote:
> On 04/29/2016 08:44 AM, Bruce Momjian wrote:
>
>> On Tue, Apr 12, 2016 at 11:07:04PM +0300, Oleg Bartunov wrote:
>>
>>> Our roadmap http://www.postgresql.org/developer/roadmap/ is the
>>> problem.
On Wed, Apr 13, 2016 at 6:57 PM, Marcelo Zabani wrote:
> Hi, Tom,
>
> You're right, I don't think one can argue that the default parser should
> know HTML.
> How about your suggestion of there being an HTML parser, is it feasible? I
> ask this because I think that a lot of people store HTML docum
On Wed, May 11, 2016 at 5:20 PM, Bruce Momjian wrote:
> I am giving a keynote at an IEEE database conference in Helsinki next
> week (http://icde2016.fi/). (Yes, I am not attending PGCon Ottawa
> because I accepted the Helsinki conference invitation before the PGCon
> Ottawa date was changed from
On Sat, May 14, 2016 at 12:10 PM, Andreas Seltenreich
wrote:
> Konstantin Knizhnik writes:
>
>> Latest information from ISP RAS guys: them have made good progress
>> since February: them have rewritten most of methods of Scan, Aggregate
>> and Join to LLVM API.
>
> Is their work available somewher
On Thu, May 26, 2016 at 3:00 PM, Josh berkus wrote:
> On 05/22/2016 06:53 PM, Teodor Sigaev wrote:
>>
>>> to_tsquery(' Berkus & "PostgreSQL Version 10.0" ')
>>>
>>> ... would be equivalent to:
>>>
>>> to_tsquery(' Berkus & ( PostgreSQL <-> version <-> 10.0 )')
>>
>> select to_tsquery('Berkus') &&
On Thu, Jan 8, 2015 at 11:20 PM, Jim Nasby wrote:
> On 1/7/15, 3:26 PM, Arthur Silva wrote:
>
>>
>> On Jan 6, 2015 7:14 PM, "Josh Berkus" > j...@agliodbs.com>> wrote:
>> >
>> > Oleg, Teodor:
>> >
>> > I take it VODKA is sliding to version 9.6?
>>
>> This is kinda off, but I was wondering if a
correct mistakes and add missing comments.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)93
rm80'::text))
Total runtime: 237.218 ms
(5 rows)
Time: 237.999 ms
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su
:* & dd:*'));
count
---
123
(1 row)
Time: 26.185 ms
Oleg
On Wed, 28 Jul 2010, Tom Lane wrote:
Oleg Bartunov writes:
you can download dump http://mira.sai.msu.su/~megera/tmp/search_tab.dump
Hmm ... I'm not sure why you're failing to reproduce it, because it&#
On Thu, 29 Jul 2010, Tom Lane wrote:
Oleg Bartunov writes:
I also wonder why did I get "right" result :) Just repeated the query:
test=# select count(*) from search_tab where (to_tsvector('german', keywords ) @@
to_tsquery('german', 'ee:* & dd:*
ostgresql.org/pgdocs/postgres/unaccent.html ?
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, h
On Wed, 25 Aug 2010, Tom Lane wrote:
Oleg Bartunov writes:
On Tue, 24 Aug 2010, Tom Lane wrote:
There's an entry in the 9.0 release notes saying that we've got
filtering dictionaries now. Cool, but I don't see any documentation
of the feature in textsearch.sgml. Shouldn&
g commit access back then that we do now.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai
27;t thought about it much yet.
6. I'm sure there are probably some statements in the documentation
that need updating, but I haven't tracked 'em down yet.
Comments, testing, review appreciated...
Regards,
Oleg
st no overlaps) and
much better performance on real-life data, plus much better index
creation time. Also, we appreciate your comments and suggestions about
API.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, He
Hi there,
attached is WIP-patch for 9.2 development source tree, which provides
implementation of SP-GiST (prototype
was presented at PGCon-2011, see
http://www.pgcon.org/2011/schedule/events/309.en.html and presentation
for details) as a core feature. Main differences from prototype version:
1.
This is updates SP-GiST patch, which fixed one bug and
replaced test to the locale independent one.
On Wed, 31 Aug 2011, Oleg Bartunov wrote:
Hi there,
attached is our WIP-patch for 9.2 development source tree, which provides
implementation of SP-GiST (prototype was presented at PGCon-2011
Attached is updated SP-GiST patch, which provides full logging support and
fixed several bugs (Thanks ALexander Korotkov for help).
Regards,
Oleg
On Thu, 1 Sep 2011, Oleg Bartunov wrote:
This is updates SP-GiST patch, which fixed one bug and replaced test to the
locale independent one.
On
I attached wrong patch in previous message, sorry ! Here is a last version.
This is a new WIP of SP-GiST patch, which provides support for:
1. Concurrent vacuum
2. Vacuum logging
3. WAL replay
Oleg
On Thu, 1 Sep 2011, Oleg Bartunov wrote:
This is updates SP-GiST patch, which fixed one bug and
Here is the latest spgist patch, which has all planned features as well as
all overhead, introduced by concurrency and recovery, so performance
measurement should be realistic now.
Oleg
On Mon, 5 Sep 2011, Oleg Bartunov wrote:
I attached wrong patch in previous message, sorry ! Here is a
I've committed the patch now, including that fix. Thanks for a great GSoC
project!
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institu
tion comment?
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +00
ru/misc/unaccent-0.2.tar.gz
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://ww
hazard in some people's usages. I can see that some people will want
this type of functionality, but others definitely won't.
regards, tom lane
Regards,
Oleg
_____
Oleg Bartunov,
We are working on the hackers documentation, hope to submit it before my
himalaya track.
Oleg
On Sun, 2 Oct 2011, Tom Lane wrote:
Heikki Linnakangas writes:
On 06.09.2011 20:34, Oleg Bartunov wrote:
Here is the latest spgist patch, which has all planned features as well as
all overhead
am not sure of that :-(
Oleg, Teodor, can you give me a description of how ts_rank decided how
to rank items? Thanks.
Any news on this question?
Regards,
Oleg
_____
Oleg Bartunov, Research Scienti
+1
On Thu, Jun 11, 2015 at 5:12 PM, Robert Haas wrote:
> On Tue, Jun 9, 2015 at 6:35 PM, Bruce Momjian wrote:
> > There has been some confusion by old and new community members about the
> > purpose of the core team, and this lack of understanding has caused some
> > avoidable problems. Theref
On Wed, Jun 8, 2016 at 7:13 PM, Tom Lane wrote:
> It appears that the new <-> operator has been made to have exactly the
> same grammatical precedence as the existing & (AND) operator. Thus,
> for example, 'a & b <-> c'::tsquery means something different from
> 'b <-> c & a'::tsquery:
>
> regress
On Wed, Jun 8, 2016 at 7:13 PM, Tom Lane wrote:
> It appears that the new <-> operator has been made to have exactly the
> same grammatical precedence as the existing & (AND) operator. Thus,
> for example, 'a & b <-> c'::tsquery means something different from
> 'b <-> c & a'::tsquery:
>
> regress
t; select to_tsvector('simple', 'cat rat bat fat') @@ to_tsquery('simple',
> 'cat <-> rat');
> returns "true"
>
> Jean-Pierre Pelletier
>
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednes
On Wed, Jun 8, 2016 at 8:12 PM, Tom Lane wrote:
> Another thing I noticed: if you test with tsvectors that don't contain
> position info, <-> seems to reduce to &, that is it doesn't enforce
> relative position:
>
> regression=# select 'cat bat fat rat'::tsvector @@ 'cat <-> rat'::tsquery;
> ?col
On Wed, Jun 8, 2016 at 1:05 AM, Tom Lane wrote:
> Jean-Pierre Pelletier writes:
>> I wanted to test if phraseto_tsquery(), new with 9.6 could be used for
>> matching consecutive words but it won't work for us if it cannot handle
>> consecutive *duplicate* words.
>
>> For example, the following re
On Thu, Jun 9, 2016 at 12:47 AM, Tom Lane wrote:
> Oleg Bartunov writes:
>> On Wed, Jun 8, 2016 at 8:12 PM, Tom Lane wrote:
>>> Another thing I noticed: if you test with tsvectors that don't contain
>>> position info, <-> seems to reduce to &, that i
On Tue, Jun 28, 2016 at 9:32 AM, Noah Misch wrote:
> On Sun, Jun 26, 2016 at 10:22:26PM -0400, Noah Misch wrote:
>> On Wed, Jun 15, 2016 at 11:08:54AM -0400, Noah Misch wrote:
>> > On Wed, Jun 15, 2016 at 03:02:15PM +0300, Teodor Sigaev wrote:
>> > > On Wed, Jun 15, 2016 at 02:54:33AM -0400, Noah
On Tue, Jun 28, 2016 at 7:00 PM, Oleg Bartunov wrote:
> On Tue, Jun 28, 2016 at 9:32 AM, Noah Misch wrote:
>> On Sun, Jun 26, 2016 at 10:22:26PM -0400, Noah Misch wrote:
>>> On Wed, Jun 15, 2016 at 11:08:54AM -0400, Noah Misch wrote:
>>> > On Wed, Jun 15, 2016 at 0
On Wed, Jun 29, 2016 at 6:17 AM, M Enrique
wrote:
> What's a good source code entry point to review how this is working for
> anyarray currently? I am new to the postgres code. I spend some time
> looking for it but all I found is the following (which I have not been able
> to decipher yet).
>
L
On Wed, Jun 29, 2016 at 7:23 PM, Yury Zhuravlev
wrote:
> Hello Hackers.
>
> I decided to talk about the current state of the project:
> 1. Merge with 9.6 master. 2. plpython2, plpython3, plperl, pltcl, plsql all
> work correctly (all tests pass).
> 3. Works done for all contrib modules. 4. You can
On Wed, Jun 29, 2016 at 2:51 AM, Stefan Keller wrote:
> Hi,
>
> FYI: I'd just like to point you to following two forthcoming standard
> parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on
> "Multi-Dimensional Arrays" (SQL/MDA).
>
> They define there some things different as already
On Tue, Aug 9, 2016 at 9:59 PM, Ryan Pedela wrote:
>
>
> I would say that it is worth it to have a "phrase slop" operator (Apache
> Lucene terminology). Proximity search is extremely useful for improving
> relevance and phrase slop is one of the tools to achieve that.
>
It'd be great if you exp
On Tue, Aug 16, 2016 at 1:03 AM, Ildar Musin wrote:
> Hi, hackers!
>
> There is a known issue that index only scan (IOS) can only work with simple
> index keys based on single attributes and doesn't work with index
> expressions. In this patch I propose a solution that adds support of IOS for
> in
Hi there,
I'm looking for the picture of PostgreSQL 9.1 poster, which we all signed
at Developers Meeting. Anybody knows where it's now ?
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head o
egards,
Alexander Korotkov.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www
ct?
One of the owners is Teodor, who is a core committer ... I hope he's not
MIA.
cheers
andrew
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternbe
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-
phere :)
Oleg
On Tue, 10 Jan 2012, Dave Cramer wrote:
Hi Oleg,
On Sun, Jan 8, 2012 at 1:19 PM, Oleg Bartunov wrote:
Dave,
The situation with pgshpere is so, that I think we need new developer, since
Janko keep silence :) I wrote him several time, since I wanted
pgsphere now could benefit very
On Tue, 10 Jan 2012, Jan-Benedict Glaw wrote:
On Sun, 2012-01-08 22:19:53 +0400, Oleg Bartunov wrote:
pgsphere now could benefit very much from our KNNGiST feature. This is
number one development from my point of view. I and Teodor have no
time to work on pgsphere, sorry. But, there are some
x27; the postmaster
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-1
On Mon, 26 Mar 2007, Florian G. Pflug wrote:
Oleg Bartunov wrote:
On Fri, 23 Mar 2007, Florian G. Pflug wrote:
Teodor Sigaev wrote:
For given schema and server's locale, it's possible to have several FTS
configurations, but the only one (with special flag enabled)
could be used
On Mon, 26 Mar 2007, Tom Lane wrote:
Oleg Bartunov writes:
On Fri, 23 Mar 2007, Florian G. Pflug wrote:
Isn't the real problem that only _one_ configuration per locale should
be marked as DEFAULT at any time, no matter what schema it is in?
I'm not sure I understand you corr
user work with view public.table_view, which is a view of
backend.table.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, R
P, which
downloaded FTSBOOK.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTE
or creating database: $rv\n" if ( $rv ne '0E0' );
$dbh->disconnect;
--- cut here -
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow Unive
On Wed, 9 May 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
I'm investigating a problem my client experienced with
"create database xxx with template=yyy" - they often get error
"ERROR: source database "yyy" is being accessed by other u
On Wed, 9 May 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
I tried that connecting to template1, but it doesn't helped. The problem
occurs even if I repeat 'drop;create' in one connection (the same backend).
Hmm. Do you have autovacuum turned on?
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Mo
should spend on many other things. We have no time even to discuss
those very useful threads about community management, patches, etc. We just
rely on community decision.
Regards,
Oleg
_____
Oleg Bartunov, Research Sci
On Tue, 15 May 2007, Joshua D. Drake wrote:
Oleg Bartunov wrote:
On Tue, 15 May 2007, Joshua D. Drake wrote:
Tsearch2 in core. I know that Tom has some reservations, he I and Treat
all commented on how it was done and to my knowledge those reservations
have not been resolved.
We'd li
On Tue, 15 May 2007, Joshua D. Drake wrote:
Oleg Bartunov wrote:
On Tue, 15 May 2007, Joshua D. Drake wrote:
Oleg Bartunov wrote:
On Tue, 15 May 2007, Joshua D. Drake wrote:
Tsearch2 in core. I know that Tom has some reservations, he I and Treat
all commented on how it was done and to my
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astr
e
approach above is not so useful.
As I mentioned, GIN is also powerful for array data type search, so I am
very expecting it will have additional information.
Anyway, thanks a lot for much information. I try to read it.
Regards,
Hitoshi Harada
-Original Message-----
From: Oleg Bartunov [mai
ers/concurrency/concurrency.pdf
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is your friend
Regards,
Oleg
_____
Oleg Bartunov, Resea
le/projects with application-dependent dictionaries.
How they could dump/reload their dictionaries ?
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomica
e errors.
Other side, that we need somehow to help user to identify what fts
configuration was used to produce tsvector. For example, comment on
tsvector column would be useful, but we don't know how to do this
automatically.
Regards,
Oleg
____
earch configuration is not a good idea
and we could just require it as a mandatory parameter, which could
eliminate many confusion with selecting text search configuration.
Regards,
Oleg
_____
Oleg Bartunov, Research
On Thu, 14 Jun 2007, Tom Lane wrote:
Oleg Bartunov <[EMAIL PROTECTED]> writes:
You're correct. But we can't defend users from all possible errors.
Other side, that we need somehow to help user to identify what fts
configuration was used to produce tsvector. For example, com
On Sun, 17 Jun 2007, Bruce Momjian wrote:
I have completed my first pass over the tsearch documentation:
http://momjian.us/expire/fulltext/HTML/sql.html
They are from section 14 and following.
I have come up with a number of questions that I placed in SGML comments
in these files:
On Wed, 20 Jun 2007, Bruce Momjian wrote:
Oleg Bartunov wrote:
On Sun, 17 Jun 2007, Bruce Momjian wrote:
I have completed my first pass over the tsearch documentation:
http://momjian.us/expire/fulltext/HTML/sql.html
They are from section 14 and following.
I have come up with a
On Wed, 20 Jun 2007, Bruce Momjian wrote:
Oleg Bartunov wrote:
On Wed, 20 Jun 2007, Bruce Momjian wrote:
Comments to editorial work of Bruce Momjian.
fulltext-intro.sgml:
it is useful to have a predefined list of lexemes.
Bruce, here should be list of types of lexemes !
Agreed. Are the
ument specification from documentation.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED],
need to remember setting tsearch_conf_name.
It could be solved using 'alter user ... set tsearch_conf_name' command though.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astr
27; and 'enable_stopwords').
Just use another configuration.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University
On Thu, 12 Jul 2007, alexander lunyov wrote:
Oleg Bartunov wrote:
alexander,
lc_ctype and lc_collate can be changed only at initdb !
You need to read localization chapter
http://www.postgresql.org/docs/current/static/charset.html
Yes, i knew about this, but i thought maybe somehow it can
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone
esn't saved in the index.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http:/
On Tue, 17 Jul 2007, Oleg Bartunov wrote:
On Tue, 17 Jul 2007, Bruce Momjian wrote:
I think the tsearch documentation is nearing completion:
http://momjian.us/expire/fulltext/HTML/textsearch.html
but I am not happy with how tsearch is enabled in a user table:
http
On Tue, 17 Jul 2007, Bruce Momjian wrote:
Oleg Bartunov wrote:
On Tue, 17 Jul 2007, Bruce Momjian wrote:
I think the tsearch documentation is nearing completion:
http://momjian.us/expire/fulltext/HTML/textsearch.html
but I am not happy with how tsearch is enabled in a user table
l, or specified by
GUC variable tsearch_conf_name. What could be simpler !
The question is do we need to define tsearch_conf_name automagically if
it's not defined ? I inclined don't do that and just issue error.
I believe this is enough error-prone.
Regards,
Ole
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83
think this the documentaiton is almost done:
http://momjian.us/expire/fulltext/HTML/textsearch-tables.html
---
Oleg Bartunov wrote:
On Wed, 18 Jul 2007, Bruce Momjian wrote:
Oleg, Teodor,
I am confused by the
.org
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
On Thu, 26 Jul 2007, Bruce Momjian wrote:
Oleg Bartunov wrote:
Bruce,
I sent you link to my wiki page with summary of changes
http://www.sai.msu.su/~megera/wiki/ts_changes
Your documentation looks rather old.
I have updated it to reflect your changes:
http://momjian.us/expire
On Thu, 26 Jul 2007, Bruce Momjian wrote:
Oleg Bartunov wrote:
On Wed, 25 Jul 2007, Erikjan wrote:
In
http://momjian.us/expire/fulltext/HTML/textsearch-intro.html#TEXTSEARCH-DOCUMENT
it says:
"A document is any text file that can be opened, read, and modified."
OOps, in m
rights. I'm asking don't forget about them !
There is no problem with current behaviour once user understand what he do.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.a
On Fri, 27 Jul 2007, Pavel Stehule wrote:
2007/7/27, Oleg Bartunov <[EMAIL PROTECTED]>:
On Fri, 27 Jul 2007, Pavel Stehule wrote:
1) Document the problem and do nothing else.
2) Make default_text_search_config a postgresql.conf-only
setting, thereby mak
still over-ride the default by specifying the configuration
in the function call.
This is ok, but it will not work in hosting environment and still
doesn't prevent errors.
Regards,
Oleg
_____
Oleg Bartunov, Re
On Mon, 30 Jul 2007, Bruce Momjian wrote:
Oleg Bartunov wrote:
OK, here is what I am thinking. If we make default_text_search_config
super-user-only, then the user can't do SET (using "zero_damaged_pages"
as a superuser-only example):
test=> set zero_damaged_pages =
t_search_config because of
this rare case.
Regards,
Oleg
PS.
Bruce, I'm in the mountains the Northern Caucasia and internet is
a bit unreliable :(
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.ast
201 - 300 of 976 matches
Mail list logo
