In addition to the -g issue, I get the following failure:
*** ./expected/privileges.out Thu Oct 9 20:49:31 2003
--- ./results/privileges.outFri Oct 24 14:07:18 2003
***
*** 247,253
(1 row)
CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE
sql; --
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: 24 October 2003 16:38
To: PostgreSQL-development
Subject: [HACKERS] Call for port reports
It is time for people to report their port testing. Please
test against current CVS or beta5 and report your
Bruce Momjian writes:
BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.
template/alpha has:
case $host_cpu in
alpha*) CFLAGS=$CFLAGS -O;; # alpha has problems with -O2
esac
Am Sa, den 25.10.2003 schrieb Nol Kthe um 01:17:
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
The current list is at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
here are
On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote:
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
checking build system type... i386-pc-solaris2.6
checking host system type... i386-pc-solaris2.6
checking
On Sat, Oct 25, 2003 at 01:03:37PM +0200, Noèl Köthe wrote:
[EMAIL PROTECTED]:~/pgsql$ uname -a
Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux
It says i686 but its AMD Opteron:
Just wondering, but does it run in 32 or 64 bit mode? I have a
feeling it's only 32
Am Sa, den 25.10.2003 schrieb Kurt Roeckx um 13:48:
Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux
It says i686 but its AMD Opteron:
Just wondering, but does it run in 32 or 64 bit mode? I have a
feeling it's only 32 bit mode ... Is it compiled for the
Of course I have no time to work on it : (, but in my opinion XA interface
and support for the JDBC driver is absolutely necessary. I think that 2pc
will generally be used more for supporting 2pc transactions between the DB
and JMS than it would be for 2pc across 2 db's.
Glad to see some
Peter Eisentraut wrote:
Bruce Momjian writes:
BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.
template/alpha has:
case $host_cpu in
alpha*) CFLAGS=$CFLAGS -O;; # alpha has
--On Saturday, October 25, 2003 10:00:59 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Peter Eisentraut wrote:
Bruce Momjian writes:
BUT: The default CFLAGS are set by configure to -O2, although the
template wants -O. I manually modified the CFLAGS to -O after
configure.
Bruce Momjian wrote:
Peter Eisentraut wrote:
Bruce Momjian writes:
BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.
template/alpha has:
case $host_cpu in
alpha*)
Larry Rosenman wrote:
After further consideration, I think that the recent patch series that
tried to centralize the CFLAGS handling in configure should be reverted
to configure.in revision 1.293. Otherwise, it's much to complicated to
handle all the special cases. There is, after all, a
Bruce Momjian writes:
In fact, another question is why this alpha test is only done in
freebsd?
Ask that to the maintainers of the FreeBSD system compiler.
Certainly other alpha gcc platforms must have problems with -O2?
I am inclined to add something to configure.in for all alpha compiles
--On Saturday, October 25, 2003 10:14:14 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Larry Rosenman wrote:
After further consideration, I think that the recent patch series that
tried to centralize the CFLAGS handling in configure should be
reverted to configure.in revision 1.293.
Peter Eisentraut wrote:
Bruce Momjian writes:
In fact, another question is why this alpha test is only done in
freebsd?
Ask that to the maintainers of the FreeBSD system compiler.
Certainly other alpha gcc platforms must have problems with -O2?
I am inclined to add something to
There have been (in the past at least) plans on adding a random access
interface to bytea fields. I don't find it in the todo, maybe it should be
added?
What kind of syntax have people thought about, to let the client read a
bytea field in a random access way? I'm thinking of something like:
Peter Eisentraut wrote:
Bruce Momjian writes:
In fact, another question is why this alpha test is only done in
freebsd?
Ask that to the maintainers of the FreeBSD system compiler.
Certainly other alpha gcc platforms must have problems with -O2?
I am inclined to add something to
Peter Eisentraut writes:
FreeBSD 4.8-RELEASE alpha
BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.
I've committed a fix for the CFLAGS handling, and now this platform works
perfectly.
--
Peter
--On Saturday, October 25, 2003 18:35:06 +0200 Peter Eisentraut
[EMAIL PROTECTED] wrote:
Peter Eisentraut writes:
FreeBSD 4.8-RELEASE alpha
BUT: The default CFLAGS are set by configure to -O2, although the
template wants -O. I manually modified the CFLAGS to -O after configure.
I've
Hi,
I really need that a FUNCTION runs allways with
this creator/owner permissions, and not with the user permission.
In other words, my FUNCTION must execute several
procedures as POSTGRES superuser, and the tables its needs
access/insert/delete/update has no permissions to normal user.
Regression testing on AIX 5 using 7.4beta5:
polymorphism ... ok
stats... ok
== shutting down postmaster ==
==
All 93 tests passed.
==
bash-2.05$ uname -a
AIX sn2 1 5 0044276A4C00
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
The current list is at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
here are some build reports. Its all on Debian GNU/Linux with
On Sat, Oct 25, 2003 at 15:11:06 -0200,
Telecontrol Networking [EMAIL PROTECTED] wrote:
Hi,
I really need that a FUNCTION runs allways with this creator/owner permissions, and
not with the user permission.
In other words, my FUNCTION must execute several procedures as POSTGRES
Bruce Momjian writes:
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
After the just-committed fix, Tru64 5.1 alpha is OK with both cc and gcc.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end
Larry Rosenman writes:
*** ./expected/privileges.out Thu Oct 9 20:49:31 2003
--- ./results/privileges.out Sat Oct 25 12:04:45 2003
***
*** 247,253
(1 row)
CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE
sql; -- fail
- ERROR: permission
Am Sa, den 25.10.2003 schrieb Nol Kthe um 01:17:
reports of these slower systems will follow but they need a bit more time:
Linux crest 2.4.20 #1 Wed Mar 5 01:39:17 EST 2003 m68k unknown
Peter gave me this patch for m68k:
-- src/include/port/linux.h.orig Sat Oct 25 13:45:44 2003
+++
Kurt Roeckx writes:
configure: using CFLAGS=-g -O2 -fno-strict-aliasing
checking whether the C compiler still works... no
configure: error: cannot proceed
oink% gcc -v
Reading specs from
/usr/local/lib/gcc-lib/i386-pc-solaris2.6/2.8.1/specs
gcc version 2.8.1
CFLAGS=-g -O2 ./configure
--On Saturday, October 25, 2003 22:29:04 +0200 Peter Eisentraut
[EMAIL PROTECTED] wrote:
Larry Rosenman writes:
*** ./expected/privileges.out Thu Oct 9 20:49:31 2003
--- ./results/privileges.outSat Oct 25 12:04:45 2003
***
*** 247,253
(1 row)
CREATE FUNCTION
On 24-okt-03, at 17:37, Bruce Momjian wrote:
It is time for people to report their port testing. Please test
against
current CVS or beta5 and report your 'uname -a'.
The current list is at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-
platforms.html
--
Bruce Momjian
Bruce Momjian wrote:
How does everyone like this patch? It removes -g from non-debug
compiles, and changes -O2 to -O for FreeBSD/Alpha.
I'd be hesitant to remove -g from non-debug compiles. If something
crashes, it's useful to be able to get a good stacktrace from the
resulting core file.
Peter Eisentraut wrote:
Kurt Roeckx writes:
configure: using CFLAGS=-g -O2 -fno-strict-aliasing
checking whether the C compiler still works... no
configure: error: cannot proceed
oink% gcc -v
Reading specs from
/usr/local/lib/gcc-lib/i386-pc-solaris2.6/2.8.1/specs
gcc version 2.8.1
After CVS update for optimization flags:
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
---
Peter Eisentraut wrote:
Bruce Momjian writes:
It is time for people to
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
---
Peter Eisentraut wrote:
Bruce Momjian writes:
It is time for people to report their port testing. Please test
I can't certify the following platform because it doesn't recognize our
spinlock code. Would you run src/tools/ccsym and report back the
symbols you have. Do you not have __powerpc__ defined?
The actual test in s_lock.h is:
#if defined(__ppc__) || defined(__powerpc__) ||
Would someone help me getting this persons name into SGML?
No?l K?the [EMAIL PROTECTED]
I am not sure how to transfer that encoding into SGML.
==
All 93 tests passed.
==
rm regress.o
make[2]: Leaving directory
Bruce Momjian writes:
I can't certify the following platform because it doesn't recognize our
spinlock code. Would you run src/tools/ccsym and report back the
symbols you have. Do you not have __powerpc__ defined?
The way I read his report (a little tricky to find the divisions) is that
ppc
Noèl Köthe wrote:
-- Start of PGP signed section.
Am Sa, den 25.10.2003 schrieb No?l K?the um 01:17:
reports of these slower systems will follow but they need a bit more time:
Linux casals 2.4.19-r4k-ip22 #1 Tue Mar 18 15:38:10 CET 2003 mips unknown
polymorphism ... ok
Bruce Momjian writes:
Would someone help me getting this persons name into SGML?
No?l K?the [EMAIL PROTECTED]
I am not sure how to transfer that encoding into SGML.
Noegrave;l Kouml;the
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
Again, I need help converting this name to SGML.
---
Hans-Jürgen Schönig wrote:
Regression testing on AIX 5 using
Dave Page wrote:
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: 24 October 2003 16:38
To: PostgreSQL-development
Subject: [HACKERS] Call for port reports
It is time for people to report their port testing. Please
test against current CVS or
Noèl Köthe wrote:
-- Start of PGP signed section.
Am Sa, den 25.10.2003 schrieb No?l K?the um 01:17:
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
The current list is at:
I am confused by your report. I have success from Solaris kernel 5.8.
I see 2.6 mentioned, and I know there is Solaris 7-9. What does uname
-a show?
---
Kurt Roeckx wrote:
On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce
Noèl Köthe wrote:
-- Start of PGP signed section.
Am Sa, den 25.10.2003 schrieb Kurt Roeckx um 13:48:
Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux
It says i686 but its AMD Opteron:
Just wondering, but does it run in 32 or 64 bit mode? I have a
Bruce Momjian writes:
The following patch has been applied and should allow m68k to work ---
please report back.
Won't work. Please see his last mail for the right patch.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP
Peter Eisentraut wrote:
Bruce Momjian writes:
In fact, another question is why this alpha test is only done in
freebsd?
Ask that to the maintainers of the FreeBSD system compiler.
Certainly other alpha gcc platforms must have problems with -O2?
I am inclined to add something to
Bruce Momjian writes:
Uh, I am not inclined to mark the port as OK if the parallel regression
tests fail --- what is the cause?
They always have been on Cygwin. This platform just can't handle that
many parallel connections.
--
Peter Eisentraut [EMAIL PROTECTED]
Peter Eisentraut wrote:
Peter Eisentraut writes:
FreeBSD 4.8-RELEASE alpha
BUT: The default CFLAGS are set by configure to -O2, although the template
wants -O. I manually modified the CFLAGS to -O after configure.
I've committed a fix for the CFLAGS handling, and now this platform
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
---
Peter Eisentraut wrote:
Bruce Momjian writes:
It is time for people to report their port testing. Please test
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
m68k patch already applied.
---
Noèl Köthe wrote:
-- Start of PGP signed section.
Am Sa, den 25.10.2003 schrieb No?l
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
m68k patch already applied.
---
Noèl Köthe wrote:
-- Start of PGP signed section.
Am Sa, den 25.10.2003 schrieb No?l
Kevin Brown wrote:
Bruce Momjian wrote:
How does everyone like this patch? It removes -g from non-debug
compiles, and changes -O2 to -O for FreeBSD/Alpha.
I'd be hesitant to remove -g from non-debug compiles. If something
crashes, it's useful to be able to get a good stacktrace from the
Noèl Köthe wrote:
-- Start of PGP signed section.
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
The current list is at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
here
Peter Eisentraut wrote:
Bruce Momjian writes:
I can't certify the following platform because it doesn't recognize our
spinlock code. Would you run src/tools/ccsym and report back the
symbols you have. Do you not have __powerpc__ defined?
The way I read his report (a little tricky to
Thanks. SGML updated.
---
Peter Eisentraut wrote:
Bruce Momjian writes:
Would someone help me getting this persons name into SGML?
No?l K?the [EMAIL PROTECTED]
I am not sure how to transfer that encoding
Peter Eisentraut wrote:
Bruce Momjian writes:
The following patch has been applied and should allow m68k to work ---
please report back.
Won't work. Please see his last mail for the right patch.
Got it --- applied --- __mc68000__.
--
Bruce Momjian|
Dave Page wrote:
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: 24 October 2003 16:38
To: PostgreSQL-development
Subject: [HACKERS] Call for port reports
It is time for people to report their port testing. Please
test against current CVS or
Added to TODO:
* Allow more ISOLATION LEVELS to be accepted, but issue a
warning for them
---
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
I think we could allow users to set the
Tom Lane wrote:
James Rogers [EMAIL PROTECTED] writes:
If we suddenly wanted to optimize Postgres for performance the way
Oracle does, we would be a lot more keen on the O_DIRECT approach.
This isn't ever going to happen, for the simple reason that we don't
have Oracle's manpower. You
Tatsuo Ishii wrote:
I've been pushing this agenda for a few releases now, but some people have
been, er, boycotting it. I think, too, that release notes *must* be
written incrementally at the same time that the feature change is made.
This is the only way we can get accurate and complete
OK, do we want to put back the mention of these in the release notes?
The non-zulu ones sound pretty strange to me and might be better left
undocumented.
---
Marcus B?rger wrote:
Hello Christopher,
Wednesday, October
Rod Taylor wrote:
-- Start of PGP signed section.
On Wed, 2003-10-22 at 04:01, Christopher Kings-Lynne wrote:
Hi guys,
What is the limit on the number of rows in a PostgreSQL table? If it's
more than MAXINT, we have a problem:
phppgadmin# select * from test limit 2147483648;
Tatsuo Ishii wrote:
I've been pushing this agenda for a few releases now, but some people have
been, er, boycotting it. I think, too, that release notes *must* be
written incrementally at the same time that the feature change is made.
This is the only way we can get accurate and
Tatsuo Ishii wrote:
OK, if Tatsuo and SRA are having problems, I have to address it. I can
supply a more detailed list to Tatsuo/SRA, or I can beef up the release
notes to contain more information. Seems some in the community would
like to have this detail so I might as well do it and
Dennis Bjorklund wrote:
There have been (in the past at least) plans on adding a random access
interface to bytea fields. I don't find it in the todo, maybe it should be
added?
First do this:
ALTER TABLE foo ALTER COLUMN foo_bytea SET STORAGE EXTERNAL;
see:
On Sat, 25 Oct 2003, Joe Conway wrote:
That will modify the bytea column so that it is stored uncompressed in
the TOAST table.
Now, simply use substr() to grab any random chunk:
SELECT substr(foo_bytea, 2, 100) from foo where foo_id = 42;
This would imply that every little read would
What is the policy for getting cvs access? The translation work
would be so much easier of one could get permission to update
the po files directly. For example, the pg_dump file now got one
string that is not updated, to fix that I have to perfom this steps:
fetch file (cvs co or other method)
66 matches
Mail list logo
