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)
up
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 wo
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:
http://www.postgresql.org/docs/view.php?v
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
> 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 accur
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 21474
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
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 co
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
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 tra
Impressive. We already have a long list of supported 7.4 platforms, all
in 24 hours!
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If
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 agains
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| h
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 th
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 t
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.h
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 f
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 K
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 K
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 tes
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
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:
> 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 some
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
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 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 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:
> > >
> > > http://can
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 agains
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 7.4b
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.
Noèl Köthe
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)--
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
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
p
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 `/home/noel/postgres
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__) || defined(__powe
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 te
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
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
CFLAGS="-
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. T
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
--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 testf
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" ./con
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 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
+++
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: permiss
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
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 su
> 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
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
checki
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.
--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 commit
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 Ei
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 some
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:
BEGI
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 some
--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.
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 compil
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, a
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
>
--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.
>
> temp
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
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 progress
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
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
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 whi
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:
> >
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.htm
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
>
> -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 you
66 matches
Mail list logo
