Re: [BUGS] BUG #3264: SPI: int64's sometimes returned by value sometimes by reference

2007-05-09 Thread Adam Kunen
"Adam Kunen" <[EMAIL PROTECTED]> writes: > I have noticed some discrepencies with 64-bit values in tuples. > For a given row with multiple int8's I have noticed sometimes the value will > be passed by value and sometime by reference. No, int8 datums are always passed by reference. If you have a

Re: [BUGS] BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables

2007-05-09 Thread Tom Lane
"Russell Smith" <[EMAIL PROTECTED]> writes: > CREATE view v1 as select * from t1; > ALTER TABLE v1 OWNER TO "USER"; See thread here: http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php and patch here: http://archives.postgresql.org/pgsql-committers/2006-09/msg00101.php This was not

[BUGS] BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables

2007-05-09 Thread Russell Smith
The following bug has been logged online: Bug reference: 3265 Logged by: Russell Smith Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: RHEL4 Description:8.1 -> 8.2 behviour change: View owner must have access to underlying tables Details:

Re: [BUGS] BUG #3264: SPI: int64's sometimes returned by value sometimes by reference

2007-05-09 Thread Tom Lane
"Adam Kunen" <[EMAIL PROTECTED]> writes: > I have noticed some discrepencies with 64-bit values in tuples. > For a given row with multiple int8's I have noticed sometimes the value will > be passed by value and sometime by reference. No, int8 datums are always passed by reference. If you have a

[BUGS] BUG #3264: SPI: int64's sometimes returned by value sometimes by reference

2007-05-09 Thread Adam Kunen
The following bug has been logged online: Bug reference: 3264 Logged by: Adam Kunen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Ubuntu 7.04 - AMD64 Description:SPI: int64's sometimes returned by value sometimes by reference Details:

Re: [BUGS] PSQL support on HP-UX, Solaris and AIX

2007-05-09 Thread Chris Browne
[EMAIL PROTECTED] ("Sridhar Sourirajan") writes: > Is PostgreSQL supported on these UNIX platforms. When I go to > www.postgresql.org, I only see binary downloads for Linux and > Win32. How about for these other flavors of Unix? Thank you! On the traditional commercial UNIX(tm) flavours, you'll ne