Re: Snapshot synchronization, again...

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Joachim Wieland <joe@mcknight.de>
Cc: Noah Misch <noah@leadboat.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-02-21T15:56:36Z
Lists: pgsql-hackers
A couple more questions:

What's the reason for this restriction?
	if (databaseId != MyDatabaseId)
		ereport(ERROR,
			(errcode(ERRCODE_INVALID_PARAMETER_VALUE),
			 errmsg("cannot import snapshot from a different database")));

Why are we using bytea as the output format instead of text?  The output
is just plain text anyway, as can be seen by setting bytea_output to
'escape'.  Perhaps there would be a value to using bytea if we were to
pglz_compress the result, but would there be a point in doing so?
Normally exported info should be short enough that it would cause more
overhead than it would save anyway.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support