> 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
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
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
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
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]
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
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
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]
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
