https://support.ispirer.com/ 2026-04-24T16:45:42+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2025-06-03T15:58:16+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/advanced-options?rev=1748966296&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL: Advanced Options At the “Target Options” page of SQLWays you can see the button “Advanced”, which opens the window with additional options for target database: Tablespaces In PostgreSQL tables and indexes can be stored in separate tablespaces. In SQLWays you can specify the tablespace for Tables or Indexes in the target PostgreSQL database, or Use tablespace names from source database in the Tablespaces secti… text/html 2025-06-03T15:58:15+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/apply-conversion?rev=1748966295&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Outer Apply and Cross Apply Conversion from Microsoft SQL Server to MySQL and PostgreSQL The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table expression. In other words, the right table expression returns rows for the left table expression match only. text/html 2025-06-03T15:58:14+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/bin-directory?rev=1748966294&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL: Bin Directory and Utilities to Perform Import SQLWays is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory. Bin Directory is a path to a folder containing command line utility of the target database, such as psql.exe, sqlcmd.exe, mysql.exe and others. With the help of this utility import process is performed. text/html 2025-08-18T06:32:31+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/bulk-collect-conversion?rev=1755498751&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial BULK COLLECT Conversion to PostgreSQL A bulk collect is a method of fetching data when many rows are placed in a collection at once. This can be a problem when migrating procedures from databases that support this mechanism to others that do not. In this case, Oracle supports the bulk collection, but PostgreSQL does not. The Ispirer toolkit allows you to solve this problem and convert procedures that contain BULK COLLECT in … text/html 2024-04-29T16:07:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/case-insensitive-comparison?rev=1714406875&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Microsoft SQL Server to PostgreSQL Case-Insensitive Comparison Case sensitivity in string comparison operations is a known issue in PostgreSQL. There are several ways to solve this, we will consider three of them. Let's assume that we have such a table in SQL Server: text/html 2024-04-29T12:54:12+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/existing-obj?rev=1714395252&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial ERROR: Relation already exists Symptoms The error may occur during the import into a PostgreSQL database. Causes This error message appears when you try to import an object into a PostgreSQL database that already exists in the target database. text/html 2023-12-15T09:23:01+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/goto-conversion?rev=1702632181&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial GOTO Conversion to PostgreSQL PostgreSQL doesn’t support the GOTO statement, that’s why it requires significant code changes. To emulate the GOTO operator when migrating from Microsoft SQL Server (or other databases that support this operator) to PostgreSQL, you can use the LOOP and CASE statements. Let's have a look in more detail: Create an auxiliary SWL_Label label and wrap the entire body of the procedure in it, not inc… text/html 2023-12-15T09:23:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/inout-out-parameters-conversion?rev=1702632206&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Functions with INOUT/OUT Parameters Conversion to PostgreSQL Oracle allows you to create functions that would return a value, and at the same time have OUT and IN OUT parameters. Writing such functions, although it is bad practice, is a fairly common thing in Oracle databases, especially those written a long time ago. In our practice, we often encounter such functions, and we have trained our tool to accurately convert this … text/html 2024-04-29T16:12:34+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/more-then-100-args?rev=1714407154&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Functions Cannot Have More Than 100 Arguments PostgreSQL has a limit on the number of procedure/function parameters = 100, which is set by the preset configuration parameter max_function_args. We do not recommend changing the value of this parameter as it may cause errors on the server. text/html 2023-12-15T09:24:21+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/no-columns-result?rev=1702632261&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial There are No Columns in the Result Set Symptoms During the export of tables from PostgreSQL database through the ODBC connection the following message arises: “There are no columns in the result set”. Cause PostgreSQL ODBC DSN is not properly tuned on your PC. text/html 2024-04-29T12:51:45+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/no-connect-to-server?rev=1714395105&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Psql: error: could not connect to server: Connection refused Is the server running on host "192.168.0.1" and accepting TCP/IP connections on port 5432 Symptoms The error may occur during the import into a PostgreSQL database. Causes and solutions text/html 2024-04-29T12:57:00+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/no-permision?rev=1714395420&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial ERROR: User has no permission for table Symptoms The error may occur during the import into a PostgreSQL database. Causes This error message appears if you are not the owner of the table or the owner has not granted you the necessary permissions. Depending on what authentication methods (trust, md5, etc. ) you have set, you may receive the following error when trying to work with a particular table. This is usually cause… text/html 2024-05-07T10:55:15+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/no-pghbaconf-entry?rev=1715079315&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial FATAL: no pg_hba.conf entry for host Symptoms During the import into PostgreSQL database which is tuned to set to use SSLmode=allow, prefer, require, verify-ca or verify-full. FATAL: no pg_hba.conf entry for host ... Causes * This type of error appears when trying to make an import into database that uses SSL mode, but there is no match for the client's network address in the pg_hba.conf client authentication rules fil… text/html 2025-08-07T07:30:07+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/no-schema-name?rev=1754551807&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial ERROR: schema does not exist Symptoms When importing into a PostgreSQL database, if the “Remove schema names in SQL objects” option is set to “No” or “Default” and/or a non-existent schema name is specified: Causes This error message appears when trying to import into a PostgreSQL schema that does not exist in the target database. text/html 2025-06-03T15:58:13+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/odbc-driver-configuration?rev=1748966293&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL: ODBC Driver Configuration To set up your PostgreSQL ODBC Driver for Windows, follow the steps below: Specifying ODBC DSN from ODBC Data Source Administrator 1. Please go to the “ODBC Administrator”. If you are using 32-bit version of Ispirer Toolkit on 64-bit machine you need to use 32-bit text/html 2026-03-20T06:34:53+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/odbc-driver-installation?rev=1773988493&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL: ODBC Driver Installation To install ODBC driver for PostgreSQL please follow the steps below: * Please find the driver with required version on the PostgreSQL website. Please note that if you are using 32-bit version of Ispirer Toolkit, you need to install 32-bit driver and 64-bit version of Ispirer Toolkit requires 64-bit driver. text/html 2023-12-15T09:45:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/out-of-memory?rev=1702633538&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Out of Memory while Reading Tuples Symptoms During the export of big tables from PostgreSQL database through the ODBC connection the following message appears: “Out of memory while reading tuples.; memory allocation error”. Cause PostgreSQL ODBC DSN is not properly tuned on your PC. text/html 2023-12-15T09:46:23+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/owner-of-plpgsql?rev=1702633583&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Must be Owner of Language plpgsql while Importing Symptoms During the import of data to PostgreSQL database the ERROR: “must be owner of language plpgsql” while importing appears. Cause The problem occurs due to the inability to execute the command: text/html 2024-04-29T12:56:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/process-in-use?rev=1714395398&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial The process cannot access the file because it is being used by another process Symptoms The error may occur during the import into a PostgreSQL database. Causes The problem may occur due to the following reasons: * The Target database setting are incorrect. text/html 2024-04-30T11:55:24+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/reject-connect-pghbaconf?rev=1714478124&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial FATAL: pg_hba.conf rejects connection for host [IP address] , user [user name], database [database name] [, SSL off] Symptoms The error may occur during the import into a PostgreSQL database that is configured to use a SSL connection. Causes text/html 2026-03-11T14:01:39+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/results-set-conversion-web?rev=1773237699&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Configuring Result Sets Conversion option for PostgreSQL As you know, PostgreSQL does not allow you to return resultsets directly from a procedure. This can be a problem when migrating procedures from databases that support these mechanisms (SQL Server, Sybase ASE, etc.). text/html 2026-03-11T14:01:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/results-set-conversion?rev=1773237719&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Configuring Result Sets Conversion option for PostgreSQL As you know, PostgreSQL does not allow you to return resultsets directly from a procedure. This can be a problem when migrating procedures from databases that support these mechanisms (SQL Server, Sybase ASE, etc.). Ispirer toolkit allows us to solve this problem and convert procedures that return resultsets in several ways. Let's look at these methods using the exampl… text/html 2026-03-11T13:34:09+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/retrieving-data-from-pg-funcs?rev=1773236049&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Retrieving Data from PostgreSQL Functions and Procedures Different mechanisms for returning result sets in PostgreSQL require different approaches for retrieving the returned data. In the article Returning Result Sets in PostgreSQL, some mechanisms that PostgreSQL provides for returning result sets are described: text/html 2026-03-11T13:43:19+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/returning-result-set-in-pg?rev=1773236599&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Returning Result Sets in PostgreSQL Unlike databases such as Microsoft SQL Server or Sybase Adaptive Server Enterprise, PostgreSQL does not allow procedures to directly return result sets in the same way as a plain SELECT statement. However, PostgreSQL provides several mechanisms to return sets of rows. text/html 2025-06-03T15:58:12+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/source-database-case?rev=1748966292&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Preserving Source Database Case in Names of Objects for PostgreSQL as Target Since in PostgreSQL unquoted names are always stored to lower case, to enclose all the identifier names in quotes in target scripts in SQLWays we can switch on the option, which is responsible for this action: text/html 2023-12-14T14:47:04+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/source-user-privileges?rev=1702565224&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL: Setting Up Source User Privileges To be able to extract DDL of objects in PostgreSQL, all you need to do is to create a new user and assign select privileges on sequences and tables to this user. It will be enough to extract the definitions of the objects required for the migration: text/html 2023-12-15T09:46:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/ssl-error?rev=1702633619&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial SSL Error: tlsv1 Alert Protocol Version Symptoms This error may appear when trying to connect to the PostgreSQL database using SSL connection and the following message is shown: SSL Error: tlsv1 alert protocol version Causes It appears because on client side it used old version of TLS protocol that is not allowed by PostgreSQL server. text/html 2025-06-03T15:58:12+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/synonyms-conversion?rev=1748966292&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Synonyms Conversion from Oracle to PostgreSQL Since the PostgreSQL doesn't support the synonyms the migration of synonyms from Oracle to PostgreSQL could have several approches: * using of synonyms in the code could be replaced by using of the objects directly referred to by these synonyms; text/html 2025-06-03T15:58:11+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/synonyms-conversion_from_db2?rev=1748966291&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Synonyms Conversion from DB2 LUW to PostgreSQL Since PG doesn’t support synonyms, they could not be converted from DB2 except those that created for tables. To convert such synonyms using view, you need to use the option: [DDL] SYNONYM_TO_VIEW=Yes text/html 2025-08-18T10:17:30+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/table-types-conversion?rev=1755512250&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Table Types Conversion from Oracle to PostgreSQL Using Arrays Oracle provides a very convenient mechanism for working with table data types. Unfortunately, this can be problematic in other databases. PostgreSQL, for example, does not support table types, so the question of how exactly to convert such types is very important. text/html 2025-06-03T15:58:09+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/table-values-conversion?rev=1748966289&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial User Table-Values Types Conversion from Microsoft SQL Server to PostgreSQL User table-value data types are not supported in the PostgreSQL database, but these objects are very often used in other databases, such as Microsoft SQL Server. Since migrations from Microsoft SQL Server to PostgreSQL are popular, issues often arise when migrating these objects. In Microsoft SQL Server, variables of user table-value data types are us… text/html 2026-04-06T08:42:41+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/target-user-privileges?rev=1775464961&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL: Setting Up Target User Privileges To make import into PostgreSQL Database you can utilize the existing user or create a new one. To create a new user you can execute the statement below: CREATE USER tester with PASSWORD 'postgres'; text/html 2025-06-03T15:58:08+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/text-values-comparison?rev=1748966288&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Comparison of Text Values when Migrating from Microsoft SQL Server to PostgreSQL Often, when migrating from Microsoft SQL Server to PostgreSQL, there is a problem when comparing text values. In contrast to Microsoft SQL Server, where comparing text values is case-insensitive, the PostgreSQL database is case-sensitive. For example, strings 'IsPiRer' and 'ispirer' are equal in Microsoft SQL Server and not equal in PostgreSQL. … text/html 2025-06-03T15:58:08+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/timestamp-conversion?rev=1748966288&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Timestamp Data Type Conversion from Microsoft SQL Server to PostgreSQL In Microsoft SQL Server timestamp is the synonym for the rowversion data. Rowversion is a counter that is incremented for each insert or update operation that is performed on a table that contains a rowversion column within the database. This tracks a relative time within a database, not an actual time that can be associated with a clock. A table can have… text/html 2023-12-15T09:50:40+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql/unicode-sequence?rev=1702633840&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial Character with Byte Sequence <unicode sequence> in Encoding "UTF8" has No Equivalent in Encoding "WIN1252" Symptoms During the export of data from PostgreSQL database the ERROR: character with byte sequence 0xe2 0x89 0xa4 in encoding “UTF8”