[EMAIL PROTECTED] (Jakub) writes:
> I need to retrieve the name of the function and the index column names
> of the functional index. The system information about the
> index(function and its args) is stored in the system catalog column
> pg_index.indexprs.
As of 7.4, this is a requirement badly i
On Mon, Jan 05, 2004 at 11:32:42 +0500,
Michael Gill <[EMAIL PROTECTED]> wrote:
>
> I think I have found the simple solution by separating the user from the
> owner of the tables, however!
>
> I have simply created tables and functions in the owner's schema(A),
> then granted execution to the
> Anything other than simple, short commands is a waste, IMHO. I can easily
> remember SHOW DATABASES and SHOW TABLES and DESC , because they
> reflect
> my intensions directly and 'make sense'.
Can you remember how to get a list of indexes on a particular table? How
about a specific indexes bui
Andrew Dunstan wrote:
Michael Gill said:
Hello,
I've tried asking this question elsewhere and have not received a
satisfactory response.
I want to restrict users of my packaged database from directly
accessing the data or reading the schema. I would provide access to
the read-on
Hi,
I need to retrieve the name of the function and the index column names
of the functional index. The system information about the
index(function and its args) is stored in the system catalog column
pg_index.indexprs. Do I have to parse pg_index.indexprs text or
pg_get_indexdef(pg_index.indexreli
Alex J. Avriette wrote:
On Sat, Jan 03, 2004 at 08:25:21PM -0500, Bruce Momjian wrote:
I finally figure it out, I just end up forgetting again later. I still
have no clue how I'd find the same data without using psql. In MySQL
I can run those queries from PHP, PERL...etc. I know you can find
I think moving the \d and simliar features in psql
to SQL is a good idea. That will make the features
available in any client library. As for the syntax,
maybe a investigation is needed.
---(end of broadcast)---
TIP 6: Have you searched our list ar
Hi,
Could you please tell how the "did you mean " feature
was implemented when the serach term has a typo.
The search engine is good .
Regds
mallah.
Oleg Bartunov wrote:
Hi there,
I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Curren
Neil Conway <[EMAIL PROTECTED]> writes:
> - to modify a BufferDesc's meta data (shared refcount, flags, tag,
> etc.), one must hold the buffer's "meta data lock". Also, I
> removed the existing "io_in_progress" lock; instead, we now hold
> the buffer's meta data lock while doi
Thanks to everyone that provided input about this idea. After taking
everything into consideration and talking with Olly Betts from the
Xapian project, what I'm going to do is implement a btree that supports
multiple roots and an "tag" value of arbitrary length for each item in
the tree. Then
Hi all,
After unsuccessfully trying to join the current OLE DB project on gborg,
I'm writing my own. So far I don't have anything too fancy (just trying
to get over the initial shock of what OLE DB actually is). It currently
does the basic infrastructure, but does not yet actually connect to
P
Greeting,
This is mainly just a heads up, I'm going to be recompiling with
symbols and rerunning the test after I get to work, but I'm getting a
segfault consistantly when doing a vacuum analyze. The trace is from
7.4.1 but I upgraded to 7.4.1 because the same was happening under
7.3.4.
12 matches
Mail list logo
