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

[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 '\\173\\134\\162\\164\\146\\061\\134\\141\\156\\163\\151\\040\\01

[GENERAL] Server specs to run PostgreSQL

?? What about memory??? How much??? SCSI Disks and 10/100/1000 netcards, it's ok!! No doubt! It's a medium use server, about 3000 transactions/day. Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo Yahoo! Messe

[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 l

Re: [GENERAL] dns less connection

driver" or something like 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

Re: [GENERAL] dns less connection

password > X6 are ODBC parameters that you like to use e.g. > "BoolsAsChar=0;TrueIsMinus1=1;RowVersioning=1;" > > This works at least for ADODB. > > DAO had it like this: > ODBC;Driver=PostgreSQL > UNICODE;DATABASE=X1;SERVER=X2;PORT=X3;UID=X4;PWD=X5;X6; > > > m

[GENERAL] Tables and Indexes

Hi guys, Is there a way I can separate things in PostgreSQL? Putting tables in a disk partition and indexes in another one? Regards, MaRcELo PeReiRa PHP/SQL/PostgreSQL __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

Re: [GENERAL] Tables and Indexes

, how many times did I write the word 'tablespace' in this e-mail??? hehehhe) Regards, Marcelo --- "Joshua D. Drake" <[EMAIL PROTECTED]> escreveu: > Patrick Fiche wrote: > > >Hi, > > > >I think that TABLESPACE is what you need... > >I

[GENERAL] Last value inserted

m not able to use the last_value() function on the sequence.) Best Regards, Marcelo Pereira Brazil ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso

[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 ve

[GENERAL] test

just a test ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ ---(end of broadcast)--- TIP 5: Have you

[GENERAL] Simple function

ally return "C" if the sum is >50. So I would do: "SELECT id,function() FROM mytable;" and get rows like these: 001 A 002 A 003 C 004 C 005 C 006 B ... Could you help me??? Thanks in advance, See ya, Marcelo __ Converse

[GENERAL] NewsForge Poll: Favorite open source database?

http://www.newsforge.com/pollBooth.pl?qid=54§ion=mainpage&aid=4   Marcelo Cid Analista de Sistemas PRODAM/DIDET/DAA/VEA5080-9227  

RES: [GENERAL] NewsForge Poll: Favorite open source database?

link did the favor of voting for you. Not good.... > > Mike Mascari No. The link dont do the voting. Why do you think so? Marcelo Cid ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

RES: RES: [GENERAL] NewsForge Poll: Favorite open source database ?

> suspected the original link you posted: > Mike Mascari Excuse me. But I dont tried to spoof the vote. I only copied the link after I voted, so the site returned this link. Maybe someone can corret the link on my initial post. Marcelo Cid ---(end of bro

[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 . Be

[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 . Best

[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 - &quo

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 &qu

[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 Ant

[GENERAL] copy from error

Folks the follow error: Warning: pg_query(): Query failed: ERROR: no existe la columna <> " the column oid don't exists" in english. CONTEXT: sentencia SQL: <> using php4 call the pgsql.so with follow query: COPY caratult(actuacion_car, id_reparticion_uc,fecha_inicio,tipo_actuacion,id_extr

[GENERAL] copy from error

Folks the follow error: Warning: pg_query(): Query failed: ERROR: no existe la columna <> CONTEXT: sentencia SQL: <> using php call the pgsql.so with follow query: COPY caratult(actuacion_car, id_reparticion_uc,fecha_inicio,tipo_actuacion,id_extracto_car,act_extramunicipal,observaciones,c

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: > >

[GENERAL] autocommit to off

Help me please! I need change autocommit to off in fedora core 3 in postgresql.conf i don´t know. How can i do? Thanks a lot Marcelo Lima. -- ___ Surf the Web in a faster, safer and easier way: Download Opera 8 at http://www.opera.com Powered by

[GENERAL] Regex

- john michael -obert -icha-d chandle- Any idea?? Thanks in advance, Regards, Marcelo P. Brazil ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com --

[GENERAL] Log Slow Queries

Hi Guys, Is there a feature in PostgreSQL like "--log-slow-queries"(MySQL) ??? Regards, Marcelo P. ___ Abra sua conta no Yahoo! Mail: 1GB de espaço, alertas de e-mail no celular e anti-spam realmente efi

[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! M

Re: [GENERAL] encoding bug or feature?

# locale for number 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 PROT

Re: [GENERAL] encoding bug or feature?

;default' PROMPT1 = '%/%R%# ' PROMPT2 = '%/%R%# ' PROMPT3 = '>> ' DBNAME = 'testutf8' USER = 'marcelo' HOST = '/var/run/sume' PORT = '5432' ENCODING = 'UTF8' HISTSIZE = '500' test

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 = &#

[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 ::varch

[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] 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 droppe

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 inde

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

[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 _create_ca

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] 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 >

[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] Logging all queries

Hi Franco, If I set 'log_statement=true', will *all* the queries sent to the backend be logged??? In which table will it be used to do this log?? Regards, Marcelo --- Franco Bruno Borghesi <[EMAIL PROTECTED]> escreveu: > you can set the log_statement parameter to true in

Re: [GENERAL] Logging all queries (almost there)

as I have more than one database, how can I know where the [stuff] table is?? Regards, Marcelo --- MaRCeLO PeReiRA <[EMAIL PROTECTED]> escreveu: > Hi Franco, > > If I set 'log_statement=true', will *all* the > queries > sent to the backend be logged??? >

Re: [GENERAL] 7.3.4 freezing

Hi guys, > =?iso-8859-1?q?MaRCeLO=20PeReiRA?= > <[EMAIL PROTECTED]> writes: > > And, yes, I was receiving "connection refused" in > the > > cases when the postmaster was gone! > > You didn't say that, you said it froze. Please be > more accu

[GENERAL] On Update (trigger hint)

y UPDATE executed on a row of this table. Do I have to create a function to do it? Can you help me? Regards, Marcelo __ Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora: http://br.yaho

[GENERAL] Number of Active Connections

Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). Regards, Marcelo Pereira Brasil __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around

Re: [GENERAL] Number of Active Connections

Hi Elein, Thanks!! It was exactly what I was looking for!!! Regards, Marcelo Pereira Brasil --- elein <[EMAIL PROTECTED]> escreveu: > select count(*) from pg_stat_activity; > > for detailed info use: > > select * from pg_stat_activity; > > On Mon, Sep 13, 2004 a

[GENERAL] Language C - Console-based FrontEnd

begin. Thanks in advance, Marcelo Pereira Programmer ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Language C - Console-based FrontEnd

Thanks, I'll check the sites. See ya, Marcelo Pereira -- Remember that only God and Esc+:w saves. __ (_.\ Marcelo Pereira | / / ___ [EMAIL PROTECTED] | / (_/ _ \__Matematica/99 - Imecc | ___\/_\___)___Unicamp__

[GENERAL] slow down on UPDATE using IN statements

in the last case I would make a software change. Thanks in advance and Best regards, Marcelo Pereira Brazil Yahoo! Mail - o melhor webmail do Brasil http://mail.yahoo.com.br ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[GENERAL] [off-topic] Bugtracker using PostgreSQL

Hi guys, Do you know any web based bug tracker software that use PostgreSQL??? Somebody has told me about Mantis, but it use MySQL... and I resign to use that! :( Which is the best bug tracker you know???(PHP+PostgreSQL) Thanks in advance and Best Regards, Marcelo Pereira Yahoo! Mail - 6MB

[GENERAL] Lock strategies!

ot the best way to do that and I am asking you for advices! 1) Is it (... max(forn_id)... ) the best way to get the next value to be inserted in the table? 2) Is there a automatic way to do that? Thanks in advance and Best Regards, Marcelo _

Re: [GENERAL] Lock strategies!

he problem!!! ;-) So, if I rollback or whatever, the ID will be populated with the sequence values, but the forn_id must increase in a controled way, ie, without holes! Advices?? Regards! Marcelo --- Dave Cramer <[EMAIL PROTECTED]> escreveu: > Marceio > > > > The seque

Re: [GENERAL] Lock strategies!

Hi Dave, Marc and all others, I know it is really weird! But, how can I explain to the user, who use the sequence numbers, that he will have to handle with those holes? Ok! I will try to handle the holes! (fight against the users) Thanks! Marcelo --- Dave Cramer <[EMAIL PROTEC

[GENERAL] Forein Key

Hi,   I'm a new user and I would like to know if I can create my table using forein key's.     Thanks   Marcelo Pereira Computer Programmer

[GENERAL] Delete Cascade

to delete a 'author' in the author table and also all your books in the book table.   When I run   delete from author where author_cod =   I dont get the row deleted if there is a row referenced by in the book table. How can I delete my rows in cascade ???   Thanks in advance,

[GENERAL] Select

4 | Bob |any 5 |David | any 6 | Paul |any Now I would like to select all employees which name begins with the letter "P". > Select * from employee where "name-begin-with-letter-P" :-) How can I do it ???

[GENERAL] Performance question

Hello list, If I've got a trigger that calls a function each time there is a DELETE or UPDATE opration on a table in my system, and in this function I retrieve some boolean information from another table and based on this information, additional code will be ran or not in this function. Could the

[GENERAL] Audit-trail engine inner-workings

e of a session_id ? Or is it per-connection ? * Do I really need to call reset_session_id ? Isn't this connection destroyed after it has been used by the application? * Would it work with an application which does not use a connection pool but a permanent connection (such as desktop apps)? Thanks in advance! Marcelo.

Re: [GENERAL] Audit-trail engine inner-workings

on to the server so that that the audit-trail can log it altogether). Once the operation is done and the connection is back to the pool, does PostgreSQL discart the associated var ? Does it mantain one "instance" per request made ? That's what I would like to know. Thanks, On 8/21/0

[GENERAL] create or replace for tables and schemas

eady exists, it will just replace it. For those curious, my company uses an application generator called GeneXus, it has a "sql" "command" which allows you to send direct sql sentences to the database **as long as** they don't return anything. Oh life. Anyway, thanks in advance, Marcelo.

Re: [GENERAL] create or replace for tables and schemas

Thanks Martijn On 8/27/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > > On Mon, Aug 27, 2007 at 08:24:51AM -0300, Marcelo de Moraes Serpa wrote: > > With this in mind, I'd like to know if there is something like CREATE OR > > REPLACE for tables and schemas

[GENERAL] [ERROR] syntax error at end of input

y to create this function without these two sentences, everything goes ok, however, when I've got these two sql senteces, I get the following error: ERROR: syntax error at end of input Is there anything wrong with the code? Thanks in advance, Marcelo.

[GENERAL] difference between function and stored procedure

Hello list, Is there any difference between a PGSQL Function and Stored Procedure in PostgreSQL (8.2) ? If so, what difference? Is the SQL used to create a SP different from the SQL used to create a function ? Thanks in advance, Marcelo.

[GENERAL] Can´t connect but listen address and pg_hba configured correctly

eSQL 8.1 Debain Etch package. Any hints greatly appreciated! Marcelo.

Re: [GENERAL] Can´t connect but listen address and pg_hba configured correctly

hat's what happens when you have a stressful day of work..). I changed it to 5432 and everything went fine. Do you see how little changes can make a **big** difference. I wonder what was going through the head of the person who altered the port number for this release... Thanks, Marcelo. On T

[GENERAL] Prefix LIKE search and indexes issue.

prefix extension, but how would I use it? Is there any other simpler / extension-free way to solve this issue? Thanks in advance, Marcelo. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Audit-trail engine: getting the application's layer user_id

e that in Postgres? Thanks in advance! Marcelo.

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

I forgot to add the link to the article I've mentioned: http://www-128.ibm.com/developerworks/db2/library/techarticle/0302stolze/0302stolze.html#section2b This is what I'd like to do on PostgreSQL, Thanks, Marcelo. On 4/24/07, Marcelo de Moraes Serpa <[EMAIL PROTECTED]> wrote

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

nection id" you say equivalent to the "applicationid" mentioned in the ibm db2 article? If so, how could I get this data through my application? On 4/24/07, Marcelo de Moraes Serpa <[EMAIL PROTECTED]> wrote: Thank you for the replies. @Richard: I've thought about having on

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

Hey guys, I really appreaciate your help, thank you very much for your time. @Manuel: What a comprehensive solution! Thanks a lot for that :) @Joris: That would be a simpler althernative, I will try it out too! Marcelo. On 4/24/07, Joris Dobbelsteen <[EMAIL PROTECTED]>

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

Hi Manuel, just a quick question: What C libraries do I need to compile this function? Or better: Where can I find a reference manual about db stored procedures written in C for PostgreSQL? Thanks! On 4/24/07, Manuel Sugawara <[EMAIL PROTECTED]> wrote: "Marcelo de Moraes Ser

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

Windows - you can see it here: http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html Thank you again. Marcelo. On 4/24/07, Manuel Sugawara <[EMAIL PROTECTED]> wrote: "Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes: > Hey guys, > > Mine is an web applicat

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

framework (Actually it is an data-oriented application generator, called GeneXus). Thanks, Marcelo. On 4/25/07, Manuel Sugawara <[EMAIL PROTECTED]> wrote: "Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes: > I'm sorry Manuel, but after some time trying to ful

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

e in your blood and haven't had a good night sleep... thanks for putting me on the track again. I will study Tim's approach more. This thing got more complicated than I thought it would be. At least I'm learning more about PostgreSQL internal architecture. Thank you for your help.

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

grateful as I really need this thing working as soon as possible. Thanks, Marcelo. On 4/25/07, Marcelo de Moraes Serpa <[EMAIL PROTECTED]> wrote: I'm doing it form the application layer and I don't think it can be > done in the database layer, how the trigger will figure ou

[GENERAL] "WARNING Bison install not found, or unsupported Bison version."

o build without." even though bison and flex are installed! (the latest version from gnuwin32). I'm trying to compile it with VS2005 (src/tools/msvc) Any feedback would be much appreaciated, Marcelo.

[GENERAL] Compiling PostgreSQL 8.2 on Windows using msvc2k5

Hello! I'd like to learn more about PostgreSQL (8.x) internal architecture so as to build C extensions and Stored Procedures in C. I think that I nice way to start is trying to compile PostgreSQL from the source. I'm on Windows XP PRO. I've found this article: http://developer.postgresql.org/pgdo

[GENERAL] Using a library compiled for 8.3 in 8.2

Detail: Server is version 8.2, library is version 8.3. How could I make it work with 8.2 without having to download the 8.2 source code and compiling it? Is there a way to do that? Thanks in advance, Marcelo.

[GENERAL] postgres.exe - Entry point not found (PostgreSQL 8.3 devel)

possible to find the entry point of the xmlNewValidCtxt procedure in the libxml2.dll dynamic link library" However, everything compiled well and without errors (only some warning). I would be grateful if someone could enlight me on this one. Marcelo.

[GENERAL] "Protocol error. Session setup failed" (PostgreSQL 8.3devel/postgresql-8.3dev-600.jdbc3)

owing PSQLException: ""Protocol error. Session setup failed" What could be happening? Note: I've attached the tomcat stack trace to the error. Thanks, Marcelo. HTTP Status 500 - type Exception report message description The server encountered an internal error () that prev

Re: [GENERAL] Audit-trail engine: getting the application's layer user_id

Hi Manuel, Just replying to say a big thank you ... I compiled the C extension with the code you , did all the necessary logic and finally solved it. Thank you very much for your help! Thank you also to all the other who helped me! Marcelo. On 4/24/07, Manuel Sugawara <[EMAIL PROTEC

[GENERAL] Where I find examples of pqtrace ???

Hi, I Have some questions of use PQtrace in Windows' systens 1- The implementation of PQtrace, is possible ONLY with non bloking connections ??? 2- Please, I need same samples of implementation of PQtrace. Regards Marcelo Silveira OBS: text original in Portuguese, translate with g

<    1   2