I repeatedly get this error whenever I try to backup a database
The command used is:
pg_dump -Fc -O -U username tablename tablename.20060122
pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table cc_ratecard failed:
PQendcopy() failed.
I am load lots of data via SQL into a database and wrapping it into transactions
speeds it up.
However this fails a number of times. The queries results are logged so it is
easy for me to find problem records.
However a single failure causes the whole transaction to fail.
Is there a setting or
Does VACUUMing reorder tables on clustered indices or is it only the CLUSTER
command that can do that?
/ r church
This message was sent using IMP, the Internet Messaging Program.
---(end of
Quoting Andreas Kretschmer [EMAIL PROTECTED]:
frank church [EMAIL PROTECTED] schrieb:
Hi guys,
What is the command change database owner in PostgreSQL 7.4?
ALTER DATABASE foo OWNER TO blob;
I tried that and it didn't work. That command appears to be available only in
8.0
Hi guys,
What is the command change database owner in PostgreSQL 7.4?
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast)---
TIP 9: In versions
How do you extract postgresql column names, types and comments in tabular form,
using an SQL command?. I know they are stored in one of the system tables, but
I don't know which.
R Church
This message was sent using IMP, the
Is it possible to use subselects as joins in PostgreSQL.
eg.
select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a (second subselect)
b where (in table criteria) and a.a = b.a
or
select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a join (second
subselect) b on a.a = b.a