postgres is compiled with Mipspro compiler, how may i prepare it for
profiling.
Thanks and regards
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
Hello!
Does anybody know a reason parse_datestyle_internal always returns TRUE?
--
WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED]
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.
On Thu, 14 Mar 2002, Tom Pfau wrote:
I don't fully understand the xlog files or WAL records but...
Why isn't the writing of the WAL record based on the CACHE value of the
sequence? If a request to nextval() can't be satisfied by the cache,
the sequence on disk should be updated resulting
I don't fully understand the xlog files or WAL records but...
Why isn't the writing of the WAL record based on the CACHE value of the
sequence? If a request to nextval() can't be satisfied by the cache,
the sequence on disk should be updated resulting in a WAL record being
written.
If two
On Thu, 14 Mar 2002, Mikheev, Vadim wrote:
And it's not. But behaviour of application *must* be
conditional on was transaction committed or not.
What's the problem for application that need nextval() for
external (out-of-database) purposes to use sequence values
only after transaction
On Thu, 14 Mar 2002, Tom Lane wrote:
If you do a SELECT nextval() and then use the returned value externally
*without waiting for a commit acknowledgement*, then I think you are
risking trouble; there's no guarantee that the WAL record (if one is
needed) has hit disk yet, and so a crash
Hello!
Is it valid to change a constant in src/include/miscadmin.h?
===
@@ -150,10 +150,10 @@
#define MAXTZLEN 10 /* max TZ name len, not counting tr.
null */
-#define USE_POSTGRES_DATES 0
#define USE_ISO_DATES
Do U know if pgSQL supports XML ?
4 example : BROWSER-APACHE JSERV-SERVLET-DB-xsl+xml-HTML
Do U know any open source DB doing that?
Thanks a lot
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
This is the c code section and sql section that I need for casting Object reference
column
If anyone know there is an internal one is already build, please let me know.
If not I'm just wondering we can put that into the src. This will allow all
object reference column to cast back as oid like
If it's a servlet calling the database in your example, the below can
be accomplished through the use of procedures which create the XML in
question and return it.
Ie. select xmlGetUser(userid);
You have to write xmlGetUser() to take in the userid and return the
xml required for it. I see no
Does anybody know a reason parse_datestyle_internal always returns TRUE?
It does not. However, if the code has not errored out on elog() calls
beforehand, the routine does return TRUE.
- Thomas
---(end of broadcast)---
Yury Bokhoncovich [EMAIL PROTECTED] writes:
Does anybody know a reason parse_datestyle_internal always returns TRUE?
Ancient history. Before GUC there were lots more routines and a lot
of control structure in variable.c; the return value of the parse/set
functions was used for something or
On Fri, 15 Mar 2002, longjohn wrote:
Do U know if pgSQL supports XML ?
4 example : BROWSER-APACHE JSERV-SERVLET-DB-xsl+xml-HTML
There's some xml stuff in the contrib directory of the PostgreSQL
distribution.
Vince.
--
You have to write xmlGetUser() to take in the userid and return the
xml required for it. I see no advantage to generating the xml in the
db rather than in the servlet.
As a counterexample, my PKIX extensions defined an XML datatype
that could be used to generate XML instead of the standard
* Peter Eisentraut [EMAIL PROTECTED] [011106 20:01]:
D'Arcy J.M. Cain writes:
I have a change I would like to discuss. It doesn't change the code
base, only the build system. The patches I would like to commit follow
this text. The only thing it does is create a config option to
Hi,
I have something that do exactly what you are looking for (and more)
but damned it's perl stuff !
You just have to set your SQL queries into XML files, associate
XSL template to them and run a cgi perl script througth apache (with or
without mod_perl). You can also add perl procedures to
Jasbir D wrote:
Checkout Firebird as well - which appears to be the other alternative.
http://firebird.sourceforge.net/index.php
q: How does open source affect the costs for companies which use
Interbase or Firebird as an embedded server?
a: Firebird server and client are free of
Makes me wonder... perhaps now someone will be convinced to take a look
at the POSIX IPC patch. On some platforms (not on Linux I am afraid)
POSIX mutexes might be quite a bit faster than SYSV semaphores.
Luis Alberto Amigo Navarro wrote:
Hi all:
again on performance, here is an extract from
Dear Igor,
Igor Kovalenko writes:
Makes me wonder... perhaps now someone will be convinced to take a look
at the POSIX IPC patch. On some platforms (not on Linux I am afraid)
POSIX mutexes might be quite a bit faster than SYSV semaphores.
Yes, but on the SGI platform, the MIPS test_and_set
I am confused to hell. I always thought MIPS does NOT have TAS
instruction ;)
Robert E. Bruccoleri wrote:
Dear Igor,
Igor Kovalenko writes:
Makes me wonder... perhaps now someone will be convinced to take a look
at the POSIX IPC patch. On some platforms (not on Linux I am afraid)
Dear Igor,
I am confused to hell. I always thought MIPS does NOT have TAS
instruction ;)
On the SGI platform, there are very high speed implementations of test
and set which allow large number of processes to safely and quickly
access shared memory. SGI has a hardware team that specifies MIPS
Okay. Anyway, the semaphores are apparently used for purposes other than
TAS. That can be made faster too, on platforms which support POSIX
mutexes (shared between processes).
Robert E. Bruccoleri wrote:
Dear Igor,
I am confused to hell. I always thought MIPS does NOT have TAS
On Fri, 15 Mar 2002, Tom Lane wrote:
'Ben Grimm' [EMAIL PROTECTED] writes:
When these bugs are fixed there is still the issue of bug #3 that I
came across. The one that I work around by resetting log_cnt to 0 when a
backend initializes a sequence. It's this third bug that made the
On Fri, 15 Mar 2002, Vadim Mikheev wrote:
But sequences should not be under transaction control. Can you
safely rollback a sequence? No! The only way to ensure that would
...
Placing a restriction on an application that says it must treat the values
returned from a sequence as if
On Fri, 2002-03-15 at 15:44, longjohn wrote:
Do U know if pgSQL supports XML ?
4 example : BROWSER-APACHE JSERV-SERVLET-DB-xsl+xml-HTML
Not natively, you need extra tier that will do (DB-xml)
Do U know any open source DB doing that?
Check http://dmoz.org/Computers/Software/Databases/XML/
Bruce Momjian [EMAIL PROTECTED] writes:
If I do this as any user:
SELECT update_pg_pwd();
it crashes all backends and causes a server-wide restart. Is this
acceptable behavior?
There are a number of things we might blame this on, all having to do
with the overuse of type OID zero to
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
If I do this as any user:
SELECT update_pg_pwd();
it crashes all backends and causes a server-wide restart. Is this
acceptable behavior?
There are a number of things we might blame this on, all having to do
with the overuse
Neil Conway wrote:
On Wed, Mar 20, 2002 at 04:10:14PM -0500, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
The breakage will come when we lengthen NAMEDATALEN, which I plan to
tackle for 7.3. We will need to re-order the NOTIFY structure and put
the NAMEDATALEN string at
[EMAIL PROTECTED] (Neil Conway) writes:
If we're going to change the structure anyway, let's fix it to be
independent of NAMEDATALEN.
Sounds good. If we're making other backwards-incompatible changes to
pgNotify, one thing that bugs me about the API is the use of relname
to refer to name of
On Thu, 2002-03-21 at 00:16, Tom Lane wrote:
[EMAIL PROTECTED] (Neil Conway) writes:
If we're going to change the structure anyway, let's fix it to be
independent of NAMEDATALEN.
Sounds good. If we're making other backwards-incompatible changes to
pgNotify, one thing that bugs me about
Hi all,
This message didn't seem to go through - am I being blocked by the list
server? Let's see if it does this time...
-Original Message-
From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 20 March 2002 1:10 PM
To: Hackers
Subject: Help with SET NULL/SET
Sorry about including the regression test changes in that last patch - just
ignore them.
Since sending in that last patch, I've fixed preproc.y to use 5 instead of 6
as the number of params to concatenate...
Chris
---(end of broadcast)---
TIP 2:
On Tue, Mar 19, 2002 at 08:28:19PM -0500, Neil Conway wrote:
On Tue, 2002-03-19 at 19:20, F Harvell wrote:
I feel that the caching should be SQL transparent. If it is
implemented reasonably well, the performance gain should be pretty
much universal.
Well, the simple query cache scheme
Tom Lane writes:
Peter Eisentraut [EMAIL PROTECTED] writes:
What's standard about it?
ISO/IEC 9075-2:1999 clause 19.1 general rule 1 c) to be exact. ;-)
Hmm. Looks like we need a wholesale revision of command tags, indeed.
At least if we want to consider command tags to be the data
Fernando Nasser [EMAIL PROTECTED] writes:
Yes, I am supposed to see if I can fix this and get rid of the into
field in SelectStmt at the same time. Right Tom?
Yeah, we had talked about that ... but I'm not sure it's worth the
trouble. I don't see any clean way for the SELECT grammar rule to
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
Hmm. Looks like we need a wholesale revision of command tags, indeed.
We would need to do:
ALTER - ALTER type of object
DROP - DROP type of object
CREATE - CREATE type of object
Those look
I wrote:
I am thinking that a non-broken approach would involve (1) treating
a domain as binary-compatible with its base type, and therefore with
all other domains on the same base type, and (2) allowing a coercion
function that produces the base type to be used to produce the domain
type.
Bruce Momjian [EMAIL PROTECTED] writes:
The breakage will come when we lengthen NAMEDATALEN, which I plan to
tackle for 7.3. We will need to re-order the NOTIFY structure and put
the NAMEDATALEN string at the end of the struct so differing namedatalen
backend/clients will work. If you want
Tom Lane wrote:
(...) or put a special case into the operator selection rules to reduce
domains to their basetypes before making the exact match test.
By definition,
which I believe should be read as
A domain is a set of permissible values (of a data type).
What I am trying to say is
Tom Lane wrote:
Any thoughts?
As we are talking about CAST,
if one CASTs to a domain, SQL99 says we have to check the constraints
and issue a integrity constraint violation if appropriate (6.22, GR 21).
--
Fernando Nasser
Red Hat - Toronto E-Mail: [EMAIL
40 matches
Mail list logo