There is no declaration of charset in the main webpage. Something like
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 correctly and in the Event part I have to tell mozilla to use
iso-8859-1
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 agai
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
> expressi
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
> > 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 thi
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:
>
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
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 a
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:
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 ver
> 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 blo
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 "Pro
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 fai
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
> > > c
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 aga
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 open/fsy
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 L
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 st
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
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=> f
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 QS is
What is this build, exactly? It is Jan's patch brough up to 7.3, or cygwin?
---
Justin Clift wrote:
> [EMAIL PROTECTED] wrote:
>
> > How about putting a README file in that directory as well, giving out
> > the same warni
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 fro
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 Ma
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!.
> -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 fi
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++
>
> 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]
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 04:08:3
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
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
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, 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
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
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 ev
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
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 bro
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" stuf
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+07:0
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]
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 return
--- Begin Message ---
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
Tom Lane wrote:
> A larger point is that this is still a protocol revision; pretending
it
> ain't is just willful obscurantism. You can tell it's a protocol
revision
> because you will need to rewrite client-side libraries to take
advantage
> of it. If we try to look the other way and pretend it
unsubscribe pgsql-hackers [EMAIL PROTECTED]STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > I presume that this implementation tracks which files have been opened
> > and uses _commit() to write all the changes to disk for those files?
>
> But are there quarantees that all closed files are flushed to disk as
> well ?
>
> Does postgres quarantee it by doing a _commit() before close()
Isn't there a space missing in there ?
limit10 - limit 10
All you've done is alias the tablename
On Friday 07 March 2003 11:25 am, Teodor Sigaev wrote:
> Query
> select * from TABLE limit10;
> returns all rows, but it seems to me this is a syntax error...
>
> pgsql 7.3.2 and current CVS has
-*- Teodor Sigaev <[EMAIL PROTECTED]> [ 2003-03-07 11:26 ]:
> Query
> select * from TABLE limit10;
> returns all rows, but it seems to me this is a syntax error...
>
> pgsql 7.3.2 and current CVS has this bug.
select*from table limit10; also works in some versions
--
Regards,
Tolli
[EMAIL
Query
select * from TABLE limit10;
returns all rows, but it seems to me this is a syntax error...
pgsql 7.3.2 and current CVS has this bug.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
Kevin Brown kirjutas R, 07.03.2003 kell 12:05:
> 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 ev
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 implemen
51 matches
Mail list logo
