[ADMIN] Very Urgent!!! Help Me !!!
Hi. We Accidently erased pg_log file of Postgresql 6.0 . We misunderstood that was just a log. There are a lot of files which are very important Tables for us. It is very serious situation for us. Please let me know how to restore pg_log file or extract data files without pg_log file or and so forth... I'll really really appreciate if you give us some help Thanks advance == Park Tae Seok (www.iyagi.co.kr) TEL : 011-504-2628 , 011-9355-9969 E-mail : [EMAIL PROTECTED] [EMAIL PROTECTED] - == No. 1 ¿ì¸® ÀÎÅͳÝ, Daum Æò»ý ¾²´Â ¹«·á E-mail ÁÖ¼Ò ÇѸÞÀÏ³Ý Áö±¸ÃÌ ÇÑ±Û °Ë»ö¼ºñ½º Daum FIREBALL http://www.daum.net
Re: [ADMIN] A few misc. questions.
On Fri, May 26, 2000 at 04:15:31PM +0200, Peter Eisentraut wrote:
> On Fri, 26 May 2000, Rainer Mager wrote:
>
> > 2. Does anyone one know a standard SQL method (that works with Postgres) to
> > retrieve the primary key of a newly INSERTed record? We've found one way but
> > it will not work with order databases since it relies on reading data from
> > the sequence tables.
>
> Again, what you do with your primary keys is up to you. Ideally you won't
> need to retrieve the primary key value because you know what you just
> inserted. If you are talking about serial, then the answer is there isn't
> one because serial isn't SQL. But as someone already said, the curval
> function will do.
Another approach is something like this:
pkey=sql("select nextval('some-sequence')")
sql("insert into table values ($pkey, $data)")
--
Ragnar Kjørstad
Re: [ADMIN] Very Urgent!!! Help Me !!!
On Sat, May 27, 2000 at 12:02:35PM +0900, µ¿¹°¿ø wrote: > Hi. > We Accidently erased pg_log file of Postgresql 6.0 . > We misunderstood that was just a log. > There are a lot of files which are very important Tables for us. > It is very serious situation for us. > Please let me know how to restore pg_log file or > extract data files without pg_log file or and so forth... What OS and filesystem are you using? If you happen to run linux and ext2, you may want to look at "lde" and try to undelete the file. Good luck. -- Ragnar Kjørstad
