Unix Technical Forum

View data - aborting randomly and no result

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Hackers

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 06:36 PM
Dhanaraj M
 
Posts: n/a
Default View data - aborting randomly and no result

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 06:36 PM
Dave Page
 
Posts: n/a
Default Re: View data - aborting randomly and no result

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-17-2008, 06:36 PM
Dhanaraj M
 
Posts: n/a
Default Re: View data - aborting randomly and no result

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:25 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com