[BUGS] BUG #4621: Password is shown on the terminal
The following bug has been logged online: Bug reference: 4621 Logged by: Rizwan Akbar Email address: rizwan.ak...@catalisse.com PostgreSQL version: 8.2 Operating system: Windows XP Description:Password is shown on the terminal Details: Steps to reproduce: - 1) Take a dump of any database from the console. 2) Now restore the DB by using the following command and parameters. psql -U postgres testdb < D:\backups\jan1809.sql 3) When you press 'Enter' button, system asks for the password. 4) When you type password, it is shown in the plain text instead of in encrypted form or hidden from the user. Expected Result: - 1) Password should be hidden or *s should be shown. Note that I am using the Win XP with service pack 3. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] postgres 8.4
On Tue, Jan 13, 2009 at 1:57 PM, Kev wrote: >> > Is any where guide how to build on Win32, which compiler to use etc? >> >> http://www.postgresql.org/docs/8.3/interactive/install-win32-full.html >> >> > Or may PostgreSQL team build binaries of PostgreSQL 8.3.1 for Perl 5.10? >> >> We won't be building against Perl 5.10 until at least 8.4.0. >> > Will this be true for 8.4, now that development binaries are being > made available? I'm not entirely sure what part of my answer you're asking about the truth of, but currently we're still not using 5.10. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4620: Unexpected(doc'd) side effects of using serial and rules
Many thanks. I guessed as much. It would be useful to add something to the documentation to explain that functions used as defaults are re-written into the sql and the implications of this if used with rules. I did re-write it with a trigger but because statement level triggers do not have access to NEW and OLD it means row level triggers and the performance issues they bring with changes in large numbers of rows. Cheers Simon Keen -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 18 January 2009 16:35 To: Simon Keen Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4620: Unexpected(doc'd) side effects of using serial and rules "Simon Keen" writes: > I have used serial columns as primary keys in some tables. I have a > rule that on insert to a table inserts in another table. However, the > rule appears to cause the seq nextval() to be invoked multiple times > thus destroying any value in NEW.serial_col. This is a well-known issue arising from the fact that a rule is really a macro: multiple references to any expression in the original statement result in multiple evaluations of that expression. By and large, the best way to propagate inserted information to other tables is with a trigger. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4621: Password is shown on the terminal
Rizwan Akbar wrote: > > The following bug has been logged online: > > Bug reference: 4621 > Logged by: Rizwan Akbar > Email address: rizwan.ak...@catalisse.com > PostgreSQL version: 8.2 > Operating system: Windows XP > Description:Password is shown on the terminal > Details: > > Steps to reproduce: - > 1) Take a dump of any database from the console. > 2) Now restore the DB by using the following command and parameters. > psql -U postgres testdb < D:\backups\jan1809.sql > 3) When you press 'Enter' button, system asks for the password. > 4) When you type password, it is shown in the plain text instead of in > encrypted form or hidden from the user. > > Expected Result: - > 1) Password should be hidden or *s should be shown. > > Note that I am using the Win XP with service pack 3. Hmmm. Please try specifying the file name with psql -f, rather than <. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
