Hi,
As i did not get any answer yesterday i'm asking it again.
I have a table with pictures stored as bytea field.
I'm able to export them from my database hosted by my web supplier.
However, when i try to import them to my local database, i get 2 types of
error message (based on how i import
What about partitioning the table using bar='criteria' and bar!='criteria'
as partitioning condition?
You can then decide to dump only the first subtable, the second or all the
data with pg_dump.
I have similar issues and this is the solution I am working on (still not
done).
Angelo
On
I wrote:
Michael Nolan [EMAIL PROTECTED] writes:
I've narrowed down the conditions under which pg_dump in 8.2.3 is creating a
segmentation fault.
It appears to happen only when dumping a sequence that is created for a
serial data element.
Thanks for the test case --- I can reproduce this
It seems to me that the logical way to do this would be that when the
underlying table is dumped the sequence is dumped with it, like indexes are.
Otherwise if the table is restored from the dump file the sequence may be
out of sync, or not present at all.
What happens when dumping a table with
On 4/13/07, Steve P Shiflett [EMAIL PROTECTED] wrote:
I wish to display the output of a cursor but haven't discovered the trick.
Here's what I'm doing:
According to the documentation, you can fetch from a returned
refcursor like this:
FETCH ALL IN unnamed cursor 1;
You can name the
Michael Nolan [EMAIL PROTECTED] writes:
It seems to me that the logical way to do this would be that when the
underlying table is dumped the sequence is dumped with it, like indexes are.
We do that. The question is how to respond when the pg_dump user
specifically commands us to dump only the
I'm trying to install PostgreSQL on my Mac laptop.
I used MacPorts for the first stage of the installation. I did the
following:
% sudo port install postresql82 +perl +python
This took quite a while to complete, but it ran without a hitch.
From that point on I followed the instructions given
OK, I found the answer to my question about the roles error.
Still, it would be nice to have more up-to-date instructions on how to
install PostgreSQL on OS X. Any pointers would be much appreciated!
TIA!
kj
On 4/15/07, Kynn Jones [EMAIL PROTECTED] wrote:
I'm trying to install PostgreSQL on
On Sun, Apr 15, 2007 at 06:18:18PM -0400, Kynn Jones wrote:
OK, I found the answer to my question about the roles error.
Still, it would be nice to have more up-to-date instructions on how to
install PostgreSQL on OS X. Any pointers would be much appreciated!
Try the main documentation at: