Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Is there _any_ way of sorting by a regproc as it appears, not as its
> underlying OID?
Can't think of one. If we supported casting regproc to text then I'd
expect ordering by the regproc-casted-to-text to do what you want.
But we don't.
Ther
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Kurt Roeckx wrote:
>> On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote:
>>> I have seen following regression failure with current(I cvs up'ed 10
>>> minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
>>> 2.2.4.
>>
>> Maybe the
I think because START TRANSACTION is SQL standard? However, I thought
BEGIN WORK was SQL standard, and we don't support READ ONLY there
either --- hmmm.
BEGIN is no part of the SQL standard. The only way to begin a
transaction under the SQL standard is START TRANSACTION.
Chris
-
Gaetano Mendola wrote:
> Hi all,
> why START TRANSACTION READ ONLY is allowed
> and not BEGIN READ ONLY ?
I think because START TRANSACTION is SQL standard? However, I thought
BEGIN WORK was SQL standard, and we don't support READ ONLY there
either --- hmmm.
--
Bruce Momjian
Kevin Brown wrote:
> > > You do realize that as of now, -g is the default for gcc?
>
> It is?
>
> [EMAIL PROTECTED]:~/tmp$ gcc -c foo.c
> [EMAIL PROTECTED]:~/tmp$ ls -l foo.o
> -rw-r--r--1 kevinkevin 876 Oct 26 18:52 foo.o
> [EMAIL PROTECTED]:~/tmp$ gcc -g -c foo.c
> [EMAIL PROTEC
Jan Wieck wrote:
> Bruce Momjian wrote:
> > Peter Eisentraut wrote:
> >> Tom Lane writes:
> >>
> >> > What Peter was advocating in that thread was that we enable -g by
> >> > default *when building with gcc*. I have no problem with that, since
> >> > there is (allegedly) no performance penalty fo
Tilo Schwarz wrote:
> Hi together, keep on the nice work!
>
> On SuSE 8.0,
> > uname -a
> Linux dell 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown
>
> During compile I got the following warning:
> gcc -g -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
> -Wmissing-declarations -I../
Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Tom Lane writes:
> >
> > > What Peter was advocating in that thread was that we enable -g by
> > > default *when building with gcc*. I have no problem with that, since
> > > there is (allegedly) no performance penalty for -g with gcc. However,
>
This is all fixed in CVS --- would you try that?
---
Dave Page wrote:
>
>
> > -Original Message-
> > From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> > Sent: 26 October 2003 01:35
> > To: Dave Page
> > Cc: Postgre
Marc G. Fournier wrote:
Speaking of which, Joe, I did forget all about you *sigh* Will get onto
that this week ... please nudge me if I don't get it setup :)
No problem, I've been swamped with other things myself for a few weeks.
I'll nudge in a few days if I don't hear back.
Joe
-
Andrew Dunstan wrote:
>
>
> Bruce Momjian wrote:
>
> >Bug tracking systems have the same limitation as incremental release
> >notes --- youi have to do a lot of piecemeal work to get complete output
> >at the end, rather than doing it more efficiently in one batch.
> >
> >Most people working on
Dave Page wrote:
>
>
> > -Original Message-
> > From: Dave Page
> > Sent: 26 October 2003 17:34
> > To: Bruce Momjian
> > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: Re: [HACKERS] Call for port reports
> >
> >
> > > No problem --- the port is already marked as working --- t
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: 26 October 2003 13:29
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Call for port reports
>
> > Previously though that just resulted in a few failed tests
> - the run
>
Hi guys,
Is there _any_ way of sorting by a regproc as it appears, not as its
underlying OID?
Chris
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Sun, 26 Oct 2003, Christopher Kings-Lynne wrote:
> > to find the row and then to perform the substr. An open command can
> > be optimized a lot more, for example to cache entries that have been
> > opened so that it's fast to read the next 1kb or whatever you want.
>
> It's an index scan, so
Bruce Momjian wrote:
I can confirm this bug in CVS.
Something is cached, if you quit your psql session after
droping the constraint, and you start another psql session
the problem disappear.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: y
Marsh Ray wrote:
Lauri Pietarinen wrote:
The theory, indeed, does not say anything about buffer pools, but by
decoupling logic
from implementation we leave the implementor (DBMS) to do as it feels
fit to do.
As DBMS technology advances, we get faster systems without having to
change our
prog
I'm using IE6 and it redirects back to http://www.postgresql.org. Mozilla
1.4 works fine.
Regards, Stephen
""Marc G. Fournier"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> 'K, just tried Konqueror, and I get the same behaviour ... Firebird 0.7,
> though, works fine for me ...
Hi all,
why START TRANSACTION READ ONLY is allowed
and not BEGIN READ ONLY ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: 26 October 2003 01:35
> To: Dave Page
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] Call for port reports
>
> > NMAKE : fatal error U1077:
> 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' :
> > return co
>
I sent this out a few days ago to pgsql-general. I'm resending it in
the hope of some comment, in particular whether there is any interest in
incorporating this into PostgreSQL itself, since this may make a
difference to how I approach it.
If people aren't in favour of including it, I will go ahe
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Bruce Momjian" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 26, 2003 3:22 PM
Subject: Re: [HACKERS] Call for port reports
>
>
> > -Original Message-
> > From: Dave Page
> >
Bruce Momjian wrote:
Peter Eisentraut wrote:
Tom Lane writes:
> What Peter was advocating in that thread was that we enable -g by
> default *when building with gcc*. I have no problem with that, since
> there is (allegedly) no performance penalty for -g with gcc. However,
> the actual present be
On Sun, 26 Oct 2003, Hannu Krosing wrote:
> I brought it up once and Tom answered that TOAST tables are not
> transaction aware, so you can't update just some parts of toasted
> entities - you must always write the whole fields. So this will not be
> just an api change.
Yes, the blocks (or what o
As I posted yesterday, I've got the priviledges test failing (it's the
only one). I posted a single-step run, and I've not heard from
anyone.
I can set up an account for anyone that want's to play with it to figure
out what I've got messed up
LER
just to refresh folks memory, here is the failu
On Sun, Oct 26, 2003 at 11:45:49PM +0100, Carlos Guzmán Álvarez wrote:
> I'm trying to give support for interval type to my postgresql 7.4
> ado.net provider, i want to know what is sent by the server for
> interval values in binary format or where to review it ?? :)
In src/backend/utils/adt/time
Dennis Bjorklund kirjutas P, 26.10.2003 kell 07:30:
> 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
Bruce Momjian wrote:
Bug tracking systems have the same limitation as incremental release
notes --- youi have to do a lot of piecemeal work to get complete output
at the end, rather than doing it more efficiently in one batch.
Most people working on PostgreSQL are volunteers, and one of my prima
Hi together, keep on the nice work!
On SuSE 8.0,
> uname -a
Linux dell 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown
During compile I got the following warning:
gcc -g -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../../src/include -D_GNU_SOURCE -c t
Kurt Roeckx wrote:
> On Sun, Oct 26, 2003 at 08:27:10AM -0500, Bruce Momjian wrote:
> >
> > Ports list updated:
> >
> > http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
> >
> > Should I mention Solaris as 2.6 or 5.6?
>
> Normally you speak about Solaris 2.5, 2.6
Hello:
I'm trying to give support for interval type to my postgresql 7.4
ado.net provider, i want to know what is sent by the server for
interval values in binary format or where to review it ?? :)
Thanks in advance
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
---(en
> -Original Message-
> From: Dave Page
> Sent: 26 October 2003 17:34
> To: Bruce Momjian
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Call for port reports
>
>
> > No problem --- the port is already marked as working --- this is a
> > known problem with the pa
On Sun, Oct 26, 2003 at 08:27:10AM -0500, Bruce Momjian wrote:
>
> Ports list updated:
>
> http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
>
> Should I mention Solaris as 2.6 or 5.6?
Normally you speak about Solaris 2.5, 2.6, 7, 8 and 9.
Which are also known as
Oh, OK, sounds like we are good.
---
Christopher Kings-Lynne wrote:
> > 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
> > und
Kurt Roeckx wrote:
> On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote:
> > I have seen following regression failure with current(I cvs up'ed 10
> > minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
> > 2.2.4.
>
> Maybe the change of TZ (summer to winter time) tonight ca
Andrew Dunstan wrote:
> >Yes, I had thought about that --- I put something about migrating to 7.3
> >on a web page and put the URL in the release notes, and the URL kept
> >becoming invalid as they changed web configurations. I am afraid we
> >have to keep this in CVS so we don't lose it over time
Dave Page wrote:
> It's rumoured that Peter Eisentraut once said:
> > 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
Ports list updated:
http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html
Should I mention Solaris as 2.6 or 5.6?
---
Kurt Roeckx wrote:
> On Sat, Oct 25, 2003 at 08:42:36PM -0400, Bruce Momjian
Christopher Kings-Lynne wrote:
> I should mention that I don't have access to a FreeBSD Alpha box anymore
> :( Hence, I have no idea if it currently compiles or not.
>
No problem --- Peter go it.
> Chris
>
>
> Peter Eisentraut wrote:
>
> > Bruce Momjian writes:
> >
> >
> >>It is time for
Noèl Köthe wrote:
-- Start of PGP signed section.
> Am So, den 26.10.2003 schrieb Bruce Momjian um 02:20:
>
> > > (unstable)[EMAIL PROTECTED]:~/pgsql$ uname -a
> > > Linux raptor 2.4.19 #1 SMP Fri Nov 29 23:53:27 CET 2002 s390 GNU/Linux
> >
> > Updated.
>
> http://candle.pha.pa.us/main/writings/
Bruce Momjian wrote:
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
On Sun, Oct 26, 2003 at 08:27:52PM +0900, Tatsuo Ishii wrote:
> I have seen following regression failure with current(I cvs up'ed 10
> minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
> 2.2.4.
Maybe the change of TZ (summer to winter time) tonight caused
this.
Kurt
---
I have seen following regression failure with current(I cvs up'ed 10
minutes ago). Any thought? This is Linux kernel 2.4.22 with glibc
2.2.4.
--
Tatsuo Ishii
*** ./expected/horology.out Mon Sep 29 17:53:48 2003
--- ./results/horology.out Sun Oct 26 20:21:59 2003
***
*** 583,59
It's rumoured that Peter Eisentraut once said:
> 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.
Previousl
On Sat, Oct 25, 2003 at 08:42:36PM -0400, Bruce Momjian wrote:
>
> 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?
SunOS oink 5.6 Generic_105182-09 i86pc i386 i86pc
Which is the same as So
Hi guys,
I've asked this of a few people now, but I haven't managed to get a
straightforward solution.
I'm working on COMMENT ON LARGE OBJECT.
If you could help me with this one, it would be really cool. Other than
this, comment on language, conversion, cast and operator class are all done.
Th
This would imply that every little read would have to do a scan on a table
to find the row and then to perform the substr. An open command can
be optimized a lot more, for example to cache entries that have been
opened so that it's fast to read the next 1kb or whatever you want.
It's an index sc
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.
What's there to go in the release notes? We haven't changed any code,
and zulu is the only 'named' timezone we support (from checking source
CREATE FUNCTION ... SECURITY DEFINER;
Read the 7.3 docs.
Chris
Telecontrol Networking 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
superu
refering to my math professor thats wrong, at least in germany.
select round(2.5); should return 3
Well, I thought mathematics theory says that you should round to the
nearest even number for a 0.5 value, so as to avoid biasing your data...?
I just tried that on my 7.2.4 and 7.4 beta 4 machines
I should mention that I don't have access to a FreeBSD Alpha box anymore
:( Hence, I have no idea if it currently compiles or not.
Chris
Peter Eisentraut wrote:
Bruce Momjian writes:
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your
Am So, den 26.10.2003 schrieb Bruce Momjian um 02:20:
> > (unstable)[EMAIL PROTECTED]:~/pgsql$ uname -a
> > Linux raptor 2.4.19 #1 SMP Fri Nov 29 23:53:27 CET 2002 s390 GNU/Linux
>
> Updated.
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
Thx. Just a minor thing. The
On Sun, 26 Oct 2003, Marc G. Fournier wrote:
> responsible for applying submit'd patches (Peter in the case of
> translations) feels that any one person is overwhelming him with patches
It's not so much that Peter can't handle the patches but that if there is
one string that have changed to creat
On Sun, 26 Oct 2003, Dennis Bjorklund wrote:
> What is the policy for getting cvs access?
generally based on the volume/size of patches being committed, as well as
the area of the code where patches are being applied ... if the person
responsible for applying submit'd patches (Peter in the case
54 matches
Mail list logo
