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