FWD » Core Development » Database

01/08/2019

12:34 AM Feature #3757: add metadata support

Ovidiu Maxiniuc wrote:
> Yes, I think this can be done. The @RecordLockEvent@ received by @LockTableUpdater@ seems t... Eric Faulhaber

01/07/2019

04:05 PM Feature #3757: add metadata support

Eric Faulhaber wrote:
> I think the @_database-feature@ and @_startup._startup-locktable@ changes can be handled via... Ovidiu Maxiniuc

01/03/2019

03:07 PM Feature #3757: add metadata support

Greg Shah wrote:
> What runtime work is needed to complete this task?
I think the @_database-feature@ and @_start... Eric Faulhaber

01:13 PM Feature #3500: implement CLOB and BLOB support

Greg Shah wrote:
> What work is left in this task?
Basic LOB CRUD access is supported, but some language features... Eric Faulhaber

01/02/2019

03:01 PM Feature #3758: misc database features

Greg Shah wrote:
> Eric: Please summarize what needs to be done for this task.
*DBTASKID Function*
Full runtime ... Eric Faulhaber

11:33 AM Feature #3758: misc database features

Eric: Please summarize what needs to be done for this task. Greg Shah

11:33 AM Feature #3757: add metadata support

What runtime work is needed to complete this task? Greg Shah

10:06 AM Feature #3500: implement CLOB and BLOB support

What work is left in this task? Greg Shah

12/16/2018

05:12 AM Feature #3500: implement CLOB and BLOB support

3750a/11346 adds support for the import of BLOBs and CLOBs. It requires that all LOB export files reside in a subdire... Eric Faulhaber

12/15/2018

03:49 AM Feature #3500: implement CLOB and BLOB support

I've added basic conversion and runtime support for BLOB and CLOB in 3750a/11334. Does not include changes to data im... Eric Faulhaber

12/13/2018

05:14 PM Feature #3500: implement CLOB and BLOB support

Turns out, I need to fetch the LOB data at the time the record is retrieved, otherwise we can't be sure we can get it... Eric Faulhaber

02:42 PM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

The cause of this issue is documented in @ConnectionManager.java@:438:... Ovidiu Maxiniuc

11:19 AM Feature #3759: setup, test and document PostgreSQL on Windows

This thread is public, but I agree that the artifacts should be seen from the other two documents as well. Greg Shah

11:16 AM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> What updates need to be made to the documentation chapters so that it is complete?
>
> https:/... Ovidiu Maxiniuc

08:57 AM Feature #3759: setup, test and document PostgreSQL on Windows

What updates need to be made to the documentation chapters so that it is complete?
https://proj.goldencode.com/pro... Greg Shah

04:34 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Eugenie,
>
> I guess you refer in note-65 of MinGW-built PostgreSQL. Building with MSVC... Eugenie Lyzenko

02:41 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie,
I guess you refer in note-65 of MinGW-built PostgreSQL. Building with MSVC-built PostgreSQL is much simp... Ovidiu Maxiniuc

09:32 PM Feature #3759: setup, test and document PostgreSQL on Windows

Several conclusions about building @PL/Java@ and modified @MinGW@ include directory with Windows environment:
1. T... Eugenie Lyzenko

12/12/2018

06:21 PM Feature #3500: implement CLOB and BLOB support

Eric Faulhaber wrote:
> I think the data has to be accessible via the database.
That is clearly better for apps t... Greg Shah

05:17 PM Feature #3500: implement CLOB and BLOB support

I think the data has to be accessible via the database. Eric Faulhaber

03:35 PM Feature #3500: implement CLOB and BLOB support

> The downside is memory consumption; it doesn't take many DMOs with big LOBs stored in memory to cause a problem.
... Greg Shah

02:48 PM Feature #3500: implement CLOB and BLOB support

The way Hibernate maps BLOBs is to @byte[]@ or to @java.sql.Blob@; CLOBs to @String@ or to @java.sql.Clob@.
Using ... Eric Faulhaber

06:40 AM Feature #3759: setup, test and document PostgreSQL on Windows

It is OK to install a pre-built (on your system) PL/Java on the customer system. Greg Shah

06:03 AM Feature #3759: setup, test and document PostgreSQL on Windows

I started to build PL/Java on customer system but at the end I stumbled on following issue: the @javah@ is missing fr... Ovidiu Maxiniuc

04:32 AM Feature #3759: setup, test and document PostgreSQL on Windows

Added openssl header files needed to built PL/Java with mingw-built PostgreSQL. Ovidiu Maxiniuc

12/11/2018

01:43 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Can you try to move your @PostgreSQL@ to @C:\PostgreSQL\pg95\..... Eugenie Lyzenko

01:39 PM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> We don't need to update the gcc version. Let's just include the missing files and update our dis... Eugenie Lyzenko

01:34 PM Feature #3759: setup, test and document PostgreSQL on Windows

We don't need to update the gcc version. Let's just include the missing files and update our distribution download.
... Greg Shah

01:27 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Can you try to move your @PostgreSQL@ to @C:\PostgreSQL\pg95\....@ and check if it works?
... Ovidiu Maxiniuc

12:54 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Strange but I do not need this to be copied in MinGW(even for @... Eugenie Lyzenko

12:52 PM Feature #3759: setup, test and document PostgreSQL on Windows

The my points about new @GCC@ version update is the following. There are a lot of changes between @4.9.0@ to @8.2.0@.... Eugenie Lyzenko

12:39 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Strange but I do not need this to be copied in MinGW(even for @GCC 8.2.0@) to build PL/Java... Ovidiu Maxiniuc

12:33 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> * @win32@ directory has about a dozen files and sub-directories. Neither have any headers. ... Eugenie Lyzenko

11:56 AM Feature #3759: setup, test and document PostgreSQL on Windows

If our existing distribution will work with just adding these files, I'm OK with that approach. Greg Shah

11:52 AM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> Ovidiu Maxiniuc wrote:
> > Greg, how do we handle the missing header files issue? Evidently, we ... Ovidiu Maxiniuc

11:27 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Greg, how do we handle the missing header files issue? Evidently, we cannot ask the custome... Greg Shah

11:15 AM Feature #3759: setup, test and document PostgreSQL on Windows

Greg, how do we handle the missing header files issue? Evidently, we cannot ask the customers to install msvc-built P... Ovidiu Maxiniuc

10:51 AM Feature #3759: setup, test and document PostgreSQL on Windows

Well, the new version of @GCC@ from @20180726@ is @8.2.0@. Need to inspect what the new features we have got in this ... Eugenie Lyzenko

10:23 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Yes, we can publish our Windows binaries for @PL/Java@. We just... Eugenie Lyzenko

10:20 AM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> I am open to changing our packaged version if needed to support all functionality. What do you r... Eugenie Lyzenko

10:18 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Yes, we can publish our Windows binaries for @PL/Java@. We just need to create and test com... Ovidiu Maxiniuc

10:00 AM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> ...
> We need to make it reasonable to get things like this built. We can also publish our Wind... Eugenie Lyzenko

09:53 AM Feature #3759: setup, test and document PostgreSQL on Windows

The addition. My previous note about @MinGW@ was wrong. We do not build @MinGW@ itself. We use already compiled binar... Eugenie Lyzenko

09:52 AM Feature #3759: setup, test and document PostgreSQL on Windows

I am open to changing our packaged version if needed to support all functionality. What do you recommend?
We need... Greg Shah

09:42 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> ...
> > Do we have a plans to upgrade our prepackaged versions.
> Yes, Greg agreed on th... Eugenie Lyzenko

08:09 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> I have good news.
>
> The @pljava 1.5.2@ package that I built today installs on both ins... Eugenie Lyzenko

07:59 AM Feature #3759: setup, test and document PostgreSQL on Windows

I have good news.
The @pljava 1.5.2@ package that I built today installs on both instances of PostgreSQL. Indeed, ... Ovidiu Maxiniuc

07:59 AM Feature #3759: setup, test and document PostgreSQL on Windows

Or as alternative you can try to manually copy the files from your @postgresql@ subdir to new location:
1. complete ... Eugenie Lyzenko

07:02 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> > The question remaining unclear for me - how can I get the @MSVC@ based PostgreSQL and @Mi... Eugenie Lyzenko

06:16 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Ovidiu Maxiniuc wrote:
> This allows to use it in command line leaving original copy in ma... Ovidiu Maxiniuc

05:58 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
...
> > 3. Use @aol.mingw.properties@ provided here.
> I tried with all above. The @aol.min... Eugenie Lyzenko

05:49 AM Feature #3759: setup, test and document PostgreSQL on Windows

Yes, this time the extension was created with success. I also upgraded to 1.5.2 (I used 1.5.0 previously). I do not k... Ovidiu Maxiniuc

03:54 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Looks like I have worked PLJava extension. What was changed:
> 0. @MSYSTEM@ must be @MINGW... Ovidiu Maxiniuc

11:04 PM Feature #3759: setup, test and document PostgreSQL on Windows

One addition. The system used is @Windows 7 64-bit Ultimate@. Eugenie Lyzenko

11:01 PM Feature #3759: setup, test and document PostgreSQL on Windows

Looks like I have worked PLJava extension. What was changed:
0. @MSYSTEM@ must be @MINGW64@
1. Upgrade @MAVEN@ to 3... Eugenie Lyzenko

12/10/2018

03:06 PM Feature #3759: setup, test and document PostgreSQL on Windows

My started config environment:
1. PostgreSQL 9.5.15 downloaded as binary (to be on the almost same level as in Linux... Eugenie Lyzenko