Re: [GENERAL] ERROR: could not open file "pg_subtrans...

> > I have Postgres 8.1.3 running on Windows XP. I keep seeing this error in > > the log files: > > Update to 8.1.3. I'm sure Alvaro means 8.1.10.. > Better yet, update to 8.2.5, as 8.1 is unsupported on Windows. > > http://www.postgresql.org/about/news.865 Since we haven't released 8.3 yet,

Re: [GENERAL] SLOW Remote Connection to PostgreSQL Database

On 10/4/07, Chris <[EMAIL PROTECTED]> wrote: > Matt White wrote: > > Hello, > > > > I am running a Rails app on server1 that connects to dbserver where > > the database is. There is another server, server2, that connects to > > dbserver quickly and returns quickly no matter how high dbserver's > >

Re: [GENERAL] Embedding code in Postgres source code

2007/10/7, Harpreet Dhaliwal <[EMAIL PROTECTED]>: > Faster by calling external or internal libraries. my concept was calling > libraries internal to the system would make it faster right ? > I thing, so it's not true, because all libraries functions are directly called. It is different than Micros

Re: [GENERAL] Embedding code in Postgres source code

Faster by calling external or internal libraries. my concept was calling libraries internal to the system would make it faster right ? On 10/7/07, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > 2007/10/7, Harpreet Dhaliwal <[EMAIL PROTECTED]>: > > My stored procedure is in Perl. Does that really mak

Re: [GENERAL] Embedding code in Postgres source code

2007/10/7, Harpreet Dhaliwal <[EMAIL PROTECTED]>: > My stored procedure is in Perl. Does that really make any difference ? > It depends. If you call external libraries you can be little bit faster. You have to test it. Pavel > On 10/7/07, Pavel Stehule <[EMAIL PROTECTED] > wrote: > > Hello > >

[GENERAL] German soundex

Hi Is there a german version of soundex available? I read it's called "Cologne Algorithm" - but i can't find anything. Best regards michael ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subsc

Re: [GENERAL] Sql problem

On Oct 7, 2007, at 9:44 AM, Anton Andreev wrote: Hi, Can you tell me more about Postgresql string functions? Have you had a look at http://www.postgresql.org/docs/8.2/interactive/ functions-string.html? I want to replace a column text "1/2/3/8/" to the corresponding values to these value

[GENERAL] Sql problem

Hi, Can you tell me more about Postgresql string functions? I want to replace a column text "1/2/3/8/" to the corresponding values to these values like "A, B, C, D". Cheers, Anton Andreev ---(end of broadcast)--- TIP 4: Have you searched our l

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

After takin a swig o' Arrakan spice grog, michi <[EMAIL PROTECTED]> belched out: > Does PostgreSQL store records sorted by primary key? No. It initially stores tuples based on the order in which they are inserted. Behaviour changes later when a table has free space due to deleted tuples. -- let

Re: [GENERAL] Install fails on Debian sid

Joe Masters wrote: > Cannot get Postgres 8.2 working on Debian sid using the Debian package. > At the config stage I get a message telling me to run:- > pg_createcluster 8.2 main --start > > Doing this (as root) produces the following output:- > > Creating new cluster (configuration: /etc/pos

Re: [GENERAL] Embedding code in Postgres source code

My stored procedure is in Perl. Does that really make any difference ? On 10/7/07, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > Hello > > If your stored procedure is writen in C language, then storing it > inside PostgreSQL hasn't any benefit. There is only one difference .. > loading library need

Re: [GENERAL] Embedding code in Postgres source code

Hello If your stored procedure is writen in C language, then storing it inside PostgreSQL hasn't any benefit. There is only one difference .. loading library needs some time, but you can load any library with statement LOAD. Regards Pavel Stehule 2007/10/7, Harpreet Dhaliwal <[EMAIL PROTECTE

[GENERAL] Install fails on Debian sid

Cannot get Postgres 8.2 working on Debian sid using the Debian package. At the config stage I get a message telling me to run:- pg_createcluster 8.2 main --start Doing this (as root) produces the following output:- Creating new cluster (configuration: /etc/postgresql/8.2/main, \ data: /var/li

[GENERAL] Embedding code in Postgres source code

Hi, I have a stored procedure that gets called every now and then in my system. This stored procedure is an implementation of client socket code basically. If somehow this stored procedure becomes a part of Postgres source code, would it really make any difference as far as performance and resour

Re: [GENERAL] windows and pg 8.2 (change database to another server)

Hi Magnus and all people... And yes, it shoul dbe set on the file and all subdirs. Use the checkbox to overwrite all permissions on subdirs, that's the fastest way. //Magnus Sorry my delay but I was very busy last week. In general, giving windows Postgres user Change right do the trick bu

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

michi wrote: >Does PostgreSQL store records sorted by primary key? Only after you cluster the table: Rainer ---(end of broadcast)--- TIP 6: explain analyze is your friend