[BUGS] BUG #1304: update does not honor order of subselect

2004-11-02 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1304 Logged by: Brendan Fagan Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.6 Operating system: RedHat ES 3 Description:update does not honor order of subselect Details: SQL Update command does

Re: [BUGS] [pgsql-bugs] Daily digest v1.1281 (14 messages)

2004-11-02 Thread Josh Berkus
Michael, Ralph, etc.: > Rules are macros, so when you refer to NEW.storage_id in the rule > then the default expression "nextval('tmp_storage_id_seq')" is > evaluated again. ÂIf you don't want that to happen then use a > trigger. > > This comes up often -- maybe somebody could add it to the FAQ.

Re: [BUGS] BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout

2004-11-02 Thread Bruce Momjian
Alex Koh wrote: > I agree with the suggestions to attach it to userids. However, setting the > statement_timeout in the conf file is good as it will enforce everyone to > have some timeout. This will be especially useful in web applications. > > Anyway, I will use ALTER USER to do it and disable s

[BUGS] BUG #1303: backend crashes due wrong TCP packet

2004-11-02 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1303 Logged by: Yevgeniy Kondratiev Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: RHEL3 Description:backend crashes due wrong TCP packet Details: over, i think, network prob

Re: [BUGS] psql: set \encoding according to the current locale

2004-11-02 Thread Peter Eisentraut
Am Sonntag, 31. Oktober 2004 22:59 schrieb Martin Pitt: > Currently (i. e. in 7.4.6) psql seems to use the default database > encoding as locale for both its own messages and for database output > strings. Whereas it is only an inconvenience for the latter, psql's > own messages should really respe