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
by 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
by 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
by 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
by 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
by 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
by 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]
Users browsing this forum: No registered users and 20 guests