Re: [osdldbt-general] dbt1: error in load dbproc

[Jenny Z. <je...@os...>]

I forgot to mention that bug causes deadlock when executing
shopping_cart.

On Thu, 2003-12-18 at 10:13, Jenny Zhang wrote:
> I found a bug in the shopping_cart stored procedure two days ago.  I
> haven't had a chance to drop another tarball yet.  But I checked in the
> code in developer.osdl.org:/var/bk/dbt1.  Please update your kit.
> 
> Thanks,
> Jenny
> 
> 
> On Wed, 2003-12-17 at 08:24, Satoshi Nagayasu wrote:
> > It is src/include/pg_config.h.in (at 7.3.4).
> > 
> > pg_config.h.in:#define INDEX_MAX_KEYS           32
> > pg_config.h.in:#define FUNC_MAX_ARGS            INDEX_MAX_KEYS
> > 
> > ma...@os... wrote:
> > > Hi,
> > > 
> > > You need to define INDEX_MAX_KEYS to 64 in the PostgreSQL header file.
> > > I'm using 7.4 now and I don't remember which file it is in, but it's one
> > > of the .in files, so be sure to rerun configure after you make the
> > > change.
> > > 
> > > Mark
> > > 
> > > On 17 Dec, Motoyuki KAWABA wrote:
> > > > Hi,
> > > > 
> > > > I'm trying dbt1-v1.3 on Red Hat Linux Advanced Server2.1.
> > > > We've found the following error message during loading dbprocs.
> > > > --
> > > > psql:/home/dbt1/dbt1-v1.3/storedproc/pgsql/shopping_cart.sql:596: ERROR:  functions cannot have more than 32 arguments
> > > > --
> > > > It looks that the shopping_cart function defined in
> > > > storedproc/pgsql/shopping_cart.sql has 46 arguments.
> > > > 
> > > > How do we avoid this error?
> > > > Is it necessary to upgrade PostgreSQL or change any sql script and
> > > > source codes?
> > > > (We used PostgreSQL-7.3.4 for the database.)
> > > > 
> > > > Thanks.
> > > > 
> > > > --
> > > > Motoyuki KAWABA
> > > > FUJITSU LABORATORIES LTD.
> > > > ka...@la...
> > > > 
> > > > 
> > > > 
> > > > 
> > > > -------------------------------------------------------
> > > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > > Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> > > > Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> > > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > > _______________________________________________
> > > > osdldbt-general mailing list
> > > > osd...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/osdldbt-general
> > > 
> > > 
> > > 
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> > > Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > _______________________________________________
> > > osdldbt-general mailing list
> > > osd...@li...
> > > https://lists.sourceforge.net/lists/listinfo/osdldbt-general
> > > 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> _______________________________________________
> osdldbt-general mailing list
> osd...@li...
> https://lists.sourceforge.net/lists/listinfo/osdldbt-general