Re: [SQL] Bizarreness at A2 Hosting

2011-03-17 Thread Good, Thomas
Hi John, No the two hosts are separate and so it's two separate pg templates. The techie told me, "well, it's ok, because you can see his table but you can't access his data..." egads From: John DeSoi [de...@pgedit.com] Sent: Thursday, March 17, 2011 1:0

Re: [SQL]How to transform table rows into Colum?

2011-03-17 Thread Richard Albright
you can also generate a crosstab table using the sign function you can check out the link below ( its a sqlite tutorial, but the same idea will work for pg too ) http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html On 03/09/2011 12:16 PM, Eric Ndengang wrote: Hi Guys, I have the fo

Re: [SQL] Bizarreness at A2 Hosting

2011-03-17 Thread John DeSoi
On Mar 17, 2011, at 12:26 PM, Good, Thomas wrote: > 4) try to run pg_dump - it fails as it is unable to lock this other guy's > table > > tech suppt argues with me that their template is not hosed, "that is the > nature of postgre," he said (not a typo, he omitted the trailing s) > > These gu

[SQL] Bizarreness at A2 Hosting

2011-03-17 Thread Good, Thomas
I realize this is not the right list for this question but I am just flabbergasted, am only on one list, and, know Tom Lane is here so, please excuse... Here is the deal: On a2 hosting I do the following: 1) create a new database in cpanel 2) login via psql 3) run \d AND - there is ALREADY a