This is a discussion on View data - aborting randomly and no result within the pgsql Interfaces Pgadmin Hackers forums, part of the PostgreSQL category; --> Hi 1. When I view the data of a table, there is no result. (blank window and status is ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi 1. When I view the data of a table, there is no result. (blank window and status is "aborting") 2. When I execute the query, the result is blank. The status is ":". Both the behaviours are not consistent. I am using pgadmin3-1.6.2/wxWidgets2.8.0 The platform is Solaris10/x86. Any idea?? Thanks Dhanaraj ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
| |||
| Dhanaraj M wrote: > Hi > > 1. When I view the data of a table, there is no result. > (blank window and status is "aborting") > > 2. When I execute the query, the result is blank. > The status is ":". > > Both the behaviours are not consistent. > > I am using pgadmin3-1.6.2/wxWidgets2.8.0 > The platform is Solaris10/x86. > > Any idea?? Are you sure that is 1.6.2? Both of those are symptoms of bugs fixed in earlier 1.6 releases. That said, one other possible reason is that your libpq is not built with --enable-thread-safety. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
| ||||
| Dave Page wrote: >Dhanaraj M wrote: > > >>Hi >> >>1. When I view the data of a table, there is no result. >> (blank window and status is "aborting") >> >>2. When I execute the query, the result is blank. >> The status is ":". >> >>Both the behaviours are not consistent. >> >>I am using pgadmin3-1.6.2/wxWidgets2.8.0 >>The platform is Solaris10/x86. >> >>Any idea?? >> >> > >Are you sure that is 1.6.2? Both of those are symptoms of bugs fixed in >earlier 1.6 releases. > >That said, one other possible reason is that your libpq is not built >with --enable-thread-safety. > > This bug does not appear, when I use Sun's Postgres instead of using my own postgres built. Thanks Dhanaraj ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
| Thread Tools | |
| Display Modes | |
|
|