Skip site navigation (1) Skip section navigation (2)

Re: BUG #4002: Error when I attemp to make a query by prompt

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: "Mario Plazas" <marioplazas(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4002: Error when I attemp to make a query by prompt
Date: 2008-02-29 18:09:05
Message-ID: 20080229130905.ae50b3d7.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-bugs
In response to "Mario Plazas" <marioplazas(at)gmail(dot)com>:

> 
> The following bug has been logged online:
> 
> Bug reference:      4002
> Logged by:          Mario Plazas
> Email address:      marioplazas(at)gmail(dot)com
> PostgreSQL version: 8.3.0
> Operating system:   win xp
> Description:        Error when I attemp to make a query by prompt
> Details: 
> 
> Hi.
> In psql ver 8.3.0, I use a prompt line to connect and query a database. In
> this line, I send the path for execute psql, database and user respectly
> (the password are in a enviroment var); Then, I try to query, but the system
> show the follow error: 
> 
> C:\Archivos de programa\PostgreSQL\8.3\bin>"C:\Archivos de
> programa\PostgreSQL\8
> .3\bin\psql.exe" DBASE superpostgres -C "SELECT * FROM companies;"
> psql: warning: extra command-line argument "-C" ignored
> psql: warning: extra command-line argument "SELECT * FROM companies;"
> ignored
> Welcome to psql 8.3.0, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> DBASE=# \q
> 
> C:\Archivos de programa\PostgreSQL\8.3\bin>
> 
> It works fine on ver. 8.2.4-1 I think that this is a bug for the ver.
> 8.3.0-1 .

I believe the problem is that you want -c, not -C (case is important).

And it should fail on 8.2 as well, the documentation lists the option
as -c and a quick test here shows similar behaviour if I use -C on
8.2.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-02-29 18:51:33
Subject: Re: BUG #4002: Error when I attemp to make a query by prompt
Previous:From: Mario PlazasDate: 2008-02-29 17:52:51
Subject: BUG #4002: Error when I attemp to make a query by prompt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group