pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCHECK problem really OK now...
5+ messages / 5 participants
[nested] [flat]
* CHECK problem really OK now...
@ 2001-09-24 18:38 Kovacs Baldvin <kb136@hszk.bme.hu>
2001-09-24 19:18 ` Re: CHECK problem really OK now... Josh Berkus <josh@agliodbs.com>
2001-09-24 19:23 ` Re: CHECK problem really OK now... Jan Wieck <JanWieck@Yahoo.com>
2001-09-26 18:36 ` Re: [SQL] CHECK problem really OK now... Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 3 replies; 5+ messages in thread
From: Kovacs Baldvin @ 2001-09-24 18:38 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Kevin Way <kevin.way@overtone.org>; pgsql-sql; pgsql-hackers@postgresql.org
Hi everybody!
I tried, and it works: the current CVS version really runs
happily the query what sent to heaven our 7.1 version of the
backend.
Kevin: your original complex schema also runs smoothly.
Thanks for our mindful developers!
Regards,
Baldvin
I think Jan wrote:
> Sorry, I missed the original post of the problem. If you can
> send it to me again and change your offer into donating blood
> at the Red Cross, I would take a look at it.
Probably the chances for a prize went... :-(( However, is there
still a shortage of blod???
Baldvin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: CHECK problem really OK now...
2001-09-24 18:38 CHECK problem really OK now... Kovacs Baldvin <kb136@hszk.bme.hu>
@ 2001-09-24 19:18 ` Josh Berkus <josh@agliodbs.com>
2 siblings, 0 replies; 5+ messages in thread
From: Josh Berkus @ 2001-09-24 19:18 UTC (permalink / raw)
To: Kovacs Baldvin <kb136@hszk.bme.hu>; Jan Wieck <JanWieck@yahoo.com>; +Cc: pgsql-sql
Baldvin,
> Probably the chances for a prize went... :-(( However, is there
> still a shortage of blod???
Last I checked, the American Red Cross does not want your blood right
now -- they want it two weeks from now. Currently blood stores are
full, but they get depleted pretty fast. Of course, what they really
want is for you to make a commitment to donate twice a year, every year.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: CHECK problem really OK now...
2001-09-24 18:38 CHECK problem really OK now... Kovacs Baldvin <kb136@hszk.bme.hu>
@ 2001-09-24 19:23 ` Jan Wieck <JanWieck@Yahoo.com>
2001-09-25 04:49 ` Re: CHECK problem really OK now... Roberto Mello <rmello@cc.usu.edu>
2 siblings, 1 reply; 5+ messages in thread
From: Jan Wieck @ 2001-09-24 19:23 UTC (permalink / raw)
To: Kovacs Baldvin <kb136@hszk.bme.hu>; +Cc: Jan Wieck <JanWieck@Yahoo.com>; Kevin Way <kevin.way@overtone.org>; pgsql-sql; pgsql-hackers@postgresql.org
Kovacs Baldvin wrote:
> Hi everybody!
>
> I tried, and it works: the current CVS version really runs
> happily the query what sent to heaven our 7.1 version of the
> backend.
>
> Kevin: your original complex schema also runs smoothly.
>
> Thanks for our mindful developers!
>
> Regards,
> Baldvin
>
> I think Jan wrote:
> > Sorry, I missed the original post of the problem. If you can
> > send it to me again and change your offer into donating blood
> > at the Red Cross, I would take a look at it.
>
> Probably the chances for a prize went... :-(( However, is there
> still a shortage of blod???
Well, for the NY disaster they probably have more than enough
- not that many injured people there - sad enough though. But
what's wrong with using the current wave of patriotism to get
as much as they can get?
It help's saving life! Using the victims for that purpose
isn't abuse. It is turning grief, anger and sadness into
help and hope.
Let blood become "Open Source". Give it for free and you'll
get plenty of it when you need some.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: CHECK problem really OK now...
2001-09-24 18:38 CHECK problem really OK now... Kovacs Baldvin <kb136@hszk.bme.hu>
2001-09-24 19:23 ` Re: CHECK problem really OK now... Jan Wieck <JanWieck@Yahoo.com>
@ 2001-09-25 04:49 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Roberto Mello @ 2001-09-25 04:49 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: pgsql-sql
On Mon, Sep 24, 2001 at 03:23:13PM -0400, Jan Wieck wrote:
>
> It help's saving life! Using the victims for that purpose
> isn't abuse. It is turning grief, anger and sadness into
> help and hope.
>
> Let blood become "Open Source". Give it for free and you'll
> get plenty of it when you need some.
I couldn't agree more!
-Roberto
--
+------------| Roberto Mello - http://www.brasileiro.net |------------+
Computer Science, Utah State University - http://www.usu.edu
USU Free Software & GNU/Linux Club - http://fslc.usu.edu
Space Dynamics Lab, Developer - http://www.sdl.usu.edu
OpenACS - Enterprise free web toolkit - http://openacs.org
TAFB -> Text Above Fullquote Below
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] CHECK problem really OK now...
2001-09-24 18:38 CHECK problem really OK now... Kovacs Baldvin <kb136@hszk.bme.hu>
@ 2001-09-26 18:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2001-09-26 18:36 UTC (permalink / raw)
To: Kovacs Baldvin <kb136@hszk.bme.hu>; +Cc: Jan Wieck <JanWieck@Yahoo.com>; Kevin Way <kevin.way@overtone.org>; pgsql-sql; pgsql-hackers@postgresql.org
Kovacs Baldvin <kb136@hszk.bme.hu> writes:
> I tried, and it works: the current CVS version really runs
> happily the query what sent to heaven our 7.1 version of the
> backend.
I believe this traces to a fix I made in May:
2001-05-27 16:48 tgl
* src/: backend/executor/execJunk.c, backend/executor/execMain.c,
include/executor/executor.h, include/nodes/execnodes.h: When using
a junkfilter, the output tuple should NOT be stored back into the
same tuple slot that the raw tuple came from, because that slot has
the wrong tuple descriptor. Store it into its own slot with the
correct descriptor, instead. This repairs problems with SPI
functions seeing inappropriate tuple descriptors --- for example,
plpgsql code failing to cope with SELECT FOR UPDATE.
I didn't realize at the time that the error would also affect updates of
child tables, but tracing through your example with 7.1 shows clearly
that the CHECK is being applied to a slot that contains a four-column
tuple and only a three-column descriptor. Ooops.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-09-26 18:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-24 18:38 CHECK problem really OK now... Kovacs Baldvin <kb136@hszk.bme.hu>
2001-09-24 19:18 ` Josh Berkus <josh@agliodbs.com>
2001-09-24 19:23 ` Jan Wieck <JanWieck@Yahoo.com>
2001-09-25 04:49 ` Roberto Mello <rmello@cc.usu.edu>
2001-09-26 18:36 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox