pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
CHECK 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