[BUGS] Documentation

2001-03-14 Thread Igor Seletskiy
text data type is described as as unlimited length, where it is actually limited by the size of page block (8k) Best, Igor Seletskiy ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/fa

[BUGS] modulo operator bug?

2001-03-14 Thread Kemal Bayram
from psql: kemal=# select 0.99 % 0.50; ?column? -- 0.04 (1 row) Am I missing something fundemental here or is this indeed a bug? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (sen

[BUGS] libpq PQstatus failed

2001-03-14 Thread philip.howell
Hi I'm having problems with the PQstatus function in the libpq library. It returns CONNECTION_OK when I know that it is not. I used the followin test program and method to test it: #include #include #include "pgsql/libpq-fe.h" PGconn *make_conn(); int main (int ar

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-14 Thread Peter Eisentraut
Tom Lane writes: > Maybe the AC_TRY_RUN tests could be moved up to before we start probing > for libraries? The overall order of the tests should stay this way, I think. Some library could actually alter the result of a run test. (Think about some -lcompat or -lbsd getting in the way, not unli

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8 INTEL

2001-03-14 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Instead we could run an empty test program before the real tests. If an > empty program fails to run we can abort in good conscience. That sounds like a plan. Do you want to do it, or shall I? regards, tom lane ---

Re: [BUGS] modulo operator bug?

2001-03-14 Thread Tom Lane
Kemal Bayram <[EMAIL PROTECTED]> writes: > from psql: > kemal=# select 0.99 % 0.50; > ?column? > -- > 0.04 > (1 row) > Am I missing something fundemental here or is this indeed a bug? Looks like a bug to me too. mod_var shouldn't be using tmp.rscale, I think.

Re: [BUGS] modulo operator bug?

2001-03-14 Thread Tom Lane
> Kemal Bayram <[EMAIL PROTECTED]> writes: >> from psql: >> kemal=# select 0.99 % 0.50; >> ?column? >> -- >> 0.04 >> (1 row) >> Am I missing something fundemental here or is this indeed a bug? > Looks like a bug to me too. mod_var shouldn't be using tmp.rscale, > I think. OK, fixed fo

[BUGS] odbc and linux bugs?

2001-03-14 Thread Lonnie Cumberland
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 sy

[BUGS] odbc bug?

2001-03-14 Thread Lonnie Cumberland
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 s

Re: [BUGS] odbc bug?

2001-03-14 Thread Tom Lane
Lonnie Cumberland <[EMAIL PROTECTED]> writes: > The problem is that no matter what I try, I am getting the errors that > it cannot connect to the database server. Could we see the exact text of the error message? Also, what if anything appears in the postmaster's stderr log?

Re: [BUGS] odbc bug?

2001-03-14 Thread Lonnie Cumberland
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