Bruce Momjian wrote:
Kevin Brown wrote:
I'd also like to see (if this is even possible) a transaction
isolation mode that would make it possible for multiple concurrent
updates to the same row to happen without blocking each other (I
imagine one way to make this possible would be for the
- Original Message -
From:
mlw
To: Igor Georgiev
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 6:52
PM
Subject: Re: Shrinkwrap Windows Product,
any issues? Anyone? (postmaster windows shell)
Hey this is a cool project. I have been thinking
Tom Lane wrote:
Magnus Naeslund(f) [EMAIL PROTECTED] writes:
Mysql is planning on making this work:
SELECT id, @a:=COUNT(*), SUM(sum_col)/@a FROM table_name GROUP BY id.
We're supposed to spend our time emulating nonstandard features that
don't even exist yet? I think I have better
Tom Lane writes:
Lee Kindness [EMAIL PROTECTED] writes:
Tom Lane writes:
Okay, so it seems -D_REENTRANT is the appropriate fix.
However, _REENTRANT is not a Solarisism... On all (recent) UNIX
systems it toggles on correct handling for thread specific instances
of historically
I'm working on a new interface to PostgreSQL and having a difficult
time. Perhaps someone here can shed some light on the subject.
1. Am I correct in thinking that the OID that I receive with the
RowDescription is the column type? I have several of those defined from
the 7.3 source code. Have
- Original Message -
From: Igor
Georgiev
To: mlw
Sent: Friday, December 06, 2002 4:57 PM
Subject: Re: Postmaster windows shell
- Original Message -
From: "mlw" [EMAIL PROTECTED]
To: "Igor Georgiev" [EMAIL PROTECTED]
Sent: Friday, December 06, 2002 3:43
PM
Subject: Re:
On Fri, 2002-12-06 at 09:55, Reggie Burnett wrote:
I'm working on a new interface to PostgreSQL and having a difficult
time. Perhaps someone here can shed some light on the subject.
1. Am I correct in thinking that the OID that I receive with the
RowDescription is the column type? I have
-Original Message-
From: Rod Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 9:19 AM
To: Reggie Burnett
Cc: PostgreSQL-development
Subject: Re: [HACKERS] new interface
On Fri, 2002-12-06 at 09:55, Reggie Burnett wrote:
I'm working on a new interface to
Let me see if I can add more information here. PSQL appears to only
retrieve table metadata when \d is given. For my interface, I will need
the ability to present every column as a proper system object (int, byte
array, currency, etc) depending on the db type. I will not be able to
wait for the
On Fri, 2002-12-06 at 10:30, Reggie Burnett wrote:
Let me see if I can add more information here. PSQL appears to only
retrieve table metadata when \d is given. For my interface, I will need
the ability to present every column as a proper system object (int, byte
array, currency, etc)
Joe, have you heard of a standard called SQL/MED? I came across a
description of it the other day. You might think it's got some medical
connotation, but actually the acronym is Management of External Data,
and what it is is a standard spec for shipping chunks of SQL queries to
remote servers.
On Fri, 2002-12-06 at 11:04, Tom Lane wrote:
Joe, have you heard of a standard called SQL/MED? I came across a
It's that one of the later parts of the SQL 99 spec? Section 9 or
thereabouts?
--
Rod Taylor [EMAIL PROTECTED]
PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description:
On Fri, 2002-12-06 at 11:35, Rod Taylor wrote:
On Fri, 2002-12-06 at 11:04, Tom Lane wrote:
Joe, have you heard of a standard called SQL/MED? I came across a
It's that one of the later parts of the SQL 99 spec? Section 9 or
thereabouts?
Note to self, don't reply to emails and have a
I have a program which worked merrily under 1.3b1, but with 1.4devel
I get the first query working (so connection OK), and the second query,
which may well be wrong, getting me:
DEBUG: reaping dead processes
DEBUG: child process (pid 13025) was terminated by signal 11
LOG: server process (pid
Tom Lane wrote:
Joe, have you heard of a standard called SQL/MED? I came across a
description of it the other day. You might think it's got some medical
connotation, but actually the acronym is Management of External Data,
and what it is is a standard spec for shipping chunks of SQL queries to
Rod Taylor [EMAIL PROTECTED] writes:
Found SQL/MED, Section 21 of ISO 9075-9.
That's the old version, though. The new draft is at (digs out article)
http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf
according to this article, but I'm not having any luck
Joe Conway [EMAIL PROTECTED] writes:
Do you think a proposal based on the SQL/MED spec would be entertained for
7.4, or would the release after be a safer bet?
The impression I get from this article is that SQL/MED is nontrivial.
If you think you can get something useful going for 7.4, step
Ian Barwick [EMAIL PROTECTED] writes:
ERROR: ExecEvalExpr: unknown expression type 108
This is fixed as of yesterday --- see thread on (I think) pgsql-general
for the patch.
regards, tom lane
---(end of broadcast)---
TIP
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Found SQL/MED, Section 21 of ISO 9075-9.
That's the old version, though. The new draft is at (digs out article)
http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Found SQL/MED, Section 21 of ISO 9075-9.
That's the old version, though. The new draft is at (digs out article)
http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf
Hi all,
I didn't find any other list compatible with this post, I hope it is the right
place.
I got a sparccenter 2000 (sun4d) few weeks ago and I wondered if the
postgresql team was interested in testing postgres on it. It has only 2 CPUs
at this time but I may get more cpu and system boards in
Patrick Welche [EMAIL PROTECTED] writes:
WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
Should I be able to cause this with a duff query?
No. That's a backend bug, not a
Ross J. Reedstrom [EMAIL PROTECTED] writes:
Having pulled that one, I discover it's actually the XML related spec. The
MED one is at:
ftp://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-09-MED-2002-01.pdf
Ah-hah, so the URL in the SIGMOD Record article is just wrong :-(
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Messing about with ADD COLUMN...
I'm not certain how to re-evaluate the default expression for each
row?
Basically you'll want to apply ExecEvalExpr (or perhaps
ExecEvalExprSwitchContext) to the cooked expression tree.
Look at the execution of
On Friday 06 December 2002 20:50, Tom Lane wrote:
(B Ian Barwick [EMAIL PROTECTED] writes:
(B ERROR: ExecEvalExpr: unknown expression type 108
(B
(B This is fixed as of yesterday --- see thread on (I think) pgsql-general
(B for the patch.
(B
(BMany thanks. Applied and appears to work :-)
Kevin Brown wrote:
How useful would it be? Beats me. Like I said, you could perform
some what if games with a database this way that you currently
can't, but I don't know how useful that would be. On thinking about
it a bit, it seems option 1 would be the most useful and perhaps the
most
Nicolai Tufar [EMAIL PROTECTED] writes:
As far as I figured from the source code this function only deals
with cleaning up locale names and nothing else. Since all the locale
names are in plain ASCII I think it will be safe to use ASCII-only
lower-case conversion.
Does PostgreSQL run on the
As someone who exists mainly as an active user (and part-time
advocate/documentation tweaker), I have found the release of PostgreSQL
7.3 to be disappointing. The ensuing pseudo-flamewar on the various
lists has been similarly disappointing.
I was surprised, for instance, to receive a non-list
Hi,
What do the columns conforencoding and contoencoding refer to in
pg_conversion?
How would I convert those numbers to a string encoding name, just using SQL?
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Dave,
BTW, we do coordinate with the Website development group
When did that happen then? I think I must have blinked :-)
Marc and Justin are periodically keeping the Advocacy group informed
of progress on wwwdevel, and we were asked to test it before. Vince
asked us for suggestions,
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]]
Sent: 06 December 2002 17:45
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Dave,
BTW, we do coordinate with the Website development group
When did that
Kris Jurka [EMAIL PROTECTED] writes:
[ GEQO doesn't work anymore in CVS tip ]
Ugh. The proximate cause of this is the code I added recently to cache
repeated calculations of the best inner indexscan for a given inner
relation with potential outer relations. Since geqo_eval() releases
all
Hi Eric,
We've already done a fair amount of testing of PostgreSQL on Sparc
hardware and Solaris, so it's probably not all that interesting... :-/
However, about an hour after you sent through your message, we received
this one from Myk Melez. He's asking us if there is a publically
I ask me, the store of large file like 2M in one field take to postgres
a big work, you do that ? any of you do that before ? the sistem work
fine or not ? Thanks for all
--
Saludos Horacio Miranda.
[EMAIL PROTECTED]
Rod, can you comment on these warnings Joe Conway's compiler is showing?
I don't see the warnings with gcc, but clearly they look like problems.
I can just assign a NULL on definition, but I thought you should take a
look.
I now have the INETv6 patch working using IPv4 on my machine, and I
don't have IPv6 enabled in my kernel. Tomorrow, I will review the
entire patch for portability issues, then post it so others can test it.
I am pretty sure it is going to fail if your machine isn't INET6 aware,
which may be
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 7:58 PM
To: Joe Conway
Cc: [EMAIL PROTECTED]; PostgreSQL-development
Subject: Re: [HACKERS] more compile warnings
Rod, can you comment on these warnings Joe Conway's compiler
is
Dann Corbit wrote:
Instead of just assigning a value, it means it is conceivable that a
path allows undefined behavior. Example:
...
int y;
if (x 5)
y = 3;
if (x 5)
y = 1;
What happens if x == 5? Then y is indeterminate.
Sometimes, the flow analysis just gets confused
On Fri, Dec 06, 2002 at 11:16:30PM -0500, Bruce Momjian wrote:
I use:
-Wall -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wcast-align
Some other useful ones are -pedantic -W -Wfloat-equal -Wshadow
-Wcast-qual -Wwrite-strings -Wconversion -Wsign-compare -Wsign-promo.
You
39 matches
Mail list logo