PostgreSQL 15 Orafce

[Faraz Ahmed]

Hi,

I am stuck with Orafce version for Postgresql 15 please help.

Regards

Syed Faraz Ahmed

[Pavel Stehule]

čt 2. 11. 2023 v 17:44 odesílatel Faraz Ahmed <faraz....@gmail.com> napsal:

Hi,

I am stuck with Orafce version for Postgresql 15 please help.

Can you be more specific? What is the problem?

Regards

Pavel

 

Regards

Syed Faraz Ahmed

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/c80d33e6-6a7c-4c55-90a2-d50f61062526n%40googlegroups.com.

[Faraz Ahmed]

I have pasted below the issue.

 make
gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fPIC -I. -I. -I/usr/include/pgsql/server -I/usr/include/pgsql/internal -D_GNU_SOURCE -I/usr/include/libxml2   -c -o convert.o convert.c
convert.c: In function ‘pg_unicode_to_server’:
convert.c:763:26: error: ‘MAX_MULTIBYTE_CHAR_LEN’ undeclared (first use in this function)
  unsigned char c_as_utf8[MAX_MULTIBYTE_CHAR_LEN + 1];
                          ^
convert.c:763:26: note: each undeclared identifier is reported only once for each function it appears in
convert.c:763:16: warning: unused variable ‘c_as_utf8’ [-Wunused-variable]
  unsigned char c_as_utf8[MAX_MULTIBYTE_CHAR_LEN + 1];
                ^
convert.c: In function ‘orafce_unistr’:
convert.c:1048:1: warning: control reaches end of non-void function [-Wreturn-type]
 }
 ^
make: *** [convert.o] Error 1

[Pavel Stehule]

Hi

po 6. 11. 2023 v 6:47 odesílatel Faraz Ahmed <faraz....@gmail.com> napsal:

I have pasted below the issue.

 make
gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fPIC -I. -I. -I/usr/include/pgsql/server -I/usr/include/pgsql/internal -D_GNU_SOURCE -I/usr/include/libxml2   -c -o convert.o convert.c
convert.c: In function ‘pg_unicode_to_server’:
convert.c:763:26: error: ‘MAX_MULTIBYTE_CHAR_LEN’ undeclared (first use in this function)
  unsigned char c_as_utf8[MAX_MULTIBYTE_CHAR_LEN + 1];
                          ^
convert.c:763:26: note: each undeclared identifier is reported only once for each function it appears in
convert.c:763:16: warning: unused variable ‘c_as_utf8’ [-Wunused-variable]
  unsigned char c_as_utf8[MAX_MULTIBYTE_CHAR_LEN + 1];
                ^
convert.c: In function ‘orafce_unistr’:
convert.c:1048:1: warning: control reaches end of non-void function [-Wreturn-type]
 }
 ^
make: *** [convert.o] Error 1

On Thursday, November 2, 2023 at 9:50:00 PM UTC+5 Pavel Stehule wrote:

it looks so some is broken in your build environment

convert.c uses

#include "mb/pg_wchar.h"

and mb/pg_wchar.h contains

/*
 * Maximum byte length of multibyte characters in any backend encoding
 */
#define MAX_MULTIBYTE_CHAR_LEN<>4

What version of Orafce and Postgres do you use?

 

čt 2. 11. 2023 v 17:44 odesílatel Faraz Ahmed <faraz....@gmail.com> napsal:

Hi,

I am stuck with Orafce version for Postgresql 15 please help.

Can you be more specific? What is the problem?

Regards

Pavel

 

Regards

Syed Faraz Ahmed

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/c80d33e6-6a7c-4c55-90a2-d50f61062526n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/42fe7dc4-3858-4aab-a809-ee35c6e164cbn%40googlegroups.com.

[Faraz Ahmed]

Thanks for the reply. The version of PostgreSQL is 15.0 and don't know the orafce version just downloaded from https://github.com/orafce/orafce. Please send me the download link if other orafce version I should use.

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRCsHdRVY5GvwjLY4nnL-K9vU3rp2tYFe1w86Ea6is3AnA%40mail.gmail.com.

[Pavel Stehule]

po 6. 11. 2023 v 7:39 odesílatel Faraz Ahmed <faraz...@ora-tech.com> napsal:

Thanks for the reply. The version of PostgreSQL is 15.0 and don't know the orafce version just downloaded from https://github.com/orafce/orafce. Please send me the download link if other orafce version I should use.

the link for orafce should be ok

Can you check the header file pg_wchar.h on your computer?

I checked https://github.com/postgres/postgres/blob/REL_15_STABLE/src/include/mb/pg_wchar.h

and MAX_MULTIBYTE_CHAR_LEN is defined there

 

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CACn671REwGp1S7oDE1F5iwSX%3DLLha3UM2SwU4fjf-bJCaUinEA%40mail.gmail.com.

[Faraz Ahmed]

Can you please elaborate you question?

[Faraz Ahmed]

Where should I put this file? I am asking about the path.

[Pavel Stehule]

po 6. 11. 2023 v 8:51 odesílatel Faraz Ahmed <faraz....@gmail.com> napsal:

Can you please elaborate you question?

you should to find the file  pg_wchar.h on your computer. Maybe you have more than one, and maybe it is too old.

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/1ac0491c-9eb2-445c-8dd2-c3c6e3fcfb99n%40googlegroups.com.

[Faraz Ahmed]

I have replace the file and after this getting this error.

convert.c:730:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
convert.c:736:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
convert.c:742:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
convert.c:762:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
convert.c:816:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
convert.c:855:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
convert.c:867:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘{’ token
 {
 ^
In file included from convert.c:6:0:
/usr/include/pgsql/server/mb/pg_wchar.h:680:13: error: old-style parameter declarations in prototyped function definition
 extern void report_invalid_encoding(int encoding, const char *mbstr, int len) pg_attribute_noreturn();
             ^
convert.c:1048:1: error: expected ‘{’ at end of input

 }
 ^
make: *** [convert.o] Error 1

[Pavel Stehule]

po 6. 11. 2023 v 9:20 odesílatel Faraz Ahmed <faraz....@gmail.com> napsal:

I have replace the file and after this getting this error.

you cannot replace just this file one - the header's files should be consistent. Any PostgreSQL major release has its own set of header's files.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/011a5ff6-25a9-478a-a08f-dc441c32992bn%40googlegroups.com.

[Faraz Ahmed]

What should I do now?

[Pavel Stehule]

po 6. 11. 2023 v 10:46 odesílatel Faraz Ahmed <faraz....@gmail.com> napsal:

What should I do now?

What is your build platform?

Probably you should (re) install dev packages for Postgres.

Pavel

 

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/6c446968-0010-4bc6-ad34-bacfcb093679n%40googlegroups.com.