Switching Log Files to Activate Blobspaces

You must switch to the next logical-log file in these situations:

• After you create a blobspace, if you intend to insert simple large objects in the blobspace right away
• After you add a new chunk to an existing blobspace, if you intend to insert simple large objects in the blobspace that will use the new chunk

The database server requires that the statement that creates a blobspace, the statement that creates a chunk in the blobspace, and the statements that insert simple large objects into that blobspace appear in separate logical-log files. This requirement is independent of the database-logging status.

For instructions on switching to the next log file, see Switching to the Next Logical-Log File.