Stack Overflow
Stack Overflow

Questions tagged [edb]

EDB usually refers to an Exchange Database. Exchange Database files store in-process and non-SMTP messages. These files are organized in a b-tree structure. Each EDB file has a corresponding STM file which contains the actual SMTP messages.

60 questions
0
votes
0 answers

How to insert data in object type column in Postgresql table

CREATE TYPE dbobj_vry AS ( a character varying[] ); CREATE TABLE IF NOT EXISTS calender ( day_name text COLLATE pg_catalog."default", day_date dbobj_vry ) TABLESPACE pg_default; Try to insert data in Calendar table. insert into…
Jit Sarkar
  • 17
  • 3
0
votes
1 answer

ALTER SESSION SET CONSTRAINTS = DEFERRED equivalent in EDB/ Postgres

What will be equivalent of following query in EDB Postgres / Open source Postgres? ALTER SESSION SET CONSTRAINTS = DEFERRED
MD NASEEM
  • 1
  • 2
0
votes
0 answers

Postgresql Replication EFM how to reject inserts when Standby nodes are not sync?

I have a 3 nodes cluster for PostgreSQL 14 made by EDB Failover Manager. When I turn off the two standby nodes, the Primary node takes forever to do the insert commands. I don't want it to do insert commands, I want it to act like a read-only node…
Mohammed Alali
  • 7
  • 2
0
votes
0 answers

Oracle And Postgres results different

In case of Oracle the Query select SYSDATE - TO_DATE('30-12-1899','dd-mm-yyyy') from dual; is Giving the Output SYSDATE-TO_DATE('30-12-1899','DD-MM-YYYY') -------------------------------------------- 44715.4067 In case of…
anant
  • 15
  • 1
  • 5
0
votes
0 answers

how can i download postgresql interactive installer for windows?

I tried to download Postgres interactive installer for my Window 10 laptop, and I got a message displaying "thank you for downloading Postgres, your download will begin momentarily, loading...(button)", but the download isn't ongoing, what can I do…
folasade oluwatosin
  • 1
0
votes
0 answers

Is there an equivalent of Oracle dba_profiles in postgres?

I am trying to run select query on one of the objects(dba_profiles) in postgres and getting an error as 'SQL: Database error ERROR: permission denied for view dba_profiles' and upon trying to grant permission for the same to my user, it is throwing…
Rohit K
  • 1
  • 1
0
votes
0 answers

NPGSQL connection pool issue

we are planning to migrate from EDB PostgreSQL to the community PostgreSQL. So we have started using the NPGSQL library instead EDB library. we configured the same connection string settings as what we have in EDB connection strings.
King_Fisher
  • 1,171
  • 8
  • 21
  • 51
0
votes
0 answers

ETABS API with C++: Can I get a Model object from an edb file without opening ETabs?

I knew we have a way to get the Etabs model object by calling the function to open the Etabs application. However, in many cases, we need to import data from etabs file but don't want to open the Etabs application. Is there any way to get the Model…
Quốc Lưu Công
  • 1
  • 1
0
votes
1 answer

Problem: nothing provides libjsoncpp.so.1()(64bit) needed by llvm6-6.0.1-43.25.sles12.x86_64 while installing edb-as12-server in SLES12

Trying to install EDB -PPAS 12 version in SLES12 , But it throws such library errors: node1:/etc/zypp/repos.d # zypper install edb-as12-server Loading repository data... Reading installed packages... Resolving package dependencies... Problem:…
Pooja G
  • 41
  • 1
  • 14
0
votes
1 answer

Dumping entries of a table index

I am trying to seek within the primary index of a table on a customers EDB database. And I fail miserably. I retrieved the index info using JetGetIndexInfo and know all about the index (it's the primary index and I know the column that's used). Now…
Fotis MC
  • 323
  • 1
  • 2
  • 12
0
votes
1 answer

nested types on EDB

I'm having problems on a migration of plsql application to edb. The current problem is, than we have nested types, like: TYPE personas_rt IS RECORD (adulto numeric, nino numeric); TYPE personas_aat IS TABLE OF personas_rt INDEX BY…
sirsanchez
  • 1
  • 1
0
votes
1 answer

Directionless relationship failing in PostgreSQL

I am trying to create a 2-way relationship table in PostgreSQL for my 3 objects. This idea has stemmed from the following question https://dba.stackexchange.com/questions/48568/how-to-relate-two-rows-in-the-same-table where I also want to store the…
User_289
  • 59
  • 1
  • 7
0
votes
1 answer

Offline slony installation on enterprise database 13.1

I have been using Windows 10 operating system. I want to use slony master-slave setup with postgresql. For this, I have downloaded enterprise database 13.1 version. After installation I select slony download from stackbuilder plus. Then I copied…
ayagmur
  • 1
  • 4
0
votes
0 answers

Reading data from edbpostgres into R (date problem)

I have a problem with importing data from edb postgres into R (with RPostgres). I using this code: library(RPostgres) conn <- dbConnect(Postgres(), dbname = 'xx', host = 'xx', port = 'xx', user = 'xx', password = 'xx', …
user8795501
  • 73
  • 10
0
votes
2 answers

Export table rows from sql developer and import in EDB(postgres)

I have exported all rows from all table in a given schema using SQL developer . A sql file is generated which has insert statements . Can I use this to import data in target database EDB(postgres). The target Db has same tables as in Source DB .…
Prashant Singh
  • 23
  • 6
1 2
3
4