postgres
diff --git a/‎src/backend/utils/time/snapmgr.c
Copy file name to clipboardExpand all lines: src/backend/utils/time/snapmgr.c
+15-3Lines changed: 15 additions & 3 deletions b/‎src/backend/utils/time/snapmgr.c
Copy file name to clipboardExpand all lines: src/backend/utils/time/snapmgr.c
+15-3Lines changed: 15 additions & 3 deletions
diff --git a/‎src/test/regress/expected/transactions.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/transactions.out
+11Lines changed: 11 additions & 0 deletions b/‎src/test/regress/expected/transactions.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/transactions.out
+11Lines changed: 11 additions & 0 deletions
diff --git a/‎src/test/regress/sql/transactions.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/transactions.sql
+9Lines changed: 9 additions & 0 deletions b/‎src/test/regress/sql/transactions.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/transactions.sql
+9Lines changed: 9 additions & 0 deletions
@@ -1390,9 +1390,21 @@ ImportSnapshot(const char *idstr)
 
 	f = AllocateFile(path, PG_BINARY_R);
 	if (!f)
-		ereport(ERROR,
-				(errcode(ERRCODE_INVALID_PARAMETER_VALUE),
-				 errmsg("invalid snapshot identifier: \"%s\"", idstr)));
+	{
+		/*
+		 * If file is missing while identifier has a correct format, avoid
+		 * system errors.
+		 */
+		if (errno == ENOENT)
+			ereport(ERROR,
+					(errcode(ERRCODE_UNDEFINED_OBJECT),
+					 errmsg("snapshot \"%s\" does not exist", idstr)));
+		else
+			ereport(ERROR,
+					(errcode_for_file_access(),
+					 errmsg("could not open file \"%s\" for reading: %m",
+							path)));
+	}
 
 	/* get the size of the file so that we know how much memory we need */
 	if (fstat(fileno(f), &stat_buf))
 
@@ -1148,6 +1148,17 @@ SELECT * FROM trans_abc ORDER BY 1;
 (3 rows)
 
 DROP TABLE trans_abc;
+-- TRANSACTION SNAPSHOT
+-- Incorrect identifier.
+BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ;
+SET TRANSACTION SNAPSHOT 'Incorrect Identifier';
+ERROR:  invalid snapshot identifier: "Incorrect Identifier"
+ROLLBACK;
+-- Correct identifier, missing file.
+BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ;
+SET TRANSACTION SNAPSHOT 'FFF-FFF-F';
+ERROR:  snapshot "FFF-FFF-F" does not exist
+ROLLBACK;
 -- Test for successful cleanup of an aborted transaction at session exit.
 -- THIS MUST BE THE LAST TEST IN THIS FILE.
 begin;
 
@@ -613,6 +613,15 @@ SELECT * FROM trans_abc ORDER BY 1;
 
 DROP TABLE trans_abc;
 
+-- TRANSACTION SNAPSHOT
+-- Incorrect identifier.
+BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ;
+SET TRANSACTION SNAPSHOT 'Incorrect Identifier';
+ROLLBACK;
+-- Correct identifier, missing file.
+BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ;
+SET TRANSACTION SNAPSHOT 'FFF-FFF-F';
+ROLLBACK;
 
 -- Test for successful cleanup of an aborted transaction at session exit.
 -- THIS MUST BE THE LAST TEST IN THIS FILE.