Thanks guys - yes Adam it seems to behave exactly like text, at least in my
experience.
From: Adam Cornett [adam.corn...@gmail.com]
Sent: Friday, October 14, 2011 2:24 PM
To: k...@rice.edu
Cc: Good, Thomas; pgsql-sql@postgresql.org
Subject: Re: [SQL
I created a table in a hurry and forgot to specify the max capacity for a
varchar() data type.
Can it be said what the max would be in a case like this (just curious)?
thanks much
--
Thomas A. Good, Senior Database Administrator
Saint Vincent's Hospital Westchester
A Division of Saint Joseph's M
hursday, March 17, 2011 1:05 PM
To: Good, Thomas
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Bizarreness at A2 Hosting
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 argue
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
This dubious query worked well previously:
select * from db_log where log_date LIKE '2011-01-%';
(currently works on bluehost.com where they run 8.1.22)
Can someone offer a (preferably ANSI compliant) way to do this on 8.4.5?
I realize that >= and so on work well (which may explain why the docs
a
Hi,
I have a question about a query that starts out fine and over time slows to a
halt - but only on a webhosted site. Locally it does fine.
The query is a singleton select (no joins), hitting a table with about 5,000
records in it. Over time the query slows to a crawl and I have to dump and
