I am having problem with pg_restore 8.1.4
pg_restore: [custom archiver] out of memorypg_restore: *** aborted because of error
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
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
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
"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
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
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
--
"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
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