On Wed, Aug 17, 2005 at 09:17:28 -0700,
[EMAIL PROTECTED] wrote:
> Which means everytime I create a new table or a new schema, I have to run
> the script again, right?
You will need to do something to grant access to the new object to whoever
is supposed to have access.
---
Which means everytime I create a new table or a new schema, I have to run the script again, right?
Thanks.
Oliver Elphick
08/17/2005 09:08 AM
Please respond to olly
To: Zuoxin Wang/CA/[EMAIL PROTECTED]
cc: [EMAIL PROTECTED], pgsql-admin@postgresql.o
Hi there,
I am running PostgreSQL Installer for Windows v.-8.0.3. It is giving
me the following error when I tried to add a new table:
"No buffer space available (maximum connections reached?)"
When I do an uninstall of postgresql-8.0.3 it seems not to fully
uninstall the software, how do I co
> Try starting a fresh backend session. Manual hacking of those tables
> isn't going to cause a relcache reload ...
>
Simply reconnecting to the backend does not help. If I restart the server
everything works as expected. I am wondering if there is a way to trigger a
relcache reload without sh
Craig Servin <[EMAIL PROTECTED]> writes:
> I am trying to make some foreign keys deferrable and initially deferred.
> These foreign key constraints already exist so I was going to change them by
> updating pg_trigger and pg_constraint.
> However the changes do not seem to take affect. Is there
On Wed, Aug 17, 2005 at 02:15:42PM -0400, D Kavan wrote:
>
> 'du -h' in the base directory.
>
> >How are you finding out the DB size?
You are considering the difference in XLog segment size, right? The
pg_xlog directory may start almost empty and then start filling. The
space will not be recov
I am trying to make some foreign keys deferrable and initially deferred.
These foreign key constraints already exist so I was going to change them by
updating pg_trigger and pg_constraint.
However the changes do not seem to take affect. Is there something I need to
do to get PostgreSQL to rec
'du -h' in the base directory.
How are you finding out the DB size?
G.-
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
You might want to try doing a reindexdb -a -e (reindexdb is in the
contrib directory of your pg source). The first time I ran this, I
gained back a significant amount of space.
I now run a vacuumdb -v -f -a and then a reindexdb -a -e every weekend
to have PostgreSQL give back as much space as it
CASE CLOSED!
Thanks for the tip on the reindex script. That did the trick. It was one
table in particuliar.
~DjK
From: Chris Hoover <[EMAIL PROTECTED]>
To: Guido Barosio <[EMAIL PROTECTED]>
CC: D Kavan <[EMAIL PROTECTED]>, pgsql-admin@postgresql.org
Subject: Re: [ADMIN] va
On Wed, Aug 17, 2005 at 08:14:02 -0700,
[EMAIL PROTECTED] wrote:
> Could you tell us what is the best way to grant a user who can select all
> data from all tables, if I don't like to write a script which Andrew
> memtioned earlier.
Other than some kind of script, you can make them a superuser
How are you finding out the DB size?
G.-
On 8/17/05, D Kavan <[EMAIL PROTECTED]> wrote:
Hi,Thanks for the tips.Unfortunatley for me, even after started doing vacuumdb -a 3 times a day
and increasing fsm dramatically , the size of the database won't go downeven 1 MB. It's stil at 5.6 GB, size a
D Kavan wrote:
Hi,
Thanks for the tips.
Unfortunatley for me, even after started doing vacuumdb -a 3 times a
day and increasing fsm dramatically , the size of the database won't go
down even 1 MB. It's stil at 5.6 GB, size after restore = 4 GB. I
even did a stop/start instead of a re-loa
On Wed, 2005-08-17 at 08:35 -0700, Andrew Gold wrote:
> Actually, I read the GRANT man page several times; what you state so
> clearly and simply, isn't described so plainly in that document.
>
> I posted because I found the GRANT man page deficient.
>
> Strictly speaking the GRANT man page indi
On Wed, 2005-08-17 at 08:14 -0700, [EMAIL PROTECTED] wrote:
>
> Could you tell us what is the best way to grant a user who can select
> all data from all tables, if I don't like to write a script which
> Andrew memtioned earlier.
Here's a quick way to generate a script and then run it, all from
On Wed, Aug 17, 2005 at 08:35:06AM -0700, Andrew Gold wrote:
> This followed a series of descriptions of various privileges (select,
> insert, update, etc.). From the context of the description, it appears
> that "GRANT ALL PRIVILEGES" bestows all of the preceding rights on the
> recipient user
Actually, I read the GRANT man page several times; what you state so
clearly and simply, isn't described so plainly in that document.
I posted because I found the GRANT man page deficient.
Strictly speaking the GRANT man page indicated the following:
-begin quote---
Could you tell us what is the best way to grant a user who can select all data from all tables, if I don't like to write a script which Andrew memtioned earlier.
Thanks.
Oliver Elphick
Sent by: [EMAIL PROTECTED]
08/16/2005 05:00 PM
Please respond to olly
To: Andre
Hi,
Thanks for the tips.
Unfortunatley for me, even after started doing vacuumdb -a 3 times a day
and increasing fsm dramatically , the size of the database won't go down
even 1 MB. It's stil at 5.6 GB, size after restore = 4 GB. I even did a
stop/start instead of a re-load to make sure t
-Original Message-
From: sandhya
[mailto:[EMAIL PROTECTED]
Sent: Wednesday,
August 17, 2005 6:16 PM
To: Sivakumar K
Cc: postgre; sandhya
Subject: Re: [ADMIN] error codes
in postgresql
Thank you Sivakumar.
ExecStatusType PQresultStatus(const PGresult *res);
Will it
On Wed, Aug 17, 2005 at 08:39:22AM -0400, [EMAIL PROTECTED] wrote:
> You stated that the SELECT currval('orderid_id_seq') statement is a
> separate query and must be treated as such.
>
> This gives me cause for concern. My intention is to obtain the orderid
> of the order inserted at that momen
Thank you.
You stated that the SELECT currval('orderid_id_seq') statement is a
separate query and must be treated as such.
This gives me cause for concern. My intention is to obtain the orderid
of the order inserted at that moment, but if I am to use a separate
query it would seem there is
Thank you Sivakumar.
ExecStatusType PQresultStatus(const PGresult *res);
Will it return code or message.If i want to use this what should be the
return value of my function?
Onemore doubt..
char *PQresultErrorField(const PGresult *res, int fieldcode);
What is the use of this?What is the diffe
Hi sandhya,
You can use PQresultStatus
API to get the result status of the command execution
And PQresStatus to
convert the enumerated type returned by PQresultStatus to a string constant.
For more information
you can check the libpq API documentation
http://www
Hi,
I want to know ,if there is any way to
return error codes/numbers as a return value from the postgresql
functions.
For ex:
If i am using my connection function
say,
DbConnect(dname,uname,.)
{
//here i use postgres connection
function
pg_conn *conn;
conninfo="dbname=exa
Hi,
I want to know ,if there is any way to
return error codes/numbers as a return value from the postgresql
functions.
For ex:
If i am using my connection function
say,
DbConnect(dname,uname,.)
{
//here i use postgres connection
function
pg_conn *conn;
conninfo="dbname
26 matches
Mail list logo
