Re: [BUGS] BUG #2789: problem with delete statement

2006-12-03 Thread Bruno Wolff III
On Tue, Nov 28, 2006 at 00:21:27 +, Lucian Capdefier <[EMAIL PROTECTED]> wrote: > > 1. I cannot user table alias in the FROM clause of the DELETE statement. That isn't in the SQL spec, but the extension to allow it has been added to 8.2 which will be released very shortly. > 2. I cannot us

[BUGS] BUG #1873: "Invalid username specified" during install

2006-12-03 Thread Gus Gutoski
Hi, Warning: I'm a total noob. See below for the original bug report. I was able to reproduce this problem on postgres 8.1.5 and I think I have a fix. Here's how I reproduced it: 1. Install postgres as a windows service (create the default posgres WinXP account, etc) 2. Uninstall postgres.

[BUGS] BUG #2802: Feature request: tinyint and unsigned types

2006-12-03 Thread Albert Strasheim
The following bug has been logged online: Bug reference: 2802 Logged by: Albert Strasheim Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Description:Feature request: tinyint and unsigned types Details: MySQL's support for 1-byte i

[BUGS] 'PostgreSQL.1' failed with no error message available, result code: -2147221163(0x80040155).

2006-12-03 Thread asp techie
dear sir, right now i using Postgresql 8.1 for my project.in the mean time i am geting the follwing error 'PostgreSQL.1' failed with no error message available, result code: -2147221163(0x80040155). during when ever i use 'select' command.but its woking fine on insert,update,delete command gi

[BUGS] BUG #2805: restore backup

2006-12-03 Thread carmelo
The following bug has been logged online: Bug reference: 2805 Logged by: carmelo Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: linux 2.4.2 debian Description:restore backup Details: Dear all, I've update postgresql from postgresql_7.2.

[BUGS] BUG #2803: server terminated abnormally when limit or offset is null

2006-12-03 Thread Greg Johnson
The following bug has been logged online: Bug reference: 2803 Logged by: Greg Johnson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2rc1 Operating system: Red Hat Enterprise Linux WS release 4 (Nahant Update 3) Description:server terminated abnormally when li

Re: [BUGS] BUG #2803: server terminated abnormally when limit or offset is null

2006-12-03 Thread Tom Lane
"Greg Johnson" <[EMAIL PROTECTED]> writes: > Description:server terminated abnormally when limit or offset is > null Sigh ... looks like this was broken by the recent change to make limit/offset be int8 instead of int4. Thanks for the report. regards, tom lane --

Re: [BUGS] BUG #2789: problem with delete statement

2006-12-03 Thread Lucian Capdefier
Thanks for the info. Probably I misread the documentation of the Delete clause. Again thank you, Lucian On 12/3/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote: On Tue, Nov 28, 2006 at 00:21:27 +, Lucian Capdefier <[EMAIL PROTECTED]> wrote: > > 1. I cannot user table alias in the FROM cla

Re: [BUGS] BUG #2805: restore backup

2006-12-03 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Dec 02, 2006 at 06:44:23PM +, carmelo wrote: > > The following bug has been logged online: > > Bug reference: 2805 > Logged by: carmelo > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.4.7 > Operating system: