dbTalk Databases Forums  

psql interactive doesn't show error messages

comp.databases.postgresql comp.databases.postgresql


Discuss psql interactive doesn't show error messages in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
luislupe@gmail.com
 
Posts: n/a

Default psql interactive doesn't show error messages - 07-04-2008 , 05:56 PM






Hi,

When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about inte22r
data type. But it doesn't say anything. How can I enable this?

I'm running:
psql 8.2.6
Slackware 12.0

# \! echo foo >&2
foo

# \echo :VERBOSITY
default

Thank you for any help.

Luis

Reply With Quote
  #2  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM






"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #3  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #4  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #5  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #6  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #7  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #8  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #9  
Old   
Ben Finney
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:33 PM



"luislupe (AT) gmail (DOT) com" <luislupe (AT) gmail (DOT) com> writes:

Quote:
When I issue this command 'alter table xx add coulumn indice
intege22r;' pgql cli should return an error complaining about
inte22r data type. But it doesn't say anything.
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.

--
\ “I call him Governor Bush because that's the only political |
`\ office he's ever held legally.” —George Carlin, 2008 |
_o__) |
Ben Finney


Reply With Quote
  #10  
Old   
luislupe@gmail.com
 
Posts: n/a

Default Re: psql interactive doesn't show error messages - 07-04-2008 , 06:44 PM



Quote:
Can you please show an actual 'psql' session that demonstrates this
behaviour?

Please also include in that session a '\set' command (no arguments)
and its full output.
Hi Ben,

here's the output:

ga=# alter table xx add column indice intege2r;
ga=#

ga=# \set
AUTOCOMMIT = 'on'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
VERBOSITY = 'default'
VERSION = 'PostgreSQL 8.2.6 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2'
DBNAME = 'ga'
USER = 'postgres'
PORT = '5432'
ENCODING = 'LATIN1'
ga=#


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.