On Fri, Dec 26, 2003 at 22:19:52 -0700,
Michael Fuhr <[EMAIL PROTECTED]> wrote:
>
> Incidentally, I see the following in README.earthdistance:
>
> A note on testing C extensions - it seems not enough to drop a function
> and re-create it - if I change a function, I have to stop and restart
Definition of log (base n) is that log n(x) = y where n^y = x for all values
of x and y. n is the base.
So a base 10 log would be reversed by doing 10^x=y. If we know x, we use
the exponential operation; if we know y we use log(y) = x. For ln (natural
logs, base e, e is approx. 2.818), use e^x=
On December 26, 2003 06:37 pm, Tom Lane wrote:
> accumulated roundoff in the monetary amounts. I think you will
> need to write a little function (in plpgsql or your language of
> choice) that performs the sequence of compounding steps, if you
> want to get an answer that a banker will like.
And
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm tyring to create a new table/database/user; and I get some errors.
I'm running:
[EMAIL PROTECTED]:template1=# SELECT version();
version
Devrim GUNDUZ (Saturday 27 December 2003 10:12)
> create_date timestamp NOT NULL DEFAULT 'NOW',
> change_date timestamp NOT NULL DEFAULT 'NOW',
Do these actually work? I've always used 'default now()'...
> And I get:
>
> NOTICE: CREATE TABLE will create implicit sequence "tdmalias_mid_seq"
Thanks All for your suggestions, I have enough information to construct
what I need.
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Friday, December 26, 2003 8:43 PM
To: Andy Lewis
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Radius of a zip code
On Fri, Dec 26, 2003
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 27 Dec 2003, Casey Allen Shobe wrote:
> > ERROR: permission denied for schema pg_catalog
>
> The user you create the user as needs to have createuser permission.
> alter user "foo" with createuser;
>
> ...(run as an appropriate user
Devrim GUNDUZ (Saturday 27 December 2003 10:45)
> > > ERROR: permission denied for schema pg_catalog
> >
> > The user you create the user as needs to have createuser permission.
> > alter user "foo" with createuser;
> >
> > ...(run as an appropriate user) will grant the user such permission.
>
> H
Devrim GUNDUZ (Saturday 27 December 2003 10:45)
> But I still could not understand why the lack of createuser permission
> caused the error above...
Though I do think a more clear error in this case would be helpful (*hint
hint*).
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
[EMAI
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Michael Fuhr <[EMAIL PROTECTED]> wrote:
>> Maybe you've already figured it out, but LOAD should allow you to reload
>> a .so file without having to restart the backend.
> I didn't write that. It came from the person(s) who worked on earthdistance
> b
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> And I get:
> NOTICE: CREATE TABLE will create implicit sequence "tdmalias_mid_seq" for
> "serial" column "tdmalias.mid"
> ERROR: permission denied for schema pg_catalog
I can't replicate that here: I get
NOTICE: CREATE TABLE will create implicit seq
Casey Allen Shobe <[EMAIL PROTECTED]> writes:
> Devrim GUNDUZ (Saturday 27 December 2003 10:45)
>> Hmm, that solved the problem, thanks.
>>
>> But I still could not understand why the lack of createuser permission
>> caused the error above...
> Because database users (and lots of other database i
Saturday 27 December 2003 13:50
> This analysis is nonsense ... system catalog operations do not do the
> same kinds of permission checks as user queries do. Furthermore, if
> he'd not had permissions to create users, the initial CREATE USER
> command would have failed, and so would CREATE DATABAS
Casey Allen Shobe <[EMAIL PROTECTED]> writes:
>> My guess is that Devrim interpreted your suggestion as telling him to
>> make the created user (tdmsoftmailserveruser) a superuser, which would
>> naturally suppress any and all permissions failures for operations
>> executed by that user.
> That is
14 matches
Mail list logo
