David Garamond wrote:
Robert Treat wrote:
Given that the cygwin version is currently labeled as not ready for
production I would say you are right. The truth is that many will never
declare win32 good for production simply because of the OS it runs on,
but we still want to make it as solid as
Neil Conway [EMAIL PROTECTED] writes:
With current sources, it appears that vpath builds (i.e. separate source
and build trees) are broken. make succeeds, but make install produces:
I can't take the time right now to test it, but try changing
TZDATAFILES := $(TZDATA:%=data/%)
to
TZDATAFILES :=
I get this since Tom's commit.
Chris
--- ./results/horology.out Sun May 23 11:39:49 2004
***
*** 1787,1796
| Wed Mar 15 13:14:02 2000 PST | @ 34 years| Tue Mar 15
13:14:02 1966 PST
| Sun Dec 31 17:32:01 2000 PST | @ 34 years
Does the following zero-column behavior strike anyone else as being a
little strange? I can take a look at fixing this, I'm just curious if
there's a consensus that the status quo isn't optimal.
(1)
neilc=# create table zero_col ();
CREATE TABLE
neilc=# select * from zero_col;
--
(0 rows)
--
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Anyone thought about this at all yet?
It seems to me that we shouldn't copy them, but I'm having a hard time
putting a finger on why exactly. I guess it goes along with the fact
that we don't copy the database's owner, and any per-database
It seems to me that we shouldn't copy them, but I'm having a hard time
putting a finger on why exactly. I guess it goes along with the fact
that we don't copy the database's owner, and any per-database variable
settings seem to me to be the database owner's decision to make.
Good points. The
Hi guys,
The latest thing we've noticed in the IRC channel and the phpPgAdmin
lists is that people want to be able to grant on all objects in a
database, etc:
grant select on all tables to blah;
or even:
grant rule on all views in schema myschema to blah;
This seriously is asked every other day
We could perhaps do something similar to the Apache 1.3 win platform
notes, where they (still) say *something* like :
Apache on windows is not as stable as on unix... but is being actively
improved all the time
This is a bit more positive than it's dangerous!.
As for people not reading the
Hi all,
Disclaimer: I'm not a C programmer and my knowledge of locales is
limited. I use Python.
PostgreSQL does not correctly use upper() and lower() for Unicode
characters. I've read the bug reports and followups at
archive.postgresql.org.
I'd like to propose two ideas:
1) Python has
Here are the two syntaxes we can use for turning off clustering:
1) ALTER TABLE / SET WITHOUT CLUSTER
This will turn off clusting on any index on the table that has it
enabled. It won't recurse so as to match the CLUSTER ON syntax.
However, this form makes the non-standardy SET WITHOUT form
On 05/21/04:20/5, Tom Lane wrote:
Hm. I do not think you can use an expression context callback for this
anyway, because the callback won't be called in the case that query
execution is abandoned due to an error.
What you'd need for something like that is a global data structure that
is
Neil Conway [EMAIL PROTECTED] writes:
Does the following zero-column behavior strike anyone else as being a
little strange? I can take a look at fixing this, I'm just curious if
there's a consensus that the status quo isn't optimal.
I think that psql's table-pretty-printing logic gets
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
I get this since Tom's commit.
On what platform? How is type time_t defined on your platform?
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through
On Sun, May 23, 2004 at 12:00:29 +0800,
Christopher Kings-Lynne [EMAIL PROTECTED] wrote:
Hi guys,
The latest thing we've noticed in the IRC channel and the phpPgAdmin
lists is that people want to be able to grant on all objects in a
database, etc:
The right way to do this is to make
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
2) ALTER TABLE / DROP CLUSTER ON idx
I like this form, however to make it work, we need to bump CLUSTER to
being a reserved keyword.
I do not think this form is enough better than the other to justify
creating a nonstandard fully-reserved
Milos Prudek [EMAIL PROTECTED] writes:
PostgreSQL does not correctly use upper() and lower() for Unicode
characters.
This is already fixed in CVS tip.
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched
Bruno Wolff III [EMAIL PROTECTED] writes:
Christopher Kings-Lynne [EMAIL PROTECTED] wrote:
... people want to be able to grant on all objects in a
database, etc:
The right way to do this is to make sure there is a group that has access
to everything and just add people to the group.
This is already fixed in CVS tip.
Oh, cool!
I know what is a CVS, but what is CVS tip?
In which PostgreSQL stable release is upper() and lower() for Unicode
planned to be included? Postgres version 7.5 ?
--
Milos Prudek
---(end of broadcast)---
On Sat, 2004-05-22 at 23:44, Mark Kirkwood wrote:
We could perhaps do something similar to the Apache 1.3 win platform
notes, where they (still) say *something* like :
Apache on windows is not as stable as on unix... but is being actively
improved all the time
This is a bit more
Hi,
On Thu, 6 May 2004, Tom Lane wrote:
We're sort of halfway there on coping with the Turkish-locale i-vs-I
problem. I'd like to finish the job for 7.5.
Cool!
snip
AFAICS the remaining problem is that there are a bunch of places that
use strcasecmp() or strncasecmp() to match inputs
Matthew T. O'Connor [EMAIL PROTECTED] writes:
There will always be people who won't read the notes, or ignore the
notes,
Does anyone want to contemplate hacking things so that the Windows port
reports a different version number? 0.1 might give people the right
sort of impression about what we
Devrim GUNDUZ [EMAIL PROTECTED] writes:
On Thu, 6 May 2004, Tom Lane wrote:
What I'm thinking of doing is inventing pg_strcasecmp and
pg_strncasecmp that act like the above and replacing all calls of the
standard library functions with these.
If you can post all the patches you'd like to
Hi,
On Sun, 23 May 2004, Tom Lane wrote:
pg_strncasecmp that act like the above and replacing all calls of the
standard library functions with these.
If you can post all the patches you'd like to apply, I'd be happy to test
them. (Sorry for the very late response, btw.)
The
Bruno Wolff III [EMAIL PROTECTED] writes:
Christopher Kings-Lynne [EMAIL PROTECTED] wrote:
... people want to be able to grant on all objects in a
database, etc:
For things like this I use simple,
but super-powerful eval function:
CREATE OR REPLACE FUNCTION eval(text)
RETURNS int4
I'm looking at the new timezone support.
First I initdb'd without TZ set. So every time I start the server I get
LOG: could not recognize system timezone, defaulting to Etc/GMT-4
HINT: You can specify the correct timezone in postgresql.conf.
Obviously the setup is wrong because DST doesn't
Devrim GUNDUZ [EMAIL PROTECTED] writes:
However, we still fail to sort small I (i dotless) and i. i dotless
comes before i in Turkish Alphabet, but ORDER BY sorts i before i
dotless.
For that, you have to complain to your locale's designer. We just do
what strcoll tells us to.
Alvaro Herrera [EMAIL PROTECTED] writes:
First I initdb'd without TZ set. So every time I start the server I get
LOG: could not recognize system timezone, defaulting to Etc/GMT-4
HINT: You can specify the correct timezone in postgresql.conf.
So what is your system timezone anyway (and
I am back from camping and will be reading my email during the next few
hours.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.
On Sat, May 15, 2004 at 02:08:39PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Regarding the lock mechanism, I simply added some code to LockReleaseAll
so it gets the array of committed child Xids; on subtransaction abort,
the whole lock struct is scanned just like it's
On Sun, May 23, 2004 at 04:58:29PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
First I initdb'd without TZ set. So every time I start the server I get
LOG: could not recognize system timezone, defaulting to Etc/GMT-4
HINT: You can specify the correct timezone in
Alvaro Herrera [EMAIL PROTECTED] writes:
First I initdb'd without TZ set. So every time I start the server I get
LOG: could not recognize system timezone, defaulting to Etc/GMT-4
HINT: You can specify the correct timezone in postgresql.conf.
I've fixed the minor issue here, which is that
On Sun, 23 May 2004, Tom Lane wrote:
Matthew T. O'Connor [EMAIL PROTECTED] writes:
There will always be people who won't read the notes, or ignore the
notes,
Does anyone want to contemplate hacking things so that the Windows port
reports a different version number? 0.1 might give people
I get this since Tom's commit.
On what platform? How is type time_t defined on your platform?
Hmmm, I just CVS up'd and all regression tests now pass...
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Matthew T. O'Connor wrote:
This weekend
Matthew T. O'Connor wrote:
This weekend I am trying to fix up all known the pg_autovacuum issues
that should be resolved for 7.4.3. I am aware of only two issues: temp
table issues, and unchecked send_query() calls, if I am forgetting
something, please let me know.
1) temp table issue:
Milos Prudek wrote:
This is already fixed in CVS tip.
Oh, cool!
I know what is a CVS, but what is CVS tip?
In which PostgreSQL stable release is upper() and lower() for Unicode
planned to be included? Postgres version 7.5 ?
CVS tip is jus the current version of all CVS files. It
Added to TODO:
* Allow GRANT/REVOKE permissions to be given to all schema
objects with one command
---
Tom Lane wrote:
Bruno Wolff III [EMAIL PROTECTED] writes:
Christopher Kings-Lynne [EMAIL
On Thu, May 13, 2004 at 09:43:42AM -0400, Tom Lane wrote:
BTW, what are your plans for state saving/reversion for the lock manager
and buffer manager?
Ok, I have skimmed through the buffer manager code. At first I thought
I'd have to set something up in shared memory for this, but then I
38 matches
Mail list logo