[COMMITTERS] recover deleted records

2009-11-24 Thread Allan Morris Caras
I have accidentally / stupidly deleted records from a table.

I tried delete from where exist and it deleted the whole table.

Is there a way I can recover it?

I'm using postgres 8.4

Any help is appreciated. TIA



  

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


Re: [COMMITTERS] recover deleted records

2009-11-24 Thread Robert Haas
On Tue, Nov 24, 2009 at 5:03 AM, Allan Morris Caras  wrote:
> I have accidentally / stupidly deleted records from a table.
>
> I tried delete from where exist and it deleted the whole table.
>
> Is there a way I can recover it?
>
> I'm using postgres 8.4
>
> Any help is appreciated. TIA

I think you're going to need to restore from backup.

Incidentally, this is the wrong place for asking questions of this
type.  You should try pgsql-general.

...Robert

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Made function better readable.

2009-11-24 Thread Michael Meskes
Log Message:
---
Made function better readable.

Modified Files:
--
pgsql/src/interfaces/ecpg/ecpglib:
misc.c (r1.52 -> r1.53)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ecpglib/misc.c?r1=1.52&r2=1.53)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix syntax in extract() examples Author: Erik Rijkers

2009-11-24 Thread Peter Eisentraut
Log Message:
---
Fix syntax in extract() examples

Author: Erik Rijkers 

Tags:

REL8_3_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.419.2.6 -> r1.419.2.7)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.419.2.6&r2=1.419.2.7)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix syntax in extract() examples Author: Erik Rijkers

2009-11-24 Thread Peter Eisentraut
Log Message:
---
Fix syntax in extract() examples

Author: Erik Rijkers 

Tags:

REL8_4_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.482.2.1 -> r1.482.2.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.482.2.1&r2=1.482.2.2)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix syntax in extract() examples Author: Erik Rijkers

2009-11-24 Thread Peter Eisentraut
Log Message:
---
Fix syntax in extract() examples

Author: Erik Rijkers 

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.491 -> r1.492)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.491&r2=1.492)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers