Tatsuo Ishii wrote:
Today I revisited the implemnetation (replacing sync() with
open/_commit) I made several days ago and found a bug with it (thanks
to Hiroshi). With the fixed version of it, now my Win32 port has
passed your test even right after checkpoint!.
I presume that this
---BeginMessage---
I've been trying to get information on a programming interface to the database. Over
the last while Dave Page and I have emailed each other. Dave has suggested I join the
hacker maillist.
Thus I am forwarding the communication I sent to Dave. I hope this is approriated in
On Thursday 06 March 2003 19:08, Bruce Momjian wrote:
Jeroen T. Vermeulen wrote:
On Tue, Feb 25, 2003 at 02:04:50PM +0100, Christoph Haller wrote:
Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT()
function on the query to learn about the number of rows to be returned.
Have you seen
libpq - C Library
Functions Associated with the COPY Command
This is best way to INSERT large amounts of data.
Regards, Christoph
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Considering the time zone abbreviations that are accepted on input, I find
a couple of bogosities:
WDT +09:00 West Australian Daylight Time
AWST+08:00 Australia Western Standard Time
WADT+08:00 West Australian Daylight Time
WST +08:00 West Australian Standard Time
WAST
I read your post, and I am struck by a few things, I am not sure I will
answer all your points, but maybe a discussion is in order.
I use PostgreSQL with C++ all the time. I actually have a SQL class that
abstracts libpq and ODBC, so I'm pretty much past a lot of the how I
want to use it
I'm pressing ahead with trying to implement the SQL92 version of updateable
views. I'm trying to track down a copy of the SQL92 standard, I thought that
ANSI sold them, but I can only find SQL89 and SQL99 there; am I looking in
the wrong place?
Eric Nielsen
---(end of
Eric D Nielsen [EMAIL PROTECTED] writes:
I'm pressing ahead with trying to implement the SQL92 version of updateable
views. I'm trying to track down a copy of the SQL92 standard, I thought that
ANSI sold them, but I can only find SQL89 and SQL99 there; am I looking in
the wrong place?
I'm
Peter Eisentraut [EMAIL PROTECTED] writes:
Considering the time zone abbreviations that are accepted on input, I find
a couple of bogosities:
Presumably we can get some local knowledge on those items from list
members. I believe that Thomas created the TZ tables on the basis of
including
Does it make sense to avoid sequence name collisions if applications
have to refer to sequence names directly? I mean, I can imagine a case
where a restore would return a sequence name that is different from the
one that dumped it. pg_dump may be hacked to fix that (look up the
sequence for the
I haven't been able to get to it all morning.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Fri, 7 Mar 2003, mlw wrote:
I couldn't get to it yesterday either. FTP worked fine though.
--
Thomas T. Thai
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
FYI.
Vince.
--
Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/
http://www.meanstreamradio.com http://www.unknown-artists.com
Internet radio: It's not file sharing, it's just radio.
-- Forwarded message --
Date: Fri, 7 Mar 2003
I haven't been able to get to it all morning.
I think its time to consider migrating off of mysql on the web server.
Merlin
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
mlw [mailto:[EMAIL PROTECTED] wrote:
I use PostgreSQL with C++ all the time. I actually have a SQL class
that
abstracts libpq and ODBC, so I'm pretty much past a lot of the how I
want to use it stuff.
What about libpq++? I have not used the thing, but if he absolutely
insists on using C++ in
On Fri, Mar 07, 2003 at 12:14:30PM -0500, Merlin Moncure wrote:
What about libpq++? I have not used the thing, but if he absolutely
insists on using C++ in his database interface that's at least worth
checking out. Same for embedded C.
And of course there's libpqxx. I haven't heard from
After finding the SQL92 draft spec that Tom quoted from earlier I think I
understand the conditions for the spec's version of view updatability. I've
made few comments below on the conditions and I'ld appreciate it if anyone
would correct any mis-interpretations on my part.
12)A query
I just tested the MOVE -5 in a simple case, and it worked:
test= begin;
BEGIN
test= declare xx cursor for select * from pg_class;
DECLARE CURSOR
test= move from xx;
MOVE 157
test= move -5 from xx;
MOVE 5
test= fetch
Bruce Momjian wrote:
The idea of using this on Unix is tempting, but Tatsuo is using a
threaded backend, so it is a little easier to do. However, it would
probably be pretty easy to write a file of modified file names that the
checkpoint could read and open/fsync/close.
Even that's not
About 1 in every 5 runs of the (parallel) regression tests are failing
for me with CVS HEAD: the triggers, inherit, vacuum, sanity_check, and
misc tests fail. I can make the failures occur fairly consistently by
running make check over and over again until the problem crops up.
The platform is
Neil Conway [EMAIL PROTECTED] writes:
About 1 in every 5 runs of the (parallel) regression tests are failing
for me with CVS HEAD: the triggers, inherit, vacuum, sanity_check, and
misc tests fail. I can make the failures occur fairly consistently by
running make check over and over again
Bruce Momjian wrote:
Kevin Brown wrote:
Bruce Momjian wrote:
The idea of using this on Unix is tempting, but Tatsuo is using a
threaded backend, so it is a little easier to do. However, it would
probably be pretty easy to write a file of modified file names that the
checkpoint
On Fri, 2003-03-07 at 17:05, Doug McNaught wrote:
Neil Conway [EMAIL PROTECTED] writes:
About 1 in every 5 runs of the (parallel) regression tests are failing
for me with CVS HEAD: the triggers, inherit, vacuum, sanity_check, and
misc tests fail. I can make the failures occur fairly
But even then, we don't actually have to track the *names* of the
files that have changed, just their RelFileNodes, since there's a
mapping function from the RelFileNode to the filename.
Right. I have noticed that too and have made changes to my
implementaion.
BTW, you need to track the block
Hi everyone,
Just came across the website for the first GCC Developers Summit, to
be held May 25-27, 2003.
http://www.gccsummit.org/2003/
Might be of interest to some people here.
:)
Regards and best wishes,
Justin Clift
--
My grandfather once told me that there are two kinds of people:
Eric D Nielsen [EMAIL PROTECTED] writes:
I beleive this should allow queries such as:
UPDATE (SELECT bar, baz FROM foo) SET bar=1 WHERE baz=2;
as well as the
CREATE VIEW foo_view AS SELECT bar, baz FROM foo;
UPDATE foo_view SET bar=1 WHERE baz==2;
DROP VIEW foo_view;
three-query analog.
Kevin Brown [EMAIL PROTECTED] writes:
Even that's not strictly necessary -- we *do* have shared memory we
can use for this, and even when hundreds of tables have been written
the list will only end up being a few tens of kilobytes in size (plus
whatever overhead is required to track and
Neil Conway [EMAIL PROTECTED] writes:
About 1 in every 5 runs of the (parallel) regression tests are failing
for me with CVS HEAD: the triggers, inherit, vacuum, sanity_check, and
misc tests fail. I can make the failures occur fairly consistently by
running make check over and over again until
There is no declaration of charset in the main webpage. Something like
meta content=text/html; charset=iso-8859-1 http-equiv=Content-Type
would be nice. What is worse is that there are several charsets used. In
the International part I have to set mozilla to use utf-8 for it to be
rendered
Bruce Momjian [EMAIL PROTECTED] writes:
What I think you are seeing are that certain cursors can't go backwards.
Lots of the more complex plan node types don't correctly implement
backwards fetch. I've looked briefly at fixing that, but it looks like
it'd be a major pain in the rear for some
Kevin Brown wrote:
Bruce Momjian wrote:
The idea of using this on Unix is tempting, but Tatsuo is using a
threaded backend, so it is a little easier to do. However, it would
probably be pretty easy to write a file of modified file names that the
checkpoint could read and
Merlin Moncure wrote:
This is the 'proof of concept' cygwin windows build. Strangely, I have
a newer build than the one on the ftp server. Is there a binary version
of postgres with Jan's patch available?
Uh Oh.
When you say newer version, what gives the feeling of it being newer?
In the Proof
Bruce Momjian wrote:
What is this build, exactly? It is Jan's patch brough up to 7.3, or cygwin?
It's a simplified installation package of 7.3.1 with cygwin. Put it
together so we can get a feel for the packaging issues we'll need to
take into account for the proper release of a 7.4 Windows
Christopher Kings-Lynne kirjutas R, 07.03.2003 kell 07:28:
Yeah, it's not really a problem for me, I just put the extra clause in.
Is indexing excluding NULLs a common application of partial indexes?
For me it is ;)
It's
basically all I use it for, when a column has like 90-95% NULLS and
On Fri, 7 Mar 2003, Dave Page wrote:
-Original Message-
From: Thomas T. Thai [mailto:[EMAIL PROTECTED]
Sent: 07 March 2003 17:05
To: mlw
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] What's up with www.postgresql.org?
On Fri, 7 Mar 2003, mlw wrote:
I couldn't get to
There are (at least) two distinct problems involved here. One is
getting plpgsql to deal correctly with rowtypes that include dropped
columns. The other is getting it to react when someone alters a table
whose rowtype is relied on by already-compiled functions.
I'm working on this
Bruce Momjian [EMAIL PROTECTED] writes:
Do we precompile SQL functions yet?
As of CVS tip, we can inline SQL functions that are simple SELECT
expression cases; and it's always been true that SQL function queries
are planned only once per outer query. I don't believe there's any
cross-query
Just checking for TODO list. Thanks.
---
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Do we precompile SQL functions yet?
As of CVS tip, we can inline SQL functions that are simple SELECT
expression
On Fri, 2003-03-07 at 11:27, Bruce Momjian wrote:
Does it make sense to avoid sequence name collisions if applications
have to refer to sequence names directly? I mean, I can imagine a case
Not at all. Hence the thought that we might create syntax to allow
applications to refer to the table /
Stanards URL's are in the developers FAQ.
---
Tom Lane wrote:
Eric D Nielsen [EMAIL PROTECTED] writes:
I'm pressing ahead with trying to implement the SQL92 version of updateable
views. I'm trying to track down a copy
-Original Message-
From: Thomas T. Thai [mailto:[EMAIL PROTECTED]
Sent: 07 March 2003 17:05
To: mlw
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] What's up with www.postgresql.org?
On Fri, 7 Mar 2003, mlw wrote:
I couldn't get to it yesterday either. FTP worked fine though.
Kevin Brown wrote:
Tatsuo Ishii wrote:
Today I revisited the implemnetation (replacing sync() with
open/_commit) I made several days ago and found a bug with it (thanks
to Hiroshi). With the fixed version of it, now my Win32 port has
passed your test even right after checkpoint!.
I
Yes, Marc mentioned needing to get some sleep after fixing a RAID
controller for perhaps 24 hours.
---
Dave Page wrote:
-Original Message-
From: Thomas T. Thai [mailto:[EMAIL PROTECTED]
Sent: 07 March
What is this build, exactly? It is Jan's patch brough up to 7.3, or cygwin?
---
Justin Clift wrote:
[EMAIL PROTECTED] wrote:
snip
How about putting a README file in that directory as well, giving out
the same
44 matches
Mail list logo