c k wrote:
> I got following error while testing some newly created functions.
>
>
> ERROR: cache lookup failed for function 111462
> CONTEXT: PL/pgSQL function "uf_postdoc" line 25 at FOR over
> SELECT rows
>
> ** Error **
>
> ERROR: cache lookup failed for function 111462
>
Dear Team
First of all I would like to thank you to provide a spatial database fro GIS
developers and user. But I have doubt in the usage. I have created a few
databases (i.e. X, Y, Z) in a default Server and I also created a user (i.e.
Us). Now what I want is to set privilege that whenever th
> BTW, I'd encourage you to start a page on the wiki site to track the specific
> issues you run into, and specific fixes your using. Would certainly be
> helpful to others and probably yourself as a reference on the topic.
I've started a page as you suggested which at the moment contains only
>>> Shashwat_Nigam <[EMAIL PROTECTED]> wrote:
> Now what I want is to set privilege that whenever the user log in as
Us
> he can only see database Y, none other than that. The user Us could
have all
> rights for database Y but can't go for any other database (X or Z).
The first thing you ne
I have a text field which I use to store names ( lastname, firstname )
and suppose we have the following 3 authors in the field:
ta, a
ta, z
tab, a
I would expect them to show up in the order shown above when I select
this field and order it by it, but instead I get:
ta, a
tab, a
> I have a text field which I use to store names ( lastname,
> firstname )
> and suppose we have the following 3 authors in the field:
>ta, a
>ta, z
>tab, a
>
> I would expect them to show up in the order shown above
> when I select
> this field and order it by it, but instead I get:
>
Select name from info order by name;
-Original Message-
From: Lennin Caro [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2008 4:26 PM
To: pgsql-admin@postgresql.org; Blanco, Jose
Subject: Re: [ADMIN] Ordering not acting right.
> I have a text field which I use to store names ( l
On Wed, Aug 20, 2008 at 1:48 PM, Blanco, Jose <[EMAIL PROTECTED]> wrote:
> I have a text field which I use to store names ( lastname, firstname )
> and suppose we have the following 3 authors in the field:
> ta, a
> ta, z
> tab, a
>
> I would expect them to show up in the order shown above wh
>
> > I have a text field which I use to store names (
> lastname, firstname )
>
> > and suppose we have the following 3 authors in the
> field:
> >ta, a
> >ta, z
> >tab, a
> >
> > I would expect them to show up in the order shown
> above when I select
> > this field and order it by
Hi, I am new to this list sorry for asking such a lame question. I
tried searching but did not find the answer i was looking for.
I am running postgresql-8.2.4 on rhel5. Do I need the files in pg_log?
When I look at one of the files, it shows INSERT, UPDATE and SELECT
statements. Reason I asked is
pg_log isn't a standard postgres dir,
so maybe it's where RHEL stores the
actual textual log files that the
server process generated.
Indeed this is suggested here:
http://www.nabble.com/-GENERAL--pg_log-missing-td7753209.html
So if these files look something like:
2008-08-03 00:30:47 CEST LOG:
Thanks, they do look like the lines you have below. I have separate
pg_xlog and pg_clog folders. i'll check the statement logging config,
is this the same as transaction logging?
On Wed, Aug 20, 2008 at 5:02 PM, Thomas Jacob <[EMAIL PROTECTED]> wrote:
> pg_log isn't a standard postgres dir,
> so m
"slamp slamp" <[EMAIL PROTECTED]> writes:
> I am running postgresql-8.2.4 on rhel5. Do I need the files in pg_log?
> When I look at one of the files, it shows INSERT, UPDATE and SELECT
> statements. Reason I asked is because the folder is about 40GB. It is
> half the size of my /var/lib/pgsql direc
13 matches
Mail list logo
