I just noticed this fairly silly behaviour:
test=# select to_char(current_date, 'D'), extract(dow from current_date);
to_char | date_part
-+---
3 | 2
(1 row)
I guess we can't change that now, but they really should number their
days from the same base...
Chris
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is it true to say that it's impossible for me to allow comments on
casts, as there is no OID on the pg_cast table?
Eh?
regression=# select oid from pg_cast;
oid
---
16420
16421
16422
16423
16424
... etc ...
It would be a very
regression=# select oid from pg_cast;
oid
---
16420
16421
16422
16423
16424
... etc ...
It would be a very serious design error if pg_cast didn't have OIDs,
because then pg_cast entries couldn't have dependency entries in
pg_depend.
OK. Weird. I could have _sworn_ I tried that and I
Some dumb-user/fat-finger/ooops protection is surely welcome, but there
is a limit. A system console has to be behind a locked door instead of
the single-user boot being root-password protected. As soon as people
Unfortunately, as more and more companies start to outsource their
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Also, with the pg_largeobject table, there seems to be no 'owner'
concept on lobs at all. So is there no problem with any random gumby
commenting on anyone else's large object?
We don't have a lot of choice. I suppose ideally LOs should
On Mon, Oct 13, 2003 at 11:51:52PM -0400, Jan Wieck wrote:
You can build more secure systems as long as you want, evolution will
develop the better idiot. As long as you create safer cars with more
Sure, but I think all Rod is asking for is something like the ability
to add the -w switch to
Neil Conway [EMAIL PROTECTED] writes:
On Mon, 2003-10-06 at 16:21, Joshua D. Drake wrote:
postgres=# create user with encrypted password '98wq7912a';
CREATE USER
postgres=# create user with encrypted password '98wq7912a';
ERROR: CREATE USER: user name with already exists
So, what are we
Bruce Momjian writes:
What to do about exposing the list of possible SQLSTATE error codes
I say we put the list in the documentatio and that's it. Exposing the
list in C header files wouldn't really be an ultimate solution, because
not everyone uses C.
Freeze message strings
That is old
Christopher Kings-Lynne writes:
Also, with the pg_largeobject table, there seems to be no 'owner'
concept on lobs at all. So is there no problem with any random gumby
commenting on anyone else's large object?
Not any worse that any random gumby reading or writing anyone else's large
object.
Michael Brusser [EMAIL PROTECTED] writes:
2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
Interrupted system call
Hmm. I found this hard to believe at first, but indeed my local man
pages for read() and write() say they can return EINTR if interrupted
by a signal. This
I wonder if this is feasible to enhance create trigger
so I could say 'create or replace'
Thanks,
Mike.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Yes, we use NFS. Many of our customers use it as well.
Mike.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
... ...
Michael Brusser [EMAIL PROTECTED] writes:
2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
Interrupted system call
Hmm. I
[EMAIL PROTECTED] (Dann Corbit) wrote in message news:[EMAIL PROTECTED]...
-Original Message-
From: Seun Osewa [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 11:52 AM
To: [EMAIL PROTECTED]
Subject: [HACKERS] Dreaming About Redesigning SQL
Hi,
This is for
Marko Karppinen writes:
GCC sets __FAST_MATH__ even if you counter a -ffast-math with the
negating flags above. This means that it is not currently possible to
use the -fast flag when compiling PostgreSQL at all. Instead, you have
to go through all the flags Apple is setting and only pass on
Hi,
I am an
Oracle DBA having 4 +years of experience and want to migrate to postgreSQL .
Please kindly Assist me for Documents to convert Oracle
Application to PostgreSQL .
And also send me the links to open source code
for postgreSQL.
Thanks Regards,
Srikanth Pentakota
This would be a good idea I think. DB2 has a page-cleaner background process that
periodically writes out dirty pages to disk. Reduces checkpoint I/O.
I don't see much point in serializing all bufferpool I/O through a separate dedicated
backend. Informix uses something like this.
--
Pip-pip
Bruce Momjian wrote:
Martin Rusoff wrote:
I was just contemplating how to make postgres parallel (for DSS
applications)... Has anyone done work on this? It looks to me like there
are a couple of obvious places to add parallel operation:
Stage 1) I/O , perhaps through MPIO - would improve
At 10:45 AM -0400 10/9/03, Bruce Momjian wrote:
Neil Conway wrote:
On Thu, 2003-10-09 at 09:35, Bruce Momjian wrote:
I only put back what was already there --- not sure why others don't use
it. You want it enabled on Linux?
Well, why do we have it enabled at all? If it's to speed
The mathematics of language is more complex than the mathematics of
relations, particularly simple relations (such as 1NF tables).
Are you sure, you know what you are talking about?
I would suggest ditching the entire relational model (as both overly
simplistic in its theory and overly
Hi,
I have to work on some software which is using JDBC and libpq (via JNI) in
the same process to connect to the same Postgres database. The software
is heavily multithreaded.
When running under heavy loads and accessing the database under JDBC and
libpq at the same time, we get obscure JVM
[EMAIL PROTECTED] (Seun Osewa) wrote in message news:[EMAIL PROTECTED]...
I have tried, twice, to download the evaluation version of the alphora
product for testing and it doesn't work. Guess there would be a lot
to learn from playing with it; the product is more than a RDBMS
Aw, that's
With all due respect, Dawn, you are an idiot.
Dawn M. Wolthuis [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Good question. Although I would want to move away from relational
databases too, if there is an RDBMS and one wants to query it, what
would I aim for? If you look at
Good question. Although I would want to move away from relational
databases too, if there is an RDBMS and one wants to query it, what
would I aim for? If you look at XQuery, you will see an example of
what I would definitely NOT aim for. Although the user of such a
language might very well be a
[EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message news:[EMAIL PROTECTED]...
I would suggest ditching the entire relational model (as both overly
simplistic in its theory and overly complex in its implementation) and
start with English (that is one of the other names for the GIRLS
Nicola,
No, the driver does not use libpq it uses it's own socket code.
Dave
On Thu, 2003-10-09 at 07:30, Nicola Pero wrote:
Hi,
I have to work on some software which is using JDBC and libpq (via JNI) in
the same process to connect to the same Postgres database. The software
is heavily
I'm tired of this kind of 2PC is too slow arguments. I think
Satoshi, the only guy who made a trial implementation of 2PC for
PostgreSQL, has already showed that 2PC is not that slow.
Where does Satoshi's implementation sit right now? Will it patch to v7.4?
Can it provide us with a base to work
On Thu, 9 Oct 2003, Bruce Momjian wrote:
Agreed. Let's get it into 7.5 and see it in action. If we need to
adjust it, we can, but right now, we need something for distributed
transactions, and this seems like the logical direction.
I've started working on two-phase commits last week, and
Mike Preece [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message
news:[EMAIL PROTECTED]...
Bob Badour [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Dawn M. Wolthuis [EMAIL PROTECTED] wrote in message
news:[EMAIL
[EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message news:[EMAIL PROTECTED]...
Bob Badour [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
Dawn M. Wolthuis [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Thank you, Seun, for asking your question with a bit of logic
Hi Marko,
I've done a checkout from CVS and performed a build under OS X Panther
7B85 with the non-hacked header files. The problem with the param.h
header file seems to be fixed, however the build is failing with
undefined symbols in libs:
make -C ecpglib all
gcc -no-cpp-precomp -g -O2 -Wall
There's an interesting thread on linux-kernel right now about O_DIRECT and the
kernel i/o APIs databases need. I noticed a connection between what they were
discussing and the earlier discussions here and the pining for an interface to
avoid having vacuum preempt other disk i/o.
Someone from
Thank you, Seun, for asking your question with a bit of logic and not
gut-reaction emotional baggage (and for also asking a question of me
off-list so I could ramble). I'll try to make this more suscinct.
First of all, I have read Codd's 1970 1974 ACM papers, as well as
his The Relational Model
Why would you spent time on implementing a mechanism whose ultimate
benefit is supposed to be increasing reliability and performance, when you
already realize that it will have to lock up at the slightest sight of
trouble? There are better mechanisms out there that you can use instead.
If you
Bob Badour [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
Dawn M. Wolthuis [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Thank you, Seun, for asking your question with a bit of logic and not
gut-reaction emotional baggage (and for also asking a question of me
Dawn M. Wolthuis [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Thank you, Seun, for asking your question with a bit of logic and not
gut-reaction emotional baggage (and for also asking a question of me
off-list so I could ramble). I'll try to make this more suscinct.
With all due
While I definitely agree that the mathematics of the data persistence
mechanism is not as important to me as whether it works or not, as a
former mathematician, I have done a little study related to the
mathematics of non-relational approaches, such as PICK (the one both
Wol and I have been know
Michael Brusser [EMAIL PROTECTED] writes:
Yes, we use NFS. Many of our customers use it as well.
You are of course aware that this is not real safe...
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and
Hans-Jürgen Schönig wrote:
Bruce Momjian wrote:
Martin Rusoff wrote:
I was just contemplating how to make postgres parallel (for DSS
applications)... Has anyone done work on this? It looks to me like there
are a couple of obvious places to add parallel operation:
Stage 1) I/O ,
Hi,
probably it's just a stupid idea, but what do you think of this:currently,
most if not all queries with aggregates (count(), sum()) make seq scans
when there are no conditions at all. especially count() is a classic question
on any postgres list.
the reason is - at least that's what I
Here is a verbatim readout of my typing commands into the database
shell. I issued a 'create database' to pg 7.4b2 and it did not fail
despite an already existing database with the same name. Just thought
I'd pass it along, I haven't been able to reproduce it. Just thought
I'd pass it along...
On 14.10.2003, at 19:52, Tom Lane wrote:
This means that relaxing the check would require (a) finding out which
of the sub-flags break our code and which don't; (b) finding out how
the
answer to (a) has varied with gcc release; and (c) finding out how we
can test whether a given sub-flag is set
James Wilson [EMAIL PROTECTED] writes:
make -C ecpglib all
gcc -no-cpp-precomp -g -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -bundle execute.o typename.o descriptor.o
data.o error.o prepare.o memory.o connect.o misc.o
-L../../../../src/port -L/opt/local/lib -L../pgtypeslib
Michael Brusser [EMAIL PROTECTED] writes:
Michael Brusser [EMAIL PROTECTED] writes:
2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
Interrupted system call
Hmm. I found this hard to believe at first, but indeed my local man
pages for read() and write() say
On Tue, Oct 14, 2003 at 01:58:24PM -0400, Merlin Moncure wrote:
Here is a verbatim readout of my typing commands into the database
shell. I issued a 'create database' to pg 7.4b2 and it did not fail
despite an already existing database with the same name. Just thought
I'd pass it along, I
Alvaro Herrera wrote:
So, how did you know the database already existed? The objects you are
seeing may be well part of template1 ...
You are right, I'm an idiot...sorry :)
Merlin
---(end of broadcast)---
TIP 5: Have you checked our extensive
On Tue, Oct 14, 2003 at 11:34:14AM -0400, Fernando Nasser wrote:
Unrelated question,
And we developed a very nice tool that depends on this feature
confident that we could count on it.
Is this tool going to be released somehow?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I dream about
Alvaro Herrera [EMAIL PROTECTED] writes:
On Tue, Oct 14, 2003 at 11:34:14AM -0400, Fernando Nasser wrote:
And we developed a very nice tool that depends on this feature
confident that we could count on it.
Is this tool going to be released somehow?
Certainly. Keep an eye on
Fernando Nasser wrote:
Bruce,
Before I comment on your suggestions, I would like to mention that many of the
things below were added on request by the few people who cared to comment on it.
Aizaz spent most of his time changing here and there to accommodate these
requests. Anyway, we
Tom Lane wrote:
Michael Brusser [EMAIL PROTECTED] writes:
Yes, we use NFS. Many of our customers use it as well.
You are of course aware that this is not real safe...
Maybe we should throw a stop using NFS if we get an EINTR from
read()/write(), or explain what NFS options they should
--On Tuesday, October 14, 2003 15:31:42 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Tom Lane wrote:
Michael Brusser [EMAIL PROTECTED] writes:
Yes, we use NFS. Many of our customers use it as well.
You are of course aware that this is not real safe...
Maybe we should throw a stop using NFS if
Larry Rosenman wrote:
-- Start of PGP signed section.
--On Tuesday, October 14, 2003 15:31:42 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
Tom Lane wrote:
Michael Brusser [EMAIL PROTECTED] writes:
Yes, we use NFS. Many of our customers use it as well.
You are of course aware
On 14 Oct 2003, Greg Stark wrote:
Michael Brusser [EMAIL PROTECTED] writes:
Michael Brusser [EMAIL PROTECTED] writes:
2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
Interrupted system call
Hmm. I found this hard to believe at first, but indeed my
On Tue, 14 Oct 2003, Bruce Momjian wrote:
I knew you were adding --help-config, but I didn't realize the extent of
the features. The commit message is:
revision 1.1
date: 2003/07/04 16:41:21; author: tgl; state: Exp;
Add --help-config facility to dump information about
On Tue, Oct 14, 2003 at 07:52:55PM +, Jon Jensen wrote:
Is there a mailing list somewhere that all the CVS commits get sent to?
Yes, pgsql-committers.
Other projects I've worked on have such a list, and each commit message is
followed by a complete diff (usually with -u for
-Original Message-
From: Jon Jensen [mailto:[EMAIL PROTECTED]
Sent: 14 October 2003 20:53
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] postgres --help-config
Is there a mailing list somewhere that all the CVS commits
get sent to?
Other projects I've worked on have such a
wscott.marlowe wrote:
If you use intr then this type of thing can happen. Lots of programs assume
the unix semantics for disk accesses. You can get all kinds of bugs when
they're violated.
If you use soft then the consequences can be much much worse. If your
fileserver were to reboot
On Tue, 2003-10-14 at 15:57, Alvaro Herrera Munoz wrote:
On Tue, Oct 14, 2003 at 07:52:55PM +, Jon Jensen wrote:
Other projects I've worked on have such a list, and each commit message is
followed by a complete diff (usually with -u for readability) so even
non-committers can do a code
I wouldn't want the whole diff on the mail, but a link to the relevant
diffs in cvsweb would be most useful (one for each changed file -- not ideal,
but much better than nothing). You're not the first one to suggest it ...
I agree, it would be very useful. Marc, would it be possible to
Marko Karppinen writes:
I'm not aware of any Darwin-specific workarounds in the tree
right now; the only thing close to that is the support for Apple's
two-level namespaces feature. And while you can argue the relative
merits of Apple's approach, the reason for its existence isn't
sloppiness
On Tue, 14 Oct 2003, Rod Taylor wrote:
I wouldn't want the whole diff on the mail, but a link to the relevant
diffs in cvsweb would be most useful (one for each changed file -- not ideal,
but much better than nothing). You're not the first one to suggest it ...
I agree, it would be
Bruce Momjian writes:
Let me be clear on this --- your tools is not part of the PostgreSQL
community. We are not required to allow any of this functionality
unless the community decides they want it. The major argument for
keeping it, in my mind, is to be helpful to Red Hat.
My current
Peter Eisentraut wrote:
Bruce Momjian writes:
Let me be clear on this --- your tools is not part of the PostgreSQL
community. We are not required to allow any of this functionality
unless the community decides they want it. The major argument for
keeping it, in my mind, is to be
Bruce Momjian [EMAIL PROTECTED] writes:
Peter Eisentraut wrote:
I'm beginning to think that we should scrap it and start with a real
design for 7.5. I know that's radical, but I don't think we're going to
arrive at anything that anyone's going to like by the time we want to
release.
The
I did the es translation of pg_dump and while looking at the code I
found that in several places the char * representation of Oid's is
used instead of the oid itself. Any one knows why is done this
way?
Regards,
Manuel.
---(end of broadcast)---
TIP
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Peter Eisentraut wrote:
I'm beginning to think that we should scrap it and start with a real
design for 7.5. I know that's radical, but I don't think we're going to
arrive at anything that anyone's going to like by the time we want
There is no backward link from a heap tuple to it's index entries. So if
you have 3 indexes on a table and do an update, you need at least 2 more
index lookups just to set that bit, if you somehow manage to remember by
what index you found this heap tuple in the first place.
On update-heavy
Srikanth,
HACKERS and DOCS are not the appropriate mailing lists for your request. If
you need follow-up help, please join NOVICE or GENERAL.
I am an Oracle DBA having 4 +years of experience and want to
migrate to postgreSQL .
Please kindly Assist me for Documents to convert Oracle
Marko Karppinen [EMAIL PROTECTED] writes:
At least the --fast-math part causes problems, seeing that PostgreSQL
actually checks for the __FAST_MATH__ macro to make sure that it isn't
turned on. There might be other problems with Apple's flags, but I
think that the __FAST_MATH__ check should
James Rogers [EMAIL PROTECTED] writes:
Someone from Oracle is on there explaining what Oracle's needs are. Perhaps
someone more knowledgable than myself could explain what would most help
postgres in this area.
There is an important difference between Oracle and Postgres that makes
Bruce Momjian [EMAIL PROTECTED] writes:
... Will Red Hat be upset if we
leave it unchanged for 7.4.X and rip this out and redo it in 7.5?
It'd be better if we could get it right the first time, with the
understanding that the output format is not very negotiable at this
late hour. But as best
Manuel Sugawara [EMAIL PROTECTED] writes:
I did the es translation of pg_dump and while looking at the code I
found that in several places the char * representation of Oid's is
used instead of the oid itself. Any one knows why is done this
way?
AFAIR pg_dump invariably stores OIDs as strings
71 matches
Mail list logo