I've implemented timestamp and time precision per SQL99 spec. The syntax
is
TIMESTAMP(2) WITH TIME ZONE
or
TIME(0)
etc etc.
One result of this is that "timestamp" is no longer a valid external
function name (among other things) due to parser ambiguity between
TIMESTAMP(2)
and, say,
TI
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> I'd feel more confident if the measurements were done using operators
>> repeated enough times to yield multiple-second runtimes.
> Any idea to do that?
Maybe something like this: declare a plpgsql function that takes two
text parameters and has a body
...
> Yes, that's apossibility. But then the actual Debian package has not been
> updated. And why messing with two mechanisms?
It may be that the static tarballs for RedHat will work for you (they
work for me on Mandrake).
I use CVSup to keep a local copy of the cvs repository on my laptop, so
Could you not include characters other than ASCII in the HISTORY file,
please.
> Python fix fetchone() (Gerhard H$BgS(Bing)
--
Tatsuo Ishii
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> will set that one up next ...
Great! Thanks...
- Thomas
> > That sounds like a good setting for anoncvs service. But I think Thomas
> > (and any other committers who use cvsup) still need a cvsup server
> > running on the master cvs machine. Even a 1-hour lag is too m
Dave Harkness wrote:
>
> At 01:45 PM 10/2/2001, Barry Lind wrote:
> >Dave,
> >
> >Secondly, you don't need a table lock, you just need to lock the row
> >between the select and the update. You should use 'select for update' to
> >do this. That way when you issue the select to get the current val
> > LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a
> > little bit slow. Probably this is due the wide character conversion
> > overhead.
>
> Could this conversion be optimized to recognize when it's dealing with a
> single-byte character encoding?
Not sure, will look into..
> Yeah, I suspect there's 10% or more noise in these numbers. But then
> one could read the results as saying we can't reliably measure any
> difference at all ...
>
> I'd feel more confident if the measurements were done using operators
> repeated enough times to yield multiple-second runtimes.
> Tatsuo Ishii wrote:
> >
> > You are definitely inputting ISO 8859-1 characters, not UTF-8. That's
> > the source of your problem.
> >
>
> Hello, In fact, we create and lodge Web sites and we use
> PostgreSQL/Apache/PHP.
>
> I parameterized the encoding in "UNICODE" thinking that it was most
In 7.1.X and earlier the INSERT rules are executed _before_ the INSERT.
This is changed to _after_ in 7.2.
> For some reason, I seam to feel as if the inserts that should be executed by
> a rule are not all getting executed, or at least, they are not getting writen.
>
> How can I find out wha
For some reason, I seam to feel as if the inserts that should be executed by
a rule are not all getting executed, or at least, they are not getting writen.
How can I find out what the rule is really doing? The logs don't say much.
Any help will be grear at this moment of stress!!! X->
Saludos.
I have used Oracle SQLOADER for many years now. It has the ability to
put rejects/discards/bad into an output file and keep on going, maybe
this should be added to the copy command.
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
In current CVS I see a failure in the btree_gist regression test.
It kinda looks like the test data was changed without updating the
expected results, but would you verify this?
regards, tom lane
*** ./expected/btree_gist.out Wed Aug 22 14:27:54 2001
--- ./results/btre
You are attacking here two things:
a) schemas, which should be done in 7.3, thus multiple databases on same
host would be unnecessary.
b) connections to remote host' databases, which is partially implemented
already (in a ugly way, but...) see contrib/dblink
What you described is a syntactic s
Hi!
0. I think access to other databases is really important. There was
a discussion about that. Using a dot operator to specify a
database (schema) seems to be very standard and elegant.
But there is another way to implement it. Here is my
suggestion.
1. First, some syntax:
CREATE [ SHARED ] [
Tatsuo Ishii writes:
> LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a
> little bit slow. Probably this is due the wide character conversion
> overhead.
Could this conversion be optimized to recognize when it's dealing with a
single-byte character encoding?
--
Peter Eisent
Tom Lane writes:
> It occurs to me that skip-the-insert might be a useful option for
> INSERTs that detect a unique-key conflict, not only for COPY. (Cf.
> the regular discussions we see on whether to do INSERT first or
> UPDATE first when the key might already exist.) Maybe a SET variable
> th
Bruce Momjian writes:
> I know you can manually run it on individual SGML files but I don't see
> a way to automate that. Do you?
I don't because there isn't. For one, if a link points to some other file
you lose.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
Justin Clift writes:
> i.e. if [ -x "$self_path/postmaster" ] && [ -x "$self_path/psql" ];
> then
>
> or
>
> if [[ -x "$self_path/postmaster" && -x "$self_path/psql" ]]; then
I don't think the second one is a valid expression. ;-)
Maybe you were wondering about [[ ]] vs [] -- In Autoconf [] ar
Bruce Momjian <[EMAIL PROTECTED]> writes:
> But the strange thing is that LIKE is faster, perhaps meaning his
> measurements can't even see the difference,
Yeah, I suspect there's 10% or more noise in these numbers. But then
one could read the results as saying we can't reliably measure any
diff
Yup, not a crucial component of the base system ... once we start to get
into the 'release candidate' mode, then it is kinda frowned upon, but
early beta, no probs ...
On Tue, 2 Oct 2001, Bruce Momjian wrote:
>
> It is my understanding we can add things to /contrib even during beta,
> right?
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > If no one can find a case where multibyte is slower, I think we should
> > enable it by default. Comments?
>
> Well, he just did point out such a case:
>
> >> no MB with MB
> >> LIKE 0.09 msec 0.08 msec
> >> REGEX
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > It is my understanding we can add things to /contrib even during beta,
> > right? We are certainly more lax with beta than with the main backend
> > tree. /contrib does get compiled so it does need to compile cleanly.
>
> The rules for contrib are
Bruce Momjian <[EMAIL PROTECTED]> writes:
> If no one can find a case where multibyte is slower, I think we should
> enable it by default. Comments?
Well, he just did point out such a case:
>> no MB with MB
>> LIKE 0.09 msec 0.08 msec
>> REGEX0.09 ms
Bruce Momjian <[EMAIL PROTECTED]> writes:
> It is my understanding we can add things to /contrib even during beta,
> right? We are certainly more lax with beta than with the main backend
> tree. /contrib does get compiled so it does need to compile cleanly.
The rules for contrib are laxer, for
>
> U ... I thought we weren't going to do this, but were going to fix the
> proper build process?
Well, until it works I can fiddle with it here. What will the future
build interval be? Are people OK with that?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAI
U ... I thought we weren't going to do this, but were going to fix the
proper build process?
On Tue, 2 Oct 2001, Bruce Momjian wrote:
> > On Sun, 30 Sep 2001, Bruce Momjian wrote:
> >
> >
> > > > On Sun, 30 Sep 2001, Bruce Momjian wrote:
> > > >
> > > >
> > > > > >
> > > > > >
> > > > > > j
On Tue, 2 Oct 2001, Tom Lane wrote:
> Did we come to any conclusion about whether to accept Gavin Sherry's
> CREATE OR REPLACE FUNCTION patch?
> http://fts.postgresql.org/db/mw/msg.html?mid=1035792
>
> AFAIR, the score was that I liked it, Bruce didn't, and no one else
> had expressed an opinion
On Monday 01 October 2001 07:33 pm, John Summerfield wrote:
> It seems you don't have to be new here to be a bit peeved about things;-(
[snip]
> Time to get your act together fellas.
This is open source John, not rocket science. (pun intended)
Lighten up. The release will happen, regardless of
If no one can find a case where multibyte is slower, I think we should
enable it by default. Comments?
> > Also, have we decided if multibyte should be the configure default now?
>
> Not sure.
>
> Anyway I have tested LIKE/REGEX query test using current. The query
> executed is:
>
> explain
It is my understanding we can add things to /contrib even during beta,
right? We are certainly more lax with beta than with the main backend
tree. /contrib does get compiled so it does need to compile cleanly.
> We're about to release brand new contrib module which is
> actually is a first ste
> Did we come to any conclusion about whether to accept Gavin Sherry's
> CREATE OR REPLACE FUNCTION patch?
> http://fts.postgresql.org/db/mw/msg.html?mid=1035792
>
> AFAIR, the score was that I liked it, Bruce didn't, and no one else
> had expressed an opinion.
I withdraw my objection. When I r
> On Sun, 30 Sep 2001, Bruce Momjian wrote:
>
>
> > > On Sun, 30 Sep 2001, Bruce Momjian wrote:
> > >
> > >
> > > > >
> > > > >
> > > > > just about to be moved to the new server, now that the new 18gi drive has
> > > > > been installed ... plan on getting that done this afternoon ...
> > > >
>
On Tue, 2 Oct 2001, Bruce Momjian wrote:
> > On Mon, 1 Oct 2001, Bruce Momjian wrote:
> >
> > > > Until the dust settles the only two people with write access to either
> > > > the developer or regular website will be Marc and myself. I have enough
> > > > to do trying to get mirroring straight,
On Tue, 2 Oct 2001, John Summerfield wrote:
> On Mon, 1 Oct 2001, Tom Lane wrote:
>
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > The one thing I can't check is the anoncvs directory. Not sure if that
> > > is the same as the CVS directory.
> >
> > It is the anoncvs server that's broken.
> > OK, new directory is /home/momjian/docs and links need to be created in
> > /usr/local/www/www/html/docs.
> >
> > internalpics.pdf is the same as the one you have on the developers site
> > but it should be a link to the copy in my home directory so I can update
> > it regularly. I know it is
> On Mon, 1 Oct 2001, Bruce Momjian wrote:
>
> > > Until the dust settles the only two people with write access to either
> > > the developer or regular website will be Marc and myself. I have enough
> > > to do trying to get mirroring straight, keep up with changes to the sites,
> > > etc. that
On Mon, 1 Oct 2001, Bruce Momjian wrote:
> > Marc,
> >
> > it worked, but now I'm again getting:
> >
> > cvs server: failed to create lock directory for
>/projects/cvsroot/pgsql/contrib/pgcrypto/expected'
>(/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied
> > cvs
We're about to release brand new contrib module which is
actually is a first step of integration of OpenFTS to postgres.
Preliminary numbers are rather impressive -
zen:~/app/pgsql/GiST/tsearch_index$ time psql-dev apod -c \
"select title from titles where titleidx @@ 'gist&patch';" > /dev/null
On Tue, Oct 02, 2001 at 10:33:55AM -0400, Tom Lane wrote:
> Or update to the fixed version of cvsup, anyway. Thomas Lockhart likes
> cvsup too, so you can be sure it will continue to be a workable means
> of working with our CVS tree.
Yes, that's apossibility. But then the actual Debian package
Tom Lane wrote:
>
> Did we come to any conclusion about whether to accept Gavin Sherry's
> CREATE OR REPLACE FUNCTION patch?
> http://fts.postgresql.org/db/mw/msg.html?mid=1035792
>
> AFAIR, the score was that I liked it, Bruce didn't, and no one else
> had expressed an opinion.
>
> The patch i
On Sun, 30 Sep 2001, Bruce Momjian wrote:
> > On Sun, 30 Sep 2001, Bruce Momjian wrote:
> >
> >
> > > >
> > > >
> > > > just about to be moved to the new server, now that the new 18gi drive has
> > > > been installed ... plan on getting that done this afternoon ...
> > >
> > > Don't rush. I am
On Mon, 1 Oct 2001, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > The one thing I can't check is the anoncvs directory. Not sure if that
> > is the same as the CVS directory.
>
> It is the anoncvs server that's broken. The committers don't seem to be
> having any problem with
Hi,
It's come to my attention that users of pgAdmin (the original, not pgAdmin
II) will not be able to dump/reload their 7.1.x databases into 7.2 without
an additional step in the upgrade procedure.
This is because pgAdmin creates a number of views on the server which
include the oid column from
Just a HUMOR, no offense and take it easy!!
=
If someone ask's you how do you compare the features and capability of
these three popular SQL servers:
Oracle, PostgreSQL and MySQL ??
Then comes the answer in layman's terms:
"A Elephant, Powerful White Horse, Fast
On Tuesday 02 October 2001 08:32 am, Marc G. Fournier wrote:
> ftp.postgresql.org:/var/spool/ftp/pub/binary
> (216.126.85.28)
So far so good. Login successful, group membership correct. I'll let you
know if I stumble across a roadblock.
Oh, and BTW: having done server splits and moves in the
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Strange enough, there's no other backend (of course except stats
> collectors) here. I make sure this with ps and pg_stat_activity view.
If you have no better way of determining what's going on, it might help
to recompile with LOCK_DEBUG defined, then en
Michael Meskes <[EMAIL PROTECTED]> writes:
> But now cvsup on my system stopped working because of that 10mil
> seconds bug but I failed to notice. Hey, I don't check the logfiles
> everytime. So when I made my last commit, I simply used these old files as a
> base and removed Tom's patch. I guess
Did we come to any conclusion about whether to accept Gavin Sherry's
CREATE OR REPLACE FUNCTION patch?
http://fts.postgresql.org/db/mw/msg.html?mid=1035792
AFAIR, the score was that I liked it, Bruce didn't, and no one else
had expressed an opinion.
The patch itself needs a little bit of cleanup
On Tue, 2 Oct 2001, Tom Lane wrote:
> Frank Wiles <[EMAIL PROTECTED]> writes:
> > It appears the cvs log functionality is working just fine, however
> > you can't actually view the source of the file by clicking on the
> > revision number. Clicking on:
> >
>http://developer.post
> -Original Message-
> From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]]
> Sent: 24 September 2001 08:13
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: [ODBC] [HACKERS] UTF-8 support
>
>
> > Which ones belong to the backend and whic
will set that one up next ...
On Tue, 2 Oct 2001, Tom Lane wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > On Mon, 1 Oct 2001, Thomas Lockhart wrote:
> >> I would like to resolve the 12 hour lag for CVSup and anoncvs service,
>
> > It should never have been 12hrs ... I had it set fo
Christof just told me that I overwrote Tom's patch fixing the setlocale
problem in ecpg. I did not notice that and for some strange reason did not
get Tom's mail either. Anyway, the CVS problem was that I use cvsup to keep
an up-to-date source tree. I have set up my system so that it updates
every
Frank Wiles <[EMAIL PROTECTED]> writes:
> It appears the cvs log functionality is working just fine, however
> you can't actually view the source of the file by clicking on the
> revision number. Clicking on:
>
>http://developer.postgresql.org/cvsweb.cgi/src/bin/psql/command.c?r
On Tue, 2 Oct 2001, Frank Wiles wrote:
> It appears the cvs log functionality is working just fine, however
> you can't actually view the source of the file by clicking on the
> revision number. Clicking on:
oops! fixed.
--
"James L. Hubbard III" <[EMAIL PROTECTED]> writes:
> Who works on the genetic query optimizer (geqo)?
AFAIK, no one has touched the genetic algorithm itself in years --- not
since the original contributor, who has not been heard from in awhile.
The only changes to that code have been to clean up
.--[ Tom Lane wrote (2001/10/02 at 09:47:41) ]--
|
| Vince Vielhaber <[EMAIL PROTECTED]> writes:
| > cvsweb is now working! It's available from the developer's site:
| > http://developer.postgresql.org/
|
| Thankyouthankyouthankyouthankyou ... I hadn't realized
Vince Vielhaber <[EMAIL PROTECTED]> writes:
> cvsweb is now working! It's available from the developer's site:
> http://developer.postgresql.org/
Thankyouthankyouthankyouthankyou ... I hadn't realized how much I'd come
to depend on that service, until I didn't have it for awhile ...
cvsweb is now working! It's available from the developer's site:
http://developer.postgresql.org/
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
56K Nationw
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Mon, 1 Oct 2001, Thomas Lockhart wrote:
>> I would like to resolve the 12 hour lag for CVSup and anoncvs service,
> It should never have been 12hrs ... I had it set for 4 ... but, I have
> drop'd it down to hourly effective this morning ...
Tha
Thanks, It works now
On Tue, 2 Oct 2001, Marc G. Fournier wrote:
>
> should have auto-fixed itself about 10 minutes ago ...
>
> On Tue, 2 Oct 2001, Oleg Bartunov wrote:
>
> > Marc,
> >
> > fix, please, permanently problem with permissions in anonymous CVS
> > cvs server: Updating pgsql/contrib/pg
should have auto-fixed itself about 10 minutes ago ...
On Tue, 2 Oct 2001, Oleg Bartunov wrote:
> Marc,
>
> fix, please, permanently problem with permissions in anonymous CVS
> cvs server: Updating pgsql/contrib/pgcrypto/expected
> cvs server: failed to create lock directory for
>/projects/cvs
Marc,
fix, please, permanently problem with permissions in anonymous CVS
cvs server: Updating pgsql/contrib/pgcrypto/expected
cvs server: failed to create lock directory for
/projects/cvsroot/pgsql/contrib/pgcrypto/expected'
(/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permiss
On Mon, 1 Oct 2001, Vince Vielhaber wrote:
> On Tue, 2 Oct 2001, Thomas Lockhart wrote:
>
> > ...
> > > Tom, what's missing or out of place? If I can I'll make sure it's there.
> > > This morning I noticed a number of things that I thought were there really
> > > weren't.
> >
> > What I was look
On Mon, 1 Oct 2001, Thomas Lockhart wrote:
> I would like to resolve the 12 hour lag for CVSup and anoncvs service,
> and frankly until that is resolved we should accept that we have a 12
> hour turnaround on most changes. Coincidentally, that is the rate at
> which the docs are (or would be, if
On Mon, 1 Oct 2001, Lamar Owen wrote:
> On Monday 01 October 2001 04:13 pm, Thomas Lockhart wrote:
>
> > > the only changes to directory schemes is:
> > > /var/spool/ftp/* for anon ftp
> > > /usr/local/www/www for web stuff
> > > directory structures under each should still be as
fixed, permanently, or should be ... let me know ..
I've also just changed the 'pull down' to be every hour at *:59 ...
On Tue, 2 Oct 2001, Hannu Krosing wrote:
> Marko Kreen wrote:
> >
> > On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote:
> > > HI,
> > >
> > > I've seen lots of
On Mon, 1 Oct 2001, Bruce Momjian wrote:
> > > > I would propose that the reference machine be one that one of the
> > > > "committers" owns, and be one whose owner is willing to *always* go
> > > > through the effort to resolve regression test changes and differences.
> > > Er ... wasn't that *y
On Mon, 1 Oct 2001, Bruce Momjian wrote:
> > Until the dust settles the only two people with write access to either
> > the developer or regular website will be Marc and myself. I have enough
> > to do trying to get mirroring straight, keep up with changes to the sites,
> > etc. that I really do
Sorry guys,
I didn't realise I actually sent this, it was part of an email I was
putting together to achieve consistency in the scripts, but I thought I
cancelled it when it got late in the morning.
My apologies.
Regards and best wishes,
Justin Clift
Bruce Momjian wrote:
>
> > Hi all,
> >
>
Marko Kreen wrote:
>
> On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote:
> > HI,
> >
> > I've seen lots of talk about anoncvs not working, but I
> > can't even find out where it is ;(
>
> :pserver:[EMAIL PROTECTED]:/projects/cvsroot
I got in now, but the general problems have now s
On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote:
> HI,
>
> I've seen lots of talk about anoncvs not working, but I
> can't even find out where it is ;(
:pserver:[EMAIL PROTECTED]/projects/cvsroot
--
marko
---(end of broadcast)---
HI,
I've seen lots of talk about anoncvs not working, but I
can't even find out where it is ;(
The old address gives
[hannu@taru pgsql]$ ../update.cvs
cvs update: authorization failed: server postgresql.org rejected
access to /home/projects/pgsql/cvsroot for user anoncvs
the link from deve
73 matches
Mail list logo
