> [ shrug... ] This is just a variant of the choose-a-new-function-name
> game. If we are going to choose a new function name, choosing one that
> collides with an existing name (obsolete or not) doesn't seem like a
> win to me. You could just as well choose another name, and avoid
> angering wh
Brendan Jurd <[EMAIL PROTECTED]> writes:
> If the current implementation of timenow() is truly obsolete, would it
> be verboten to change its return type? We could rewrite the function
> to return timestamp, for example.
[ shrug... ] This is just a variant of the choose-a-new-function-name
game.
> I'd be interested to see how you do that, considering that abstime
> can't store fractional seconds. timenow() is even more obsolete than
> timeofday() --- AFAICS it's not documented at all, anywhere. The whole
> abstime datatype is obsolete, actually, and will have to go away
> sometime before
Brendan Jurd <[EMAIL PROTECTED]> writes:
> Does anybody know why this function returns text? The documentation
> cites "historical reasons". Are any of those historical reasons still
> relevant?
Backwards compatibility --- changing the result datatype would
surely break some applications. I'm a
On 8/7/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Brendan Jurd <[EMAIL PROTECTED]> writes:
> > Are there any good reasons why the output of timeofday() needs to
> > include the three letter day-of-week?
>
> If we are going to change it, I'd be inclined to make it output the
> canonical ISO format (
Bruce Momjian writes:
> Mike Mascari wrote:
>> How long has a partial index implementation been in PostgreSQL?
> We have had partial indexes since the Berkeley days, per-1996, but we
> have improved them quite a bit.
We inherited code for the feature from Berkeley, but it was broken for
some con
Brendan Jurd <[EMAIL PROTECTED]> writes:
> Are there any good reasons why the output of timeofday() needs to
> include the three letter day-of-week?
If we are going to change it, I'd be inclined to make it output the
canonical ISO format (-MM-DD HH:MM:SS.-TZ). Or perhaps the
format should
Here we go ... line 498 of backend/utils/adt/datetime.c:
/* Used for SET australian_timezones to override North American ones */
static datetkn australian_datetktbl[] = {
{"acst", TZ, POS(38)}, /* Cent. Australia */
{"cst", TZ, POS(42)}, /* Australia Central Std
On 8/7/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sun, Aug 07, 2005 at 12:05:43PM +1000, Brendan Jurd wrote:
> > => select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
> > ERROR: 22007: invalid input syntax for type timestamp: "Sat Aug 06
> > 12:00:43.668919 2005 EST"
>
> What are your
Mike Mascari wrote:
> I find this Q & A a bit amusing:
>
> http://www.sigmod.org/sigmod/record/issues/0506/p71-column-winslet.pdf
>
>
>
> Q. If you magically had enough extra time to do one additional thing at
> work that you're not doing now, what would it be?
>
> A. I think I would work
On Sun, Aug 07, 2005 at 12:05:43PM +1000, Brendan Jurd wrote:
> => select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
> ERROR: 22007: invalid input syntax for type timestamp: "Sat Aug 06
> 12:00:43.668919 2005 EST"
What are your timezone and australian_timezones settings? I can
duplicate t
On 8/7/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sat, Aug 06, 2005 at 10:06:35AM -0400, Tom Lane wrote:
> > Can anyone else duplicate the problem?
>
> I couldn't duplicate the problem in 8.0.2 or in any other version
> from 7.2.8 through HEAD (latest CVS for all).
>
> Brendan, if you execu
Thanks ,
Would seem there is no problem eith cpanel + postgresql.
thanks for the link to a2hosting I will look them up.
John DeSoi wrote:
On Aug 4, 2005, at 10:28 PM, Richard Sydney-Smith wrote:
I have asked my internet host to include postgresql as part of their
service but it seems tha
I find this Q & A a bit amusing:
http://www.sigmod.org/sigmod/record/issues/0506/p71-column-winslet.pdf
Q. If you magically had enough extra time to do one additional thing at
work that you're not doing now, what would it be?
A. I think I would work on indexing a little harder.
Q. What
William Bug wrote:
> Hi All,
>
> Sorry to bring up the topic of PostgreSQL inheritance again, but after
> going through the archives and Google results, I still don't have a
> clear sense of whether my plan to implement a schema I'm working on is
> the preferred way to go.
>
> First, I'd like
On Sat, Aug 06, 2005 at 10:06:35AM -0400, Tom Lane wrote:
> Can anyone else duplicate the problem?
I couldn't duplicate the problem in 8.0.2 or in any other version
from 7.2.8 through HEAD (latest CVS for all).
Brendan, if you execute "\set VERBOSITY verbose" in psql and then
generate the errors,
OK.thanks...I suppose I don't need it.
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>;
Sent: Saturday, August 06, 2005 9:55 PM
Subject: RE: [GENERAL] tables in public
Could you, please, give me short description of
functional
> Could you, please, give me short description of
> functionalities of those modules?
tsearch2 is full text indexing. postgis is geographical functionality.
//Magnus
---(end of broadcast)---
TIP 5: don't forget to increase your free space map set
Could you, please, give me short description of functionalities of those
modules?
I don't know whether I need it, because I don't know what is the purpose of
those tables...
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>;
Sen
> Hello.
>
> Postgres automatically included some tables in my public domain:
> pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,
I beleive these are from tsearch2.
> spatial_ref_sys.
And this is postgis.
> I suppose it's because I switched on all additional options
> during initdb...
Yes
David Goodenough wrote:
> On Friday 05 August 2005 11:57, Martijn van Oosterhout wrote:
>
>>On Fri, Aug 05, 2005 at 10:08:42AM +0100, David Goodenough wrote:
>>
>>>I was looking at an application recently which was written in Java and
>>>used Postgresql as it DB. In it extensive use had been made
On Sat, Aug 06, 2005 at 12:38:50AM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > Your are correct in that 8.0 is doing a request first. I am running
> > Red Hat version 8.0. The difference in the way 7.2 and 8.0 resolve the
> > host option has to be because of the change from geth
Brendan Jurd <[EMAIL PROTECTED]> writes:
> On 8/6/05, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Brendan Jurd <[EMAIL PROTECTED]> writes:
>>> timeofday() returns text, and moreover it returns in a bizarre format
>>> which cannot be converted directly into any useful temporal types, at
>>> least not in
Richard Huxton said:
> You don't say what the limitations of Hibernate are. Usually you might
> look to:
> 1. Use COPY not INSERTs
Not an option, unfortunately.
> 2. If not, block INSERTS into BEGIN/COMMIT transactions of say 100-1000
We're using 50/commit...we can easily up this I suppose.
> 3
Hi all
Is there an LC_COLLATE setting, or any other method, which allows all data
in a database to be treated in a case-insensitive manner?
I have two scenarios in mind. There are workarounds for both of them, but it
would be nice if they were not necessary.
1. In a UNIQUE column, I would like a
On Aug 4, 2005, at 10:28 PM, Richard Sydney-Smith wrote:
I have asked my internet host to include postgresql as part of
their service but it seems that there are issues in getting it to
work with "cpanel" which is their support service for their
clients. Is their a reason why Postgresql is
On 8/6/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Brendan Jurd <[EMAIL PROTECTED]> writes:
> > timeofday() returns text, and moreover it returns in a bizarre format
> > which cannot be converted directly into any useful temporal types, at
> > least not in 8.0.2:
>
> Hm? Works fine for me. What da
Hello.
Postgres automatically included some tables in my
public domain:
pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,
spatial_ref_sys.
I suppose it's because I switched on all
additional options during initdb...
My question regarding those tables is wheter I
can delete them safely f
28 matches
Mail list logo
