The following bug has been logged online:

Bug reference: 2840
Logged by: Ned T. Crigler
Email address: crigler (AT) users (DOT) sourceforge.net
PostgreSQL version: 8.2
Operating system: Linux (Debian unstable)
Description: \set HISTCONTROL ignoredups doesn't work in psql
Details:

In psql, doing:

\set HISTCONTROL ignoredups
select 1;
select 1;
select 1;
select 1;
select 1;

adds every select statement into the history, instead of ignoring the
duplicate statements.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

------=_Part_16217_32101006.1166543956812
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 12/19/06, Ned T. Crigler <crigler (AT) users (DOT) sourceforge.net> wrote:
Can you please let us know the environment? If it is psql on Windows, then I
think it is the cmd.exe thats storing that history for you and not psql
itself.

Regards,


--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

------=_Part_16217_32101006.1166543956812
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 12/19/06, <b class="gmail_sendername">Ned T. Crigler</b> &lt;<a href="mailto:crigler (AT) users (DOT) sourceforge.net">crigler (AT) users (DOT) sourceforge.net</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>In psql, doing:<br><br>\set HISTCONTROL ignoredups<br>select 1;<br>select 1;<br>select 1;<br>select 1;<br>select 1;<br><br>adds every select statement into the history, instead of ignoring the<br>duplicate statements.
<br></blockquote></div><br>Can you please let us know the environment? If it is psql on Windows, then I think it is the cmd.exe thats storing that history for you and not psql itself.<br><br>Regards,<br><br clear="all"><br>
-- <br>gurjeet[.singh]@EnterpriseDB.com<br>singh.gurjeet@{ gmail | hotmail | yahoo }.com

------=_Part_16217_32101006.1166543956812--

"Ned T. Crigler" <crigler (AT) users (DOT) sourceforge.net> writes:
Ooops, seems it got broken somewhere between 8.1 and 8.2. Thanks for
the report!

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"Ned T. Crigler" <crigler (AT) users (DOT) sourceforge.net> writes:
Fixed, thanks for the report.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly