Re: [HACKERS] pg_restore recovery from error.

2004-06-15 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Chris , pg_restore: [custom archiver] could not read data block -- expected 4096, got 3870 pg_restore: *** aborted because of error It appears some of the data itself is not readable, which is fine, but I'd like it to skip past this table and move onto the next one. Has anyone got any ide

Re: [HACKERS] [GENERAL] select statement against pg_stats returns inconsistent

2004-02-25 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Shelby Cain , Is this expected behavior or perhaps a bug? For a novice like me can anyone please tell me 1. Will this effect my application developed on PostgreSQL 2. Will my Application break at some point I heavly use the type of queries defined in the post. Would be greatfull for

[HACKERS] Select query inside function must read commited data

2004-01-25 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear all , Would like to receive your kind attention and enormous knowledge on the following I have a function sai_func_a() Which does as follows and in the same order: 1. Retrieves the latest record from the table test_sai    (By latest I mean the record corresponding to max primary key o

Re: [HACKERS] Old binary packages.

2004-01-20 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Lamar Owen , Since we are keeping all source releases (although I would question that, since we use CVS), keeping all the binaries around is just a space waster, IMHO. Comments? Keeping 7.X and then 7.X.y where y is the last minor version for 7.X is fine As you would have noticed from