pg.ddx.io  pgsql-students@postgresql.org mailing list archive  
help / color / mirror / Atom feed
UPDATE... RETURNING AFTER/BEFORE
4+ messages / 3 participants
[nested] [flat]

* UPDATE... RETURNING AFTER/BEFORE
@ 2013-06-28 20:12 Karol Trzcionka <karlikt@gmail.com>
  2013-07-05 20:56 ` Re: UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Karol Trzcionka @ 2013-06-28 20:12 UTC (permalink / raw)
  To: pgsql-students

Hello,
the core of the feature is done. It works for simple statements like:
UPDATE foo2 SET bar1=bar1+1 RETURNING before.bar1, after.bar1,
foo2.bar1, foo2.bar1*before.bar1 AS sth;
or
UPDATE foo SET bar = bar || ' __ ' RETURNING md5(after.bar),
md5(before.bar);
However some of regression tests fail (71 of 136) and it is the next
step of my work. The other problem is the performance, it unnecessary
Seq Scan over whole table (values from these scans are not used).
Regards,
Karol Trzcionka


-- 
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: UPDATE... RETURNING AFTER/BEFORE
  2013-06-28 20:12 UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
@ 2013-07-05 20:56 ` Karol Trzcionka <karlikt@gmail.com>
  2013-07-06 19:47   ` Re: UPDATE... RETURNING AFTER/BEFORE Joshua Berkus <josh@agliodbs.com>
  2013-07-08 01:35   ` Re: UPDATE... RETURNING AFTER/BEFORE David Fetter <david@fetter.org>
  0 siblings, 2 replies; 4+ messages in thread

From: Karol Trzcionka @ 2013-07-05 20:56 UTC (permalink / raw)
  To: pgsql-students

This week I've finished the feature patch. It is sent to -hackers and
posted on commitfest. The remaining work is to prepare regression tests
and fix any issues reported on -hackers (if any).
Regards,
Karol


-- 
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: UPDATE... RETURNING AFTER/BEFORE
  2013-06-28 20:12 UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
  2013-07-05 20:56 ` Re: UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
@ 2013-07-06 19:47   ` Joshua Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Joshua Berkus @ 2013-07-06 19:47 UTC (permalink / raw)
  To: Karol Trzcionka <karlikt@gmail.com>; +Cc: pgsql-students



----- Original Message -----
> This week I've finished the feature patch. It is sent to -hackers and
> posted on commitfest. The remaining work is to prepare regression tests
> and fix any issues reported on -hackers (if any).
> Regards,
> Karol

I wouldn't expect any real feedback on it until CF1 ends, except from your mentor.

--Josh Berkus


-- 
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: UPDATE... RETURNING AFTER/BEFORE
  2013-06-28 20:12 UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
  2013-07-05 20:56 ` Re: UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
@ 2013-07-08 01:35   ` David Fetter <david@fetter.org>
  1 sibling, 0 replies; 4+ messages in thread

From: David Fetter @ 2013-07-08 01:35 UTC (permalink / raw)
  To: pgsql-students

On Fri, Jul 05, 2013 at 10:56:24PM +0200, Karol Trzcionka wrote:
> This week I've finished the feature patch.

Not quite :)

> It is sent to -hackers and posted on commitfest. The remaining work
> is to prepare regression tests and fix any issues reported on
> -hackers (if any).

Regression tests and bug fixes are good.  Documentation may need
improving, too.  This is all part of the craft of actually delivering
working software that people will use, maintain, etc.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


-- 
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2013-07-08 01:35 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-06-28 20:12 UPDATE... RETURNING AFTER/BEFORE Karol Trzcionka <karlikt@gmail.com>
2013-07-05 20:56 ` Karol Trzcionka <karlikt@gmail.com>
2013-07-06 19:47   ` Joshua Berkus <josh@agliodbs.com>
2013-07-08 01:35   ` David Fetter <david@fetter.org>

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