Re: [HACKERS] PostgreSQL JDBC and sub-select

snpe <[EMAIL PROTECTED]> writes: > I work with JDeveloper and PostgreSQL JDBC and I have one problem. > I get error : > sub-SELECT in FORM must have an alias > Is it SQL standard (must have alias) or PostgreSQL specific ? The SQL standard says you must write an alias. A FROM item is a (SQL

[HACKERS] All outstanding 7.4 patches applied

I have applied all outstanding patches that were saved for 7.4. Unlike the 7.2 release when I had a mailbox full of patches that I couldn't resolve, for this release I had only about 10, and they were very clear. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTE

Re: [HACKERS] Outstanding patches

I have applied the following doc patch for array_upper/lower(). The other issues have already been addressed. --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I will be applying outstanding 7.4 patches on

Re: [HACKERS] missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3

Patch applied, with doc updates by me. Thanks. --- Tommi Mäkitalo wrote: > Hi, > > I just discovered, that there is missing a const when passing a buffer to > PQescapeBytea and PQunescapeBytea. I fixed it and tried to cr

Re: [HACKERS] [GENERAL] PostgreSQL JDBC and sub-select

On Sat, 9 Nov 2002, snpe wrote: > Hello, > I work with JDeveloper and PostgreSQL JDBC and I have one problem. > I get error : > sub-SELECT in FORM must have an alias > I can't change SQL command, but it is internal JDeveloper command > > Is it SQL standard (must have alias) or PostgreSQL spec

Re: [HACKERS] Question about row visibility after locks

On Sat, 9 Nov 2002, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > Basically, if I've got a select that's running using > > HeapTupleSatisfiesDirty so that I can see uncommitted rows > > and I block in the middle for another transaction (waiting > > to see if it commits the row I'

[HACKERS] PostgreSQL JDBC and sub-select

Hello, I work with JDeveloper and PostgreSQL JDBC and I have one problem. I get error : sub-SELECT in FORM must have an alias I can't change SQL command, but it is internal JDeveloper command Is it SQL standard (must have alias) or PostgreSQL specific ? Regards Haris Peco --

Re: [HACKERS] Beta 4

Michael Furgal writes: > We know that the readline support is missing from the psql client. > It was missing with the cygwin port as well. You must be using a different cygwin port. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--

Re: [HACKERS] Win32 port

Bruce Momjian writes: > OK, Steve's vote is enough to indicate that most want [something] Amazing. How can others hope to achieve such powers? ;-) -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscrib

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

Billy G. Allie writes: > I disagree that it's a new feature. The code to add the -rpath (-R) option > was already there. My patch made it more useful in that the additional search > libraries are now placed in the -rpath (-R) option. Yeah, you're doing additional things, so it's a new feature.

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > There are differences in the regression tests for PostgreSQL > 7.3b2 with handling of times before 1970. I recently sent out a set of > diffs for the changes. I've looked through the datetime.c code, but > it's not obvious to me what the cause of

Re: [HACKERS] Question about row visibility after locks

Stephan Szabo <[EMAIL PROTECTED]> writes: > Basically, if I've got a select that's running using > HeapTupleSatisfiesDirty so that I can see uncommitted rows > and I block in the middle for another transaction (waiting > to see if it commits the row I'm looking at) and that > transaction inserts an