Re: [BUGS] BUG #4638: Bug with Geometry in Array

2009-03-02 Thread Kris Jurka
On Mon, 2 Mar 2009, "Dr. Björn Weitzig" wrote: I can't find any "modified JDBC driver", only the "JDBC extension" postgis.jar (your link), which I use und which doesn't help. postgis.jar seems to be an add-on to the default JDBC driver, not an replacement. I use postgis_1.3.5.jar with postgres

Re: [BUGS] BUG #4684: lastval in function

2009-03-02 Thread Jaime Casanova
On Mon, Mar 2, 2009 at 12:21 PM, Tom Lane wrote: > > Before considering complicating the definition of lastval, I'd vote > for removing it entirely.  It's a foot-gun and will never be anything > but. > +1 -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo

Re: [BUGS] BUG #4684: lastval in function

2009-03-02 Thread Tom Lane
Chris Browne writes: > I'm not sure I'd *want* to have a more-sophisticated scoping mechanism > for this. We already have an appropriate language-level solution for this: it's called INSERT RETURNING. The fact is that lastval was invented to aid in porting brain-dead mysql applications that were

[BUGS] BUG #4687: PostgreSQL website won't let me register

2009-03-02 Thread Tihamer Toth-Fejel
The following bug has been logged online: Bug reference: 4687 Logged by: Tihamer Toth-Fejel Email address: tihamer.toth-fe...@gd-ais.com PostgreSQL version: n/a (web page) Operating system: n/a Description:PostgreSQL website won't let me register Details: After I pu

Re: [BUGS] BUG #4684: lastval in function

2009-03-02 Thread Chris Browne
Andreas writes: > Heikki Linnakangas schrieb: >> andreas wrote: >>> if nextval is used inside a function in a insertstatement, you get always >>> the value from inside the last function. but i expected, that lastval() >>> deliver the value from the insertstatement. i think, this should >>> clearif

Re: [BUGS] BUG #4684: lastval in function

2009-03-02 Thread Andreas
Heikki Linnakangas schrieb: andreas wrote: if nextval is used inside a function in a insertstatement, you get always the value from inside the last function. but i expected, that lastval() deliver the value from the insertstatement. i think, this should clearify in the documentation, or better

[BUGS] BUG #4686: There is not enough memory to complete this operation

2009-03-02 Thread Jonas R. Pacheco
The following bug has been logged online: Bug reference: 4686 Logged by: Jonas R. Pacheco Email address: supo...@migrate.com.br PostgreSQL version: 8.3.5 Operating system: Windows Server 2003 Description:There is not enough memory to complete this operation Details:

Re: [BUGS] BUG #4638: Bug with Geometry in Array

2009-03-02 Thread Dr. Björn Weitzig
Thank you for your fast reply. I can't find any "modified JDBC driver", only the "JDBC extension" postgis.jar (your link), which I use und which doesn't help. postgis.jar seems to be an add-on to the default JDBC driver, not an replacement. I use postgis_1.3.5.jar with postgresql-8.3-603.jdbc3.ja

Re: [BUGS] BUG #4684: lastval in function

2009-03-02 Thread Heikki Linnakangas
andreas wrote: if nextval is used inside a function in a insertstatement, you get always the value from inside the last function. but i expected, that lastval() deliver the value from the insertstatement. i think, this should clearify in the documentation, or better fixed that the nextval from an