[BUGS] interface differences in the 7.0.3 version
Hello, My name is Lonnie Cumberland and I have recently started to migrate our project over to PostgreSQL 7.0.3 as I really like some of the extendability features that I see in you product. We are working on an Internet project demo that will be shown to various people to get our new company off of the ground after which we will be looking to obtain commercial support for the database server. The problem that we are finding is that PostgreSQL 7.0.3 does not seem to be downward compatible with previous releases of PostgreSQL. What I mean to say is that we have been looking at some database web applications such as "www-sql" and "MetaHTML" to handle the database connection to our data. Both of these products are open source and say that they will function with PostgreSQL, but it turns out that they seem to connect bu do not return any data with this 7.0.3 version of PostgreSQL. I initially thought that the applications were the problem, but gound that when I compiled the example code in the libpq++ and executed the applications then data is returned like it should be. This is VERY dissapointing as we are unable to run older versions of PostgreSQL on this system, and the web interface applications that we need to use, and should be downward compatible, do not want to function correctly even though they compile just fine with the new 7.0.3 PostgreSQL. You might want to look into this compatibility problem as it will affect all of the existing applications that were using your previous versions and now CANNOT function correctly. If someone could also let me know about the solution to this problem, then I would greatly appreciate it. Best Regards, Lonnie Cumberland OutStep Technologies Inc., ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] odbc and linux bugs?
Hello, I have been trying for a VERY LONG time to get PostgreSQL 7.0.x to talk to various odbc managers such as unixODBC and OpenLink iODBC which is the latest. The problem is that no matter what I try, I am getting the errors that it cannot connect to the database server. My development system is a PIII 500Mhz running Mandrake Linux 7.2 and I have installed the Postgresql 7.0.3 mdk rpms and also Postgresql-odbc 7.0.3-8mdk.rpm as well with the drivers. With OpenLink iODBC version 2.50-3, my configuration files are: odbc.ini ; ; odbc.ini ; [ODBC Data Sources] OpenLink = OpenLink (MT) [PostgreSQL] Description = PostgreSQL driver for Linux Driver = PostgreSQL Trace = Yes TraceFile = /tmp/sql.log Host = localhost ServerType = PostgreSQL FetchBufferSize = 99 UserName = Password = Database = ServerOptions = ConnectOptions = Options = ReadOnly = no Port = 5432 ;Protocol = 6.4 ;RowVersioning = No ;ShowSystemTables = No ;ShowOidColumn = No ;FakeOidIndex = No ;ConnSettings = -- and odbcinst.ini -- [PostgreSQL] Description = PostgreSQL driver for Linux Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1 --- I have tried to simply run the "postgresql" script located in the /etc/init.d directory and also have tried to run: su -l postgres -c "postmaster -i -d 2 -p 5432 -D /var/lib/pgsql/data " but in every case it seems to be the same thing and I am not sure if your drivers are working. My goal is to use PosegreSQL 7.0.3 with MetaHTML to interface to some HTML code for our site being developed. Can you please help??? Best Regards, Lonnie Cumberland
[BUGS] odbc bug?
Hello, I have been trying for a VERY LONG time to get PostgreSQL 7.0.x to talk to various odbc managers such as unixODBC and OpenLink iODBC which is the latest. The problem is that no matter what I try, I am getting the errors that it cannot connect to the database server. My development system is a PIII 500Mhz running Mandrake Linux 7.2 and I have installed the Postgresql 7.0.3 mdk rpms and also Postgresql-odbc 7.0.3-8mdk.rpm as well with the drivers. With OpenLink iODBC version 2.50-3, my configuration files are: odbc.ini ; ; odbc.ini ; [ODBC Data Sources] OpenLink = OpenLink (MT) [PostgreSQL] Description = PostgreSQL driver for Linux Driver = PostgreSQL Trace = Yes TraceFile = /tmp/sql.log Host = localhost ServerType = PostgreSQL FetchBufferSize = 99 UserName = Password = Database = ServerOptions = ConnectOptions = Options = ReadOnly = no Port = 5432 ;Protocol = 6.4 ;RowVersioning = No ;ShowSystemTables = No ;ShowOidColumn = No ;FakeOidIndex = No ;ConnSettings = -- and odbcinst.ini -- [PostgreSQL] Description = PostgreSQL driver for Linux Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1 --- I have tried to simply run the "postgresql" script located in the /etc/init.d directory and also have tried to run: su -l postgres -c "postmaster -i -d 2 -p 5432 -D /var/lib/pgsql/data " but in every case it seems to be the same thing and I am not sure if your drivers are working. My goal is to use PosegreSQL 7.0.3 with MetaHTML to interface to some HTML code for our site being developed. Can you please help??? Best Regards, Lonnie Cumberland -- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] odbc bug?
Hello, Thanks for the quick response. if I use the "odbctest" to see if my program is there then I get one thing and if I use "odbctest DNS=PostgreSQL", I get something else [root@Treazurac samples]# ./odbctest OpenLink ODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DNS=PostgreSQL [iODBC][Driver Manager]Dialog failed, SQLSTATE=IM008 Have a nice day. [root@Treazurac samples]# ./odbctest DNS=PostgreSQL OpenLink ODBC Demonstration program This program shows an interactive SQL processor [iODBC][Driver Manager]Dialog failed, SQLSTATE=IM008 Have a nice day. --- My odbc.ini is: - ; ; odbc.ini ; [ODBC Data Sources] OpenLink = OpenLink (MT) [PostgreSQL] Description = PostgreSQL driver for Linux Driver = PostgreSQL Trace = Yes TraceFile = /tmp/sql.log Host = localhost ServerType = PostgreSQL FetchBufferSize = 99 UserName = Password = Database = ServerOptions = ConnectOptions = Options = ReadOnly = no Port = 5432 ;Protocol = 6.4 ;RowVersioning = No ;ShowSystemTables = No ;ShowOidColumn = No ;FakeOidIndex = No ;ConnSettings = -- and my odbcinst.ini is --- [PostgreSQL] Description = PostgreSQL driver for Linux Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1 - The MetaHTML is located on the same Linux machine as this odbc manager also. I do not seem to have this ./oplrqb from ~/openlink/bin as I got these drivers from libiodbc-2.50-3.i386-glibc2.rpm libiodbc-devel-2.50-3.i386-glibc2.rpm And have installed the PostgreSQL 7.0.3 from the RPM's on their site along with the PostgreSQL ODBC 7.0.3 drivers from their site as well. I started the Broker in two ways with the same results: I ran the standard /etc/init.d/postgresql start daemon and I also tried another way when things did not communicate by: su -l postgres -c "postmaster -i -d 2 -p 5432 -D /var/lib/pgsql/data " Which also seemed not to communicate with the odbc manager as well. I checked for communications by using the odbctest and MetaHTML applications along with one other one which also gave me: [root@Treazurac tests]# ./scroll PostgreSQL Connecting to PostgreSQL... Failed to connect to datasource: [iODBC][Driver Manager]Dialog failed I am at a loss as to the problem and how to fix it. Best Regards, Lonnie __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] iodbc and Postgresql 7.0.3 update
Hello, I still have not been able to get the PostegreSQL 7.0.3 and iODBC database manager to be set up correctly and am still getting the same errors that I reported yesterday although I attempted to set up the local ~/.odbc.ini I do not know why this is so difficult and it should be relatively easy I think, and even re-installed my PostgreSQL server with the 7.0.3 binary RPM's and still the same result. I was just wondering if ODBC has been compiled into the server in the binary distribution as it seems as though the psqlODBC drivers do not want to work. If the PostgreSQL developers have gotten ODBC to work then I would be VERY interested in hearing how they set it up and what drivers they used. Cheers :( :( Lonnie ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] PostgreSQL tcp connection
Hello, I have installed PostgreSQL 7.0.3 on my Mandrake 7.2 Linux system and have been trying to get it to listen for TCP connectins. I added the "-i" command to the /etc/init.d/postgresql script, but still it does not seem to accept any connections. I can make local connections, but need to be able to have the database on one machine and my webserver database connection application on another machine. Is there something that I have not done correctly and could you please tell me how to get this working? Best Regards, Lonnie Cumberland ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[BUGS] g++ not working for postgresql extension languages?
Hello,
Here is something very important that I think might be a bug for you to look
into as there is some aparent inconsistancies
I was doing some testing before I started to write my c++ routine to extend
PostgreSQL 7.03 on my Linux box and found this problem.
I made two copies of the same file called "funcs.c" and "funcs.cc" as can be
see below.
If I work with the "funcs.cc" file then I can get:
-
[root@Treazurac /test]# g++ -I./include -I./backend -O2 -Wall
-Wmissing-prototypes -Wmissing-declarations -I/usr/include/pgsql -I/usr/include
-fpic -c -o funcs.o funcs.cc
[root@Treazurac /test]# g++ -shared -o funcs.so funcs.o
[root@Treazurac /test]# ls
Makefile Makefile.global Makefile.port funcs.cc funcs.o funcs.so*
funcs.sql
[root@Treazurac /test]# pico -w funcs.sql
[root@Treazurac /test]# psql -f funcs.sql -d trdata
DROP
CREATE
[root@Treazurac /test]# psql trdata
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
trdata=# select concat_text('a','b');
ERROR: Can't find function concat_text in file /test/funcs.so
trdata=#
--
And although I should not be running as "root", this is a test machine and it
is ok for the time being.
If I do the same thing as above, but using the "funcs.c" file (which is the
exact same file just renamed)
---
funcs.c and funcs.cc
-
#include "postgres.h" // for variable length type
#include #include #include #include
#include // for unix crypt function
text *
concat_text(text *arg1, text *arg2);
text *
concat_text(text *arg1, text *arg2)
{
int32 new_text_size = VARSIZE(arg1) + VARSIZE(arg2) - VARHDRSZ;
text *new_text = (text *) malloc(new_text_size);
memset((void *) new_text, 0, new_text_size);
VARSIZE(new_text) = new_text_size;
strncpy(VARDATA(new_text), VARDATA(arg1), VARSIZE(arg1)-VARHDRSZ);
strncat(VARDATA(new_text), VARDATA(arg2), VARSIZE(arg2)-VARHDRSZ);
return (new_text);
}
--
with funcs.sql
--
DROP FUNCTION concat_text(text, text);
CREATE FUNCTION concat_text(text, text) RETURNS text
AS '/test/funcs.so' LANGUAGE 'c';
With the "funcs.c" file in place I get:
-
[root@Treazurac /test]# gcc -I./include -I./backend -O2 -Wall
-Wmissing-prototypes -Wmissing-declarations -I/usr/include/pgsql -I/usr/include
-fpic -c -o funcs.o funcs.c
[root@Treazurac /test]# gcc -shared -o funcs.so funcs.o
[root@Treazurac /test]# psql -f funcs.sql -d trdata
DROP
CREATE
[root@Treazurac /test]# psql trdata
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
trdata=# select concat_text('a','b');
concat_text
-
ab
(1 row)
trdata=#
-
so now I do not understand why the "gcc" version works and the "g++" version
does not?
Just a side note in that I can easliy compile c++ the examples in the
interfaces/libpq++ directory without any problems so that this is very strange
to me.
I really need the "g++" version to work correctly as well?
Any ideas on how to fix this so that I can use c++ functions compiled with g++
in the PL/pgSQL extensions?
Cheers
Lonnie
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
