The following bug has been logged online:
Bug reference: 2389
Logged by: James M Doherty
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: RH9
Description:function within function return value
Details:
reate or replace function get_glaccttot
OK, you're right about the log_min_error_statement value, but this behaviour
has changed from 8.0. In earlier versions ERROR statements did get logged if
log_statment was set to all or in 7.4, set to "on" DMaybe I missed something in
the changelog of 8.1?
On Tue, 11 Apr 2006 23:51:51 +0200, "G
The following bug has been logged online:
Bug reference: 2390
Logged by: Andreas Kretschmer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Debian Linux
Description:check constraint
Details:
i want to add a check constraint like:
create
The following bug has been logged online:
Bug reference: 2391
Logged by: Eric Noriega
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.0.5
Operating system: Linux Fedora core 4
Description:"Similar to" pattern matching does not operate as
documented
Details:
A
I encountered a rare BUG in the way PG is logging. Let me first enlight with
some configuration I have and PG version:
prueba2=> SELECT version();
version
---
I'm a bit hurt by your statement that what I sent was just about useless :(
The problem here is that I am new to PostgreSQL and PGAdmin III and so, in
my confusion about what's normal and what's not, I am unable to provide you
with all the details that would help you resolve the problem. However, I
It turns out we've been getting rather huge numbers of "Permission
denied" errors relating to fsync so perhaps it wasn't really a precursor
to the crash as I'd previously thought.
I've pasted in a complete list following this email covering the time
span from 3/20 to 4/6. The number in the firs
On Wed, 12 Apr 2006, Andreas Kretschmer wrote:
> The following bug has been logged online:
>
> Bug reference: 2390
> Logged by: Andreas Kretschmer
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.3
> Operating system: Debian Linux
> Description:check const
Sounds good.
There is nothing sensitive in DbTranImageStatus_pkey so if you decide
you want it after all, it's there for the asking.
Pete
>>> Tom Lane <[EMAIL PROTECTED]> 04/13/06 3:30 am >>>
Oh, never mind ... I've sussed it.
---(end of broadcast)--
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Wed, 12 Apr 2006, Andreas Kretschmer wrote:
>> i want to add a check constraint like:
>> create table foo (i char(7) CHECK (i ~ '^[0-9]{6,7}$'));
>>
>> i doesn't work, but if works, if i change the type for i to varchar(7).
> Well, the regex doesn't
"James M Doherty" <[EMAIL PROTECTED]> writes:
> The above function is called as follows:
> trec.tot_value :=
> get_glaccttotals(RECORD_DATE,BANKID,''A50'',''A500299'');
> The result is always null.
It's impossible to do much with this when you have not shown us a
complete test case, but I'm
"Eric Noriega" <[EMAIL PROTECTED]> writes:
> db=# select 'tab' similar to 'a|b';
> ?column?
> --
> t
Yeah, this is a bug ... the cause can be seen by looking at the
underlying similar_escape() function, which converts a SIMILAR TO
pattern into a POSIX regex pattern:
regression=# select
On Thu, 13 Apr 2006, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Wed, 12 Apr 2006, Andreas Kretschmer wrote:
> >> i want to add a check constraint like:
> >> create table foo (i char(7) CHECK (i ~ '^[0-9]{6,7}$'));
> >>
> >> i doesn't work, but if works, if i change the typ
"Peter Brant" <[EMAIL PROTECTED]> writes:
> It turns out we've been getting rather huge numbers of "Permission
> denied" errors relating to fsync so perhaps it wasn't really a precursor
> to the crash as I'd previously thought.
> I've pasted in a complete list following this email covering the t
> > - The file system is NTFS
>
> OK, anyone know anything about permissions on NTFS?
Yes. What do you need to know ;-)
BTW, win32 sometimes has a bad habit of returning access denied for
other things as well - in some caes you can get access denied instead of
sharing violation, and you can of
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> BTW, win32 sometimes has a bad habit of returning access denied for
> other things as well - in some caes you can get access denied instead of
> sharing violation, and you can often get it from AV and firewalls and
> such.
Looking at the fsync code i
I think our problem is that we understand the backend very well, but not
how pgadmin does this operation.
---
Patrick Headley wrote:
> I'm a bit hurt by your statement that what I sent was just about useless :(
> The problem
The culprit is CLUSTER. There is a batch file which runs CLUSTER
against six, relatively small (60k rows between them) tables at 7am,
1pm, and 9pm. Follows is the list of dates and hours when the
"Permission denied" errors showed up. They match up to a tee (although
the error apparently sometime
pgAdmin just uses pg_dump/pg_restore to handle the heavy lifting.
Regards, Dave.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
> Sent: 13 April 2006 20:40
> To: Patrick Headley
> Cc: 'Tom Lane'; pgsql-bugs@postgresql.org
> Subject:
"Peter Brant" <[EMAIL PROTECTED]> writes:
> The culprit is CLUSTER. There is a batch file which runs CLUSTER
> against six, relatively small (60k rows between them) tables at 7am,
> 1pm, and 9pm. Follows is the list of dates and hours when the
> "Permission denied" errors showed up. They match u
20 matches
Mail list logo
