NOTE: I posted this in novices also, but I have not seen it posted so I
thought I'd put it up here too.
I've had pgsql working in the past, but can't get it working now.
In order to get this thing working, there are a few basic things I don't
fully understand.
I'm running an 7.0.2 RMP on RH6.2.
If he wants to restrict access to certains rows, he could create views on
those tables containing only the desired rows and then grant access in that
view to the correspondent user. Of course, he would have to create a view to
each user, but that would be no worse than manually grant/revoke access
I have written the following function but when I try to run it, I get Error:
ERROR: parser: parse error at or near "". As you can see, there is no
instance of "" in my function. Does anyone have any idea why this is
happening?
CREATE FUNCTION dropifexists(text)
RETURNS text
AS 'DECLARE
numcou
Hi all,
If anybody has a minute or two, can they please email me the startup
script they use on their system to automatically start PostgreSQL when
the system boots?
I have a Linux Mandrake 7.2 startup script for PostgreSQL 7.0.3 on the
techdocs.postgresql.org site, and I'm looking for startup s
will trillich <[EMAIL PROTECTED]> writes:
> HOW do you find out if your postgresql (mine's 7.0.3) can support
> the plperl.so feature? And HOW do you go about installing it, if
> it does? What parts are necessary?
See
http://www.postgresql.org/devel-corner/docs/postgres/plperl.html
These are 7.1
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > Should I leave postgres tuning alone and let Linux use all of the memory
> > for buffer caching?
>
> You shouldn't try to make Postgres consume *all* of memory for buffers;
> for one thing, if the shmem region is too large then (at least on some
>
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Should I leave postgres tuning alone and let Linux use all of the memory
> for buffer caching?
You shouldn't try to make Postgres consume *all* of memory for buffers;
for one thing, if the shmem region is too large then (at least on some
Unixen, not s
On Sat, Mar 31, 2001 at 12:17:46AM -0600, will trillich wrote:
> On Fri, Mar 30, 2001 at 06:34:45PM -0800, Eric G. Miller wrote:
> > On Fri, Mar 30, 2001 at 06:40:13PM -0600, will trillich wrote:
> > > even using PLPGSQL, is it possible to send VARYING relation
> > > tuples to a procedure/function
At 11:01 AM 3/31/01 -0400, Matthew Rice wrote:
>Hi guys,
>
>I'm looking for some advice from someone that has probably done this before.
>I have a server this is connected to by various client programs (CLI and Web
>Interface for now).
>The problem now is how to do record locking when updating in
Have you tried drop sequence?
On Sat, 31 Mar 2001, Jeff wrote:
> Hi,
>
> I've accidently deleted the file employees.key.seq, however there's still an
> entry in pg_class.
>
> It would not allow me to create employees.key.seq anymore because it thinks
> it already exists.
>
> How can I delete it
Hi,
I've accidently deleted the file employees.key.seq, however there's still an
entry in pg_class.
It would not allow me to create employees.key.seq anymore because it thinks
it already exists.
How can I delete it from pg_class?
Thanks
---(end of broadcast)-
On Sat, Mar 31, 2001 at 10:31:36AM +0200, Peter Eisentraut wrote:
> > what i want is for the pg_shadow file to contain encrypted passwords like
> > /etc/passwd, and for the server to encrypt the plain text password handed
> > to it and compare with the crypto-gunge in pg_shadow.
>
> This is not p
Hi guys,
I'm looking for some advice from someone that has probably done this before.
I have a server this is connected to by various client programs (CLI and Web
Interface for now).
This server is about to have a concept of users as far as the client/server
part goes but the server connects to
Pluto wrote:
> Can PostgreSQL, MySQL or other database programs can allow some user to
> access some specific data while other data is prohibited to them in a
> same database? If so, how to implement that? For instance, a client can
Check the GRANT and REVOKE commands. This will give you table-le
Jim Mercer writes:
> i seem to recall setting this up before, but now i can't seem to
> get passwords working the way i want.
>
> i'm running 7.0.3 on FreeBSD 4.3-RC.
>
> i've set the entry in pg_hba.conf to both "crypt" and "password".
>
> i've used "ALTER USER pgsql WITH PASSWORD 'test';
>
> re
15 matches
Mail list logo
