Re: [GENERAL] can't create index with 'dowcast' row

Louis what if you create one wrapper function immutable? some thing like this. CREATE OR REPLACE FUNCTION myextract(timestamp ) RETURNS date AS $BODY$ BEGIN return extract(date from $1) ; END; $BODY$ LANGUAGE 'plpgsql' IMMUTABLE best regards mdc --- Louis-David Mitterrand

Re: [GENERAL] can't create index with 'dowcast' row

Sorry forgot to mention later try CREATE UNIQUE INDEX visit_idx ON visit_buffer( id_session, id_story ,myextract(created_on)); best regards Louis what if you create one wrapper function immutable? some thing like this. CREATE OR REPLACE FUNCTION myextract(timestamp ) RETURNS

[GENERAL] postgres 8.3 rc-1 ispell installation problem

hi folks i've tried to install ispell for CREATE TEXT SEARCH DICTIONARY spanish_ispell ( TEMPLATE = ispell, DictFile = spanish, AffFile = spanish, StopWords = spanish ); sentence, but, one error ocurrs ERROR: syntax error at line 432 of affix file

Re: [GENERAL] postgres 8.3 rc-1 ispell installation problem

Teodor i've tried with openoffice.org but whitout success, :) ERROR: invalid byte sequence for encoding UTF8: 0xe16261 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, i've tried too with convmv -f iso-8859-1 --notest -t utf-8

Re: [GENERAL] postgres 8.3 rc-1 ispell installation problem

Thanks Teodor for quick response,and your work That's right, but you should convert dictionary and affix file in UTF8 encoding. how to i can do it? best regards MDC Yahoo! Encuentros. Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros

Re: [GENERAL] postgres 8.3 rc-1 ispell installation problem [RESOLVED]

Thanks Alvaro iconv -f iso-8859-1 -t utf-8 es_ES.dict es.dict works!! --- Alvaro Herrera [EMAIL PROTECTED] escribió: marcelo Cortez escribió: i've tried too with convmv -f iso-8859-1 --notest -t utf-8 es_ES.dic whitout success too. convmv only recodes the name

[GENERAL] 8.3beta bug or feature?

folks the follow queries work in postgres 8.2 but in 8.3beta don't work SELECT c.* FROM c WHERE c.numero LIKE '1%'; i think automatic conversion of numeber to text is the problem , in 8.3beta don't work numero field is integer type any ideas? best regards mdc ps:PostgreSQL

Re: [GENERAL] 8.3beta bug or feature?

( not manual code here). there any way simulate previous behavior? (automatic conversion), create cast can help? best regards. mdc Regards Pavel Stehule On 10/01/2008, marcelo Cortez [EMAIL PROTECTED] wrote: folks the follow queries work in postgres 8.2 but in 8.3beta don't work

Re: [GENERAL] 8.3beta bug or feature?

Alvaro --- Alvaro Herrera [EMAIL PROTECTED] escribió: marcelo Cortez escribió: Pavel --- Pavel Stehule [EMAIL PROTECTED] escribió: Hello, it isn't bug. You have to cast to string before. http://www.postgresql.org/docs/8.3/static/release-8-3.html E.1.2.1

Re: [GENERAL] 8.3beta bug or feature?

Alvaro --- Alvaro Herrera [EMAIL PROTECTED] escribió: marcelo Cortez escribió: Pavel --- Pavel Stehule [EMAIL PROTECTED] escribió: Hello, it isn't bug. You have to cast to string before. http://www.postgresql.org/docs/8.3/static/release-8-3.html E.1.2.1

[GENERAL] double free corruption?

Folks i received the follow message from backend ,it's this a bug? best regards and happy new year MDC pd: any clue are welcomed. *** glibc detected *** postgres: postgres richelet 201.235.11.133(2504) SELECT: double free or corruption (!prev): 0x0845d7e8 *** === Backtrace:

Re: [GENERAL] double free corruption?

8.3beta3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1) i'ts correct GCC version? best regards. MDC pd: gdb can help? ( for debugging my own code) links about howto debug? --- Tom Lane [EMAIL PROTECTED] escribió: marcelo Cortez [EMAIL PROTECTED] writes

[GENERAL] postgres8.3beta encodding problem?

Folks select chr(165); ERROR: requested character too large for encoding: 165 it's one old scrip if not remember wrong works postgres in 8.2.4 any clue? best regars mdc info: select version(). PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)

[GENERAL] 8.3 beta FATAL: invalid value for parameter timezone_abbreviations: Default

folks i've installed 8.3beta but at start up receive FATAL: invalid value for parameter timezone_abbreviations: Default any clue? best regards. MDC info: Linux richelet-internet 2.6.21.6 #9 SMP Sun Dec 2 17:52:20 ART 2007 i686 Pentium III (Coppermine) GenuineIntel GNU/Linux gp_config

Re: [GENERAL] 8.3 beta FATAL: invalid value for parameter timezone_abbreviations: Default

Alvaro ,folks --- Alvaro Herrera [EMAIL PROTECTED] escribió: marcelo Cortez escribió: folks i've installed 8.3beta but at start up receive FATAL: invalid value for parameter timezone_abbreviations: Default Do you have a file named Default on the share/timezonesets dir

Re: [GENERAL] Tsearch2 - spanish

Felipe --- Felipe de Jesús Molina Bravo [EMAIL PROTECTED] escribió: Hi You are rigth, the output of show lc_ctype; is C. Then I did is: prueba1=# show lc_ctype; lc_ctype - es_MX.ISO8859-1 (1 row) and do it % initdb -D /YOUR/PATH -E LATIN1 --locale

[GENERAL] help with tsearch2 stem compile

hi all i'm using postgresql 8.2.4 and install tsearch2 , but i need spanish idiom. following http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/README.gendict and downloading http://snowball.tartarus.org/algorithms/spanish/stemmer.html stem.c and stem.h ./config.sh -n pt -s -p

[GENERAL] tsearch2 on postgres8.2.4

Hi all has anybody created using Gendict generate dictionary in spanish successful ?. __ Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). ¡Probalo ya!

Re: [GENERAL] troubble with contrib compile

Tom Thanks works fine! best regards mdc --- Tom Lane [EMAIL PROTECTED] escribió: marcelo Cortez [EMAIL PROTECTED] writes: i downloaded postgres8.2.4 sources , expand and ./configure and install with success. Now i need one module from contrib directory , fuzzystrmatch cd

[GENERAL] troubble with contrib compile

hi all i downloaded postgres8.2.4 sources , expand and ./configure and install with success. Now i need one module from contrib directory , fuzzystrmatch cd /postgres/contrib/fuzzymatchstr [ ok ] make throws make Makefile:15: ../../src/Makefile.global: No such file or directory

Re: [GENERAL] PostgreSQL Installer for Windows x64

Magnus , folks The only caveat i found in winxp64 is with psqlODBC my application dont work very well on it into xp64 platform, the work around was change odbc profile in favor of dns file , with dns file my application return to work, ok. BTW i using linux server without problems, but my

[GENERAL] help with libpq program

folks i need help with libpq program ,i made on C program for wrapper libpq.dll program , the routine failing is copy from stdin interface. PQputCopyData return 1 (AKA ok) PQputCopyEnd return 1 (AKA ok) but nothing is append to database. tailing log file invalid input syntax for integer:

Re: [GENERAL] help with libpq program

not match the delimiter from your copy statement. -Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-general- [EMAIL PROTECTED] On Behalf Of marcelo Cortez Sent: Saturday, June 16, 2007 9:04 PM To: pgsql-general@postgresql.org Subject: [GENERAL] help with libpq program

Re: [GENERAL] initdb

Hi Jhon Diferent distros put file in diferent path try /usr/local/pgsql/initdb bla bla bla or /var/lib/postgres/bin/initdb bla bla bla or locate initdb for locate that file best regards mdc --- John K Masters [EMAIL PROTECTED] escribió: I feel somewhat embarrassed to post this

[GENERAL] help with query...

Folks I am confused , way planer it does not use the partial index? query: SELECT cliente_base.* FROM cliente_base WHERE (cliente_base.inst_class_ = 'Cliente' ) ORDER BY cliente_base.nombre ASC plan: QUERY PLAN

[GENERAL] help with query

Folks I am confused , way planer it does not use the partial index? any help be appreciated pd: sorry for my english. data: table definition: -- Table: cliente_base CREATE TABLE cliente_base ( id_ integer NOT NULL, activo boolean, numero integer, categ character

Re: [GENERAL] dns less connection

this, even psqlodb installed. Any suggestion will be appreciated? best regards MDC --- Magnus Hagander [EMAIL PROTECTED] escribió: On Mon, May 14, 2007 at 08:46:23PM -0300, marcelo Cortez wrote: hi all there any was successful with connect to postgres with psqlodbc in dsn less mode

Re: [GENERAL] dns less connection

at least for ADODB. DAO had it like this: ODBC;Driver=PostgreSQL UNICODE;DATABASE=X1;SERVER=X2;PORT=X3;UID=X4;PWD=X5;X6; marcelo Cortez schrieb: Hi folks Magnus thanks for respond, but i can't success full with this. Hi think it's string connection mater, but can't connect

[GENERAL] dns less connection

hi all there any was successful with connect to postgres with psqlodbc in dsn less mode? It's wrong list for this subject? any pointer be appreciated best regards mdc __ Preguntá. Respondé. Descubrí. Todo lo que querías saber, y

[GENERAL] nedd help bytea encode

folks I need help my client application need to save rtf text format, i'm codding string data into bytea format by hand but without success need some body check this input sample data: '{\rtf1\ansi }' output codding

Re: [GENERAL] string fields helps

Thanks Tom! this works. best regards MDC --- Tom Lane [EMAIL PROTECTED] escribió: Bill Moran [EMAIL PROTECTED] writes: marcelo Cortez [EMAIL PROTECTED] wrote: I need to save data on rtf format but , postgres refuses to storage for backslah or character's problem's any idea

[GENERAL] string fields helps

Folks I need to save data on rtf format but , postgres refuses to storage for backslah or character's problem's any idea or vice are welcomed best regards mdc pd: sample off data to save ( from postgres log) UPDATE plbrecord SET documentation =

Re: [GENERAL] PGSQL 8.2.3 Installation problem

on a Fat32 partition and gave the data directory path to an NTFS partition. I have not set any file permissions. Installing as a default postgres user. Paul Lambert-2 wrote: marcelo Cortez wrote: hi there same things occurs to me. Any body install win32 version with success

Re: [GENERAL] PGSQL 8.2.3 Installation problem

:/Archivos de programa/PostgreSQL/8.2/data note path is truncated in message ??? file not exists i delete directory one more time thanks best regardsd mdc --- Paul Lambert [EMAIL PROTECTED] escribió: marcelo Cortez wrote: Magnus I have NTFS only , i don't have FAT partitions at all

Re: [GENERAL] PGSQL 8.2.3 Installation problem

hi there same things occurs to me. Any body install win32 version with success??? best regards MDC --- RPK [EMAIL PROTECTED] escribió: When I run the setup of PGSQL 8.2.3, it displays error while initializing database cluster. Error displayed is: Failed to execute initdb. Unable to

[GENERAL] Help with install postgres 8.2 win32 version

folks I can't install postgresql on winxp profesional Installer fail ( creating cluster) Installer with out cluster . ok creating cluster on hand .fail initdb The files belonging to this database system will be owned by user postgres. This user must also own the server process. The

Re: [GENERAL] How to preserve characters with accent?

Hi there --- Peter Eisentraut [EMAIL PROTECTED] escribió: dfx wrote: I have some fiel name with character with accent (à, ò...) but when I make a plain backup of schema (file.sql) that characters are converted to strange sequence of two (or more?) characters. This sounds to me

[GENERAL] win32 install fail

oblfolks I can't install postgresql on winxp profesional Installer fail ( creating cluster) Installer with out cluster . ok creating cluster on hand .fail initdb The files belonging to this database system will be owned by user postgres. This user must also own the server process.

Re: [GENERAL] how to read bytea field

[EMAIL PROTECTED] escribió: This might help you: select encode(col1,'escape') from tblBytea; where col1 is of type bytea... - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/24/07, marcelo Cortez [EMAIL PROTECTED] wrote: folks help me ,i cant read bytea

Re: [GENERAL] how to read bytea field

hi Markus ,folks Are you sure you tested with a real bytea field? Yeah , i store bytea using encode function , how you say . The field of my table is bytea type , and store real bytea data in this field. My problem is , i can't convert this field to text anymore, not function receiving

Re: [GENERAL] how to read bytea field

folks my table CREATE TABLE pblfield ( id_ integer NOT NULL, value_field bytea, name character varying(128), osset integer, length integer, version_ integer, inst_class_ character varying(128), CONSTRAINT pblfield_pkey PRIMARY KEY (id_) ) insert into pblfield( id_ ,

Re: [GENERAL] how to read bytea field

ok my mistake , insert into pblfield( id_ , value_field ) values(1 ,encode(E'\\000\\001', 'escape') ::bytea ) ; best regards mdc __ Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo

Re: [GENERAL] how to read bytea field

Richard H i'm understood now!, sorry for the noise. thanks very, very much best regards mdc --- Richard Huxton dev@archonet.com escribió: marcelo Cortez wrote: ok my mistake , insert into pblfield( id_ , value_field ) values(1 ,encode(E'\\000\\001', 'escape') ::bytea

Re: [GENERAL] capacity of tables

People In my experience work very well con tables with 172.000.000 of records ( 172 millions). In fact is not too large number of records for postgresql. important aspect of this installation is your .conf file, take care of this, check old email with config subject. Best regards mdc ---

[GENERAL] how to read bytea field

folks help me ,i cant read bytea type field's. how to convert bytea to text or varchar ? when using bytea types? any clue be appreciated best regards mdc __ Preguntá. Respondé. Descubrí. Todo lo que

[GENERAL] lock table problem

folk the pg_statistics show too many lock table ( fron my app.) and all of them is in waiting state. the only way to go out from this situation is restart the cluster. where is the way to investigate lock's table tree ? any clue? best regards MDC

Re: [GENERAL] trigger help

Michael ,list You are you are right, thanks a lot for your help and tinme. best regards MDC --- Michael Fuhr [EMAIL PROTECTED] escribió: On Tue, Aug 22, 2006 at 02:37:19PM -0300, marcelo Cortez wrote: This isn't a trigger function. Are you sure trigger is the word you meant

[GENERAL] trigger help

folks I think my trigger need transaction ,but the pgsql compiler refuse to compile 'begin .. commit ' sequence I use the perform , to do the works i'm wrong? tia. any help be appreciated. MDC code below ( note (*) for perform instruction) CREATE OR REPLACE FUNCTION

Re: [GENERAL] trigger help

Micheal This isn't a trigger function. Are you sure trigger is the word you meant? yes i do CREATE TABLE actlocat ( id_actlocal numeric(2) NOT NULL, d_actlocal char(8) NOT NULL, f_novedad float8 NOT NULL, ordenado_por char(18) NOT NULL, CONSTRAINT pk_actlocat PRIMARY KEY

Re: [GENERAL] wal files on temporary tables

Tom thanks for to respond quickly, see below marcelo Cortez [EMAIL PROTECTED] writes: Then i've created normal tables but the wal file generated by this tables grows and grows. The WAL files shouldn't grow indefinitely unless you've got some fairly serious problem

[GENERAL] wal files on temporary tables

folks I have a asp application connected with postgres. The postgres temporary tables is useless because i need remain this tables between sessions, perfomance reasons. This tables are created on the fly and remain between session but asp server finalize connection and temporary table are

Re: [GENERAL] wal files on temporary tables

Tom thanks for to respond quickly, see more below marcelo Cortez [EMAIL PROTECTED] writes: Then i've created normal tables but the wal file generated by this tables grows and grows. The WAL files shouldn't grow indefinitely unless you've got some fairly serious problem

[GENERAL] table space for temporal tables

Hi all there any way to isolate the transaction log for some tables? the temporary tables generate transaction's log's i want to islotate this , for backups propouses, any sugestion are welcomed. best regards MDC

[GENERAL] my first procedure

folks i´ts is my first procedure/function the pgadmin show 10 secs in execute it any pointer be apreciated CREATE OR REPLACE FUNCTION fs_getstring() RETURNS TEXT AS ' DECLARE DECLARE curs1 CURSOR FOR select id_reparticion ::varchar || chr(1) || codigo_reparticion

Re: [GENERAL] encoding bug or feature?

Jorge my test, i created one utf8 database but don´t work ideas? testutf8=# \set VERSION = 'PostgreSQL 8.1.0 on i386-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13)' AUTOCOMMIT = 'on' VERBOSITY = 'default' PROMPT1 = '%/%R%# '

Re: [GENERAL] encoding bug or feature?

Tom , folks I've recreated the database with --locale=es_AR keyword and all works fine thanks a lot. best MDC --- Tom Lane [EMAIL PROTECTED] escribió: marcelo Cortez [EMAIL PROTECTED] writes: testutf8=# \set ... ENCODING = 'UTF8' HISTSIZE = '500' testutf8=# select upper('ñ

[GENERAL] encoding bug or feature?

folks select ucase( 'ñ'); - 'ñ' i want this statemen return 'Ñ' any ideas? best regards mdc _ Horóscopos, Salud y belleza, Chistes, Consejos de amor: el contenido más divertido para tu celular está en Yahoo!

Re: [GENERAL] encoding bug or feature?

formatting lc_time = 'es_AR' # locale for time formatting but the upper function fail for me. what is your settings? BTW the database is SQL_ASCII any pointer be appreciated best regards MDC --- Jorge Godoy [EMAIL PROTECTED] escribió: marcelo Cortez [EMAIL

Re: [GENERAL] copy from error

Tom , Michael Thanks for your responses, there any procedure for fix fts installation? any advice will be appreciated Tia. best regards. MDC --- Tom Lane [EMAIL PROTECTED] escribió: marcelo Cortez [EMAIL PROTECTED] writes: the follow error: Warning: pg_query(): Query failed

[GENERAL] copy from error

Folks the follow error: Warning: pg_query(): Query failed: ERROR: no existe la columna oid the column oid don't exists in english. CONTEXT: sentencia SQL: select oid from public.pg_ts_cfg where locale = $1 using php4 call the pgsql.so with follow query: COPY caratult(actuacion_car,

[GENERAL] copy from error

Folks the follow error: Warning: pg_query(): Query failed: ERROR: no existe la columna oid CONTEXT: sentencia SQL: select oid from public.pg_ts_cfg where locale = $1 using php call the pgsql.so with follow query: COPY caratult(actuacion_car,

[GENERAL] encoding problem

folks i have problems with encodings the scenario is: database: CREATE DATABASE testLatin WITH OWNER = owner1 ENCODING = 'LATIN9'; test table: CREATE TABLE test ( nombre varchar(20)) WITH OIDS; ALTER TABLE test OWNER TO marcelo; data: nombre - maricón ñañoso pícaro test

Re: [GENERAL] encoding problem

--- Tom Lane [EMAIL PROTECTED] escribió: marcelo Cortez [EMAIL PROTECTED] writes: i have problems with encodings You need to make sure that the database locale matches what you want, not only the encoding. See the Localization chapter in the docs: http://www.postgresql.org/docs/8.1

[GENERAL] Encoding problem

hi Tom , folks how do i You need to make sure that the database locale matches what you want, ? any pointer by appreciated sorry for silly questions ;) best ___ 1GB gratis, Antivirus y

[GENERAL] psqlodbc don't work on winxp64

hi folks the lastest postgres odbc driver don't work into winxp64 ( AKA Windows Vista) Operative System. The installer fail, i'm try to register dll manually but still fail at add conection time into control panel any ideas best regards mdc

Re: [GENERAL] lock problem

hi Richard ,folks Question: is normal this locks ? which is the reason of this? thanks for your time best regards MDC --- Richard Huxton dev@archonet.com escribió: marcelo Cortez wrote: Richard Sorry for a delay question the select * from pg_stat_activity

[GENERAL] lock problem

74274|52800||30186|AccessShareLock|t this queries show locks into 30816 pid or a'im wrong? best regards MDC --- Richard Huxton dev@archonet.com escribió: marcelo Cortez wrote: Hi Richard , folks the query is: SELECT c.actuacion_car AS c_actuacion, c.comentario1

Re: [GENERAL] lock problem

--- Richard Huxton dev@archonet.com escribió: marcelo Cortez wrote: Hi Richard , folks the query is: SELECT c.actuacion_car AS c_actuacion, c.comentario1 || ' ' || c.comentario2 || ' ' || c.comentario3 AS c_comentario FROM caratult AS c INNER JOIN extractt AS t1 ON ...etc

[GENERAL] postgres 8.x on debian

Hello all, does anyone know, whether there is a Debian Package for postgresql 8.x for stable version? Thanks in advance. MDC __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu cuenta ya! -

[GENERAL] lock problem

hi all I have a lock problem, one select query freeze my application, the query in question is on complex select , with many join's, but select all of them. The select * from pg_catalog.pg_locks show many rows while the query freeze my aplication. the aplication use ODBC . any ideas?. any help

Re: [GENERAL] lock problem

-linux-gnu, compiled by GCC 2.95.4 kernel: Linux serverf 2.4.26-1-686-smp #1 SMP Fri Aug 20 19:39:10 CEST 2004 i686 unknown Distro: Debian --- Richard Huxton dev@archonet.com escribió: marcelo Cortez wrote: hi all I have a lock problem, one select query freeze my application, the query

Re: [GENERAL] query optimization

hi guys , Richad you are right!, my apologies profile data: postgres: PostgreSQL 7.4.3 on i386-pc-linux-gnu, compiled by GCC 2.95.4 HP proliant processor: Dual Xeon 3.40 Ghz. HD:250 Gigabytes hard disk storage. responses: Comment 4 - you apply a LIMIT without an ORDER BY. Are

[GENERAL] query optimization

hi guys i need advice for query optimization,take too long time. any coments are welcomed :). best MDC SELECT c.actuacion_car AS c_actuacion, c.comentario1 || ' ' || c.comentario2 || ' ' || c.comentario3 AS c_comentario FROM caratult AS c INNER JOIN extractt AS t1 ON

[GENERAL] postgresql.conf value need advice

folks what is preferible value for stats_reset_on_server_start ? what is default value? best regards MDC __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar

[GENERAL] query don't optimize

hi folks the query: SELECT P.ACT_INCORPORADA, P.FECHA_INICIO, P.OBSERVACIONES1 FROM PASEST AS P WHERE P.FECHA_INICIO between '1999-08-22 00:00:00.00'::timestamp AND '1999-12-22 23:59:00.00'::timestamp ORDER BY P.ACT_INCORPORADA make table scan ,

[GENERAL] fts error

hi folks the follow script fail select to_tsquery('hello world '); - ERROR: syntax error how to catch this error, any clue? best regards mdc __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu

[GENERAL] how to xml on debian?

hi any pointer's to install xml on debian be appreciated. best regards mdc ___ A tu celular ¿no le falta algo? Usá Yahoo! Messenger y Correo Yahoo! en tu teléfono celular. Más información en http://movil.yahoo.com.ar

[GENERAL] LOG: invalid message length

folks the server log message is LOG: invalid message length any clue? best regards mdc pd: where to found the foot print header messages for bki protocol? ___ A tu celular ¿no le falta algo? Usá Yahoo! Messenger y Correo Yahoo! en tu

[GENERAL] invalid message length

folks the server log message is LOG: invalid message length any clue? best regards mdc pd: where can i find header format messages for bki protocol? ___ A tu celular ¿no le falta algo? Usá Yahoo! Messenger y Correo Yahoo! en

[GENERAL] md5 autentication error

Folks I am a little confused, I am trying to implement md5 autentication protocol, as the field is used salt? is hash of md5 algorithm? how build the key? the server log say: 'Password authentication failed for user' is algun example of as it is the protocol? best regards mdc

[GENERAL] postgres db failure

hi folks the postgres fail with follow mwssage pg_dump: dumpClasses(): SQL command failed pg_dump: Error message from server: ERROR: xlog flush request 190/3F08779C is not satisfied --- flushed only to 190/3FD0 CONTEXT: writing block 268606 of relation 17142/17501 any clue? best

[GENERAL] segmentation fault

hello to all I have the following problem, when making massive update of a table, I received the message segmentation fault without no other data of the error in log. Some idea of because it gives east message? I am using gentoo postgres 7.4.6 dual processor HP proliant 5 gigabyte of

Re: [GENERAL] segmentation fault

Lonni , folks You're doing this from within psql or elsewhere? from putty terminal from windows statiom What logging level default i' guest are you using? How 'massive' is this update? full , the update statement not have filter clause. kind of parameters the update statement

Re: [GENERAL] segmentation fault

Lonni , folks configuration data: sorry for long response ;) Linux sume 2.6.9-gentoo-r1 #1 SMP Mon Feb 21 10:46:46 Local time zone must be set--see zic i686 Intel(R) Xeon(TM) CPU 2.80GHz GenuineIntel GNU/Linux postgres: PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4

Re: [GENERAL] segmentation fault

Lonni , folks Full meaning all the rows are being updated? What kind of data is this that you're updating? the fts engine using one tsvector field indexing with gist index the statement is something like this update from veryLargeTable set field = to_tsvector( coleace(field1) ); any

[GENERAL] large dbII to postgresql migration

hello to all Soon time I am going to face a migration of a DBII database our dear postgresql . I will thank for any advice that can give me, in addition this migration will have 20 million records. 20 million record is to large instalation, exist some tips for this type of facilities? Tia .

[GENERAL] large installation help.

hello to all Soon time I am going to face a migration of a DBII database our dear poststoneware. I will thank for any advice that can give me, in addition this migration will have 20 million records. 20 million record is to large instalation, exist some tips for this type of facilities? Tia .

[GENERAL] vacuum problem?

hello to all the scene is following: /psql someDatabase vaccum full verbose; but nothing informs. in which cases vacuum do not inform anything? postgresql 7.4 on red hat 9.0 any clue be appreciate. best regards klingon PS: the application has problems for that reason it wanted to