Re: [BUGS] Segmentation fault in psql

2001-06-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > sql-# \a? > Output format is aligned. > \a: extra argument '?' ignored > Segmentation fault > $ psql 7.1.1? If so, this is a minor bug that slipped into psql for about two days at just the wrong time :-(. Update to 7.1.2. regards, tom lane -

Re: [BUGS] Strange CREATE VIEW behavior??

2001-06-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > View definition: SELECT zz.ff AS "user", zz.ss AS num FROM zz; > View definition: SELECT zz.ff AS user1, zz.ss AS num FROM zz; > Why in the first case column has name "user" (with '"') ? USER is a keyword. It happens not to be reserved, so you can use it for an AS n

[BUGS] ODBC Interface version 07_01_0005, problem with C++ exceptions

2001-06-13 Thread Mister X
Hi, developing in MFC/Visual Studio 6 I've encountered a strange problem in last version of ODBC Driver (actually 07_01_0005). Each time a SQL error occours, the istructions TRY/ CATCH doesn't report the error string: the CDBException ' member m_strError is empty Follows an example: // MFC C++

Re: [BUGS] Strange CREATE VIEW behavior??

2001-06-13 Thread Stephan Szabo
On Thu, 14 Jun 2001 [EMAIL PROTECTED] wrote: > Basil A. Evseenko ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > Strange CREATE VIEW behavior?? > > Long Description > createdb test > psql test > > test=# create table

[BUGS] Segmentation fault in psql

2001-06-13 Thread pgsql-bugs
Paul Mamin ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Segmentation fault in psql Long Description $ psql Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help wi

[BUGS] Strange CREATE VIEW behavior??

2001-06-13 Thread pgsql-bugs
Basil A. Evseenko ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Strange CREATE VIEW behavior?? Long Description createdb test psql test test=# create table zz(ss int, ff varchar); test=# create view ff2 as select ff as user,

Re: [BUGS] "WHERE col NOT IN" yields falsely empty result.

2001-06-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > Since the difference set bar - foo is nonempty, the above > should yield one or more rows. However, the presence of a null > in foo.col1 (tests 3 and 8 below) yields zero rows, even where > the difference set has rows with no null entries (see test 2). This is the spe

Re: [BUGS] coalesce in execute crashes backend

2001-06-13 Thread Tom Lane
Vinod Kurup <[EMAIL PROTECTED]> writes: > Will this fix then be placed in the next 7.1.x release as well? Yes, if there is one. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://w

[BUGS] "WHERE col NOT IN" yields falsely empty result.

2001-06-13 Thread pgsql-bugs
Dr M J Carter ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description "WHERE col NOT IN" yields falsely empty result. Long Description Consider SELECT * FROM bar WHERE col2 NOT IN (SELECT col1 FROM foo) where tables foo and b