Re: [BUGS] BUG #1145: silent REVOKE failures

2004-05-17 Thread Bruce Momjian
Tom Lane wrote: > Fabien COELHO <[EMAIL PROTECTED]> writes: > > Well, if I issue a "REVOKE" and the rights are not revoked and could never > > have been because I have no right to issue such statement on the object, I > > tend to call this deep absence of success a "failure". > > > If I do the ver

[BUGS] problem

2004-05-17 Thread Tomasz Lisica
Hi, i installed Postrgersql 7.5 Win version and postmaster gives me the following error: unknown option -- t WindowsXP Prof Regards, tom [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] Fix for buffer overflow ready [was: Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)]

2004-05-17 Thread Martin Pitt
Hi again! Sorry for crossposting, but I sent the initial post also to -bugs, because I did not get an answer on -odbc. On 2004-05-11 12:03 +0200, Martin Pitt wrote: > I noticed Apache segfaulting when I feed a simple form with long inputs: > > [Tue May 4 11:32:10 2004] [notice] child pid

Re: [BUGS] Patch for not going beyond NOFILE system limit

2004-05-17 Thread Bruce Momjian
We have already fixed this in CVS and the fix will be in 7.5: revision 1.107 date: 2004/02/23 20:45:59; author: tgl; state: Exp; lines: +145 -88 Do a direct probe during postmaster startup to determine the maximum number of openable files and the number

Re: [BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered in string literal, not even with \000 notation

2004-05-17 Thread Martin Pitt
Hi! On 2004-05-17 8:37 -0400, Bruce Momjian wrote: > The issue is that bytea needs double-backslashes because single > backslashes are processed by the parser into strings: Indeed. Thank you for this! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED]

Re: [BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered

2004-05-17 Thread Bruce Momjian
Martin Pitt wrote: > Hi PostgreSQL hackers! > > We recently got the Debian bug report below. Does anybody have an idea about that? > > Thanks and have a nice day! > > if i issue the following query: > $ select decode(encode('\001\000\001'::bytea,'hex'),'hex'); > the result will always be '\001' a

[BUGS] Patch for not going beyond NOFILE system limit

2004-05-17 Thread Martin Pitt
Hi PostgreSQL developers! Jacek Drobiecki recently sent me a patch which stops postgresql to actively violate the system limit of maximum open files (RLIMIT_NOFILE) in src/backend/storage/file/fd.c, function count_usable_fds(). This avoids irritating kernel logs (if system overstep violations ar

[BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered in string literal, not even with \000 notation

2004-05-17 Thread Martin Pitt
Hi PostgreSQL hackers! We recently got the Debian bug report below. Does anybody have an idea about that? Thanks and have a nice day! Martin - Forwarded message from Peter Schueller <[EMAIL PROTECTED]> - Subject: Bug#249036: postgresql: zero bytes cannot be entered in string litera

Re: [BUGS] abnormal behaviour of a CHECK CONSTRAINT with a regular

2004-05-17 Thread Daniel Struck
> I don't see any bug here; it's just that CHECK constraints are applied > after any BEFORE triggers are run. Since the triggers could change the > data to be inserted, the reverse order would be insecure. Ups, it did make some false assumptions. Thank you for the clarification. If I understo