On Fri, 2007-07-20 at 14:19 -0400, Mark Steben wrote:
> We are currently at version 7.4.5.
You should upgrade if you want better performance and scalability.
Or maybe you should just use COPY?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
---(end of bro
On Fri, Jul 20, 2007 at 09:06:53AM -0700, Jessica Richard wrote:
> I have a huge table that has a char(80) name column (indexed).
Do you really nead char(N) instead of varchar(N) or text?
> The name pattern is like
>
> A_B_C-D.123.456.pdf
> A_B_C-D.123.333.doc.2
>
> When I select name from tab
Hi, Jessica,
1. How do I get rid of the nonstandard warning, but still using the
index search?
You have two options.
- Turn off the warnings in the postgresql.conf file. Use this with
caution (or don't use it at all) as it does pose a potential threat for
SQL injections if other options aren'
