[GENERAL] ridiculously large crosstabs
I need to generate a very large crosstab. about 50 rows x 50 columns -- for a request for a recurring report. Example: Column Headings = Job_IDand Row Headings = Employee_ID and Values in the table = Hours_worked Got the idea? I've looked at : http://www.postgresonline.com/journal/archives/14-CrossTab-Queries-in-Postgr eSQL-using-tablefunc-contrib.html ...and the comments there. Of course, the Job_IDs change every month... I need some more clues on how to proceed with this - how to 'get' and output the column headings? (Using pgsql 8.2) Thanks, JPD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Windows ODBC connection trouble? ISP issue?
I cannot think of any special reason why the cloud server would allow a connection from my home versus any other location. I will test another location or two. Regards, JPD -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Thursday, March 17, 2011 6:00 PM To: pgsql-general@postgresql.org Cc: Joseph Doench Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue? On Thursday, March 17, 2011 2:50:18 pm Joseph Doench wrote: > My home ISP, our cloud server, and the office ISP are all separate > entities. > > I infer that the problem is with the office ISP - DSL provided by a phone > company. But you could not connect from two Wi-Fi locations either, that tends to rule out the office ISP as root of problem. The common point in all the connections is the cloud server. You can connect from home but not any where else. Would seem to indicate that your cloud server(the server itself,not the Postgres server) is only taking connections from your home. > > > > Regards, > > JPD > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Windows ODBC connection trouble? ISP issue?
My home ISP, our cloud server, and the office ISP are all separate entities. I infer that the problem is with the office ISP - DSL provided by a phone company. Regards, JPD -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Thursday, March 17, 2011 5:44 PM To: pgsql-general@postgresql.org Cc: Joseph Doench Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue? On Thursday, March 17, 2011 2:29:00 pm Joseph Doench wrote: > I have set up a pg database server for my organization on a cloud server > using PG 8.2; > > I am trying to provide connections to the db for some members using MS > Access. I developed a small MS Access application using Windows ODBC - it > works fine from my house. > > I have this line in pg_hba.conf: > > HostallmydbuserID0.0.0.0/0 password > > BUT. I cannot re-create the ODBC connection in our organization's offices! > > > I have de-bugged by taking my laptop to the office - it will not connect > to the db there - but is ok at my house. > (I have also checked 2 other locations with public wi-fi; could not connect > from either of them) > > This seems to be related to the ISP blocking data - I have ruled out the > router in the office. When you say ISP do you mean the cloud provider or the service provider(s) from the various sites? I am assuming that that your home, office and the public Wi-Fi locations are not all using the same ISP. > > Is this a common SNAFU to encounter? My guess is that the firewall rules on your cloud server is only allowing connections from your home site. > > I spent an hour on the phone with tech support for the office's ISP; the > guy insisted it could not be a problem on their side! > > Is there something I could be overlooking? > > Any help or guidance would be greatly appreciated. > > > Regards, > > JPD -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Windows ODBC connection trouble? ISP issue?
I have set up a pg database server for my organization on a cloud server using PG 8.2; I am trying to provide connections to the db for some members using MS Access. I developed a small MS Access application using Windows ODBC - it works fine from my house. I have this line in pg_hba.conf: HostallmydbuserID0.0.0.0/0 password BUT. I cannot re-create the ODBC connection in our organization's offices! I have de-bugged by taking my laptop to the office - it will not connect to the db there - but is ok at my house. (I have also checked 2 other locations with public wi-fi; could not connect from either of them) This seems to be related to the ISP blocking data - I have ruled out the router in the office. Is this a common SNAFU to encounter? I spent an hour on the phone with tech support for the office's ISP; the guy insisted it could not be a problem on their side! Is there something I could be overlooking? Any help or guidance would be greatly appreciated. Regards, JPD
