Tom Lane a écrit :
> Richard Bayet <[EMAIL PROTECTED]> writes:
> > And the problem is that they can't add any language support with
> > createlang.
> > Anytime they tried (for example '$>createlang plpgsql theirdb'), the
> > program seemed to "freeze" on authentification ...
> > They got a :
>
Richard Bayet <[EMAIL PROTECTED]> writes:
> Thanks a lot Tom, that do solves the first part of my problem...
> Has anyone an idea about the second part, that is, one the
> authentification passed, this error message:
> "$>createlang plpgsql theirdb
> createlang: A function named 'plpgsql_call_hand
Hi PG-Admins,
I think this question is asked more often than you'd like it to be
so excuse me ...
Is there any possibility to restrict database-access user based?
When I create a user without the permission to create databases this
user has access to all available databases on the syste
snef wrote:
> Hi,
> I have read the man's with Postgres.
> But I can't seem to get Postgres use European time notation (dd/mm/).
>
> Where can I adjust this? (in which file?)
>
> Snef
SET DATESTYLE TO 'SQL, EUROPEAN';
SELECT NOW();
It looks like it is fixed in the current sources. He probably had an
old version.
Bruce Momjian wrote:
>
> We have had a number of fixes in the 7.1 beta JDBC driver. Would you test
> that and let us know if it is still broken. You can get the JAR file
> from the JDBC website at http://www.ret
I would like to see some restrictions on who can or
who can not create things in a database too.
Hoping too see this soon
Rumen
--- Markus Wigge <[EMAIL PROTECTED]> wrote:
> Hi PG-Admins,
>
> I think this question is asked more often than
> you'd like it to be
> so excuse me ...
> Is
I think there's one possible solution, though I haven't fully tried it and
the administration can become rather bothersome and even complicated, but
here goes.
I did some testing by modifying the pg_hba.conf file, specifying which
database may be access from which IP address, and it worked, thoug
Hallo Alfonso,
AP> As I said before:
AP> 1.- If you have several connections from diferent machines this method
AP> could become rather complicated, but it's an idea.
AP> 2.- I haven't fully tested it.
This won't work for me becaus all connections come from the same
machine and it hosts about 50
Here's the trick: I had to do a PostgreSQL install as a unix user.
That's mine the postmaster process is ran under my login name, and all
the database files belong to me.
And so, my login name under this system was added (i presume when i
launched initdb) in pg_user as a PostgreSQL superuser.
I co
Greetings,
I installed postgresql-7.0.3-2 from rpms on a new machine. The
postgresql-server installation gave me the following:
root@www148 /home/deckard/databases> rpm -ivh
postgresql-server-7.0.3-2.i386.rpm
postgresql-server ##
/sbin/ldc
You have set in your pgsql ODBC driver to open databases in readonly
mode. You should change it to do the 'forward engineer'.
Nelio
Niral Trivedi wrote:
>
> All,
>
> Thank you all for your response to my previous post. And You were right. I
> had now our postgreSQL started with -i option and I
Max Pyziur wrote:
> postgresql-server ##
> /sbin/ldconfig: warning: can't open var/tmp/rpm-tmp.4657 (Not a directory),skipping
> /sbin/ldconfig: warning: can't open 1 (No such file or directory), skipping
> The server starts up properly, ho
12 matches
Mail list logo
