Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
Hello Have you enabled autovacuum? Pavel p.s. please, don't use pgsql-commiters mailing list for general questions. use pgsql-general. 2009/11/24 Allan Morris Caras amsca...@yahoo.com: I have accidentally / stupidly deleted records from a table. I tried delete from where exist and it

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Allan Morris Caras
Hi, No, auto vacuum is not enabled. - Original Message From: Pavel Stehule pavel.steh...@gmail.com To: Allan Morris Caras amsca...@yahoo.com Cc: pgsql-general@postgresql.org PG-General Mailing List pgsql-general@postgresql.org Sent: Tue, November 24, 2009 6:14:22 PM Subject: Re:

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
2009/11/24 Allan Morris Caras amsca...@yahoo.com: Hi, No, auto vacuum is not enabled. ok then don't try to call vacuum in any form. so some undelete is possible. It was good new. Bad new - nobody wrote any tool for it. There are pgfsck, but itsn't three years actualised - but you can try it.

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Allan Morris Caras
Hi, I tried to test it but it says couldn't find class 'pg_attribute' When I tried looking into the table that deleted records from, it didn't revert back what I've deleted. Any clues? - Original Message From: Pavel Stehule pavel.steh...@gmail.com To: Allan Morris Caras

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
2009/11/24 Allan Morris Caras amsca...@yahoo.com: Hi, I tried to test it but it says couldn't find class 'pg_attribute' It is strange - but this software isn't maintained long time, and it's not actual. so it is a bad Pavel When I tried looking into the table that deleted records from, it

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Scott Bailey
Pavel Stehule wrote: 2009/11/24 Allan Morris Caras amsca...@yahoo.com: Hi, I tried to test it but it says couldn't find class 'pg_attribute' It is strange - but this software isn't maintained long time, and it's not actual. so it is a bad Pavel When I tried looking into the table that

Re: [GENERAL] [COMMITTERS]

2009-04-06 Thread Emanuel Calvo Franco
2009/4/6 eehab hamzeh eeha...@hotmail.com: here are the code and the error , i compile them using vc++ 6 and VC++ 2008 and minGW the example below are for minGW THANKS #include postgres.h #include string.h #include fmgr.h #ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif /* by value */

Re: [GENERAL] [COMMITTERS]

2009-04-06 Thread Emanuel Calvo Franco
2009/4/6 eehab hamzeh eeha...@hotmail.com: Dear Sir I am trying to build some functions using C language. these functions are mentioned in the postgresql documentation. the only function that are work are the one with int32 variable. the other function bring errors and are not working any

Re: [GENERAL] [COMMITTERS] How I can add new function writing on C under Win32

2005-02-08 Thread Bruce Momjian
deeps1 wrote: Hello pgsql-committers, How I can compiling and linking Dynamically-Loaded Functions on Win32? In Docs describe all platforms BSD , FreeBSD, Linux for example The compiler flag to create PIC is -fpic. On some platforms in some situations -fPIC must be used if

Re: [GENERAL] [COMMITTERS] PostgreSQL on MAINFRAME

2001-09-24 Thread Tatsuo Ishii
[Moved to general] We are attempting to introduce LINUX/POSTGRESQL into our environment. We will test TURBOLINUX on the mainframe. Has anyone installed POSTGRESQL on the MAINFRAME? I got an account on IBM/S390/Turbo Linux combo and happily ran PostgreSQL 7.1. -- Tatsuo Ishii