[GENERAL] HELP - compiling C functions for wiondws

2012-01-31 Thread Edwin Quijada
0) : see declaration of 'errcode' The command that I used to compile is thiscl /I "\Program Files\postgreSQL\9.0\include" /I "\Program Files\postgreSQL\9.0\include\server" /I "\Program Files\postgreSQL\9.0\include\server\port\win32" /c "D:\exte_c\pg2

Re: [GENERAL] Compiling C function with VC++ for Windows version

2012-01-13 Thread Edwin Quijada
> Date: Fri, 13 Jan 2012 14:44:24 +0800 > From: ring...@ringerc.id.au > To: listas_quij...@hotmail.com; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Compiling C function with VC++ for Windows version > > On 13/01/2012 1:55 AM, Edwin Quijada wrote: > > > >

Re: [GENERAL] Compiling C function with VC++ for Windows version

2012-01-12 Thread Edwin Quijada
Date: Thu, 12 Jan 2012 13:45:06 +0800 From: ring...@ringerc.id.au To: listas_quij...@hotmail.com CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Compiling C function with VC++ for Windows version On 12/01/12 11:06, Edwin Quijada wrote

[GENERAL] Compiling C function with VC++ for Windows version

2012-01-11 Thread Edwin Quijada
compilation I need as gcc in windows and Linux. Somebody here has compiled any function for working in Windows for Postgres using VC++? Any help will be so appreciated. *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-Soporte

[GENERAL]

2011-02-14 Thread Edwin Giraldo
i was using holdem manager and my for some reason it said that i coudlnt connect to my postgres so i tried uninstalling postgres and installing it again, but i received a message saing that i could connect to the logon server please help i have team viewer if anyone can help me

[GENERAL] How to generate XML output from a Store Procedure

2010-09-17 Thread Edwin Plauchu
Hello List I hope all of you are ok I would like to know if exist a manner to obtain a output on xml format from a store procedure It may lead me to improve my current develop practices when I have to send a Xml ouput which I want to transform by XSLT scripts. I'll be waiting for your commments

[GENERAL] Compiling with MinGW in windows , compile but my server down

2010-09-08 Thread Edwin Quijada
This compile without errors but when I created the function and try to run I get my server down. There is any way to debug this function to find out what cause the error ?? TIA *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-S

Re: [GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-03 Thread Edwin Quijada
> Date: Fri, 3 Sep 2010 09:41:17 +0200 > Subject: Re: [GENERAL] Compiling extension C with MingW in windows, Error... > From: mag...@hagander.net > To: listas_quij...@hotmail.com > CC: pgsql-general@postgresql.org > > On Fri, Sep 3, 2010 at 5:31 AM, Edwin Quijada &

[GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-02 Thread Edwin Quijada
xt); } Any clues about this ??? *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-Soporte PostgreSQL *-www.jqmicrosistemas.com *-809-849-8087 *---*

Re: [GENERAL] details locks

2009-08-28 Thread Edwin Plauchu
I understood 2009/8/28 paulo matadr > Im work with postgres > my questions is,its possible on postgres: > for example > procpidLocker object_locked user_lockedtypeof lock comand > 1 admin fooadmin2 > exclusive update... > > > thnks

Re: [GENERAL] Select data for current week only

2009-08-27 Thread Edwin Plauchu
you need to group dates per number week 2009/8/27 Edwin Plauchu > Postgresql has these functions > http://www.postgresql.org/docs/8.1/static/functions-formatting.html for > formatting data time > > > 2009/8/27 BlackMage > > >> Hey all, >> >> I'

Re: [GENERAL] Select data for current week only

2009-08-27 Thread Edwin Plauchu
Postgresql has these functions http://www.postgresql.org/docs/8.1/static/functions-formatting.html for formatting data time 2009/8/27 BlackMage > > Hey all, > > I've been trying to figure this problem out with just using sql but I'm not > sure how too. I have a table that holds events for each

Re: [GENERAL] Import data from XML file

2009-08-26 Thread Edwin Plauchu
I think.. you'll need to parse that one... Where do you have your data types to xml document ? 2009/8/26 Erwin Brandstetter > Hi! > > How do you import data from an xml-file? > For instance, if I have a file like this: > > > > > > Sonstiges > 5 > > > Buehne

Re: [GENERAL] Which JDBC version to use with PostgreSQL 8.1.11?

2008-03-19 Thread - Edwin -
heck http://jdbc.postgresql.org/download.html for list) -- - Edwin - "The righteous themselves will possess the earth, And they will reside forever upon it."―Psalms 37:29 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

Re: [GENERAL] rpmbuild: command not found

2008-03-19 Thread - Edwin -
.redhat.com/ . Or, just try installing the one from CentOS. http://mirror.centos.org/centos/3/os/ -- - Edwin - "Happy are those conscious of their spiritual need..." - Matthew 5:3 -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] [ADMIN] Priorities for users or queries?

2007-02-12 Thread Edwin Eyan Moragas
On 2/11/07, Benjamin Arai <[EMAIL PROTECTED]> wrote: Hi Edwin, Which connection parameters effect system resources? i remembered wrong. the connection parameters i was thinking of is here: http://www.postgresql.org/docs/8.2/static/libpq-envars.html however, looking more closely to the

Re: [GENERAL] [ADMIN] Priorities for users or queries?

2007-02-11 Thread Edwin Eyan Moragas
(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate -- edwin eyan moragas aspiring programmer garnet:jasmin:beryllium:gluon::90-12264 http://www.eyan.org/ ---

[GENERAL] slow inet within cidr query

2006-11-28 Thread Edwin Grubbs
rsus 0.5 seconds). Be aware that EXPLAIN ANALYZE seems to be run a different query plan since the first query runs even slower with EXPLAIN ANALYZE. Setting enable_seqscan did not improve the query speed. -Edwin Here is the original query: --

Re: [GENERAL] GUID for postgreSQL

2005-07-27 Thread Edwin Hernán Barrios Núñez
sequence asocited to id. and always you insert something using its default value, the serial id autoincrements its value. thanks , i have not a good english but i try to help ! Atte: Edwin Barrios ! Gerente iBand Networks Ltda On 7/27/05, Riaan van der Westhuizen <[EMAIL PROTECTED]

Re: [GENERAL] [pgsql-es-ayuda] transportar base de datos

2005-07-22 Thread Edwin Quijada
La forma facil y rapido crea , un link a ese directorio y muevelo a otro directorio *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo

[GENERAL] Clearing locks

2005-03-21 Thread Edwin New
roll back an incomplete transaction without access to the connection that created the lock?  All I've been able to do is a complete stop/start of the database, but that is obviously sub-optimal.   Thanks, Edwin New Software Developer Toll - Integrated Business Systems 43 - 63 Princ

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-08 Thread Edwin New
Title: RE: [GENERAL] PostgreSQL still for Linux only? I don't want to split hairs, but wasn't Firebird originally Interbase?  If so, you'll find it was originally a *nix product before it was a Windows database (back in the Ashton-Tate days for those with long memori

Re: [GENERAL] How to increase number of connections to 7.2.1

2004-10-17 Thread Edwin New
Title: RE: [GENERAL] How to increase number of connections to 7.2.1 It was the shared buffers.  Thanks to everyone for your quick and accurate responses. Regards, Edwin. -Original Message- From: Doug McNaught [mailto:[EMAIL PROTECTED]] Sent: Monday, 18 October 2004 11:45 AM To

[GENERAL] How to increase number of connections to 7.2.1

2004-10-17 Thread Edwin New
ted in the server failing to restart.   I know we should upgrade from 7.2.1 and that is going to happen soon, but this is a production server and I need a solution sooner.   Thanks in advance, Edwin New Analyst Programmer Toll - Integrated Business Systems 43 - 63 Princes Highway, Doveton,  VIC.

Re: [GENERAL] [HACKERS] OT moving from MS SQL to PostgreSQL

2004-10-04 Thread Edwin Grubbs
You could use Sun's ASP engine which was originally produced by chilisoft. http://wwws.sun.com/software/chilisoft/ -Edwin On Sun, 03 Oct 2004 11:24:28 -0600, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Sun, 2004-10-03 at 06:33, stig erikson wrote: > > Hello. > > i

Re: [GENERAL] ERROR: AllocSetFree: cannot find block containing c

2004-07-23 Thread Edwin New
t six months in favour of 7.4.2.  I need to get the data out of it. Regards, Edwin. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 July 2004 12:32 PM To: Edwin New Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] ERROR: AllocSetFree: cannot find block conta

[GENERAL] Big string using Zeos from Delphi

2004-04-08 Thread Edwin Quijada
testing and nothing happens I got the same error. Somebody has idea? I know maybe it doesnt appear here but is just help! :( *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcio

Re: [GENERAL] PostgeSQL problem (server crashed?)

2004-03-15 Thread Edwin Pauli
Edwin Pauli wrote: I've put a strace on my webspace. http://epauli.dyndns.org/strace I've never used the strace command. I see no crazy things in the strace, is that opinion true? -- Edwin Pauli ---(end of broadcast)--- TIP 9: the planner w

Re: [GENERAL] PostgeSQL problem (server crashed?)

2004-03-15 Thread Edwin Pauli
Richard Huxton wrote: On Monday 15 March 2004 18:49, Edwin Pauli wrote: There are no Postgres binaries in /usr/local/pgsql, but in /usr/local/bin. Because i've only copied /usr/local/pgsql, the binaries are no changed. If you're binaries work with the old data but not the new, then th

Re: [GENERAL] PostgeSQL problem (server crashed?)

2004-03-15 Thread Edwin Pauli
Frank Finner wrote: Seems we have been hunting the wrong bugs in the beginning. Could it be possible that there was a major version update of the database engine (7.2.x -> 7.4.x for example), without a database reload? I have noticed several new "features" for queries, I think, 7.4 is much closer

Re: [GENERAL] Recovery Data Cant Be!!!

2003-11-07 Thread Edwin Quijada
How can I do from postgresql.conf? From: Bruce Momjian <[EMAIL PROTECTED]> To: Tom Lane <[EMAIL PROTECTED]> CC: Edwin Quijada <[EMAIL PROTECTED]>,[EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [GENERAL] Recovery Data Cant Be!!! Date: Fri, 7 Nov 2003 16:31:43 -0500 (ES

Re: [GENERAL] Recovery Data Cant Be!!!

2003-11-07 Thread Edwin Quijada
OKi how can I do that from postgresql.conf? *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo

Re: [GENERAL] Recovery Data Cant Be!!!

2003-11-07 Thread Edwin Quijada
Sure you can, and in fact that's the only place that will work for Edwin's problem. He hasn't *got* a psql session, because postmaster startup is failing Please, How can I do that *---* *-Edwin Quijada *-Developer DataBase *-J

Re: [GENERAL] Recovery Data Cant Be!!!

2003-11-07 Thread Edwin Quijada
isk *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun" *---* From: "scott.marlowe"

Re: [GENERAL] Power Electrical Down!!!!!

2003-11-07 Thread Edwin Quijada
block 8805 of 17097 LOG: startup process (pid 1531) was terminated by signal 6 LOG: aborting startup due to startup process failure *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr

Re: [GENERAL] Recovery Data Cant Be!!!

2003-11-07 Thread Edwin Quijada
Where set zero_damaged_pages ?? *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo

Re: [GENERAL] Service doesnt UP!!!!

2003-11-07 Thread Edwin Quijada
: startup process (pid 1531) was terminated by signal 6 LOG: aborting startup due to startup process failure *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de hacer

[GENERAL] Problem with Pg_dumpall

2003-11-04 Thread Edwin Quijada
Hi! I am trying to do a dump all and when I do this I get this error pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to timestamp pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb, usesuper, CAST(valuntil AS timestamp) FROM pg_shadow WHERE usesysid <> (SE

Re: [GENERAL] Error size varchar

2003-10-29 Thread Edwin Quijada
wHAT IS unconstrained varchar??? *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo

[GENERAL] Trigger delete

2003-10-29 Thread Edwin Quijada
What is that I have to return in a delete trigger?? return OLD or NEW _ Add MSN 8 Internet Software to your current Internet access and enjoy patented spam control and more. Get two months FREE! http://join.msn.com/?page=dep

[GENERAL] backup another server

2003-10-29 Thread Edwin Quijada
Hi!! I wanna take a whole database running in a box1 pg7.3.4 and moving to another box2 with 7.3.4 too. There is a fast way to do that?? Which??/ *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si d

[GENERAL] Error size varchar

2003-10-29 Thread Edwin Quijada
not works. This error is over than trigger execution?? This is the error ERROR: value too long for type character varying(30) *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcio

[GENERAL] Perl and Postgres

2003-10-17 Thread Edwin Quijada
Hi! Where can I find examples to accesing postgres with perl. TIA _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/ ---(end of broadcast)--- TIP 3:

Re: [GENERAL] is possible to read oracle tables from PostgresSQL

2003-10-16 Thread Edwin Quijada
Wel, If you use Plperl I supposed or perl!! From: "Marco" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [GENERAL] is possible to read oracle tables from PostgresSQL Date: Wed, 15 Oct 2003 19:10:42 GMT I need to know if is possible to read oracle tables from PostgresSQL (and vice versa). Can s

[GENERAL] I dont know the error with updtae

2003-09-18 Thread Edwin Quijada
etipoagnivel = who and f_fecha = vfecha; end if; end if; *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr cosas excepcionales debes de ha

[GENERAL] Picture with Postgres and Delphi

2003-09-09 Thread Edwin Quijada
field bytea but I dont know about this. Another way is save the path to the picture file but I dont like so much because I need to write to disk by OS and have permission to write a directory to OS. What do u think?? Edwin Quijada ---(end of broadcast)--

[GENERAL] Panic Index!!!!

2003-09-05 Thread Edwin Quijada
using t_modelos_f_idmodelo_idx on t_modelos f (cost=0.00..17.07 rows=5 width=47) Index Cond: ("outer".f_modelo = f.f_idmodelo) / *---

Re: [GENERAL] Activate Index

2003-09-04 Thread Edwin Quijada
setup From: "scott.marlowe" <[EMAIL PROTECTED]> To: Edwin Quijada <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Activate Index Date: Thu, 4 Sep 2003 08:58:57 -0600 (MDT) What query are you running? If you run select

[GENERAL] IP from conexion

2003-09-04 Thread Edwin Quijada
Hi [EMAIL PROTECTED] There is a something way to know which are the IP from conexcion to Postgres since plPgsql something like CURRENT_IP *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * " Si deseas lograr

Re: [GENERAL] Activate Index

2003-09-04 Thread Edwin Quijada
Well , My table has 38 records!!! From: "Mattias Kregert" <[EMAIL PROTECTED]> To: "Edwin Quijada" <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Activate Index Date: Thu, 4 Sep 2003 15:58:33 +0200 Hello Edwin, The index will be used automatically when you hav

[GENERAL] Activate Index

2003-09-04 Thread Edwin Quijada
delphi and delphi does not support this. I know there is a command to activate index aand always postgrres will be the index Which are this command??? Anyone knows? *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * &quo