FM <[EMAIL PROTECTED]> writes:
> BUT if I grant the same priv to the group (that include the user) :
> SELECT nextval('reflex_cited_reports_id');
> ERROR: permission denied for sequence reflex_cited_reports_id
Works for me ...
regression=# create sequence s1;
CREATE SEQUENCE
regression=# create
Hello,
We are using PGSQL 8.3.4
I have problem to grant privileges to a sequence.
If I grant all to the user I can do something like :
SELECT nextval('reflex_cited_reports_id');
SELECT nextval('reflex_cited_reports_id');
nextval
--
40442939
(1 row)
BUT if I grant the same priv to the
On Mon, Oct 20, 2008 at 8:10 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> I would like to have an SQL statement that would move all of the tables and
> indexes found within a particular schema to a particular tablespace. Is
> there a way I can do this?
I think you'll have to write a script (e
Martin Badie wrote:
Hi,
I have a 64 bit machine that has 32 bit pgsql rpms (8.2.5) installed.
If I install 64 bit of the same version does that create any
problems? Of course I am thinking to make a dump but I wanted to ask
first because db is very huge (about 100 gb)
The 32bit and 64bit wi
>>> Martin Badie <[EMAIL PROTECTED]> wrote:
> I have a 64 bit machine that has 32 bit pgsql rpms (8.2.5) installed.
If I
> install 64 bit of the same version does that create any problems?
They can co-exist with no problem. When you are running multiple
instances of PostgreSQL on the same box
I would like to have an SQL statement that would move all of the tables
and indexes found within a particular schema to a particular tablespace.
Is there a way I can do this?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
On Mon, 2008-10-20 at 08:31 +0200, Florian Weimer wrote:
> We've set up WAL-shipping replication on one of our database servers,
> and the question is whether it runs correctly.
There's two answers here.
The first is that the code used is exactly the same as crash recovery.
So if you trust cra
Florian Weimer wrote:
> We've set up WAL-shipping replication on one of our database servers,
> and the question is whether it runs correctly. Is there an easy way
> to access some tables and see if the data matches (possibly in
> single-user mode)?
>
> Stopping replication and starting the serve
Hi,
I have a 64 bit machine that has 32 bit pgsql rpms (8.2.5) installed. If I
install 64 bit of the same version does that create any problems? Of course I
am thinking to make a dump but I wanted to ask first because db is very huge
(about 100 gb)
Regards?
_
On Mon, 2008-10-20 at 01:08 -0700, wstrzalka wrote:
> There is not such a possibility. However it's on TODO list:
> http://wiki.postgresql.org/wiki/Todo
> I'm waiting for this feature too.
>
> I can understand your fear about the data, that you can not query for
> it.
Please test the Hot Standb
There is not such a possibility. However it's on TODO list:
http://wiki.postgresql.org/wiki/Todo
I'm waiting for this feature too.
I can understand your fear about the data, that you can not query for
it. I had the same :)
So script as much as you can, for the rest create a formal procedure -
the
Florian Weimer a écrit :
> We've set up WAL-shipping replication on one of our database servers,
> and the question is whether it runs correctly. Is there an easy way
> to access some tables and see if the data matches (possibly in
> single-user mode)?
>
Nope. The only way you can look at data o
12 matches
Mail list logo
