[BUGS] 7.3 GROUP BY differs from 7.2

2003-02-21 Thread Dan Langille
I notice this today when migrating an application from 7.2 to 7.3. The column name is not being recognized. See also: http://archives.postgresql.org/pgsql-sql/2003-02/msg00480.php This is the query in question: SELECT element_id as wle_element_id, COUNT(watch_list_id) FROM watch_list JOIN wat

[BUGS] pg_dumpall ignores --globals-only

2003-03-06 Thread Dan Langille
roblem exists in 7.3. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] pg_dumpall ignores --globals-only

2003-03-07 Thread Dan Langille
On Thu, 6 Mar 2003, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > $ pg_dumpall --globals_only > > pg_dumpall: unrecognized option `--globals_only' > > There seems to be a bit of a disconnect between the code, the usage > mess

[BUGS] man pg-dump + triggers

2003-03-10 Thread Dan Langille
I found this hard to comprehend upon the first reading: When doing a data only dump, pg_dump emits queries to disable triggers on user tables before inserting the data and queries to re-enable them after the data has been inserted. If the restore is stopped in the middle, the system catalogs m

Re: [BUGS] Backend crashe with signal 11 wher restoring big database.

2003-03-25 Thread Dan Langille
11 normally indicates a hardware problem, such as faulty RAM. Have you tested the RAM? NOTE: I'm guessing. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org