> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > I'm just wondering why we do not use fsync() to flush data/index
> > pages.
>
> There isn't any efficient way to do that AFAICS. The process that wants
> to do the checkpoint hasn't got any way to know just which files need to
> be sync'd. Even if i
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I'm just wondering why we do not use fsync() to flush data/index
> pages.
There isn't any efficient way to do that AFAICS. The process that wants
to do the checkpoint hasn't got any way to know just which files need to
be sync'd. Even if it did know, it
Hi,
Is there any way of making the 'up' arrow retrieve all of the last multiline
query, instead of just the last line? It's really annoying working with
large multiline queries at the moment...
Chris
---(end of broadcast)---
TIP 2: you can get of
> > Are you saying that fsync() might not wait untill the IO completes?
>
> No, I said that sync() might not. Read the man pages. HPUX's man
> page for sync(2) says
>
> sync() causes all information in memory that should be on disk to be
> written out.
> ...
> The writing, a
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> What we really need is something better than sync(), viz flush all dirty
>> buffers to disk *and* wait till they're written. But sync() and sleep
>> for awhile is the closest portable approximation.
> Are you saying that fsync() might not wait untill th
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Can someone tell me why we need sync() here?
> ?? I thought WAL files are synced by pg_fsync() (if needed).
They are. But to write a checkpoint record --- which implies that the
WAL records before it need no longer be replayed --- we have to ensure
that
> > As part of checkpoint, we discard some WAL files. To do that, we must
> > first be sure that all the dirty buffers we have written to the kernel
> > are actually on the disk. That is why the sync() is required.
>
> What we really need is something better than sync(), viz flush all dirty
> bu
> Tatsuo Ishii wrote:
> > I noticed sync() is used in PostgreSQL.
> >
> > CHECKPOINT -> FlushBufferPool() -> smgrsync() -> mdsync() -> sync()
> >
> > Can someone tell me why we need sync() here?
>
> As part of checkpoint, we discard some WAL files. To do that, we must
> first be sure that all t
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tatsuo Ishii wrote:
>> Can someone tell me why we need sync() here?
> As part of checkpoint, we discard some WAL files. To do that, we must
> first be sure that all the dirty buffers we have written to the kernel
> are actually on the disk. That is why
Tatsuo Ishii wrote:
> I noticed sync() is used in PostgreSQL.
>
> CHECKPOINT -> FlushBufferPool() -> smgrsync() -> mdsync() -> sync()
>
> Can someone tell me why we need sync() here?
As part of checkpoint, we discard some WAL files. To do that, we must
first be sure that all the dirty buffers w
I noticed sync() is used in PostgreSQL.
CHECKPOINT -> FlushBufferPool() -> smgrsync() -> mdsync() -> sync()
Can someone tell me why we need sync() here?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unre
> > It also logged that it was killed with signal 9, although I
> didn't kill it!
> > Is there something weird going on here?
>
> Is this Linux? The Linux kernel seems to think that killing
> randomly-chosen processes with SIGKILL is an appropriate response to
> running out of memory. I cannot of
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> FETCH LAST should return the last one row.
That's not clear to me. Generally, I would think the cursor should
remain positioned on whatever row is returned, but the spec clearly says
that the final cursor position after FETCH LAST is *after* the last ro
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> My postgres totally messed up again for some reason (there were like 3
> postmasters running, other weirdness).
> I noticed this as it was starting up again:
> 2003-01-07 18:01:34 DEBUG: ReadRecord: unexpected pageaddr 16/F2794000 in
> log fi
Tom Lane wrote:
(B>
(B> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
(B> > Tom Lane wrote:
(B> >> Sure. FETCH n in Postgres has always corresponded to FETCH RELATIVE n.
(B>
(B> > IIRC in SQL standard FETCH retrieves rows one by one.
(B>
(B> Yes, Postgres' idea of FETCH is only weakly relat
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Refresh my memory: what is the point of inventing an additional LAST
> >> keyword, when the behavior is exactly the same as MOVE ALL ?
>
> > SQL compatibility, per Peter.
>
> Oh, I see. But then really it should
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Sure. FETCH n in Postgres has always corresponded to FETCH RELATIVE n.
> IIRC in SQL standard FETCH retrieves rows one by one.
Yes, Postgres' idea of FETCH is only weakly related to the spec's idea.
But I believe you get similar resu
Tom Lane wrote:
(B>
(B> Sure. FETCH n in Postgres has always corresponded to FETCH RELATIVE n.
(B
(BIIRC in SQL standard FETCH retrieves rows one by one.
(B
(Bregards,
(BHiroshi Inoue
(Bhttp://w2422.nsk.ne.jp/~inoue/
(B
(B---(end of broadcast)
johnn <[EMAIL PROTECTED]> writes:
> On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
>> -> Seq Scan on CNX_DS_53_SIS_STU_OPT_FEE_TB a
>> (cost=1.00..100112549.62 rows=6139062 width=24)
> Those big round numbers suggest that you haven't run vacuum analyze on
> all of your t
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> IIRC *FETCH LAST* doesn't mean *FETCH ALL*.
SQL92 says
ii) If the implicitly or explicitly spec-
ifies NEXT, specifies ABSOLUTE or RELATIVE with K greater
than N, or specifies LAST, then CR is positioned a
Tom Lane wrote:
(B>
(B> Bruce Momjian <[EMAIL PROTECTED]> writes:
(B> > Tom Lane wrote:
(B> >> Refresh my memory: what is the point of inventing an additional LAST
(B> >> keyword, when the behavior is exactly the same as MOVE ALL ?
(B>
(B> > SQL compatibility, per Peter.
(B>
(B> Oh, I s
Hi guys,
My postgres totally messed up again for some reason (there were like 3
postmasters running, other weirdness).
I noticed this as it was starting up again:
2003-01-07 18:01:34 DEBUG: ReadRecord: unexpected pageaddr 16/F2794000 in
log file 22, segment 249, offset 7946240
2003-01-07 18:01:
> A diff utility with a mandatory GUI frontend through a webserver is
> positively the most bizarre thing I have ever heard of.
This may be true of a file diff utility but for a dbms diff utility there is
sometimes ambiguity and pgdiff attempts to be more than just a diff utility.
pgdiff allows
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Refresh my memory: what is the point of inventing an additional LAST
>> keyword, when the behavior is exactly the same as MOVE ALL ?
> SQL compatibility, per Peter.
Oh, I see. But then really it should be documented as a FETCH keywor
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> No analyze for 7.1.3.
> Just ran vacuum a few minutes before the query. No boost at all.
VACUUM or VACUUM ANALYZE? Standalone ANALYZE was not in 7.1 but
VACUUM ANALYZE does what you need to do...
-Doug
---(end of broadcast)-
Tom Lane wrote:
> > 2002-11-12 19:44 momjian
> >
> > * doc/src/sgml/ref/move.sgml, src/backend/commands/portalcmds.c,
> > src/backend/executor/execMain.c, src/backend/parser/gram.y,
> > src/backend/parser/keywords.c, src/backend/tcop/utility.c,
> > src/include/commands/portalcmds.
--On Tuesday, January 07, 2003 15:25:06 -0800 Dann Corbit
<[EMAIL PROTECTED]> wrote:
No analyze for 7.1.3.
Just ran vacuum a few minutes before the query. No boost at all. Even
with SET enable_seqscan = 0 it still does a table scan.
did you do VACUUM ANALYZE?
If not, the stats weren't upda
> -Original Message-
> From: johnn [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 07, 2003 3:33 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
> What am I doing wrong?
>
>
> On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
>
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
> NOTICE: QUERY PLAN:
>
> SetOp Except (cost=202028537.97..202120623.90 rows=1227812 width=24)
> -> Sort (cost=202028537.97..202028537.97 rows=12278124 width=24)
> -> Append (cost=1.00..200225099.24 rows=12278124
> -Original Message-
> From: Jean-Luc Lachance [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 07, 2003 2:43 PM
> To: Tom Lane
> Cc: Dann Corbit; Nigel J. Andrews;
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
> What am I doing w
On 7 Jan 2003, Greg Copeland wrote:
> On Tue, 2003-01-07 at 16:46, Vince Vielhaber wrote:
> > On Tue, 7 Jan 2003, mlw wrote:
> >
> > > This is a serious inquiry, very serious. People are complaining about ads.
> > >
> > > What do we need in the form of equipment, bandwidth, etc.
> >
> > FTP is jus
> 2002-11-12 19:44 momjian
>
> * doc/src/sgml/ref/move.sgml, src/backend/commands/portalcmds.c,
> src/backend/executor/execMain.c, src/backend/parser/gram.y,
> src/backend/parser/keywords.c, src/backend/tcop/utility.c,
> src/include/commands/portalcmds.h, src/include/nodes
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2003 22:47
> To: mlw
> Cc: [EMAIL PROTECTED]; Marc G. Fournier
> Subject: Re: [HACKERS] PostgreSQL site, put up or shut up?
>
>
> On Tue, 7 Jan 2003, mlw wrote:
>
> > This is a serious inquiry,
On Tue, 2003-01-07 at 16:46, Vince Vielhaber wrote:
> On Tue, 7 Jan 2003, mlw wrote:
>
> > This is a serious inquiry, very serious. People are complaining about ads.
> >
> > What do we need in the form of equipment, bandwidth, etc.
>
> FTP is just over 800MB, plan for growth.
> WEB is just over 9
On Tue, 7 Jan 2003, mlw wrote:
> This is a serious inquiry, very serious. People are complaining about ads.
>
> What do we need in the form of equipment, bandwidth, etc.
FTP is just over 800MB, plan for growth.
WEB is just over 90MB, can't tell you what to plan for there.
On www/ftp.us I don't e
Dann Corbit wrote:
Message
I have
a machine with 4 CPU's and 2 gigabytes of physical ram.
I would
like to get PostgreSQL to use as much memory as possible. I can't seem
to get PostgreSQL to use more than 100 megabytes or so.
How can
I optimize the us
Dear Peter,
Thank you very much for your answers. It rings a bell.
> Finally, when you display East Asian characters you will
> have a font problem because the Chinese, Japanese, and Korean characters
> are mapped to the same range in Unicode but you are supposed to use
> country-specific glyphs.
Yeah, the MS one - sorry 'bout that :-). I was feeling quite chipper
before another day of voip hell...
> -Original Message-
> From: scott.marlowe [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2003 21:28
> To: Dave Page
> Cc: Greg Copeland; Justin Clift; PostgresSQL Hackers Mailing List
>
This is a serious inquiry, very serious. People are complaining about ads.
What do we need in the form of equipment, bandwidth, etc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Sorry to be commenting so late.
We could do that CLUSTER way of making a new heap file, but we rejected
that for DROP COLUMN, so I am not sure why we would use that for ALTER
COLUMN. Can anyone think of a good reason?
Clearly if the new data type is binary compatible and it is just a
catalog ch
On Tue, 7 Jan 2003, Dan Langille wrote:
> On 7 Jan 2003 at 16:25, mlw wrote:
>
> > I think banner ads that build on PostgreSQL's message is a good thing.
> > A RedHat ad, maybe IBM, etc. Companies with a related purpose to the
> > PostgreSQL mission will offset some of the cost and help build the
Yeah, it's called cygwin. Oh, you probably meant that miserable excuse
for a posix layer MS included when they shipped it. :-)
On Tue, 7 Jan 2003, Dave Page wrote:
> So does NT iirc ;-)
>
> > -Original Message-
> > From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> > Sent: 07 January 2
On 7 Jan 2003 at 16:25, mlw wrote:
> I think banner ads that build on PostgreSQL's message is a good thing.
> A RedHat ad, maybe IBM, etc. Companies with a related purpose to the
> PostgreSQL mission will offset some of the cost and help build the
> cedibility of the site.
>
> Hotel ads and sweep
Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
Please understand something here ... a large portion of the banner ads are
*not* paid ... they are recognition of the many mirror sites that are
supporting the project by reducing the amount of bandwidth that is
requi
Hi all,
How is this path created without the (.profile)?
$ echo $PATH
/usr/local/bin:/usr/bin:/bin:/cygdrive/c/amtagent:/cygdrive/c/informix/bin:/cygd
rive/c/winnt:/cygdrive/c/winnt/system:winnt/system32:/cygdrive/c/Windows:/cygdri
ve/c/Windows/command:C:jdk1.2.2/bin
How can I add this path (~/
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Peter was the first to mention it. His reasoning was that if IPv6 was
> > working, but then stopped working, the admin would never know on startup
> > because of the IPv4 fallback.
>
> My view was that we should treat unix, ipv4, and ipv6 as
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Where are you planning to check this?
> In general, I'm trying to align it like a (self-imposed) permission check.
> For the query-like statements I'm looking at ExecCheckRTPerms(). (That
> also handles EXECUTE and EXPLAIN most ea
Jean-Michel POURE writes:
> - Are some database encodings not translatable into UTF-8 using SET
> CLIENT_ENCODING = 'Unicode'. It used to be the case for Latin1, but it has
> been fixed now.
It should be possible. If not, it's a bug.
> - Some letters, like the euro sign, do not belong to Latin1
Bruce Momjian writes:
> Peter was the first to mention it. His reasoning was that if IPv6 was
> working, but then stopped working, the admin would never know on startup
> because of the IPv4 fallback.
My view was that we should treat unix, ipv4, and ipv6 as independent
address families each with
Tom Lane writes:
> Where are you planning to check this?
In general, I'm trying to align it like a (self-imposed) permission check.
For the query-like statements I'm looking at ExecCheckRTPerms(). (That
also handles EXECUTE and EXPLAIN most easily.) Utility statements have a
check in tcop/utili
--- Tom Lane <[EMAIL PROTECTED]> escreveu:
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > Sorry, don't know. Can anyone on pgsql-hackers tell us the purpose of
> > the FunctionCall message?
>
> It's used to invoke the "fast path" function call code
> (src/backend/tcop/fastpath.c). libpq's large-o
*raised eyebrow* Someone want to scan and post one of these?
On Tue, 7 Jan 2003, Dave Page wrote:
>
>
> > -Original Message-
> > From: Lamar Owen [mailto:[EMAIL PROTECTED]]
> > Sent: 07 January 2003 06:12
> > To: Christopher Kings-Lynne; Hackers; [EMAIL PROTECTED]
> > Subject: Re: [HACK
Greg Stark <[EMAIL PROTECTED]> writes:
> You missed the point of his post. If one process in your database does
> something nasty you damn well should worry about the state of and validity of
> the entire database, not just that one backend.
Right. And in fact we do blow away all the processes wh
On Tue, 2003-01-07 at 12:21, Greg Stark wrote:
> Greg Copeland <[EMAIL PROTECTED]> writes:
>
> > That's the power of using the process model that is currently in use. Should
> > it do something naughty, we bitch and complain politely, throw our hands in
> > the air and exit. We no longer have to w
Greg Copeland <[EMAIL PROTECTED]> writes:
> That's the power of using the process model that is currently in use. Should
> it do something naughty, we bitch and complain politely, throw our hands in
> the air and exit. We no longer have to worry about the state and validity of
> that backend.
Yo
On Tuesday 07 January 2003 12:40, Peter Eisentraut wrote:
> Justin Clift writes:
> > Just found out that the "pgdiff" utility (the one for comparing two
> > different PostgreSQL database's) was released and uploaded to
> > SourceForge in November:
> A diff utility with a mandatory GUI frontend thr
Justin Clift writes:
> Just found out that the "pgdiff" utility (the one for comparing two
> different PostgreSQL database's) was released and uploaded to
> SourceForge in November:
A diff utility with a mandatory GUI frontend through a webserver is
positively the most bizarre thing I have ever h
--On Tuesday, January 07, 2003 12:24:41 -0500 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Larry Rosenman wrote:
--On Tuesday, January 07, 2003 12:20:31 -0500 Tom Lane
<[EMAIL PROTECTED]> wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>> We already do. The issue is what way should we give
Larry Rosenman wrote:
>
>
> --On Tuesday, January 07, 2003 12:20:31 -0500 Tom Lane <[EMAIL PROTECTED]>
> wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> We already do. The issue is what way should we give admins to _fail_ if
> >> IPv6 doesn't start.
> >
> > What is "IPv6 doesn't st
Joe Conway writes:
> I found the definition in FIPS 127-2:
>http://www.itl.nist.gov/fipspubs/fip127-2.htm
>
> The relevant section is section 16.6.
The table described there does not match the schema of the SQL_SIZING
table defined in the SQL standard. I'm also suspicious because the
SQL_FEA
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > We already do. The issue is what way should we give admins to _fail_ if
> > IPv6 doesn't start.
>
> What is "IPv6 doesn't start"? Either the machine has IPv6 addresses,
> or it doesn't. It is not our job to notify the DBA what the
--On Tuesday, January 07, 2003 12:20:31 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
We already do. The issue is what way should we give admins to _fail_ if
IPv6 doesn't start.
What is "IPv6 doesn't start"? Either the machine has IPv6 addresses,
or it
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > The issue was that folks didn't like silent fallback to just IPv4 if the
> > code supported IPv6 but it didn't bind to IPv6 for some reason, e.g.
> > kernel doesn't have IPv6 enabled.
>
> Who didn't like it, and what was their rationa
Bruce Momjian <[EMAIL PROTECTED]> writes:
> We already do. The issue is what way should we give admins to _fail_ if
> IPv6 doesn't start.
What is "IPv6 doesn't start"? Either the machine has IPv6 addresses,
or it doesn't. It is not our job to notify the DBA what the addresses
on his machine are
Bruce Momjian <[EMAIL PROTECTED]> writes:
> The issue was that folks didn't like silent fallback to just IPv4 if the
> code supported IPv6 but it didn't bind to IPv6 for some reason, e.g.
> kernel doesn't have IPv6 enabled.
Who didn't like it, and what was their rationale? This seems to me to
be
Tom Lane wrote:
> Larry Rosenman <[EMAIL PROTECTED]> writes:
> > Please make sure that you can handle the situation of a IPv6 API, but no
> > IPv6 stack. (E.G. UnixWare up to at least 7.1.3).
>
> Certainly. But that is just an autoconfiguration problem. If a v6 IP
> address is available, we sh
--On Tuesday, January 07, 2003 12:07:05 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
Larry Rosenman <[EMAIL PROTECTED]> writes:
Please make sure that you can handle the situation of a IPv6 API, but no
IPv6 stack. (E.G. UnixWare up to at least 7.1.3).
Certainly. But that is just an autoconfigu
Larry Rosenman wrote:
> > No one has offered any scenario in which it's important to bind to only
> > v4 or only v6 addresses when both are present. In the absence of a
> > compelling argument why that would be useful, I do not see why we're
> > worrying. My own thought is that if I wanted to con
Tom Lane wrote:
> Rocco Altier <[EMAIL PROTECTED]> writes:
> > Another idea is to have the -i take an optional argument. Something where
> > -i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only
> > v6.
>
> I don't see why we need any such thing. The current behavior of th
Larry Rosenman <[EMAIL PROTECTED]> writes:
> Please make sure that you can handle the situation of a IPv6 API, but no
> IPv6 stack. (E.G. UnixWare up to at least 7.1.3).
Certainly. But that is just an autoconfiguration problem. If a v6 IP
address is available, we should bind to it.
--On Tuesday, January 07, 2003 11:51:44 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
Rocco Altier <[EMAIL PROTECTED]> writes:
Another idea is to have the -i take an optional argument. Something
where -i means bind to both v4 and v6, and -i4 means to only v4, and -i6
to only v6.
I don't see why
Rocco Altier <[EMAIL PROTECTED]> writes:
> Another idea is to have the -i take an optional argument. Something where
> -i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only
> v6.
I don't see why we need any such thing. The current behavior of the
postmaster (assuming -i or
Another idea is to have the -i take an optional argument. Something where
-i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only
v6.
I am guessing that most people will want to bind to both when they
just specify -i, which is what is usually suggested when they want to get
t
You mean ship with only IPv4 enabled, but not IPv6. (Of course, both
are enabled in the binary.) But then what does -i do? We currently
tell people to use -i. Do we need another postgresql.conf option that
says, "If tcpip_socket is enabled, enable IPv6 too"? But that doesn't
work if you want
San someone point me to what exactly is planned for the
protocol/networking stuff? Networking/protocols is one of my fortes and
I believe that I could actually help here.
Regards,
Greg
On Tue, 2003-01-07 at 09:01, Tom Lane wrote:
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > Sorry, don
Bruce Momjian writes:
> Lee Kindness wrote:
> > Right, so a reasonable angle for me to take is to go through the libpq
> > source looking for potential problem areas and use of "known bad"
> > functions. I can add autoconf checks for the replacement *_r()
> > functions, and use these in place
Forwarded from a response on pgsql-sql:
> I thought that the idea behind noup was to protect single columns from
> update. However, when I apply the noup trigger as above, I can't
> update /any/ column. Is this the intended behaviour?
Idly looking at the source code for contrib/noupdate/noup.c,
On Tue, 2003-01-07 at 02:00, Shridhar Daithankar wrote:
> On 6 Jan 2003 at 6:48, Greg Copeland wrote:
> > > 1) Get I/O time used fuitfully
> > AIO may address this without the need for integrated threading.
> > Arguably, from the long thread that last appeared on the topic of AIO,
> > some hold th
I forgot to reply to the list aswell...
Magnus
- Original Message -
From: "Magnus Naeslund(f)" <[EMAIL PROTECTED]>
To: "Jeroen T. Vermeulen" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 3:32 PM
Subject: Re: [HACKERS] Error using cursors/fetch and execute
> Jeroen T. Vermeulen <[
Justin Clift wrote:
> Hi guys,
>
> Also received a through the Advocacy website asking if anyone has
> ported PostgreSQL to the AlphaServers under VMS.
>
> Anyone know if we run on VMS? Last time I touched VMS (about 10 years
> ago) it wasn't all that Unix-like.
It used to work under VMS a f
Yep, got it. Thanks.
---
Christopher Kings-Lynne wrote:
> gmake[2]: Entering directory `/home/chriskl/pgsql-head/src/backend'
> Makefile:145: *** missing separator (did you mean TAB instead of 8 spaces?).
> Stop.
>
> Chris
Lee Kindness wrote:
> Tom Lane writes:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > We have definatly had requests for improved thread-safeness for libpq
> > > and ecpg in the past, so whatever you can do would be a help. We say
> > > libpq is thread-safe, but specifically mention the n
So does NT iirc ;-)
> -Original Message-
> From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2003 15:00
> To: Justin Clift
> Cc: PostgresSQL Hackers Mailing List
> Subject: Re: [HACKERS] Next platform query: Alphaservers under VMS?
>
>
> IIRC, they too have a POSIX layer
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2003 15:01
> To: Dave Page
> Cc: Kristis Makris; Francisco Figueiredo Jr.;
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] [Npgsql-general] Get function OID and
> function calling suppor
"Dave Page" <[EMAIL PROTECTED]> writes:
> Sorry, don't know. Can anyone on pgsql-hackers tell us the purpose of
> the FunctionCall message?
It's used to invoke the "fast path" function call code
(src/backend/tcop/fastpath.c). libpq's large-object routines use this,
but little else does AFAIK. Th
IIRC, they too have a POSIX layer available.
Greg
On Tue, 2003-01-07 at 02:44, Justin Clift wrote:
> Hi guys,
>
> Also received a through the Advocacy website asking if anyone has
> ported PostgreSQL to the AlphaServers under VMS.
>
> Anyone know if we run on VMS? Last time I touched VMS (
Justin Clift <[EMAIL PROTECTED]> writes:
> Anyone know if we run on VMS?
I'm pretty sure we don't. But there are plenty of Linux and *BSD
distros that will run on that hardware.
regards, tom lane
---(end of broadcast)---
TI
On Tue, Jan 07, 2003 at 02:29:30PM +0100, Magnus Naeslund(f) wrote:
>
> mag=# create table test (id serial unique primary key, txt text);
> mag=# insert into test(txt) values('hoho1');
> mag=# prepare berra (integer) as select * from test where id = $1;
> mag=# declare berra_c cursor for execute b
Dear all,
We are working on PhpPgAdmin UTF-8 support. I would like to be able to view
UTF-8, ASCII and Latin1 databases in PhpPgAdmin without changing HTML header
encodings.
I guess this can be done using:
SET CLIENT_ENCODING='Unicode'
for all PhpPgAdmin connections.
My question are:
- Are so
I have a problem...
We're using cursors to be able to fetch X tuples from the server.
If we would take 'em all our app would blow up because of memory
constraints.
What i would like to is something like this:
mag=# create table test (id serial unique primary key, txt text);
mag=# insert into test(
Dear all,
Does psql support UTF-8 encoding?
>su postgres
>psql template1
>CREATE DATABASE foo_é WITH encoding = 'Unicode';
does not work.
It seems that Schema objects only accept ASCII letters.
Do I miss something?
Cheers,
Jean-Michel POURE
---(end of broadcast)
On Tue, 7 Jan 2003, Justin Clift wrote:
> Hi everyone,
>
> Just found out that the "pgdiff" utility (the one for comparing two
> different PostgreSQL database's) was released and uploaded to
> SourceForge in November:
>
> http://sourceforge.net/projects/pgdiff
>
> Have people already looked at thi
Tom Lane writes:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > We have definatly had requests for improved thread-safeness for libpq
> > and ecpg in the past, so whatever you can do would be a help. We say
> > libpq is thread-safe, but specifically mention the non-threadsafe calls
> > in th
On Tue, 07 Jan 2003 11:18:15 +0100, I wrote:
>what I have hacked together yesterday afternoon:
[included it twice]
Sorry!
Servus
Manfred
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
On Fri, 03 Jan 2003 15:37:56 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
>The system tables are not the problem. [...]
>
>Changes in the on-disk representation of user tables would be harder to
>deal with, but they are also much rarer (AFAIR we've only done that
>twice: WAL required additions to pag
> -Original Message-
> From: Lamar Owen [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2003 06:12
> To: Christopher Kings-Lynne; Hackers; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Thank-you to Cybertec Geschwinde & Schonig
>
>
> On Monday 06 January 2003 21:01, Christopher Kings-Lynne
> -Original Message-
> From: Kristis Makris [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2003 03:05
> To: Francisco Figueiredo Jr.
> Cc: [EMAIL PROTECTED]
> Subject: Re: [Npgsql-general] Get function OID and function
> calling support
>
>
> Hi Francicso,
>
> > I could, however, call
Hi guys,
Have passed on the info everyone provided about ways of getting
PostgreSQL working on the OS/400 on to the requestor. It would be
interesting to see if they go with it.
Thanks for the assistance... more stuff will keep on coming through of
course.
:-)
Regards and best wishes,
Just
Hi guys,
Also received a through the Advocacy website asking if anyone has
ported PostgreSQL to the AlphaServers under VMS.
Anyone know if we run on VMS? Last time I touched VMS (about 10 years
ago) it wasn't all that Unix-like.
:-)
Regards and best wishes,
Justin Clift
--
"My grandfather
On 6 Jan 2003 at 6:48, Greg Copeland wrote:
> > 1) Get I/O time used fuitfully
> AIO may address this without the need for integrated threading.
> Arguably, from the long thread that last appeared on the topic of AIO,
> some hold that AIO doesn't even offer anything beyond the current
> implementa
100 matches
Mail list logo
