[BUGS] Bug report: selects rope in tables they shouldn't

2000-07-02 Thread Stephen van Egmond
Sorry for the unformatted bug report, I can't find the bug form on postgresql.org. Version: 7.0 Platform: Debian Linux (woody) running kernel 2.2.14 Question: Is it valid syntax to refer to a table when it's not in the FROM of the select? It's producing awfully wierd output: CREATE TABLE A (

[BUGS] Queries with multiple USINGs crash backend

2000-07-02 Thread Chris Pascoe
Hello, The following SQL demonstrates a crash in the backend. It occurs in both the current Debian Linux 7.0.2 package, and in a separately compiled version of the same. --8<-- CREATE TABLE A ( A INT4, B INT4, C INT4 ); CREATE TABLE B ( A

[BUGS] joins on the same table with aggregates

2000-07-02 Thread Darcy Buskermolen
POSTGRESQL BUG REPORT TEMPLATE Your name : Darcy Your email address : [EMAIL PROTECTED

[BUGS] \d* won't work in 7.0.2?

2000-07-02 Thread Matías Giovannini
Dear PostgreSQL people, I'm baffled at this: \d (and friends) won't give me the definition of a table, view, function, etc: $ initdb /var/lib/pgsql ...stuff... $ psql template1 Welcome to psql, the PostgreSQL interactive terminal. ...stuff... template1=# \dS List of relations Nam