Bug 447755 - Review Request: postgresql-plpgpsm - Implementation of SQL/PSM language for PostgreSQL
Review Request: postgresql-plpgpsm - Implementation of SQL/PSM language for ...
Product: Fedora
Classification: Fedora
Component: Package Review (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Nobody's working on this, feel free to take it
Fedora Extras Quality Assurance
Depends On:
  Show dependency treegraph
Reported: 2008-05-21 11:58 EDT by Devrim GUNDUZ
Modified: 2010-01-25 19:03 EST (History)
4 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2009-10-02 19:01:58 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Devrim GUNDUZ 2008-05-21 11:58:41 EDT
Spec URL: 



In 1998 a draft of the new standard became part of SQL3 - under the
name SQL/PSM (ANSI/ISO/IEC 9075-4:1999). Unfortunately at that time
most big companies had their own languages (incompatible with the
standard) and refused to abandon them in favor of standard. SQL/PSM
was implemented only in those RDBMS, in which there was no support for
stored procedures before 1998. Except for DB2 (SQL PL, IBM, 2001) all
of them were minor RDBMS: Miner, Solid, 602SQL Server. After 2005 the
SQL/PSM standard started to become more popular, when it was
implemented in Advantage Database Server (Sybase iAnywhere, 2005),
MySQL (2005) and PostgreSQL (2007). Implementation of SQL/PSM is
usually incomplete, SQL PL in DB2 is considered to be one of the best
implementations. PostgreSQL implementation is called PL/pgPSM (using
the standard naming scheme in PostgreSQL).
Comment 1 Till Maas 2009-04-18 11:16:22 EDT
It looks like $RPM_OPT_FLAGS are not honoured.

Also the package does not build on koji, which looks like missing BRs:

bison -y -d  gram.y
/usr/bin/flex  -o'pl_scan.c' scan.l
make: execvp: bison: Permission denied
make: /usr/bin/flex: Command not found
make: *** [pl.tab.h] Error 127
make: *** Waiting for unfinished jobs....
make: *** [pl_scan.c] Error 127

Please remove the NotReady from the Whiteboard when this review request is ready for a review, i.e. at least builds in koji and the $RPM_OPT_FLAGS are honoured. You can test it yourself with:

koji build --scratch dist-f12 /path/to/*.src.rpm

Please post the URL of the koji scratch build, if you did one.
Comment 2 Devrim Gündüz 2009-10-02 19:01:58 EDT
I'm no longer interested in maintaining this package (Also 8.3+ version is not around).

Closing bug.

Note You need to log in before you can comment on or make changes to this bug.