2004-10-17 05:00:00
2004-11-17 06:00:00
> If this is true, then perhaps forbid timezone abbreviation in input
> string, or emit warning about this?
Maybe a warning that the specified timezone wouldn't be in effect
on the given date?
--
Michael Fuhr
http://www.fuhr.org/~m
27;s suggestion for a shared lock on the foreign key, but as far
as I can tell, no such solution has been implemented as of 8.0.0beta3.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
TIP 6: Have you searched
to
take advantage of 8.0.0's savepoints (e.g., an application might
want to know if a foreign key constraint has been violated so it
can roll back only the offending statement).
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
transactions could acquire it at the same time without blocking.
Then all transactions could read the foreign key record, but no
transaction could modify it until the other transactions completed
and released their locks.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of b
cks shared so these kinds of hacks arent necessary, unfortunately
> I have to make do with the present state of things.
Your hack might not be as effective as you'd like -- have you done
any tests with it? Until a shared lock is implemented, you might
be stuck with the way things are.
> SELECT * FROM information_schema.applicable_roles
What version of PostgreSQL are you using? Are you sure the current
user belongs to any groups? What's the output of the following
queries?
SELECT current_user;
SELECT usename, usesysid FROM pg_user WHERE usename = current_user;
SELECT * FROM pg_group;
2.396357);
haversine
--
147.614987754694
That's more like the true distance in miles between Portland and
Seattle
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
TIP 8: explain analyze is your friend
nd and Seattle is around 150mi.
> Also, do not forget that it is the line distance not the driving distance.
I doubt anybody thought that earth_distance() was calculating driving
distance. How would it know what route to follow without an extensive
road database and a route specification?
--
Mich
other half it works.
By "half" do you mean exactly 50% of the time, or are you approximating?
Can you identify anything common to the successful transactions that's
different from the failed transactions?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(en
ERROR: parser: parse error at or near "[" at character 24
What version of PostgreSQL are you running? According to the Release
Notes, array constructors and array_to_string() were added in 7.4.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)
On Tue, Oct 05, 2004 at 02:39:13PM +0200, Harald Fuchs wrote:
> I think we don't need the randomness provided by /dev/[u]random. How
> about XORing in getpid?
What about making the seeding mechanism and perhaps random()'s
behavior configurable?
--
Michael Fuhr
http://www
On Tue, Oct 05, 2004 at 07:23:32AM -0600, Michael Fuhr wrote:
> On Tue, Oct 05, 2004 at 02:39:13PM +0200, Harald Fuchs wrote:
>
> > I think we don't need the randomness provided by /dev/[u]random. How
> > about XORing in getpid?
>
> What about making the seeding mec
stall-all-headers" while installing to install
> the server-side headers there.
BTW, did this just change in 8.0? The latest CVS sources no longer
have an install-all-headers target (GNUmakefile.in 1.41); it looks
like the install target installs all headers now
1301 - 1313 of 1313 matches
Mail list logo
