473,605 Members | 2,735 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

RPM RH9.0 conflict with unixODBC

This is what I got installing the RPM for 9.0:

file /usr/include/sqltypes.h from install of
postgresql-devel-7.4-0.3PGDG conflicts with file from package
unixODBC-devel-2.2.3-6

BTW I think that something is wrong with the file size
between two distributions:

this are the rpm for 9.0:

3768418 Nov 24 10:07 postgresql-7.4-0.3PGDG.i386.rp m
2660177 Nov 24 10:07 postgresql-contrib-7.4-0.3PGDG.i386.rp m
2030011 Nov 24 10:08 postgresql-devel-7.4-0.3PGDG.i386.rp m
1185543 Nov 24 10:07 postgresql-docs-7.4-0.3PGDG.i386.rp m
948473 Nov 24 10:07 postgresql-jdbc-7.4-0.3PGDG.i386.rp m
760377 Nov 24 10:07 postgresql-libs-7.4-0.3PGDG.i386.rp m
660158 Nov 24 10:07 postgresql-pl-7.4-0.3PGDG.i386.rp m
98019 Nov 24 10:07 postgresql-python-7.4-0.3PGDG.i386.rp m
9864477 Nov 24 10:06 postgresql-server-7.4-0.3PGDG.i386.rp m
158713 Nov 24 10:07 postgresql-tcl-7.4-0.3PGDG.i386.rp m
1053201 Nov 24 10:05 postgresql-test-7.4-0.3PGDG.i386.rp m
and this for rhas-2.1:

2080872 Nov 24 10:08 postgresql-7.4-0.3PGDG.i386.rp m
487992 Nov 24 10:08 postgresql-contrib-7.4-0.3PGDG.i386.rp m
674440 Nov 24 10:08 postgresql-devel-7.4-0.3PGDG.i386.rp m
1126355 Nov 24 10:09 postgresql-docs-7.4-0.3PGDG.i386.rp m
948208 Nov 24 10:08 postgresql-jdbc-7.4-0.3PGDG.i386.rp m
157377 Nov 24 10:08 postgresql-libs-7.4-0.3PGDG.i386.rp m
248003 Nov 24 10:08 postgresql-pl-7.4-0.3PGDG.i386.rp m
43065 Nov 24 10:08 postgresql-python-7.4-0.3PGDG.i386.rp m
3127278 Nov 24 10:08 postgresql-server-7.4-0.3PGDG.i386.rp m
28270 Nov 24 10:09 postgresql-tcl-7.4-0.3PGDG.i386.rp m
1048176 Nov 24 10:09 postgresql-test-7.4-0.3PGDG.i386.rp m
how you can see the sizes are completely different.
Am I missing something ?

Regards
Gaetano Mendola


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
7 1847
On Monday 24 November 2003 03:05 pm, Gaetano Mendola wrote:
This is what I got installing the RPM for 9.0: file /usr/include/sqltypes.h from install of
postgresql-devel-7.4-0.3PGDG conflicts with file from package
unixODBC-devel-2.2.3-6
Namespace collision, I guess. Makes me wonder about popping all those devel
files in /usr/include; I'll have to research. I can confirm that the
conflict exists in Fedora Core; I don't typically have unixODBC-devel
installed on my build boxes.
BTW I think that something is wrong with the file size
between two distributions: this are the rpm for 9.0: 3768418 Nov 24 10:07 postgresql-7.4-0.3PGDG.i386.rp m and this for rhas-2.1: 2080872 Nov 24 10:08 postgresql-7.4-0.3PGDG.i386.rp m how you can see the sizes are completely different.
Am I missing something ?


Compiler version and flags. Although that is a substantial difference. The
rhas-2.1 compiler is the Red Hat gcc 2.96, and the RH9 compiler is gcc 3.
Apparently gcc 3 generates large code. Sander, can you verify this, since
you built both of these?
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2
Hi,
this are the rpm for 9.0:
3768418 Nov 24 10:07 postgresql-7.4-0.3PGDG.i386.rp m
and this for rhas-2.1:
2080872 Nov 24 10:08 postgresql-7.4-0.3PGDG.i386.rp m

how you can see the sizes are completely different.
Am I missing something ?


Compiler version and flags. Although that is a substantial difference.

The rhas-2.1 compiler is the Red Hat gcc 2.96, and the RH9 compiler is gcc 3.
Apparently gcc 3 generates large code. Sander, can you verify this, since
you built both of these?


The file sizes are correct. I can't explain the huge difference though...
They both contain the same files, and are built from the same specfile. The
only difference between the build commands is that the RedHat 9 RPMs are
built with --define 'build89 1', and the RHEL RPMs are built with --define
'build7x 1' and --define 'plperl 0'. The exclusion of plperl shouldn't make
a difference in this RPM, only in the postgresql-pl RPM...

In short: both filesizes are correct, and I can't explain it :(
Sander.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #3
Sander Steffann wrote:
Hi,

this are the rpm for 9.0:
3768418 Nov 24 10:07 postgresql-7.4-0.3PGDG.i386.rp m

and this for rhas-2.1:
2080872 Nov 24 10:08 postgresql-7.4-0.3PGDG.i386.rp m

how you can see the sizes are completely different.
Am I missing something ?


Compiler version and flags. Although that is a substantial difference.


The
rhas-2.1 compiler is the Red Hat gcc 2.96, and the RH9 compiler is gcc 3.
Apparently gcc 3 generates large code. Sander, can you verify this, since
you built both of these?

The file sizes are correct. I can't explain the huge difference though...
They both contain the same files, and are built from the same specfile. The
only difference between the build commands is that the RedHat 9 RPMs are
built with --define 'build89 1', and the RHEL RPMs are built with --define
'build7x 1' and --define 'plperl 0'. The exclusion of plperl shouldn't make
a difference in this RPM, only in the postgresql-pl RPM...

In short: both filesizes are correct, and I can't explain it :(
Sander.


However 6MB of difference for postgresql-server-7.4-0.3PGDG.i386.rp m
and 2.2 MB for postgresql-contrib-7.4-0.3PGDG.i386.rp m
are too much !
I'd like to have time to dig on it...
Regards
Gaetano Mendola

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #4
On Tue, 2003-11-25 at 12:39, Gaetano Mendola wrote:
Sander Steffann wrote:

....
In short: both filesizes are correct, and I can't explain it :(
Sander.


However 6MB of difference for postgresql-server-7.4-0.3PGDG.i386.rp m
and 2.2 MB for postgresql-contrib-7.4-0.3PGDG.i386.rp m
are too much !


If you do a 'file' command on the executables does one set show
up stripped while the other doesn't. The sizes of individual
files are consistent with that difference (roughly).

If they are the same, and 'ldd' shows the same set of shared
libraries loaded, then look at the sizes of the non-shared
libraries used on the two OS versions.

--
Steve Wampler -- sw******@noao.e du
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #5
Steve Wampler wrote:
On Tue, 2003-11-25 at 12:39, Gaetano Mendola wrote:
Sander Steffann wrote:
...
In short: both filesizes are correct, and I can't explain it :(
Sander.


However 6MB of difference for postgresql-server-7.4-0.3PGDG.i386.rp m
and 2.2 MB for postgresql-contrib-7.4-0.3PGDG.i386.rp m
are too much !

If you do a 'file' command on the executables does one set show
up stripped while the other doesn't. The sizes of individual
files are consistent with that difference (roughly).

If they are the same, and 'ldd' shows the same set of shared
libraries loaded, then look at the sizes of the non-shared
libraries used on the two OS versions.


This mean that file for 9.0 must be stripped ?

RHAS-2.1:
tsearch2.so 152888 bytes

RH9.0:
tsearch2.so 951236 bytes

compiling this file from a postgresql-7.4.tar.gz
on a RH9.0 I obtain:
libtsearch2.so. 0.0 158565 bytes

that is most like a RHAS2.1 size.

RH9.0 where I compiled the tar.gz:

ldd libtsearch2.so. 0.0
libm.so.6 => /lib/tls/libm.so.6 (0x4003d000)
libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

RH9.0:

ldd tsearch2.so
libm.so.6 => /lib/tls/libm.so.6 (0x40040000)
libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

RHAS2.1:

ldd tsearch2.so
libm.so.6 => /lib/i686/libm.so.6 (0x4002c000)
libc.so.6 => /lib/i686/libc.so.6 (0x4004f000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

RHAS-2.1:
gdb tsearch2.so GNU gdb Red Hat Linux (5.3post-0.20021129.18rh )
Copyright 2003 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-redhat-linux-gnu"...(no debugging
symbols found)...
RH9.0:
gdb tsearch2.so

GNU gdb Red Hat Linux (5.3post-0.20021129.18rh )
Copyright 2003 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-redhat-linux-gnu"...

note that there is no warning about the debugging symbols :-(
is strange because the gdb on libtsearch2.so. 0.0 ( 158565 bytes )
don't complain neather about the debugging symbols...

Am I crazy ?


Regards
Gateano Mendola



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #6
On Tuesday 25 November 2003 03:38 pm, Gaetano Mendola wrote:
RHAS-2.1:
tsearch2.so 152888 bytes RH9.0:
tsearch2.so 951236 bytes


FWIW, on Fedora Core:
[lowen@localhost pgsql]$ ls -l tsearch2.so
-rwxr-xr-x 1 root root 141348 Nov 21 21:53 tsearch2.so
[lowen@localhost pgsql]$

Something is certainly unusual here. Sander, can you rebuild the RH9 set and
see why it is so large? For some reason, I missed how many places were in
there, and missed the fact that there were multiple megabytes difference.
Debugging symbols or no, this is big.

And as Fedora Core uses gcc 3, that doesn't explain it.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #7
Hi,
Something is certainly unusual here. Sander, can you rebuild the RH9 set and see why it is so large? For some reason, I missed how many places were in
there, and missed the fact that there were multiple megabytes difference.
Debugging symbols or no, this is big.


The difference in size is 100% related to the stripped/unstripped binaries.
These are the RH9 files in /usr/bin as they are in the RPM:

-rwxr-xr-x 1 planeet sander 208173 Nov 23 01:40 clusterdb
-rwxr-xr-x 1 planeet sander 208816 Nov 23 01:40 createdb
-rwxr-xr-x 1 planeet sander 258577 Nov 23 01:40 createlang
-rwxr-xr-x 1 planeet sander 208161 Nov 23 01:40 createuser
-rwxr-xr-x 1 planeet sander 205248 Nov 23 01:40 dropdb
-rwxr-xr-x 1 planeet sander 257890 Nov 23 01:40 droplang
-rwxr-xr-x 1 planeet sander 205322 Nov 23 01:40 dropuser
-rwxr-xr-x 1 planeet sander 739671 Nov 23 01:40 pg_dump
-rwxr-xr-x 1 planeet sander 176362 Nov 23 01:40 pg_dumpall
-rwxr-xr-x 1 planeet sander 32745 Nov 23 01:41 pg_encoding
-rwxr-xr-x 1 planeet sander 36674 Nov 23 01:40 pg_id
-rwxr-xr-x 1 planeet sander 539901 Nov 23 01:40 pg_restore
-rwxr-xr-x 1 planeet sander 908106 Nov 23 01:40 psql
-rwxr-xr-x 1 planeet sander 143996 Nov 23 01:40 vacuumdb

And after stripping them:

-rwxr-xr-x 1 planeet sander 22936 Nov 26 01:15 clusterdb
-rwxr-xr-x 1 planeet sander 22944 Nov 26 01:15 createdb
-rwxr-xr-x 1 planeet sander 28160 Nov 26 01:15 createlang
-rwxr-xr-x 1 planeet sander 23000 Nov 26 01:15 createuser
-rwxr-xr-x 1 planeet sander 20772 Nov 26 01:15 dropdb
-rwxr-xr-x 1 planeet sander 27564 Nov 26 01:15 droplang
-rwxr-xr-x 1 planeet sander 20836 Nov 26 01:15 dropuser
-rwxr-xr-x 1 planeet sander 160776 Nov 26 01:15 pg_dump
-rwxr-xr-x 1 planeet sander 28824 Nov 26 01:15 pg_dumpall
-rwxr-xr-x 1 planeet sander 4464 Nov 26 01:15 pg_encoding
-rwxr-xr-x 1 planeet sander 4592 Nov 26 01:15 pg_id
-rwxr-xr-x 1 planeet sander 77120 Nov 26 01:15 pg_restore
-rwxr-xr-x 1 planeet sander 152344 Nov 26 01:15 psql
-rwxr-xr-x 1 planeet sander 13012 Nov 26 01:15 vacuumdb

This makes the difference between 4.1M (before) and 644K (after). I just
noticed that I disabled the debug-package that RH9 builds by default. That
very probably causes this difference. I will rebuild the RPMs with the
debug-package enabled to see what happens.

Sander.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4129
by: Cary | last post by:
Trying to install on SuSE 8.2 from source. ../configure --with-apxs=/usr/local/apache/bin/apxs --with-mysql --with-unixODBC=/usr/lib getting this error: /root/php-4.3.2/ext/odbc/php_odbc.c -o ext/odbc/php_odbc.lo In file included from /root/php-4.3.2/ext/odbc/php_odbc.c:37: /root/php-4.3.2/ext/odbc/php_odbc_includes.h:118:17: sql.h: No such file or directory
0
1427
by: Tbird67ForSale | last post by:
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed UnixODBC to access it. It appears that the performance is dramatically slower using the same application, pointed to the RedHat server. The performance of command line queries works as expected on the Linux box. I have to use ODBC to access the data (unless anyone knows of a SAS...
0
2481
by: Bang | last post by:
Hi All, Recently I installed unixODBC(2.2.3) and MySql and MyODBC on Redhat 9.0. After the installation, I am able to use test program isql to connect to the database I created with mysql. However, if I run my application (linked with -lodbc), in SQLConnect it will get the following error: Message: Can't open cursor lib 'libodbccr' : /lib/libo
3
4856
by: Greg | last post by:
Hi, Does anyone know what is the difference between the two ODBC systems ? Are there any other popular and established standards ? Thanks for the help. -greg
3
6898
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the Accpac 5.1 client program (I would like to find an OpenSource generic ODBC program for Wiindows that can do simple SQL). An Accpac database was installed and the Win32 ODBC connection is working. Trying to connect a Linux client via unixODBC I...
0
1408
by: zhengfish | last post by:
HI,all I used an odbc-wrapper connectting mysql with unixODBC. But it didnt work well, often some exception occured. So I need one new wrapper for unixODBC, it must run stably. Could U give me an advice? THX
0
1099
by: erik.myllymaki | last post by:
I am using a script that's worked for me in the past on Windows, but now that i've moved it to a Linux machine it is not. The trouble seems to be when trying to insert escaped characters into a varchar field (\n \r ,etc.). ----------------------------------------------------------------------------- # conn = mx.ODBC.WINDOWS.DriverConnect('DSN=myDSN;UID=sa;PWD=pwd') conn = mx.ODBC.unixODBC.DriverConnect('DSN=myDSN;UID=sa;PWD=pwd')...
0
1562
by: UDBDBA | last post by:
Hi: We have a setup which connects a V8.2 32bit db2 instance on AIX to SQLServer 2000 using the unixODBC driver. We have 5 SQLServer "Server mappings" and 4 of them work just fine and can use the nicknames associated with it. The one last mapping is going against a sqlserver and can't seem to get the nicknames setup on db2. The error is:
4
5036
by: Gregor =?UTF-8?B?S292YcSN?= | last post by:
Hi! I have DB2 Express-C v9.1 installed on my machine. It is Linux UBUNTO 6.10. I've installed unixODBC version 2.2.11. My /etc/odbcinst.ini: Trace=yes Tracefile=/home/gregor/trc.log
0
8001
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7934
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8424
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8069
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6742
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5445
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3912
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3958
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1270
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.