[BUGS] pg_restore

I am having problem with pg_restore 8.1.4   pg_restore: [custom archiver] out of memorypg_restore: *** aborted because of error

[BUGS] pg_restore not work on windows 2000, when dump file size > 4G

Hello, I run pg_restore on windows. I meet a problem. It is ...   pg_restore not work on windows 2000, when dump file size > 4G and dump file format is custom.     Error information: dir pg_100.dat  2005-12-13  09:27 4,391,630,151 pg_100.dat  D:\Program Files\PostgreSQL\8.1\bin>pg_restore

[BUGS] BUG #2557: field`s default value not restored in big sql script

The following bug has been logged online: Bug reference: 2557 Logged by: Boris Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: win 2000, freebsd Description:field`s default value not restored in big sql script Details: Hi! This sql scrip

[BUGS] The column index is out of range in PostgreSQL + resolve

Dear All,   SQL Query is running perfect from PG Admin but it gives error “The column index is out of range “ when running through java application.Please advise me how to solve this issue.   Best Regards Murali

Re: [BUGS] BUG #2557: field`s default value not restored in big sql script

"Boris" <[EMAIL PROTECTED]> writes: > But table "auth"."access_flag" has wrong def value for "access_flag_id". > I think ii must be > nextval('auth.access_flag_access_flag_id_seq'::regclass). > From script it becomes nextval('access_flag_access_flag_id_seq'::regclass) This is not wrong, or at lea

[BUGS] Fwd: [NOVICE] Trigger and Recursive Relation ?

Is this a bug or not? Actually, ordinary person get used to think that if "delete from tbl" ends, then there should no rows exists in tbl, but I understand that DELETE FROM works in a loop and... Let's take a look at the standard paper (ISO/IEC 9075-2:2003 -- 14.7 -- General Rules): "... 11) Al

[BUGS] BUGS: pg_restore custom archiver out of memory

Below is the result of restoring specific tables from backup made by pgadmin using postgresql 8.1.4 for windows Note: Same result also applies to linux distribution of postgresql 8.1.4 --

Re: [BUGS] Fwd: [NOVICE] Trigger and Recursive Relation ?

"Nikolay Samokhvalov" <[EMAIL PROTECTED]> writes: > Is this a bug or not? I don't think so --- or perhaps better, this is a buggy trigger. he UPDATE in the trigger will supersede the base DELETE query for any rows that the UPDATE changes before the base DELETE has reached 'em. Essentially you've w

Re: [BUGS] pg_restore not work on windows 2000, when dump file size > 4G

On Tue, Aug 01, 2006 at 04:16:29PM +0800, Wang Haiyong wrote: > Hello, I run pg_restore on windows. I meet a problem. It is ... > > pg_restore not work on windows 2000, when dump file size > 4G and dump file > format is custom. [...] > pg_restore: [archiver] file offset in dump file is too large