Stack Overflow
Stack Overflow

Questions tagged [postgres-plus]

"Postgres Plus" was the name of EnterpriseDB's Postgres Plus and Postgres Plus Advanced Server products. These are not PostgreSQL, they are semi-compatible PostgreSQL variants aimed at Oracle compatibility.

Postgres Plus was a line of PostgreSQL variants with improved Oracle compatibility and additional management tooling. The product has been supplanted by EDB Postgres Advanced Server - see:

7 questions
1
vote
1 answer

How to avoid a big log file with WAL archiving?

I enabled WAL archiving in EDB Postgresql 9.6 for PITR, but now every time a 16MB log file is created and filling Disk volume. How do I avoid that? These are the changes made to Postgresql.conf to enable the wal archive: wal_level =…
SQLDBA
  • 13
  • 5
0
votes
1 answer

Executing a PostgreSQL Database Package's Function within C# code using LINQ

I am wondering if anyone knows how exactly to go about calling a Package's function within C# code(within a repository class), specifically using LINQ? I have created a package with the help of EDB Postgres documentation. All it does is query a…
JPho
  • 19
  • 4
0
votes
1 answer

("") on calling procedures in EDBPOSTGRESQL

I have a situation here, we are migrating from Oracle to EDB POSTGRES ADVANCED SERVER(ORACLE COMPATIBLE). I will share a sample procedure (the same method is used everywhere in our organization procedures). CREATE OR REPLACE PROCEDURE get_emp( OUT…
vishnudas
  • 53
  • 1
  • 10
0
votes
1 answer

Does Postgres Plus Advanced Server (PPAS) 9.5 support altering (dropping/adding) attributes to composite object types?

According to my reading of the PostgreSQL documentation on ALTER TYPE I should be able to do the following: CREATE TYPE compfoo AS OBJECT (f1 int, f2 text); CREATE TYPE compbar AS OBJECT (f1 int, f2 compfoo); ALTER TYPE compbar DROP ATTRIBUTE…
rbellamy
  • 5,683
  • 6
  • 38
  • 48
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
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
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