Re: [BUGS] select where id=random()*something returns two results

2003-09-19 Thread Ian Grant
> Sorry for buggering you, I get the point :) I think you mean 'bugging.' Buggering is something quite different. ---(end of broadcast)--- TIP 8: explain analyze is your friend

[BUGS] 7.3.3 configure should check for curses before readline

2003-07-02 Thread Ian Grant
The canned readline check assumes that curses is already installed. If it isn't then the readline check fails and configure reports that readline is not available. The real problem though is that curses is not available. -- Ian Grant, Computer Lab., William Gates Building, JJ Thomso

Re: [BUGS] initdb fails on ia64 SMP system

2002-08-20 Thread Ian Grant
> Ian Grant <[EMAIL PROTECTED]> writes: > > Architecture (example: Intel Pentium) : ia64, 4 way SMP > > Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.3 SMP kernel > > Does anything else work for you on that box? I seem to recall that >

Re: [BUGS] initdb fails on ia64 SMP system

2002-08-20 Thread Ian Grant
> Ian Grant <[EMAIL PROTECTED]> writes: > > Architecture (example: Intel Pentium) : ia64, 4 way SMP > > Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.3 SMP kernel > > Does anything else work for you on that box? I seem to recall that >

[BUGS] initdb fails on ia64 SMP system

2002-08-20 Thread Ian Grant
Hello PostgreSQL people, Thanks for making PostgreSQL, it's great. Here's a bug report. Thanks Ian Your name : Ian Grant Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : ia64,

Re: [BUGS] large object seek/write bug

2000-06-15 Thread Ian Grant
our mind you might consider implementing lo_truncate (the lo_ analog of the unix truncate system call.) At present there is no way to reduce the size of a large object except by copying to a new one (and then we still can't delete the old one, or can we do that now?) Cheers Ian -- Ian Gr

[BUGS]

2000-06-14 Thread Ian Grant
sage(conn)); exec_cmd(conn, "END TRANSACTION"); exit(0); } void exec_cmd(PGconn *conn, char *str) { PGresult *res; if ((res = PQexec(conn, str)) == NULL) { fprintf(stderr, "Error executing %s.\n", str); fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn)); exit(1); } if (PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, "Error executing %s.\n", str); fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn)); PQclear(res); exit(1); } PQclear(res); } -- Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge Phone: +44 1223 334420 Personal e-mail: iang at pobox dot com

[BUGS] Bug in libpq large-object interface

2000-05-29 Thread Ian Grant
believed it was then fixed by Tatsuo, after a couple of iterations. I'm sorry to be the bearer of bad news ... Please reply to me directly since I'm not on the list. Thanks Ian -- Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge Phone: +44 1223 334420 Personal e-mail: iang at pobox dot com

[BUGS] Bug in libpq large-object interface

2000-05-29 Thread Ian Grant
exec_cmd(conn, "END TRANSACTION"); exit(0); } void exec_cmd(PGconn *conn, char *str) { PGresult *res; if ((res = PQexec(conn, str)) == NULL) { fprintf(stderr, "Error executing %s.\n", str); fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn)); exit(1); } if (PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, "Error executing %s.\n", str); fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn)); PQclear(res); exit(1); } PQclear(res); } -- Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge Phone: +44 1223 334420 Personal e-mail: iang at pobox dot com