Cedar Cox [EMAIL PROTECTED] writes:
AFAIK the "triggered data change" message comes out of the AFTER trigger
code. You sure you don't have any AFTER triggers on the table? Perhaps
ones added implicitly by a foreign-key constraint?
Not any that I wrote. Ok, the table def is:
CREATE TABLE
Title: RE: [HACKERS] Final Call: RC1 about to go out the door ...
Redhat Linux 7.0 (glibc 2.2-12, gcc 2.96-69)
MikeA
-Original Message-
From: Peter Eisentraut
To: The Hermit Hacker
Cc: [EMAIL PROTECTED]
Sent: 20/03/01 19:11
Subject: Re: [HACKERS] Final Call: RC1 about to go out
Ok, thanks to our snowstorm :-0 I have been working on the beta 6 RPM situation
on my _slow_ notebook today (power outages for ten minutes at a time happening
at hour or so intervals due to 45mph+ winds and a foot of snow).
Well, I have preliminary RPM's built -- just need to work on the
On Tue, 20 Mar 2001 10:56, you wrote:
I've looked at the elog calls in the source, about 1700 in total (only
[ ... ]
So we need some good error numbering scheme. Any ideas?
Just that it might be a good idea to incorporate the version / release
details in some way so that when somebody on
I have talked to Jan over the phone, and he has convinced me that UDP is
the proper way to communicate stats to the collector, rather than my
shared memory idea.
The advantages of his UDP approach is that the collector can sleep on
the UDP socket rather than having the collector poll the shared
Peter Eisentraut [EMAIL PROTECTED] writes:
We need a supported platform list. Let's hear it.
HPUX 10.20 (HP-PA architecture)
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
regards, tom lane
---(end of
So we need some good error numbering scheme. Any ideas?
I'm a newbie, but have been following dev and have a few comments
and these are thoughts not criticisms:
1) I've seen a huge mixture of "how to implement" to support some
desired feature without first knowing "all" of the features
On Wed, Mar 21, 2001 at 09:41:44AM +1200, Christopher Sawtell wrote:
On Tue, 20 Mar 2001 10:56, you wrote:
Just that it might be a good idea to incorporate the version / release
details in some way so that when somebody on the list is squeaking about
an error message it is obvious to the
The patch below adds:
- acinclude.m4: A new macro A_FUNC_SMMAP to check that sharing
pages
through mmap() works. This is taken from Joerg Schilling's star.
- configure.in: A_FUNC_SMMAP
- ogg123/buffer.c: If we have a working mmap(), use it to create
a region of
OK, seems there have been enough objections that I will not implement a
"experts" page, nor change the way patches are applied.
I will be posting a diff -c of any patches I have to munge into place,
so people can see how stuff was merged into the code.
It seems the problem of people having to
Lamar Owen [EMAIL PROTECTED] writes:
DROP TABLE temptest;
+ NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0,
global 1)
+ ERROR: heap_drop_with_catalog: FlushRelationBuffers returned -2
SELECT * FROM temptest;
Hoo, that's interesting ... Exactly what
(First of all, is this the right list?)
When doing
pg_dump testdb -u
I get
failed sanity check, type with oid 899762 was not found
I searched my backend log for this oid and found something near the
'tryme' function. As far as I can find I have two functions defined with
different args
At 17:35 20/03/01 +0100, Peter Eisentraut wrote:
Philip Warner writes:
elog(CACHELOOKUPFAIL, cacheItemThatFailed);
The disadvantage of this approach, which I tried to explain in a previous
message, is that we might want to have different wordings for different
occurences of the same class
On Tue, 20 Mar 2001, Lamar Owen wrote:
Ok, thanks to our snowstorm :-0 I have been working on the beta 6 RPM situation
on my _slow_ notebook today (power outages for ten minutes at a time happening
at hour or so intervals due to 45mph+ winds and a foot of snow).
Well, I have preliminary
At 09:41 21/03/01 +1200, Christopher Sawtell wrote:
Just that it might be a good idea to incorporate the version / release
details in some way so that when somebody on the list is squeaking about
an error message it is obvious to the helper that the advice needed is to
upgrade from the
On Tue, 20 Mar 2001, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
DROP TABLE temptest;
+ NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0,
global 1)
+ ERROR: heap_drop_with_catalog: FlushRelationBuffers returned -2
SELECT * FROM temptest;
Hoo,
Lamar Owen [EMAIL PROTECTED] writes:
DROP TABLE temptest;
+ NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0,
global 1)
+ ERROR: heap_drop_with_catalog: FlushRelationBuffers returned -2
SELECT * FROM temptest;
Hoo, that's interesting ... Exactly what fileset
On Tue, 20 Mar 2001, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
DROP TABLE temptest;
+ NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0,
global 1)
+ ERROR: heap_drop_with_catalog: FlushRelationBuffers returned -2
SELECT * FROM temptest;
Hoo,
Lamar Owen [EMAIL PROTECTED] writes:
I'm hoping it was a problem on my machine -- educate me on
what caused the error
Well, that's exactly what I'd like to know. The direct cause of the
error is that DROP TABLE is finding that some other backend has a
reference-count hold on a page of the
I'm rerunning to see if it is intermittent. Second run -- no
error. Running a third time..no error. Now I'm confused.
What would cause such an error, Tom? I'm going to check on my
Hmm, concurrent checkpoint? Probably we could simplify dirty test
in ByfferSync() - ie test
On Tue, 20 Mar 2001, Tom Lane wrote:
Since no other backend should be trying to touch this temp table,
there's something pretty fishy here.
I see.
Given that this is a parallel test, you may be looking at a
low-probability timing-dependent failure. I'd say set up the machine
and run
With RC1 nearing, when should I run pgindent? This is usually the time
I do it.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt to
modify anything fails with "pg_inherits: No such file or directory".
I've reindexed the database (w/postgres -P -O). Vacuuming fails (w/error
above).
* Bruce Momjian [EMAIL PROTECTED] [010320 14:10] wrote:
The patch below adds:
- acinclude.m4: A new macro A_FUNC_SMMAP to check that sharing
pages
through mmap() works. This is taken from Joerg Schilling's star.
- configure.in: A_FUNC_SMMAP
- ogg123/buffer.c: If
On Tue, 20 Mar 2001, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
I'm hoping it was a problem on my machine -- educate me on
what caused the error
Well, that's exactly what I'd like to know. The direct cause of the
error is that DROP TABLE is finding that some other backend has
I'm sorry, I should have included:
PostgreSQL 7.1beta4
Linux-Mandrake 7.1 (very simiiar RedHat 7)
Intel hardware
--
Joel Burton [EMAIL PROTECTED]
Director of Information Systems, Support Center of Washington
---(end of broadcast)---
TIP 3:
"Mikheev, Vadim" [EMAIL PROTECTED] writes:
Hmm, concurrent checkpoint? Probably we could simplify dirty test
in ByfferSync() - ie test bufHdr-cntxDirty without holding
shlock (and pin!) on buffer: should be good as long as we set
cntxDirty flag *before* XLogInsert in access methods. Have to
Go here to report or to see the list.
http://www.postgresql.org/~vev/regress/
Vince.
On Tue, 20 Mar 2001, Larry Rosenman wrote:
UnixWare 7, Rel 7.1.1, using UDK FS Compiler
FreeBSD 4.[23]
LER
Original Message
On 3/20/01, 1:11:21 PM, Peter Eisentraut [EMAIL PROTECTED] wrote
Joel Burton wrote:
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt to
modify anything fails with "pg_inherits: No such file or directory".
I've reindexed the database (w/postgres -P -O). Vacuuming
The Hermit Hacker [EMAIL PROTECTED] writes:
Okay, I roll'd an RC1 but haven't put it up for FTP yet ... I'll wait for
a few hours to see if anyone can reproduce this, and, if not, put out what
I've rolled ...
This will not be RC1 :-(
I'm been running one backend doing repeated iterations of
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt to
modify anything fails with "pg_inherits: No such file or directory".
I've
On Tue, Mar 20, 2001 at 08:11:21PM +0100, Peter Eisentraut wrote:
We need a supported platform list. Let's hear it.
Linux 2.4.2 (Debian, Woody), glibc 2.2.2, gcc 2.95.3 (from CVS).
-Roberto
--
+| http://fslc.usu.edu USU Free Software GNU/Linux Club|--+
Roberto
On Tue, 20 Mar 2001, Tom Lane wrote:
This will not be RC1 :-(
'Ive already gotten a
couple occurrences of Lamar's failure.
Well, I was at least hoping it was a problem here -- particularly since I
haven't been able to reproduce it. But, since it is not a local problem, I'm
glad I caught it
Joel Burton [EMAIL PROTECTED] writes:
and I could find a $PGDATA/base/18720/16567 file.
Could you find such a file ?
No. I do have the db directory, and all of the other file for the existing
classes, but not this.
Hm. You could make an empty file by that name (just 'touch' it) and
then
Joel Burton wrote:
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt to
modify anything fails with "pg_inherits: No such file or
Lamar Owen [EMAIL PROTECTED] writes:
Although I am now much more leery of our regression suite
The regression tests are not at all designed to test concurrent
behavior, and never have been. The parallel form runs some tests
in parallel, true, but those tests are deliberately designed not to
On Tue, 20 Mar 2001, Tom Lane wrote:
Joel Burton [EMAIL PROTECTED] writes:
and I could find a $PGDATA/base/18720/16567 file.
Could you find such a file ?
No. I do have the db directory, and all of the other file for the existing
classes, but not this.
Hm. You could make an empty
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
On Wed, 21 Mar 2001, Hiroshi Inoue wrote:
Joel Burton wrote:
Postmaster crashed on me, and on restart, pg_inherits cannot be found.
I can see it in pg_class (and it shows up w/ \dS), but any attempt to
I think the problem is that BufferSync unconditionally does PinBuffer
on each buffer, and holds the pin during intervals where it's released
BufMgrLock, even if there's not really anything for it to do on that
buffer. If someone else is running FlushRelationBuffers then it's
possible for
HPUX 10.20 (HP-PA architecture)
Time to drop 9.2 from the list?
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
What processor? Tatsuo had tested on a 603...
- Thomas
---(end of
Yikes. It gets weirder.
Fixed the pg_inherits problem, went back to my Zoping, trying to optimize
some views, and during another run, get an error that trelclasspq, one of
my tables, couldn't open.
Trying this out in psql, I get the same error message--the file doesn't
exist. And, getting the
I think the problem is that BufferSync unconditionally does PinBuffer
on each buffer, and holds the pin during intervals where it's released
BufMgrLock, even if there's not really anything for it to do on that
buffer. If someone else is running FlushRelationBuffers then it's
possible for
Thomas Lockhart [EMAIL PROTECTED] writes:
HPUX 10.20 (HP-PA architecture)
Time to drop 9.2 from the list?
I don't have it running here anymore. Is there anyone on the list
who can test on HPUX 9?
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
What
On Tue, Mar 20, 2001 at 08:03:16PM -0500, Joel Burton wrote:
Yikes. It gets weirder.
I have
Zope 2.3.1b2 (most recent version of Zope)
running on a Linux-Mandrake 7.2 box (server #1)
What kind of filesystem is the pgsql data tree living on? If you do a fsck,
does anything turn up
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
What processor? Tatsuo had tested on a 603...
It's a Powerbook G3 (FireWire model), but I'm not sure which chip is
inside (and Apple's spec sheet isn't too helpful)...
From what I can tell (which isn't much ;)
Further note: this bug does not arise in 7.0.* because in that code,
BufferSync will only pin buffers that have been dirtied in the current
transaction. This cannot affect a concurrent FlushRelationBuffers,
which should be holding exclusive lock on the table it's flushing.
Or can it? The
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
What processor? Tatsuo had tested on a 603...
It's a Powerbook G3 (FireWire model), but I'm not sure which chip is
inside (and Apple's spec sheet isn't too helpful)...
From what I can tell (which isn't much ;)
On Tue, 20 Mar 2001, Thomas Lockhart wrote:
Seeing that RC1 is in prep, is there a pressing need to upload and release beta
6 RPM's, or will it be a day or two before RC1?
Can I get the src rpm to give a try on Mandrake? I had trouble with
7.0.3 (a mysterious disappearing file in the perl
On Wed, 21 Mar 2001, Thomas Lockhart wrote:
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
What processor? Tatsuo had tested on a 603...
It's a Powerbook G3 (FireWire model), but I'm not sure which chip is
inside (and Apple's spec sheet isn't too
I'll go ahead and upload the one I'm testing with right now if you'd like.
Not necessary, unless (I suppose) that you know the rpm for beta 4 is
broken. That vintage CVS tree behaved well enough for me try it out
afaicr...
- Thomas
---(end of
mklinux is older Motorola 68k-based systems
LinuxPPC is the newer powerPC-based systems
Hmm. I have mklinux listed as being on the 750. My vague recollection is
that the distinction is between NuBus and PCI machines (not necessarily
in that order), but...
I also vaguely recalled that the
OK, here is my current platform list taken from the -hackers list and
from Vince's web page. I'm sure I've missed at least a few reports, but
please confirm that platforms are actually running and passing
regression tests with recent betas or the latest release candidate.
If a platform you are
* Thomas Lockhart [EMAIL PROTECTED] [010320 20:04]:
OK, here is my current platform list taken from the -hackers list and
from Vince's web page. I'm sure I've missed at least a few reports, but
please confirm that platforms are actually running and passing
regression tests with recent betas
On Tue, 20 Mar 2001, Thomas Lockhart wrote:
I'll go ahead and upload the one I'm testing with right now if you'd like.
Not necessary, unless (I suppose) that you know the rpm for beta 4 is
broken. That vintage CVS tree behaved well enough for me try it out
afaicr...
It's a good start to
At 09:43 21/03/01 +1100, Philip Warner wrote:
Code SQL Text
PGERR_TYPALREXI 02xxx "type %s cannot be created because it already exists"
PGERR_FUNCNOTYPE 02xxx "type %s used as argument %d of function %s doesn't
exist"
Peter,
Just to clarify, because in a previous email you
SCO OpenServer 5 x86...
OK, I see that Billy Allie recently updated FAQ_SCO to indicate
demonstrated (?) support for OpenServer. I will reflect that in the
platform support info.
- Thomas
---(end of broadcast)---
TIP 5: Have
[Cced: to PostgreSQL hackers list]
Alexander,
I believe this problem was fixed in the latest JDBC driver, that is
supposed to be shipped with 7.1. It asks your database which encoding
is used for particular database while connecting to the database. So
you should be able to see "select
Tatsuo, I have a separate listing for "mklinux" for the 7.0 release. Is
that distro still valid and unique? Or is there a better way to
represent the PPC options under Linux?
I think MkLinux is completely different from Linux/PPC. Will test RC1
on my MkLiux box soon...
--
Tatsuo Ishii
It's a good start to test with for the purposes for which I think you want to
test for. (and I'm an English teacher by night -- argh).
:)
Mandrake (as of 7.2) still does a brain-dead mix of "-O3" and
"-ffast-math", which is a risky and unnecessary combination according to
the gcc folks (and
Tatsuo, I have a separate listing for "mklinux" for the 7.0 release. Is
that distro still valid and unique? Or is there a better way to
represent the PPC options under Linux?
mklinux is older Motorola 68k-based systems
No. MkLinux runs on Power PC based system also. I believe there is a
Creating central message files/objects has the added advantage of a much
simpler locale support - they're just resource files, and they're NOT
embedded throughout the code.
Finally, if you do want to have some kind of error classification beyond
the SQL code, it could be encoded in the error
At 03:28 21/03/01 +, Thomas Lockhart wrote:
Creating central message files/objects has the added advantage of a much
simpler locale support - they're just resource files, and they're NOT
embedded throughout the code.
Finally, if you do want to have some kind of error classification beyond
On Wed, 21 Mar 2001, Thomas Lockhart wrote:
Linux/PPC (LinuxPPC 2000 Q4 distro tested here; 2.2.18 kernel I think)
What processor? Tatsuo had tested on a 603...
It's a Powerbook G3 (FireWire model), but I'm not sure which chip is
inside (and Apple's spec sheet isn't too
At 3/20/2001 09:24 PM, Thomas Lockhart wrote:
It's a good start to test with for the purposes for which I think you
want to
test for. (and I'm an English teacher by night -- argh).
:)
Mandrake (as of 7.2) still does a brain-dead mix of "-O3" and
"-ffast-math", which is a risky and
Hi,
I want to ask question:
can i write my own concurrency control algorithm and
apply it using postgresql?
Thanks in advance
Manal
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
Hi all,
I'm just wondering if this is an error on my part, or a bug. I have the
same trouble with PG 7.1beta6 and PG7.1 snapshot (March 8th) on Solaris
8 INTEL, Solaris 8 SPARC and Linux Mandrake 7.2.
When using the libpqeasy library in a C function, I have the following
section of code :
Hi all,
Something minor, but when you do a "make check" from the main source
directory and it finishes, it mentions that the regression.diff file is
in ./regression.diff
It's really at src/test/regress/regression.diff, and although not hard
to figure out (it's a carry-over from pre 7.1), it
Joel Burton [EMAIL PROTECTED] writes:
Yikes. It gets weirder.
Fixed the pg_inherits problem, went back to my Zoping, trying to optimize
some views, and during another run, get an error that trelclasspq, one of
my tables, couldn't open.
Trying this out in psql, I get the same error
I am kind of stumped. Glad to see _someone_ is using libpgeasy. :-)
I would be glad to run tests here if you can shoot over the code.
Hi all,
I'm just wondering if this is an error on my part, or a bug. I have the
same trouble with PG 7.1beta6 and PG7.1 snapshot (March 8th) on Solaris
-
Hi,
I am trying to access PostGreSQL database running at the default port
5432
using JDBC. But the application is giving error "Cannot find suitable
driver". I have included JDBC driver JAR file in my CLASSPATH and
Class.forName("org.postgresql.Driver") is loading driver successfully.
mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii
I got core dump while running the parallel regression test of beta6.
Will look at...
--
Tatsuo Ishii
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry
We've got 7.0.3 and 7.1b4 running on
Compaq Tru64 4.0G Alpha
Will do the regression test once RC1 is out.
Adriaan
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
I don't know but it may be that you're trying to insert a number larger than
maxint?
ie: 2147483648
???
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Justin Clift
Sent: Tuesday, 20 March 2001 5:54 PM
To: [EMAIL PROTECTED]
Subject: [HACKERS]
mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii
I got core dump while running the parallel regression test of beta6.
Will look at...
--
Tatsuo Ishii
VACUUM;
! FATAL 2: ZeroFill(logfile 0 seg 1) failed: No such file or directory
! pqReadData() -- backend closed the channel
Added to TODO:
* Rename some /contrib modules from pg* to pg_*
On Mon, Mar 19, 2001 at 05:50:01PM +0100, Peter Eisentraut wrote:
In future ... please ignore patches those ignore the /contrib's practice
-- the trouble is overhaul the contrib tree during each version.
Tom Lane writes:
Cedar Cox [EMAIL PROTECTED] writes:
Added note: The trigger is a BEFORE trigger.
AFAIK the "triggered data change" message comes out of the AFTER trigger
code. You sure you don't have any AFTER triggers on the table? Perhaps
ones added implicitly by a foreign-key
Added note: The trigger is a BEFORE trigger.
-- Forwarded message --
To: [EMAIL PROTECTED]
Date: Tue, 20 Mar 2001 20:43:59 +0200 (IST)
Subject: triggered data change violation
ERROR: triggered data change violation on relation "tblstsc2options"
What is this? It doesn't
Larry Rosenman writes:
* Tom Lane [EMAIL PROTECTED] [010319 18:58]:
However, if the C99 spec has such a concept, they didn't use that name
for it ...
My C99 compiler (SCO, UDK FS 7.1.1b), defines the following:
Predefined names
The following identifiers are predefined as
I found interesting paper http://citeseer.nj.nec.com/330257.html
"Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication"
Abstract:
Database designers often point out that eager, update everywhere replication suffers
from
high deadlock rates, message overhead and
* Pete Forman [EMAIL PROTECTED] [010320 04:22]:
Larry Rosenman writes:
* Tom Lane [EMAIL PROTECTED] [010319 18:58]:
However, if the C99 spec has such a concept, they didn't use that name
for it ...
My C99 compiler (SCO, UDK FS 7.1.1b), defines the following:
Predefined names
Thomas Lockhart [EMAIL PROTECTED] writes:
So we need some good error numbering scheme. Any ideas?
SQL9x specifies some error codes, with no particular numbering scheme
other than negative numbers indicate a problem afaicr.
Shouldn't we map to those where possible?
Good point, but I
Zeugswetter Andreas SB [EMAIL PROTECTED] writes:
I do not think it would be appropriate to send file, line and func
infos to the client though.
We still need to work out the details, but my first thought would be to
make this conditional on the value of some SET variable. Also, probably
the
Justin Clift writes:
Something minor, but when you do a "make check" from the main source
directory and it finishes, it mentions that the regression.diff file is
in ./regression.diff
But it says afterwards, "make: leaving directory xyz". If figured that
would be sufficient. I hesitated to
Philip Warner writes:
elog(CACHELOOKUPFAIL, cacheItemThatFailed);
The disadvantage of this approach, which I tried to explain in a previous
message, is that we might want to have different wordings for different
occurences of the same class of error.
Additionally, the whole idea behind
So we need some good error numbering scheme. Any ideas?
SQL9x specifies some error codes, with no particular numbering scheme
other than negative numbers indicate a problem afaicr.
Shouldn't we map to those where possible?
Yes, it defines at least a few dozen char(5) error codes.
Peter Eisentraut [EMAIL PROTECTED] writes:
The regress README is also documented, but it involves manual labour.
I ended up just applying the same diffs to the README by hand, so it's
not an issue at the moment.
regards, tom lane
---(end of
It's all documented: Developer's Guide - Documentation - Building the
Documentation - Plain Text Files.
The three affected text files are:
INSTALL
HISTORY
src/test/regress/README
The INSTALL file hasn't been updated in a while, but I am keeping my eye
on it, but we need to have a
Zeugswetter Andreas SB writes:
SQL9x specifies some error codes, with no particular numbering scheme
other than negative numbers indicate a problem afaicr.
Shouldn't we map to those where possible?
Yes, it defines at least a few dozen char(5) error codes. These are hierarchical,
Thomas Lockhart writes:
Just make sure that we have a *complete* list of files which need to be
formatted from sgml to something other than HTML and postscript or pdf
and we'll get them built for the release.
It's all documented: Developer's Guide - Documentation - Building the
#define PGERR_TYPE 1854
#define PGSQLSTATE_TYPE "S0021"// char(5) SQLSTATE
The standard calls this error variable SQLSTATE
(look up in ESQL standard)
first 2 chars are class next 3 are subclass
"0" is e.g. Success
"02000" is Data not found
"U0xxx" user defined routine error xxx
Coming from an IBM Mainframe background, I'm used to ALL OS/Product
messages having a message number, and a fat messages and codes book.
I hope we can do that eventually.
(maybe a database of the error numbers and codes?)
LER
Original Message
On 3/20/01, 10:53:42 AM, Peter Eisentraut
Zeugswetter Andreas SB [EMAIL PROTECTED] writes:
PGELOG(ERROR, PGSQLSTATE_TYPE, ("type %s cannot be created because it already
exists", ...))
put varargs into parentheses to avoid need for ... macros see Tom's proposal
I'd be inclined to make it
PGELOG((ERROR, PGSQLSTATE_TYPE, "type %s
Okay folks ...
We'd like to wrap up an RC1 and get this release happening this
year sometime :) Tom mentioned to me that he has no outstandings left on
his plate ... does anyone else have any *show stoppers* left that need to
be addressed, or can I package things up?
Speak
The Hermit Hacker [EMAIL PROTECTED] writes:
Speak now, or forever hold your piece (where forever is the time
between now and RC1 is packaged) ...
I rather hope it's *NOT*
regards, tom lane
---(end of
* Tom Lane [EMAIL PROTECTED] [010320 10:21] wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Speak now, or forever hold your piece (where forever is the time
between now and RC1 is packaged) ...
I rather hope it's *NOT*
And still no LAZY vacuum. *sigh*
--
-Alfred Perlstein
We'd like to wrap up an RC1 and get this release happening
this year sometime :) Tom mentioned to me that he has no
outstandings left on his plate ... does anyone else have any
*show stoppers* left that need to be addressed, or can I package
things up?
I wonder if anybody tried to
And still no LAZY vacuum. *sigh*
Patch will be available in a few days after release.
Sorry, Alfred.
Vadim
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
The Hermit Hacker writes:
We'd like to wrap up an RC1 and get this release happening this
year sometime :) Tom mentioned to me that he has no outstandings left on
his plate ... does anyone else have any *show stoppers* left that need to
be addressed, or can I package things up?
I
1. One "writer", many "reader" PostgreSQL servers. We will want to write
provisioning / configuration information centrally and can tolerate a
"writer" failuer for a time.
2. Consitency at the transaction level. All changes to the "writer" server
will be wrapped in transactions, and there
BSDI 4.01.
[ Charset ISO-8859-1 unsupported, converting... ]
UnixWare 7, Rel 7.1.1, using UDK FS Compiler
FreeBSD 4.[23]
LER
Original Message
On 3/20/01, 1:11:21 PM, Peter Eisentraut [EMAIL PROTECTED] wrote regarding
Re: [HACKERS] Final Call: RC1 about to go out the door ...:
1 - 100 of 102 matches
Mail list logo