Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread marcelo
Again: knowing of .pgpass (thank you Scott) this is what I will do. On 17/11/17 17:49, Ron Johnson wrote: On 11/17/2017 02:23 PM, John R Pierce wrote: On 11/17/2017 12:19 PM, marcelo wrote: Sorry, I was not exact. I don't need nor like to change pg_dump. Rather, based on pg_dump code, I

Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread marcelo
Thank you, Scott. That's happening me because incomplete docs reading. Truly, I'm catched in a very big app, so I have no time to read all the docs. On 17/11/17 18:31, Scott Mead wrote: On Fri, Nov 17, 2017 at 4:06 PM, marcelo <mailto:marcelo.nico...@gmail.com>> wro

Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread marcelo
I will give expect a try. But the source code embedded in my daemon. On 17/11/17 17:49, Ron Johnson wrote: On 11/17/2017 02:23 PM, John R Pierce wrote: On 11/17/2017 12:19 PM, marcelo wrote: Sorry, I was not exact. I don't need nor like to change pg_dump. Rather, based on pg_dump co

Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread marcelo
I need to "emulate" the pg_dump code because the password prompt. Years ago I write a program (for the QnX environment) that catched some prompt and emulates the standard input. I don't like to do that again. On 17/11/17 17:23, John R Pierce wrote: On 11/17/2017 12:19 PM

Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread marcelo
using that same data, of course, encripted to the common users). Thank you, Scott. On 17/11/17 10:49, Scott Mead wrote: On Fri, Nov 17, 2017 at 7:51 AM, marcelo <mailto:marcelo.nico...@gmail.com>> wrote: I would need to do a mild change to pg_dump, working against a 9.4 s

[GENERAL] mild modification to pg_dump

2017-11-17 Thread marcelo
I would need to do a mild change to pg_dump, working against a 9.4 server on linux. Which source tree do I need? Have gcc 4.9.2 in my Lubuntu installation. TIA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/

[GENERAL] Call a builtin function from Devart's linqConnect

2017-09-18 Thread marcelo
s it done, and how to get the result? TIA Marcelo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Porting libpq to QNX 4.25

2017-08-25 Thread marcelo
refer to do all the development using only one paradigm. My best regards Marcelo On 25/08/17 15:26, Peter J. Holzer wrote: On 2017-08-22 12:57:15 -0300, marcelo wrote: We'll replace those QNX machines with WIndows XP ones The future is already here — it's just not very eve

Re: [GENERAL] Porting libpq to QNX 4.25

2017-08-22 Thread marcelo
Thank you, Tom. We'll replace those QNX machines with WIndows XP ones (via dual boot), so we can use our Devart's ORM the same as the most "user oriented" applications. On 22/08/17 12:39, Tom Lane wrote: marcelo writes: Is there a libpq porting to QNX 4.25? I just tri

Re: [GENERAL] Porting libpq to QNX 4.25

2017-08-22 Thread marcelo
I'm pretty sure that Watcom 9.6 libraries lacks long long or any such variants. And, of course, I don' t have another tool chain. Thank you On 21/08/17 22:20, George Neuner wrote: On Mon, 21 Aug 2017 13:27:56 -0300, marcelo wrote: Is there a libpq porting to QNX 4.25? I jus

[GENERAL] Porting libpq to QNX 4.25

2017-08-21 Thread marcelo
Is there a libpq porting to QNX 4.25? I just tried to compile one of the modules, but was rejected because the QNX's standard library have not an Int64 type. TIA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams

2017-08-21 Thread marcelo
Thank you Jerry. I read about "server parameters" as options, but forgotten search_path. On 20/08/17 20:11, Jerry Sievers wrote: marcelo writes: The system I'm building needs to connect some QNX 4.x machines to the Postgres' server (by the way, a Linux machine). Of cou

[GENERAL] Selecting some schema not suported for libpq PQconnectdbParams

2017-08-20 Thread marcelo
ing this because the schema to use will not be the "current user" nor "public". Any help will be appreciated. TIA 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] sequence used on null value or get the max value for a column whith concurrency

2017-08-10 Thread marcelo
In some table, I have a bigint column which at the app level can be null. Call it "DocumentNumber", and of course is not the PK. In most cases, the applications give some value to the column. But sometimes, the value remains null, expecting the backend or someone assign it a unique value. Cou

Re: [GENERAL] ErrorCode=-2147467259 storing a .net string

2017-08-09 Thread marcelo
Solved. I recreated the database with LATIN9 encoding. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] ErrorCode=-2147467259 storing a .net string

2017-08-09 Thread marcelo
The database has UTF8 encoding. The Windows machine's locale where the string was created is set to es_AR.utf8. When sending the data (thru Devart's Devart.Data.PostgreSql module) the server returned the error in the subject. I don't know how exactly the offending string was encoded. Any help wi

Re: [GENERAL] Schemas and serials

2017-07-30 Thread marcelo
must go to another transactional one. The example would be "order" and "order_detail": customer, product, etc must be referenced from public, but the FK from order_detail must point to season.order. So, the question is solved, at least using some "postgresql complaint

Re: [GENERAL] Schemas and serials

2017-07-30 Thread marcelo
Sequences, tables, etc.. belong to the schema where was created. Roberto. Em sáb, 29 de jul de 2017 às 16:17, marcelo mailto:marcelo.nico...@gmail.com>> escreveu: Some days ago I asked regarding tables located in different schemas. Now, my questi

[GENERAL] Schemas and serials

2017-07-29 Thread marcelo
copy the tables definitions to production. It will automatically create the sequences in the new schema, starting at zero? TIA Marcelo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

2017-07-26 Thread marcelo
You can try SQL Manager for PostgreSql. The Lite edition is enough ans it's free. It's fast, secure and very friendly. On 26/07/17 19:41, Tiffany Thang wrote: Hi, I'm new to PostgreSQL. I'm looking for a developer tool that works similarly to TOAD or SQL Developer for Oracle/MySQL which would

Re: [GENERAL] Schemas and foreign keys

2017-07-21 Thread marcelo
Thank you, Andreas. Your answer closes this thread. On 21/07/17 11:07, Andreas Kretschmer wrote: Am 21.07.2017 um 14:58 schrieb marcelo: Recently I asked regarding schemas, and received very useful answers. I conclude that I can put some tables in one schema and left others in the public

[GENERAL] Schemas and foreign keys

2017-07-21 Thread marcelo
what about foreign keys? At least, I will have foreign keys from the tables in the specified schema to the tables in "public", because I'm thinking that the tables in "public" would be references, while the tables residing in the specified schema will be the transactional one

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
e. So, I will close this thread. Thanks to all who answered. I acquired some new knowledge. On 14/07/17 13:50, John R Pierce wrote: On 7/14/2017 4:59 AM, marcelo wrote: Now I have a related question. Could I select a specific schema in the connection string? Say, by example database=mydb.

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
erer wrote: marcelo schrieb am 14.07.2017 um 13:59: Could I select a specific schema in the connection string? Say, by example database=mydb.schemanumbertwo ? The JDBC driver does indeed support that: jdbc:postgresql://localhost/somedatabase?currentSchema=some_schema I think in the backrou

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
/07/17 09:19, Bill Moran wrote: On Fri, 14 Jul 2017 08:59:13 -0300 marcelo wrote: Thank you. Now I have a related question. Could I select a specific schema in the connection string? Say, by example database=mydb.schemanumbertwo ? I'm asking this because I will be using Devart's dotC

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
o I cannot set the search path immediately after the connection. If the first example is possible, I will replace the schema name on the fly, before connection attempt. TIA On 14/07/17 07:58, Berend Tober wrote: marcelo wrote: The question is not trivial. Could I maintain two or three separat

[GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
The question is not trivial. Could I maintain two or three separate/distinct "versions" of same database using one schema for every of them? Could some tables (in the public schema) be shared among all the schemas? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] Unknown lvalue 'PIDFILE' in section 'Service'

2017-06-28 Thread marcelo
On 28/06/17 10:17, Adrian Klaver wrote: On 06/28/2017 05:06 AM, marcelo wrote: Hi Today I installed postgresql 9.4 on Lubuntu 15.04 from the EnterpriseDB's package. I modified pg_hba.conf to accept connections from the local network, and tried to start the backend. It do not; lookin

[GENERAL] Unknown lvalue 'PIDFILE' in section 'Service'

2017-06-28 Thread marcelo
s Environment=PGDATA=/opt/PostgreSQL/9.4/data What is going wrong? TIA Marcelo

[GENERAL] Prefix LIKE search and indexes issue.

2010-07-23 Thread Marcelo de Moraes Serpa
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] PG 8.4 and pg_autovacuum functionality

2009-10-13 Thread Marcelo
ta is actually being rewritten. Thank you, 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] Please remove me from the list!

2009-05-28 Thread Marcelo Giovane
Please, remove me from the list! Marcelo Giovane

[GENERAL] Comando USE

2009-03-19 Thread Marcelo Giovane
É possível alterar o database corrente para criar um schema nele sem uso do \c do psql? Obrigado MarceloG

[GENERAL] pg_dump estimation

2008-06-24 Thread Marcelo Martins
x27;t want to take any chances of filling up the disk due to a pg_dump you know. thanks, Marcelo Linux/Solaris System Administrator [EMAIL PROTECTED] http://www.zeroaccess.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

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

2008-04-10 Thread Marcelo de Moraes Serpa
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] Can´t connect but listen address and pg_hba configured correctly

2008-04-10 Thread Marcelo de Moraes Serpa
eSQL 8.1 Debain Etch package. Any hints greatly appreciated! Marcelo.

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

2008-01-24 Thread marcelo Cortez
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 ) >

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

2008-01-24 Thread marcelo Cortez
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] postgres 8.3 rc-1 ispell installation problem [RESOLVED]

2008-01-20 Thread marcelo Cortez
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

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

2008-01-20 Thread marcelo Cortez
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

2008-01-20 Thread marcelo Cortez
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 http://y

[GENERAL] postgres 8.3 rc-1 ispell installation problem

2008-01-20 Thread marcelo Cortez
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 "/usr/local/pgsql/share/ts

Re: [GENERAL] 8.3beta bug or feature?

2008-01-10 Thread marcelo Cortez
Alvaro --- Alvaro Herrera <[EMAIL PROTECTED]> escribió: > marcelo Cortez escribió: > > Pavel > > > > > > --- Pavel Stehule <[EMAIL PROTECTED]> > escribió: > > > > > Hello, > > > > > > it isn't bug. You have

Re: [GENERAL] 8.3beta bug or feature?

2008-01-10 Thread marcelo Cortez
Alvaro --- Alvaro Herrera <[EMAIL PROTECTED]> escribió: > marcelo Cortez escribió: > > Pavel > > > > > > --- Pavel Stehule <[EMAIL PROTECTED]> > escribió: > > > > > Hello, > > > > > > it isn't bug. You have

Re: [GENERAL] 8.3beta bug or feature?

2008-01-10 Thread marcelo Cortez
pper ,explicit cast is not an option ( 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: > &

[GENERAL] 8.3beta bug or feature?

2008-01-10 Thread marcelo Cortez
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 8.3

Re: [GENERAL] double free corruption?

2007-12-28 Thread marcelo Cortez
n: "PostgreSQL 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ó: > ma

[GENERAL] double free corruption?

2007-12-28 Thread marcelo Cortez
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: =

[GENERAL] postgres8.3beta encodding problem?

2007-12-17 Thread marcelo Cortez
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)"

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

2007-12-05 Thread marcelo Cortez
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_abbreviatio

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

2007-12-05 Thread marcelo Cortez
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_confi

Re: [GENERAL] Tsearch2 - spanish

2007-09-20 Thread marcelo Cortez
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 -

[GENERAL] difference between function and stored procedure

2007-08-28 Thread Marcelo de Moraes Serpa
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] [ERROR] syntax error at end of input

2007-08-27 Thread Marcelo de Moraes Serpa
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.

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

2007-08-27 Thread Marcelo de Moraes Serpa
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] create or replace for tables and schemas

2007-08-27 Thread Marcelo de Moraes Serpa
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] Audit-trail engine inner-workings

2007-08-22 Thread Marcelo de Moraes Serpa
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] Audit-trail engine inner-workings

2007-08-21 Thread Marcelo de Moraes Serpa
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.

[GENERAL] Performance question

2007-08-16 Thread Marcelo de Moraes Serpa
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] help with tsearch2 stem compile

2007-07-21 Thread marcelo Cortez
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 spanish

[GENERAL] tsearch2 on postgres8.2.4

2007-07-18 Thread marcelo Cortez
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! http://www.yaho

Re: [GENERAL] troubble with contrib compile

2007-07-12 Thread marcelo Cortez
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

[GENERAL] troubble with contrib compile

2007-07-11 Thread marcelo Cortez
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 Make

Re: [GENERAL] PostgreSQL Installer for Windows x64

2007-06-20 Thread marcelo Cortez
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 c

Re: [GENERAL] help with libpq program

2007-06-18 Thread marcelo Cortez
u have posted that the delimiter > you supplied does 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, Jun

[GENERAL] help with libpq program

2007-06-18 Thread marcelo Cortez
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] initdb

2007-06-17 Thread marcelo Cortez
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

2007-05-28 Thread marcelo Cortez
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 vary

[GENERAL] help with query...

2007-05-28 Thread marcelo Cortez
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

Re: [GENERAL] dns less connection

2007-05-16 Thread marcelo Cortez
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

Re: [GENERAL] dns less connection

2007-05-16 Thread marcelo Cortez
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

[GENERAL] dns less connection

2007-05-14 Thread marcelo Cortez
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] Audit-trail engine: getting the application's layer user_id

2007-05-09 Thread Marcelo de Moraes Serpa
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] Server specs to run PostgreSQL

2007-05-08 Thread MaRCeLO PeReiRA
?? 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] "Protocol error. Session setup failed" (PostgreSQL 8.3devel/postgresql-8.3dev-600.jdbc3)

2007-04-28 Thread Marcelo de Moraes Serpa
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

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

2007-04-27 Thread Marcelo de Moraes Serpa
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] Using a library compiled for 8.3 in 8.2

2007-04-27 Thread Marcelo de Moraes Serpa
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] Compiling PostgreSQL 8.2 on Windows using msvc2k5

2007-04-26 Thread Marcelo de Moraes Serpa
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] "WARNING Bison install not found, or unsupported Bison version."

2007-04-26 Thread Marcelo de Moraes Serpa
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.

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

2007-04-25 Thread Marcelo de Moraes Serpa
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

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

2007-04-25 Thread Marcelo de Moraes Serpa
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

2007-04-25 Thread Marcelo de Moraes Serpa
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

2007-04-25 Thread Marcelo de Moraes Serpa
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

2007-04-25 Thread Marcelo de Moraes Serpa
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

2007-04-25 Thread Marcelo de Moraes Serpa
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

2007-04-24 Thread Marcelo de Moraes Serpa
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

2007-04-24 Thread Marcelo de Moraes Serpa
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

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

2007-04-24 Thread Marcelo de Moraes Serpa
e that in Postgres? Thanks in advance! Marcelo.

[GENERAL] nedd help bytea encode

2007-04-20 Thread marcelo Cortez
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

Re: [GENERAL] string fields helps

2007-04-16 Thread marcelo Cortez
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] string fields helps

2007-04-16 Thread marcelo Cortez
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 = '{\rtf1\ansi\deff0{\fonttbl{\f

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-11 Thread marcelo Cortez
Hi folks I Agree with Stephen ,before update to 8.2.3 version i can see "vacuum database xx " tailing the file log, off course log statements i'ts in 'all' . After update don't see anymore, plus pgAdmin reclaim to me for vacuum databases. best regards MDC --- "Schwenker, Stephen" <[EMAIL

Re: [GENERAL] PGSQL 8.2.3 Installation problem

2007-02-14 Thread marcelo Cortez
rectory "C:/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 > >

Re: [GENERAL] PGSQL 8.2.3 Installation problem

2007-02-14 Thread marcelo Cortez
gt; Sent: 2-14-'07, 5:14 > > > > > Paul, > > > > I installed 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. > > > >

Re: [GENERAL] PGSQL 8.2.3 Installation problem

2007-02-13 Thread marcelo Cortez
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. Unab

[GENERAL] missing FROM-clause (more)

2007-02-13 Thread MaRCeLO PeReiRA
Hi guys, (1) I change postgresql.conf: add_missing_from = off (2) pg_ctl stop (3) pg_ctl start Without success!! The warning is still there!! :( Any ideas Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo

[GENERAL] missing FROM-clause

2007-02-13 Thread MaRCeLO PeReiRA
till there!! Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ ---(end of broadcast)--- TIP 4: Have you searched our lis

[GENERAL] Help with install postgres 8.2 win32 version

2007-02-12 Thread marcelo Cortez
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?

2007-02-11 Thread marcelo Cortez
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

[GENERAL] win32 install fail

2007-02-10 Thread marcelo Cortez
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. T

  1   2   >