Hi there,
Refering to https://www.postgresql.org/message-id/1352742344.21373.4@mofo
I'm running into situations where I'd need to bulk transfer of data
tables across servers, but a drop and recreate schema isn't feasible
as we are running different permissions etc. on the two databases.
Thus
Sorry for the delay in following up here.
On Mon, Nov 26, 2012 at 8:30 PM, Karl O. Pinc k...@meme.com wrote:
On 11/26/2012 08:45:08 PM, Josh Kupershmidt wrote:
On Mon, Nov 26, 2012 at 3:42 PM, Robert Haas robertmh...@gmail.com
wrote:
On Mon, Nov 26, 2012 at 4:51 PM, Karl O. Pinc
On 12/04/2012 09:26:47 PM, Josh Kupershmidt wrote:
Sorry for the delay in following up here.
No problem at all.
Well, as far as I was able to tell, the use-case where this patch
worked without trouble was limited to restoring a table, or schema
with table(s), that:
a.) has some view(s)
On Wed, Nov 21, 2012 at 12:53 AM, Josh Kupershmidt schmi...@gmail.com wrote:
TBH, I didn't find the example above particularly compelling for
demonstrating the need for this feature. If you've just got one table
with dependent views which needs to be restored, it's pretty easy to
manually
On 11/26/2012 12:06:56 PM, Robert Haas wrote:
On Wed, Nov 21, 2012 at 12:53 AM, Josh Kupershmidt
schmi...@gmail.com wrote:
TBH, I didn't find the example above particularly compelling for
demonstrating the need for this feature. If you've just got one
table
with dependent views which
On Mon, Nov 26, 2012 at 4:51 PM, Karl O. Pinc k...@meme.com wrote:
Where I would like to go with this is to first introduce,
as a new patch, an ALTER TABLE option to disable a
constraint. Something like
ALTER TABLE foo UNVALIDATE CONSTRAINT constraintname;
This doesn't really make sense,
On Mon, Nov 26, 2012 at 3:42 PM, Robert Haas robertmh...@gmail.com wrote:
On Mon, Nov 26, 2012 at 4:51 PM, Karl O. Pinc k...@meme.com wrote:
P.S. An outstanding question regards --truncate-tables
is whether it should drop indexes before truncate
and re-create them after restore. Sounds like
On 11/26/2012 08:45:08 PM, Josh Kupershmidt wrote:
On Mon, Nov 26, 2012 at 3:42 PM, Robert Haas robertmh...@gmail.com
wrote:
On Mon, Nov 26, 2012 at 4:51 PM, Karl O. Pinc k...@meme.com wrote:
P.S. An outstanding question regards --truncate-tables
is whether it should drop indexes before
On 11/26/2012 09:30:48 PM, Karl O. Pinc wrote:
On 11/26/2012 08:45:08 PM, Josh Kupershmidt wrote:
It is a common administrative task to selectively restore some
existing tables' contents from a backup, and IIRC was the impetus
for
this patch.
Yes. (And aside from listing tables
On Wed, Nov 21, 2012 at 5:48 AM, Karl O. Pinc k...@meme.com wrote:
On Fri, Sep 21, 2012 at 8:54 AM, Karl O. Pinc k...@meme.com wrote:
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
OT:
After looking at the code I found a number of conflicting
option combinations are not tested for or
Hi Josh,
On 11/20/2012 11:53:23 PM, Josh Kupershmidt wrote:
Hi Karl,
I signed on to review this patch for the current CF.
I noticed. Thanks very much.
On Fri, Sep 21, 2012 at 8:54 AM, Karl O. Pinc k...@meme.com wrote:
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
First, the problem:
Hi Karl,
I signed on to review this patch for the current CF. Most of the
background for the patch seems to be in the message below, so I'm
going to respond to this one first.
On Fri, Sep 21, 2012 at 8:54 AM, Karl O. Pinc k...@meme.com wrote:
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
I've
Hi,
Attached is version 4. Version 3 no longer
built against head.
On 10/16/2012 09:48:06 PM, Karl O. Pinc wrote:
On 09/23/2012 08:52:07 PM, Karl O. Pinc wrote:
On 09/23/2012 12:24:27 AM, Karl O. Pinc wrote:
On 09/23/2012 12:19:07 AM, Karl O. Pinc wrote:
On 09/21/2012 10:54:05
Hi,
Attached is version 3.
The convention seems to be to leave the operator at the
end of the line when breaking long lines, so do that.
Add extra () -- make operator precedence explicit and
have indentation reflect operator precedence.
On 09/23/2012 08:52:07 PM, Karl O. Pinc wrote:
On
Attached is version 2. The sgml did not build.
On 09/23/2012 12:24:27 AM, Karl O. Pinc wrote:
Whoops. Do over. Sent the wrong file.
On 09/23/2012 12:19:07 AM, Karl O. Pinc wrote:
On 09/21/2012 10:54:05 AM, Karl O. Pinc wrote:
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
I've
On 09/21/2012 10:54:05 AM, Karl O. Pinc wrote:
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
I've had problems using pg_restore --data-only when
restoring individual schemas (which contain data which
has had bad things done to it). --clean does not work
well because of dependent
Whoops. Do over. Sent the wrong file.
On 09/23/2012 12:19:07 AM, Karl O. Pinc wrote:
On 09/21/2012 10:54:05 AM, Karl O. Pinc wrote:
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
I've had problems using pg_restore --data-only when
restoring individual schemas (which contain data
On 09/20/2012 12:24:49 PM, Karl O. Pinc wrote:
I've had problems using pg_restore --data-only when
restoring individual schemas (which contain data which
has had bad things done to it). --clean does not work
well because of dependent objects in other schemas.
Before doing any more work I
Hi,
I've had problems using pg_restore --data-only when
restoring individual schemas (which contain data which
has had bad things done to it). --clean does not work
well because of dependent objects in other schemas.
Patch to the docs attached (before I go and do any
real coding.)
Karl
19 matches
Mail list logo