Re: [GENERAL] Postgresql connection on suse 10

Leonel Nunez wrote: edit your postgresql.conf and set the listen_address variable to your needs thanks Leonel, it is possible to setup subnet mask for postgresql through listen_address?? thanks, miso ---(end of broadcast)--- TIP 3:

[GENERAL] Postgresql connection on suse 10

hello, I installed PostgreSQL 8.0.3 on Suse 10 (x86_64). Firewall is down. telnet localhost 5432 result: x:/var # telnet localhost 5432 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. but telnet ip_address 5432 result: x: # telnet 158.195.xx.xx 5432 Trying

[GENERAL] tsearch2 unicode

hello, I have suse 9.3 with installed postgresql 8.0.3 from rpm. All my databases are unicode with locale sk_SK.UTF-8. I installed slovak ispell dictionary and tsearch2 is working very well. m13=# SELECT lexize('sk_ispell','Ivana'); lexize -- {ivana,ivan} (1 row) On the other

Re: [GENERAL] tsearch2 unicode

Oleg Bartunov wrote: Michal, tsearch2 doesn't supports UTF-8. It might works though. full support of UTF-8 and other features are planned http://www.sai.msu.su/~megera/oddmuse/index.cgi/todo hello Oleg, thanks for reply... is there any time plan for new release of tsearch2? miso

Re: [GENERAL] suse 9.2

martin wrote: i try to find a new postgre rpm package for suse 9.2 but i didnt find some. ftp://ftp.suse.com/pub/projects/postgresql/ select postgresql version first and then suse version... miso ---(end of broadcast)--- TIP 9: the planner will

[GENERAL] jdbc3 and ResultSet.getFetchSize()

helo, I have this code: ResultSet rs = stmt.executeQuery(SELECT attr FROM table WHERE id=1); System.out.println(rs.getFetchSize()); rs.getFetchSize() everytime returns 0... why??? thanx, miso ---(end of broadcast)--- TIP 9: the planner will

[GENERAL] create user with database and contrib

hello, is there some simple way, how to do this??? I need to create user 'diplo' with no database create and no add users privileges... createuser -A -D -P -E -U root diplo after that I create database 'diplo'; I need to import ltree into database 'diplo' with user diplo, but I can't add

Re: [GENERAL] create user with database and contrib

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? ---(end of broadcast)--- TIP 7: don't forget to

[GENERAL] GUID data type support

does postgresql supports GUID data type??? I think, that it is slow to use GUID as varchar... thanks, miso ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Lower case

Tino Wildenhain wrote: Hi, On Wed, 2005-01-26 at 12:01 +, Vladimir S. Petukhov wrote: Hi! Sorry for my English.. I want to do case-insensitivity search, like this ... WHERE lower (column_name) LIKE lower (%value%); This work fine for English.. But i need search for Russian words, lower()

[GENERAL] PostgreSQL users on webhosting

hello, we have some webhosting servers and we can start postgresql support... I need to create for one webhosting account one postgresql account, which will have access only to databases created byh this postgresql account. I know, that it is no problem in mysql... thanx, miso

Re: [GENERAL] Stored procedure failure

Michal Hlavac wrote: hello, I have interesting problem... I have stored procedure, which works good, but only if input is correct. Correct input is, when $1 is id, which exists in table... If I put non exists id, database fall down and restart with this error: server closed the connection

Re: [GENERAL] Stored procedure failure

Richard Huxton wrote: Looking at the 8.0beta source, the functions (...ltree_isparent) are all marked strict so they should just return null on a null parameter. What happens if you set my_path to some non-null but un-matched value before the problem line? When my_path have non-null value,

[GENERAL] 7.4.5 release

Hello, is this version ftp://ftp.postgresql.org/pub/src/7.4.5/ stable release ??? thanx -- [ miso hlavac ][ [EMAIL PROTECTED] ][ http://www.medium13.sk ] [ icq:94900232 ][ callto://hlavki ] ---(end of broadcast)--- TIP 2: you can get off all

[GENERAL] Index Using

hello, I have in db table with 3 columns... table name is l_model_to_part columns: i_model_id, i_part_id, i_year I have index on every column separately and primary key is (i_model_id, i_part_id, i_year) when I use: EXPLAIN SELECT * FROM l_model_to_part WHERE i_part_id=234;

Re: [GENERAL] Index Using

Michal Hlavac wrote: my question is, why postgres doesn't use index_50 in second query??? when I create this structure in clear db, everything is all right... of course, index_50 is BTREE index with one column (i_model_id)... thanx, hlk -- [ miso hlavac ][ [EMAIL PROTECTED] ][ http://hlavki.sk

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

Dias Bantekas wrote: does any one know how to get an md5()-like hash function using pgcrypto for postgresql 7.3 ? without upgrading to 7.4 Thanks for any input. SELECT encode(digest(v_password, 'md5'), 'hex'); hlk ---(end of broadcast)--- TIP 8:

[GENERAL] Filesystem vs. Postgres for images

Hello, I am working on web portal. There are some ads. We have about 200 000 ads. Every ad have own directory called ID, where is 5 subdirectories with various sizes of 5 images. Filesystem is too slow. But I don't know, if I store these images into postgres, performace will grow. Second question

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

I think, that all is about key management. You can store your data with strong RSA encryption. On server you will have only public key and on client PC private key. it's not so easy to use, but it's more secure than symmetrical cipher. miso ---(end of

[GENERAL] Optimize query

Hello, I have one main table and 2 many-to-many relation tables and 2 one-to-many relation table. Main table has 150 000 rows and many-to-many tables have about 300 000 rows. I am creating web portal. In my query I must call distinct with many-to-many relation. But this query is too slow for web

[GENERAL] Array in stored procedure

DECLARE groups integer[]; tmp RECORD; tmpi integer; BEGIN FOR tmp IN SELECT i_group_id FROM l_group_to_user WHERE i_user_id = $1 LOOP SELECT i_group_id INTO tmpi FROM s_group WHERE i_group_id = tmp.i_group_id; groups[] := tmpi; RETURN NEXT tmp.i_group_id; END LOOP; RETURN