table_name returns empty array

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

table_name returns empty array

Postby samweiss » Tue Jan 22, 2013 2:39 pm

The sql query "SELECT ALL table_name FROM tourney_holdem_table"

is returning an empty array on my machine.

Do I need to add an additional table to the FROM statement?
samweiss
 
Posts: 9
Joined: Thu Jan 10, 2013 7:23 am

Re: table_name returns empty array

Postby kraada » Tue Jan 22, 2013 2:49 pm

I don't think you should, do you have holdem tournaments imported into your database?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: table_name returns empty array

Postby samweiss » Tue Jan 22, 2013 2:51 pm

Im certain that I do have tournaments imported.

I can read the tournament start times with

query ='SELECT ALL id_table FROM tourney_holdem_hand_summary';


but "table_name" is always empty
samweiss
 
Posts: 9
Joined: Thu Jan 10, 2013 7:23 am

Re: table_name returns empty array

Postby samweiss » Tue Jan 22, 2013 3:00 pm

This is strange -

I can access table names from holdem_table, perfectly, but nothing from tourney_holdem_table.

Tournaments must be in the database because I can read their start times
samweiss
 
Posts: 9
Joined: Thu Jan 10, 2013 7:23 am

Re: table_name returns empty array

Postby kraada » Tue Jan 22, 2013 4:17 pm

I've never had a report of that particularly being broken before. I don't have a PT3 database handy to test on right now but in PT4 the analogous table does populate properly for tournaments.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: table_name returns empty array

Postby samweiss » Wed Jan 23, 2013 2:46 pm

Could you please test a PT3 database, just to confirm whether it is a problem with my install or PT3 in general?
samweiss
 
Posts: 9
Joined: Thu Jan 10, 2013 7:23 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 20 guests

cron