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.
>
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 g
> -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 compil
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 many.
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 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]
---
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
available
Are you 64-bit s390?
We have OS/390 patches in 7.4 but they were judged too risky for 7.3.
Attached is the patch. Comment is:
revision 1.103
date: 2002/11/22 01:13:16; author: tgl; state: Exp; lines: +29 -2
TAS code originally written for s390 (32-bit) does not work
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?
http://www
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
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
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 mem
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 w
> -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
> >
>
"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 exec
"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 :-(
Me
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, n
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 t
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
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
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)---
T
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
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 acces
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
r
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 suggesti
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 1
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
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:
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. F
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
>
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) dep
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
> -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
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 ha
- 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:
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 t
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 his
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
- 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
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
> -Original Message-
> From: Josh Berkus [mailto:[EMAIL PROTECTED]]
> Sent: 05 December 2002 23:37
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
>
>
> BTW, we do coordinate with the Website development group
When did that happen then? I
41 matches
Mail list logo
