Stack Overflow
Stack Overflow

Questions tagged [enterprisedb]

EnterpriseDB (EDB) is the vendor of EDB Postgres Advanced Server, an Oracle-compatible variation of PostgreSQL, and associated tooling

EDB is a commercial vendor of products and services based on the PostgreSQL database. Use this tag for questions concerning EDB Postgres Advanced Server (self- or cloud-hosted) or the older Postgres Plus product (see also: ), as well as EDB-specific tools such as the EDB Backup and Recovery Tool and EDB Postgres Enterprise Manager.

For services, support, and other non-programming-related questions, please use EDB's customer support portal or contact EDB directly: https://www.enterprisedb.com/contact

Further reading:

105 questions
0
votes
1 answer

Issue running Postgresql 9.6 backup (pg_dump/pg_dumpall)

I have a postgreSQL 9.6 installation on Ubuntu 16.04, provided by the EnterpriseDB. I've been connecting to the local server and using it for a number of months. I figured I should backup the server at this point, so I tried using the pg_dump…
Will
  • 87
  • 6
0
votes
3 answers

Migrate MySQL database to PostgreSQL using EnterpriseDB Migration Toolkit

I'm trying to convert my MySQL database to PostgreSQL using EnterpriseDB Migration Tool. My setup is as follows: Windows 10 x64 MySQL 5.5.52 Community Edition GPL EDB PostgreSQL 9.6.2-2 EnterpriseDB Migration Toolkit 50.0.1 The issue is - it…
Alex B
  • 70
  • 7
0
votes
2 answers

java CallableStatement failed, while calling function of postgreSQL enterprise edition

Case History: I have upgraded postgreSQL normal to Enterprise edition Old version: PostgreSQL 9.5.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit New Version: EnterpriseDB 9.5.0.5 on x86_64-pc-linux-gnu,…
Mohit M
  • 769
  • 7
  • 15
0
votes
1 answer

Procedure with OUT parameters in a PostgreSQL package not working

During migration from Oracle to PostgreSQL. I encounter a problem: Procedure with OUT parameters in a PostgreSQL package not working. Whenever run the procedure, it say procedure does not exist. CREATE OR REPLACE PACKAGE pkg_productdetails IS …
Paarth
  • 580
  • 3
  • 10
0
votes
1 answer

"An operation is already in progress" on DataAdaper.Fill

I am trying the Postgres Plus 9.5 with .Net 4.5, Npgsql 3.1.6 NuGet package. I have read what is here about this error, but I do not understand why I get it. Everything is disposed. Here the is code: public override DataTable getActListData(int…
Mottor
  • 1,938
  • 3
  • 12
  • 29
0
votes
1 answer

Postgres copy data & evaluate expression

Is it possible a copy command to evaluate expressions upon insertion? For example consider the following table create table test1 ( a int, b int) and we have a file to import 5 , case when b = 1 then 100 else 101 25 , case when b = 1 then 100…
dimcookies
  • 1,930
  • 7
  • 31
  • 37
0
votes
1 answer

getting error during 'select query' in postgresql with hibernate

we are using ppas9.3 database and hibernate3 in our project. We are using a method that is already calling two other methods. In one method we are executing 'select' query(that becomes fail to execute because that 'column doesn't exist' ) and after…
Krishna
  • 795
  • 2
  • 7
  • 24
0
votes
2 answers

Getting error during insertion of the data in postgresql 9.3

currently i am using PostgreSQL Professional Advanced Server (PPAS) 9.3 (a modified version of PostgreSQL 9.3). I'm trying to insert a row in to postgresql database and getting following error: error…
Krishna
  • 795
  • 2
  • 7
  • 24
0
votes
1 answer

EnterpriseDB - When querying a list of functions/procedures, how to distinguish between the two types

I'm trying to query a list of Functions and Procedures in EnterpriseDB 9.2. I want to distinguish between the two types of function, however, as PgAdmin does in its tree display. I'm trying to script the creation of grant statements for new users,…
Henry
  • 600
  • 2
  • 7
  • 22
0
votes
1 answer

Can we read data from CLOB or TEXT data type column in EnterpriseDB 9.2

I am using EnterpriseDB 9.2 advanced server (an Oracle compatible PostgreSQL fork) and I want to read data from a clob or text type data type column using getClob() method. I'm getting error when trying: org.postgresql.util.PSQLException: Bad…
Krishna
  • 795
  • 2
  • 7
  • 24
0
votes
0 answers

Access package level variables in stored functions written in EnterpriseDB PPAS 9.2

In Oracle we have packages, which we can also use to keep the constant values in one single place. I want to do the same in postgres 9.2. I don't want to hard code the values at every functions I write. I know EnterpriseDB Postgres Plus Advanced…
iDroid
  • 1,140
  • 1
  • 13
  • 30
0
votes
2 answers

PostgreSQL: set cluster Slony I Path

I have installed PostgreSQL enterprise which is have installed slony, I try to set path in the Options Slony-I ... because when I try to make new cluster I see message: slony-i creation scripts not available only joining possible I set path…
Armen Arzumanyan
  • 1,939
  • 3
  • 30
  • 56
0
votes
2 answers

Problem with returning records

Here is the problem with Postgresql that I am facing for last few days: Using select usage_rep_sp.get_result('2009-01-01','2009-12-01')full_name from dual; The package below supposes to return a number of records((at least 5 different names)…
sfslku
  • 1
  • 1
0
votes
1 answer

sql query for converting string to date in gridsql 2.0

I have start_date column in a table of type varchar.eg., GridSQL -> select start_date,count(*) from table_name group by start_date order by start_date asc; start_date -------------- 05-FEB-2010 11-FEB-2011 …
Sukumar
  • 13
  • 3
0
votes
0 answers

Can not write to PPAS logfile

Now, I am testing query from application to PPAS via PgPool. When I query select a.name, b.name from tb_01 a, tb_02 c where a.id = b.id_ref ... or update/insert, I have to wait for a long time (30 --> 60 seconds). I check in my PPAS log file…
Luan Huynh
  • 358
  • 4
  • 20
1 2 3 4 5 6
7