Re: [BUGS] BUG #4450: Postgres do not ask for passord

2008-10-05 Thread Gurjeet Singh
On Sun, Oct 5, 2008 at 10:06 PM, <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Sun, Oct 05, 2008 at 02:42:31PM +, Carlos wrote: > > > > The following bug has been logged online: > > > > Bug reference: 4450 > > Logged by: Carlos > > Email addr

Re: [BUGS] BUG #4568: sporadic error doing COUNT(*) on empty table

2008-12-14 Thread Gurjeet Singh
This mail landed in my Spam box... with this message: "Warning: This message may not be from whom it claims to be. Beware of following any links in it or of providing the sender with any personal information" You might want to report it again. Best regards On Mon, Dec 8, 2008 at 6:34 PM, Sameer

Re: [BUGS] BUG #4650: can't specify table schema in CREATE TABLE AS

2009-02-12 Thread Gurjeet Singh
On Thu, Feb 12, 2009 at 6:22 PM, Thue Janus Kristensen wrote: > > The following bug has been logged online: > > Bug reference: 4650 > Logged by: Thue Janus Kristensen > Email address: thu...@gmail.com > PostgreSQL version: 8.3.5 > Operating system: Linux > Description:

Re: [BUGS] log : bad file dscriptor????

2009-03-14 Thread Gurjeet Singh
--- Sorry about the previous mail; that did not have the proper subject line (for no fault of mine) Hi All, Acting on a customer's report I analyzed this bug, and have found a fix for it. It is not a critical error, but it definitely is a bug, and can have security implications. This er

[BUGS] BUG #5358: Throwing unexpected ERROR

2010-03-02 Thread Gurjeet Singh
The following bug has been logged online: Bug reference: 5358 Logged by: Gurjeet Singh Email address: singh.gurj...@gmail.com PostgreSQL version: 8.4.2 Operating system: Windows Vista 64bit Description:Throwing unexpected ERROR Details: I am using Postgres Plus

Re: [BUGS] BUG #5358: Throwing unexpected ERROR

2010-03-02 Thread Gurjeet Singh
On Tue, Mar 2, 2010 at 7:51 PM, Tom Lane wrote: > "Gurjeet Singh" writes: > > select relname, pg_relation_size( 'public."' || relname || '"' )/1024 > > from (select distinct relname > > from (select r.relname, c.attname, c.a

Re: [BUGS] BUG #5358: Throwing unexpected ERROR

2010-03-03 Thread Gurjeet Singh
On Tue, Mar 2, 2010 at 10:24 PM, Gurjeet Singh wrote: > On Tue, Mar 2, 2010 at 7:51 PM, Tom Lane wrote: > >> "Gurjeet Singh" writes: >> > select relname, pg_relation_size( 'public."' || relname || '"' )/1024 >> > from

Re: [BUGS] BUG #5358: Throwing unexpected ERROR

2010-03-03 Thread Gurjeet Singh
On Wed, Mar 3, 2010 at 8:37 AM, Robert Haas wrote: > On Wed, Mar 3, 2010 at 7:29 AM, Gurjeet Singh > wrote: > > I just realized that it is the subquery pull-up that is leading to this > > problem, not predicate push-down. Sleeping over it does really help I > guess > &g

Re: [BUGS] log : bad file dscriptor????

2010-03-11 Thread Gurjeet Singh
On Wed, Mar 18, 2009 at 3:47 AM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote: > Gurjeet Singh wrote: > >>On Windows, the write to log file is done by a thread (whose main >> function is pipeThread() ), and since it works completely independent of

Re: [BUGS] Win32: missing log file option for pg_ctl running as service

2006-05-28 Thread Gurjeet Singh
When running pg_ctl as a windows service (WinXP Pro), I don't see any way currently to configure a log file for it to use. I am using the following syntax to register pg_ctl as a service: pg_ctl register -N MyService -U myUser -P myPword -D myDataDir -w -o "-i" A "-l myLog" option passed in wou

Re: [BUGS] Win32: missing log file option for pg_ctl running as service

2006-05-28 Thread Gurjeet Singh
log entries to a FS log fle instead of OS event log!!! Thanks, Gurjeet. On 5/28/06, Gurjeet Singh <[EMAIL PROTECTED]> wrote: >>When running pg_ctl as a windows service (WinXP Pro), I don't >>see any way >>currently to configure a log file for it to use. I am using >

[BUGS] A bug or documentation error?

2006-11-21 Thread Gurjeet Singh
Hi all, On this page ( http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the entry for array_lower() says: Example: array_lower(array_prepend(0, ARRAY[1,2,3]), 1) -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | yahoo }.com

Re: [BUGS] A bug or documentation error?

2006-11-22 Thread Gurjeet Singh
=# select array_lower(array_prepend( 0, array[1,2,3] ), 1 ); array_lower - 1 (1 row) postgres=# Is it a bug in array_lower, array or is it a doc error? I am on 8.2 Beta 1. -- gurjeet[.singh]@ EnterpriseDB.com [EMAIL PROTECTED] gmail | hotmail | yahoo }.com

Re: [BUGS] A bug or documentation error?

2006-11-22 Thread Gurjeet Singh
Sorry for an incomplete mail: Hi all, On this page ( http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the entry for array_lower() says: Example: array_lower(array_prepend(0, ARRAY[1,2,3]), 1) Result: -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | yahoo }.co

Re: [BUGS] A bug or documentation error?

2006-11-22 Thread Gurjeet Singh
On 11/22/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Gurjeet Singh" <[EMAIL PROTECTED]> writes: > On this page ( > http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the > entry for array_lower() says: > Example: > array_lower(array_pr

[BUGS] BUG #2790: constructor for int2vector seems to be buggy

2006-11-28 Thread Gurjeet Singh
The following bug has been logged online: Bug reference: 2790 Logged by: Gurjeet Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2beta3 Operating system: Windows Description:constructor for int2vector seems to be buggy Details: I couldn't fin

Re: [BUGS] BUG #2790: constructor for int2vector seems to be buggy

2006-11-28 Thread Gurjeet Singh
On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote: The syntax is space-separated integers; where did you get the idea to use commas? I donno... I just tried and it worked. But silently ignoring invalid input...!!??? Potential bug's symptoms: http://www.postgresql.org/docs/current/static/bug-re

Re: [BUGS] BUG #2840: \set HISTCONTROL ignoredups doesn't work in psql

2006-12-19 Thread Gurjeet Singh
On 12/19/06, Ned T. Crigler <[EMAIL PROTECTED]> wrote: 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. Can you please let us know the environment? If it

[BUGS] BUG #2849: Erroronous UPDATE syntax in documentation

2006-12-21 Thread Gurjeet Singh
The following bug has been logged online: Bug reference: 2849 Logged by: Gurjeet Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: Windows Description:Erroronous UPDATE syntax in documentation Details: The documentation at http

Re: [BUGS] BUG #2849: Erroronous UPDATE syntax in documentation

2006-12-21 Thread Gurjeet Singh
On 12/21/06, Gurjeet Singh <[EMAIL PROTECTED]> wrote: The following bug has been logged online: Bug reference: 2849 Logged by: Gurjeet Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: Windows Description:Erroronous UPDATE

[BUGS] BUG #2851: Error in documentation or in code?

2006-12-21 Thread Gurjeet Singh
The following bug has been logged online: Bug reference: 2851 Logged by: Gurjeet Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: Windows XP Professional Description:Error in documentation or in code? Details: The documentation at

Re: [BUGS] Internal Error XXOO...Mission Critical

2006-12-21 Thread Gurjeet Singh
The community will need more details to move forward. Please read the following mail; it is a good guide to how to post queries to get answers and responses quickly. http://archives.postgresql.org/pgsql-performance/2004-06/msg00235.php Be a better student, ask good questions :) Good luck. On 1

Re: [BUGS] BUG #2847: Bug with IN statement

2006-12-22 Thread Gurjeet Singh
On 12/21/06, Sandip <[EMAIL PROTECTED]> wrote: CREATE OR REPLACE FUNCTION sp_get_phase(character varying, character varying, character varying) RETURNS ret_dv_sp_get_phase AS $BODY$ SELECT BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID, UPDATE_DATE, AddInfo1

[BUGS] BUG #3363: Unable to load a plugin/library using -c switch to the psql

2007-06-05 Thread Gurjeet Singh
The following bug has been logged online: Bug reference: 3363 Logged by: Gurjeet Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3devel Operating system: Windows Description:Unable to load a plugin/library using -c switch to the psql Details: The

Re: [BUGS] BUG #3363: Unable to load a plugin/library using -c switch to the psql

2007-06-05 Thread Gurjeet Singh
been using the Windows shell, I wouldn't have faced this problem :) Thanks for the pointer not a bug Is it possible that $libdir has a different meaning in psql than it does to the shell? On Jun 5, 2007, at 4:20 PM, Gurjeet Singh wrote: The following bug has been logged online:

Re: [BUGS] BUG #3363: Unable to load a plugin/library using -c switch to the psql

2007-06-05 Thread Gurjeet Singh
On 6/5/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Gurjeet Singh" <[EMAIL PROTECTED]> writes: > The following command fails: > psql postgres test -X -c "load '$libdir/plugins/index_adviser.dll';" Define "fails". I get complai

Re: [BUGS] BUG #3430: Case Sensitive Table Names

2007-07-06 Thread Gurjeet Singh
On 7/6/07, Ashwin <[EMAIL PROTECTED]> wrote: The following bug has been logged online: Bug reference: 3430 Logged by: Ashwin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:Case Sensitive Table Names Details: I have a

Re: [BUGS] BUG #3901: Received error

2008-01-24 Thread Gurjeet Singh
It sure looks like Postgres's ASSERT failure. And mcxt.c is Postgres' memory management module. Can you please figure out, and try to reproduce what were you (or your app) doing when this happened. Best regards, On Jan 24, 2008 12:37 PM, Chris Hoover <[EMAIL PROTECTED]> wrote: > > The follo

Re: [BUGS] BUG #3945: unexpected ON INSERT rule behaviour

2008-02-09 Thread Gurjeet Singh
On Feb 8, 2008 2:20 PM, Holger Klawitter <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 3945 > Logged by: Holger Klawitter > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.6 > Operating system: Linux/i386 > Description:

Re: [BUGS] pg_ctl problem

2008-03-04 Thread Gurjeet Singh
On Tue, Mar 4, 2008 at 4:11 PM, <[EMAIL PROTECTED]> wrote: > > When running the pg_ctl command i am facing this error > pg_ctl: no database directory specified and environment variable PGDATA > unset > I use other options also but no solution was found. > could someone help me on this > Thats

Re: [BUGS] pg_ctl problem

2008-03-04 Thread Gurjeet Singh
On Tue, Mar 4, 2008 at 4:51 PM, <[EMAIL PROTECTED]> wrote: > > > thanks for replying > > when i run this command i found the error as > > pg_ctl reload -l logfile -D /var/lib/pgsql/data > could not change directory to "/root" > pg_ctl: PID file "/var/lib/pgsql/data/postmaster.pid" does not exist >

Fwd: [BUGS] pg_ctl problem

2008-03-04 Thread Gurjeet Singh
Madhu... Please please... please use the 'REPLY TO ALL' option in your mail client. Forwarding again to the bugs list, in the hopes of pooling in others. -- Forwarded message -- From: <[EMAIL PROTECTED]> Date: Tue, Mar 4, 2008 at 7:02 PM Subject: RE: [BUGS] pg_ctl problem

Re: [BUGS] BUG #4038: Problem with locale changing by initdb

2008-03-16 Thread Gurjeet Singh
On Sat, Mar 15, 2008 at 6:06 PM, Alexey <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 4038 > Logged by: Alexey > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.5 > Operating system: Windows 2003 > Description:Pr

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Gurjeet Singh
On Mon, Mar 17, 2008 at 7:34 PM, Martin Pitt <[EMAIL PROTECTED]> wrote: > Mika Fischer [2008-03-17 10:19 +]: > > Description:psql should provide option to not prompt for > password > > Details: > > > > Hi, > > > > I'm currently working on the bash-completion package. The problem with >

[BUGS] superuser unable to modify settings of a system table

2010-06-03 Thread Gurjeet Singh
On PG 8.4.4 I am unable to set per-table autovacuum setting for the pg_listener table. Being a superuser, I'd expect Postgres to allow me to do that. postgres=# select version(); version --- P

Re: [BUGS] superuser unable to modify settings of a system table

2010-06-03 Thread Gurjeet Singh
On Thu, Jun 3, 2010 at 1:02 PM, Tom Lane wrote: > Gurjeet Singh writes: > > On PG 8.4.4 I am unable to set per-table autovacuum setting for the > > pg_listener table. Being a superuser, I'd expect Postgres to allow me to > do > > that. > > See allow_system_

[BUGS] Negative result with (now()-previously_inserted_timestamp)

2010-07-06 Thread Gurjeet Singh
I have an IRC logger storing its data in a Postgres 8.3.3. The table in question has the interesting column declared as: time timestamp with time zone default now() The logger uses a prepared statement to insert data, and does not mention this column in the INSERT statement, hence the assumption

Re: [BUGS] Negative result with (now()-previously_inserted_timestamp)

2010-07-06 Thread Gurjeet Singh
On Wed, Jul 7, 2010 at 12:18 AM, Tom Lane wrote: > Gurjeet Singh writes: > > I ran the following query, and got an unexpected negative value. Does > this > > imply that SELECT-transaction was able to see a row created by > > INSERT-transaction which started after the SEL

Re: [BUGS] Negative result with (now()-previously_inserted_timestamp)

2010-07-06 Thread Gurjeet Singh
On Wed, Jul 7, 2010 at 12:18 AM, Tom Lane wrote: > Gurjeet Singh writes: > > I ran the following query, and got an unexpected negative value. Does > this > > imply that SELECT-transaction was able to see a row created by > > INSERT-transaction which started after the SEL

Re: [BUGS] BUG #5802: configure script does not check for perl devel files

2010-12-28 Thread Gurjeet Singh
On Tue, Dec 28, 2010 at 6:22 PM, Peter Eisentraut wrote: > On tis, 2010-12-28 at 12:19 +, Mario Ohnewald wrote: > > However, during the make, postgres requires perl devel. Should this > > not be covered in the configure script? > > No, it's not configure's job to do the job of make or the com