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 comun

[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 * Si

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

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 * from indexed_table you'll get a seq scan

[GENERAL] Panic Index!!!!

2003-09-05 Thread Edwin Quijada
) / *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun

[GENERAL] Picture with Postgres and Delphi

2003-09-09 Thread Edwin Quijada
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)--- TIP

[GENERAL] I dont know the error with updtae

2003-09-18 Thread Edwin Quijada
and f_fecha = vfecha; end if; end if; *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-747-2787 * Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun

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

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

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

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

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 comun

[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

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 cosas

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 comun

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

2003-11-07 Thread Edwin Quijada
in 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 cosas

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

2003-11-07 Thread Edwin Quijada
*---* *-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 [EMAIL PROTECTED] To: Edwin

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 *-JQ Microsistemas

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 comun

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 (EST) Tom Lane wrote: Bruce

[GENERAL] Big string using Zeos from Delphi

2004-04-08 Thread Edwin Quijada
, for 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 excepcionales

[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

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

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: Ok. This is the way that I compile

[GENERAL] HELP - compiling C functions for wiondws

2012-01-31 Thread Edwin Quijada
/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.c Any cluees ort any ideas ?I am using PG 9.0.6 *---* *-Edwin Quijada

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

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

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 listas_quij...@hotmail.com wrote

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

2010-09-08 Thread Edwin Quijada
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 *-Soporte PostgreSQL *-www.jqmicrosistemas.com *-809-849-8087 *---*