Re: [GENERAL] Is This A Set Based Solution?

roadcast)--- TIP 2: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute,

Re: [GENERAL] Sw to generate ER model

http://archives.postgresql.org/ 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.

Re: [GENERAL] GIST index on geometry+integer

your joining column's datatypes do not match Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet:

Re: [GENERAL] Slow running to_tsvector (tsearch2 in PG 8.2.3)

ation ? to_tsvector does a lot of work. Regards, Henrik ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scie

Re: [GENERAL] tsearch2 parser configuration

rds, 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-

Re: [GENERAL] "simple" dict with stop words in tsearch2

{} (1 row) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ Regards, Oleg _____ Oleg Bar

Re: [GENERAL] Avoiding empty queries in tsearch

increase your free space map settings Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http:/

Re: [GENERAL] 8.2.1 TSearch changes?

ply it for minor version. 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.

Re: [GENERAL] Does pgsql's regex processor optimize Common-Prefix?

s appreciated. Thank you and appologize for my poor English. Compared to the use of indexes to skip whole table scanning, this optimization is going to have very little impact. So don't worry about it. Regards, Oleg __

Re: [GENERAL] Let's play bash the search engine

to me... for example keywords like AND, OR etc. Ah, I forgot about them. Now, with GiN we could definitely try stop-words free search ! - thomas Regards, Oleg _ Oleg Bartunov, Research Scientist, Hea

Re: [GENERAL] Let's play bash the search engine

llow pg_dict dictionary. 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/~me

Re: [GENERAL] Let's play bash the search engine

an select multiple places to search. Eg. search in 8.2 release, 8.0 release, ans as just suggested by Alvaro, pgsql-hackers mailing list also. Too many check-boxes :) Better to have pull-down menu with multiple selections. Regards, Oleg ____

Re: [GENERAL] Let's play bash the search engine

ay <8.2 Documentation>. 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/~mege

Re: [GENERAL] Let's play bash the search engine

7;url', 'sfloat', 'uri', 'float','word') and ts_name = 'pg'; //Magnus ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg __

Re: [GENERAL] tsearch2: pg8.1 to pg8.2

necessary steps to convert to the upgraded tsearch2? ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg ____

Re: [GENERAL] Tsearch2 / PG 8.2 Which stemmer files?

with: stem_UTF_8_german.c stem_UTF_8_german.h from: http://snowball.tartarus.org/dist/libstemmer_c.tgz gives: http://hannes.imos.net/make.txt Thanks! Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [GENERAL] unaccent as stored procedure?

ember whet did I get it. Thanks, -Steve ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scientist, He

[GENERAL] GiN for 8.1 patch updated

/ 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

Fix for 8.2 release. Was: [GENERAL] Problems to create the portuguese dictionary

message can get through to the mailing list cleanly Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia In

Re: [GENERAL] Problems to create the portuguese dictionary

ds, 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-16-83, +007(495)939-23-83

Re: [GENERAL] Using GIN indexes on 8.2

use GIN for archive search and GiST for online one. Table inheritabce with CE would help maintaining of good search performance and fast update. Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.

Re: [HACKERS] [GENERAL] Index greater than 8k

On Fri, 3 Nov 2006, Joshua D. Drake wrote: Oleg Bartunov wrote: Gregory, All you described you do with fti is possible with tsearch2. Just need some think, of course. If you don't need stemming, just don't use it, if you need something like %txt%, just write simple dictionary, whi

Re: [HACKERS] [GENERAL] Index greater than 8k

uses another signature calculations. And, there are some tips and trics: removing HTML marking,removing punctuation, lowercasing text and so on - it's interesting and complex task. Regards, Oleg _ Oleg Bartun

Re: [HACKERS] [GENERAL] Index greater than 8k

hua D. Drake 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/~m

Re: [GENERAL] old Pg interface

On Mon, 16 Oct 2006, Oleg Bartunov wrote: I added some compatibility functions and it worked with new PostgreSQL. Sorry, I got confused :) I added them to wdb interface Let me know if you need it Oleg On Mon, 16 Oct 2006, Brandon Metcalf wrote: I'm currently using version 1.9.0 of th

Re: [GENERAL] old Pg interface

ed to upgrade PostgreSQL before this is going to happen. Does anyone know of any issues with continuing to use the old Pg interface with newer versions of PostgreSQL? Thanks. Regards, Oleg _ Oleg Bartunov, Res

Re: [GENERAL] Tsearch2 & Hebrew

;ideal" one: ispell, stemmer Of course, some words will not recognized and will leave as is. Also, you may write very simple stemmer using collection of very common endings. Oleg Oleg Bartunov wrote: On Tue, 5 Sep 2006, Yonatan Ben-Nes wrote: Hi all, Well my problem was that I di

Re: [GENERAL] Tsearch2 & Hebrew

h I can use but I can't seem to find one, so sadly one of the best features of Tsearch2 isn't working for me. Do you use hebrew ispell dictionary ? If I'm wrong please let me know :) Thanks a lot in advance, Yonatan Ben-Nes Oleg Bartunov wrote: You need to provide mor

Re: [GENERAL] Two billion records ok?

pm, Oleg Bartunov wrote: Nick, if you need very fast spatial queries (spherical) you may use our Q3C module for POstgreSQL (q3c.sf.net). We use it for providing access to very big astronomical catalogs. Oleg On Tue, 5 Sep 2006, Nick Bower wrote: We're considering using Postgresql for st

Re: [GENERAL] Two billion records ok?

ostgresql.org 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/~

Re: [GENERAL] Tsearch2 & Hebrew

ebian GNU/Linux Consultant Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su,

Re: [GENERAL] TSearch: Need debug help

erman snowball stemmer, dictionary used is http://hannes.imos.net/german_iso.med (From OpenOffice) What causes some words to result in `sen', though they don't contain that lexem? Thanks! Regards, Oleg ___

Re: [GENERAL] TSearch vs. Homebrew

On Tue, 27 Jun 2006, Hannes Dorbath wrote: On 27.06.2006 13:31, Oleg Bartunov wrote: On Tue, 27 Jun 2006, Hannes Dorbath wrote: http://www.symfony-project.com/askeet/21 How does this dead simple approach compare to TSearch performance / scaling wise? You miss the main point in tsearch2

Re: [GENERAL] TSearch vs. Homebrew

of these features, so it could use some well known optimization and, and so, scales better. If you don't need ACID, metadata access, why do you need database at all ? Regards, Oleg _ Oleg Bartunov, Res

Re: [GENERAL] Computing transitive closure of a table

ks, 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/

Re: [GENERAL] minimizing downtime when upgrading

/docs/faq 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

Re: [GENERAL] Compound words giving undesirable results with tsearch2

ach other or in completely different parts of the text being indexed. In many situations, this will lead to a lot of 'false' matches, seen from a user perspective. Ideas on how to handle this problem will be much appreciated. this is where order by relevance should helps.

Re: [GENERAL] Use of ISpell dictionaries with tsearch2 - what is

y solve > the same problem? Ask linguists :). ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scientist, Hea

Re: [GENERAL] Please comment on the following OpenFTS/tsearch2

log and we could get 1mln search/day on 8Gb RAM server. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg ____

Re: [GENERAL] full text indexing

Chris, try REL8_1_STABLE branch, because you save a lot of time of indexing Oleg On Fri, 17 Mar 2006, Chris wrote: Oleg Bartunov wrote: On Wed, 15 Mar 2006, chris smith wrote: Hi all, Just wondering which full text module is better & what the differences are between tsearch and fti ?

Re: [GENERAL] Indexes on array columns

explain analyze is your friend 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.s

Re: [GENERAL] full text indexing

gick.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), S

Re: [GENERAL] Tsearch2 ranking

y to make a difference between those to rows? Any? Even if it's a bad hack? I really need it :/ Thanks in advance Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg

Re: [GENERAL] Operator for int8 array

regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg _ Oleg Bartunov, Research S

Re: [GENERAL] TSearch2 / German compound words / UTF-8

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-16-83, +007(495)939-

Re: [GENERAL] TSearch2 / German compound words / UTF-8

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-16-83, +00

Re: [GENERAL] TSearch2 / German compound words / UTF-8

trekksgrilldresser" example from the tsearch2:compounds tutorial, that I cannot reproduce). Any hints? Alexander ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your

[GENERAL] tsearchd (tsearch2 daemon) is available for playing

umentation is available http://www.sai.msu.su/~megera/oddmuse/index.cgi/tsearchd Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [GENERAL] full text search

searched our list archives? http://archives.postgresql.org Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University

Re: [GENERAL] is it possible to delete the psql log while psql is

rst, and only delete the logfile after that? thanks, gabor Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia I

Re: [GENERAL] TSearch2 / Get all unique lexems

On Thu, 8 Dec 2005, Hannes Dorbath wrote: On 07.12.2005 16:13, Oleg Bartunov wrote: hmm, you could dump tsvector column and use awk+sort+uniq Thanks. I hoped for something possible inside a pl/pgsql proc. I'm trying to integrate pg_trgm with Tsearch2. I'm still on my UTF-8 datab

Re: [GENERAL] fts, compond words?

bout tokens that come before? Just a thought. Andy ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Regards, Oleg ___

Re: [GENERAL] TSearch2 / Get all unique lexems

_ 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-16-83, +007(495)939-23-83

Re: [GENERAL] tables with lots of columns - what alternative from

with 700 column (i have more :) - then i must have missed something absolutelyl simple, fast and elegant. what is this? depesz Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

[GENERAL] ltree patch is available

, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [GENERAL] fts, compond words?

improving, but not for your case. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)9

Re: [GENERAL] fts, compond words?

roadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly Regards, Oleg __

Re: [GENERAL] intarray index

g_ops Thanks. ML ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Regards, Oleg _____ Oleg Bartunov,

Re: [GENERAL] tool for DB design

f broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Int

Re: [GENERAL] tsearch2: more than one index per table?

gist/tsearch/V2/docs/tsearch-V2- intro.html See the section "TSEARCH2 CONFIGURATION". It explains, and has examples on how to set this up. ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards,

Re: [GENERAL] TSearch2 / German compound words / UTF-8

h for 8.1 will be available from our site as soon as we complete UTF-8 support for CVS HEAD. We have no deadlines yet, but we have discussed support of this project with OpenACS community (grant from University of Mannheim), so it's possible that we could complete it really soon (we have no

Re: [GENERAL] tsearch2: more than one index per table?

ARCH2 CONFIGURATION". It explains, and has examples on how to set this up. I added paragraph about this problem, check my notes http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes Regards, Oleg _ Ole

Re: [GENERAL] tsearch2: more than one index per table?

database locale, update pg_ts_cfg.locale in wished row to correct value. Actually, it's described in tsearch2 introduction. Make sure pg_ts_cfg.locale matched server's locale (see 'show all') Regards, Oleg __

Re: [GENERAL] TSearch2 Questions

ex on top of inverted index. But this is long-term plan. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su,

Re: [GENERAL] Custom GIST getting ERROR: too many LWLocks taken

like you're leaking locks. 100 locks is a maximum number of simultaneous locks (backend/storage/lwlock.c). Thanks. Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astro

Re: [GENERAL] Tsearch2: casting text to tsquery

On Wed, 16 Nov 2005, Alexander Presber wrote: Am 16.11.2005 um 13:52 schrieb Oleg Bartunov: On Wed, 16 Nov 2005, Alexander Presber wrote: Hello, I have a question that arose while using tsearch on a large database of book information. In order to inject unstemmed + stemmed versions of

Re: [GENERAL] Tsearch2: casting text to tsquery

incerely yours Alexander Presber ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of A

Re: [GENERAL] using new bitmap scans to index bit columns?

You can use GiST to do that. TJ O'Donnell ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg _

Re: [GENERAL] which charset use for cyrilic?

alid byte sequence for encoding "UNICODE":..." Regards, Zet ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _____ Oleg Bart

Re: [GENERAL] tsearch2 setweight

asses, but then you'll increase storage for tsvector. tnks!!! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster Regards, Oleg _

Re: [GENERAL] Tsearch & functional indexes

-- TIP 5: don't forget to increase your free space map settings Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: o

Re: [GENERAL] How to inject knowledge into a Postgres database

Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 --

Re: [GENERAL] Slow search.. quite clueless

speed, if anyone got a better idea ill be glad to hear it. what's your actual query ? have you tried multicolumn index ? Anyway thanks alot everyone! Ben-Nes Yonatan Regards, Oleg _____ Oleg Bartunov,

Re: [GENERAL] tsearch2 for alphabetic character strings & codes

(and if so, could someone please point me in the right direction), or are there other things I should be looking to. Ron ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Regards, Ole

Re: [GENERAL] Slow search.. quite clueless

n advance, Yonatan Ben-Nes ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly R

Re: [GENERAL] Slow search.. quite clueless

ng/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaste

Re: [GENERAL] PostgreSQL and XML support

ou need some advanced query capabilities? Like XQuery, XPath 2.0 No. - Do you need some advanced update capabilities? Like node-level updates No. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of Astr

Re: [GENERAL] tsearch2 & unicode

nks, miso ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astro

Re: [GENERAL] Out Of Memory Error on GiST Index

---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of Astr

Re: [GENERAL] Searching for LTree dmoz-testdata

tgres community and I'm looking for a actually (4 days ago?) vanished website from Teodor Sigaev and Oleg Bartunov (ex: http://www.sai.msu.su/~megera/postgres) Bside tsearch2 they have worked on LTree (googlecache: http://64.233.183.104/search?q=cache:AynIHdkXWGMJ:www.sai.msu.su/~megera

Re: [GENERAL] Adjacency List & total item counts

)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Regards, Oleg _ Oleg Bar

Re: [GENERAL] tsearch2: very slow queries

---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of A

Re: [GENERAL] tsearch2 frequent updates

ll ignore your desire to choose an index scan if your joining column's datatypes do not match Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institu

Re: [GENERAL] fts error

tu cuenta ya! - http://correo.yahoo.com.ar ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg ____

Re: [GENERAL] tsearch2 and case

/faq Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [GENERAL] Transparent i18n?

an if your joining column's datatypes do not match Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai

Re: [GENERAL] tsearch2 errors after db move

_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [GENERAL] Finding points within 50 miles

rds, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23

Re: [GENERAL] [SQL] Set Membership operator -- test group membership

mand (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.ms

Re: [GENERAL] Limits of SQL

gresql.org Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(

Re: [GENERAL] How to add an INHERITS to an already populated table

On Tue, 31 May 2005, Oleg Bartunov wrote: look on pg_inherits table and pg_class.relhassubclass. More info http://www.pgsql.ru/db/mw/msg.html?mid=2044343 example: create table t (i int4); create table t1 (i int4); create table t2 (i int4); -- mark 't' has children tables updat

Re: [GENERAL] How to add an INHERITS to an already populated table

solution is probably to script some ALTER TABLE ADD COLUMN commands. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet

Re: [GENERAL] Tsearch2 lexeme position

y your own ranking function. Do you really need it ? greeds Peter Schmelzer ---(end of broadcast)--- TIP 8: explain analyze is your friend Regards, Oleg _ Ole

Re: [GENERAL] Interesting article on transactional algorithms includes

nd of broadcast)--- TIP 8: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet:

Re: [GENERAL] Problem with GIST-index and timestamps

Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(e

Re: [GENERAL] List of Functions

the mailing list cleanly ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of As

Re: [GENERAL] Strange interaction of union and expressions

elect foo from b; Produces this output: foo --- "baz" woof (2 rows) I would expect the following instead: foo --- "baz" "woof" (2 rows) Is this a known issue? Has it been fixed? Thanks, Regards, Oleg ___

Re: [GENERAL] Foreign Keys Question

ias Loitsch Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-

Re: [GENERAL] Log File Maintainance

ate your syslog.conf and restart syslogd Add a line like: local0.* /var/log/pgsql probably, better -/var/log/pgsql Read the man page(s) for details. Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of

Re: [GENERAL] create user with database and contrib

On Sat, 9 Apr 2005, Michal Hlavac wrote: Oleg Bartunov wrote: so, what's the problem ? psql diplo < ltree.sql ok, I can add ltree via superuser, but I must grant access for user diplo to every function... it is possible to do that easier? Did you try what I recommend you ? It shou

<    1   2   3   4   5   >