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() faile
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 broadcast)
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. T
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 b
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 Inter
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 wher
