hi,
you can use the EXPLAIN instruction.
"\h EXPLAIN" in psql for help.
bye
David Cana wrote:
> Hello!
>
> I have got a view like:
>
> create view consulta_material as
> select
> material.clave as clave,
> referencia,
> sede.nombre_es as nombre_s
Title: Message
you
have to start a transaction with begin
Dave
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of MonaSent: October 13, 2001 2:32
AMTo: [EMAIL PROTECTED]Subject: [GENERAL]
Hi
We are trying to rollback an update
"Mihai Gheorghiu" <[EMAIL PROTECTED]> writes:
> It is possible that a user is a member of more than one group.
> Do this user's privileges AND or OR the privileges of each of the two
> groups?
OR. A user's privileges are always the union of what he has personally
and what he has via any group.
On Tuesday 16 October 2001 02:39 pm, samsom, debra wrote:
> I just installed postgresql 7.1.3 on Linux Redhat 7.1. All is well except
> Postgresql will not start on Boot. I have added the -o '-i' to the
> postgresql.conf and done the chkconfig --add postgresql. Is there anything
> else that I a
Are you disposing the results of each select call? Not being familiar with
Python, as well as not knowing which interface for Python you are using, or
the code used to invoke the selects, I can only surmise that the result data
from each select is being stored in RAM and never garbage collected. A
a really quick question:
are the postgresql 7.1.3 rpms compiled with jdbc support, or do i need to build
from source to get jdbc to work?
thanks,
richard
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED
Try:
begin;
update TABLE set FIELDx = VALUEy
rollback;
On Sat, Oct 13, 2001 at 12:02:01PM +0530, Mona wrote:
>
> We are trying to rollback an update in postgres. But so far we have not been able to
>do it.
> When we Rollback..
> it says:
>
> ROLLBACK: No transaction in progress.
>
Yes. The error log entries showing why Postgres won't boot. Without them, we
can't help you.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
From: "samsom, debra" <[EMAIL PROTECTED]>
Date: Tue, 16 Oct 2001 13:39:15 -0500
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> I am having a problem with the "pg_views" view. It seems that the
> internal function pg_get_viewdef() is the problem. See below.
It looks to me like you've got some one view that refers to a
no-longer-existent function. To figure out which it is
The users can access the database only via rules. Some of the rules do call
functions.
I found in PG notes that: "An SQL or plpgsql function invoked by a rule
would be executed with the current user's permissions, not the rule
owner's." What exactly does this mean? What do I need to do with respec
No they are not.
I wondered if they were temporary space or something other.
I might take a punt at moving them, but then again :-(!
Thanks
Lee
- Original Message -
From: "David Link" <[EMAIL PROTECTED]>
To: "Lee Crampton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October
It is possible that a user is a member of more than one group.
Do this user's privileges AND or OR the privileges of each of the two
groups?
Thank you all.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.
Marshall Spight wrote:
> "Daniel Åkerud" <[EMAIL PROTECTED]> wrote in message
> 007101c13b96$834e8960$c901a8c0@automatic100">news:007101c13b96$834e8960$c901a8c0@automatic100...
> >
> > Anyway I called it "uzer" now. Maybe usr is better... users is out of the
> > question since table names are supp
i'm trying to get postgresql to listen on 127.0.0.1:5432,
192.168.1.1:5432 but not on xx.yy.zz.qq:5432 --
from the admin guide i see:
VIRTUAL_HOST (string)
Specifies the TCP/IP hostname or address on which the
postmaster is to listen for connections from c
I have a db in which users can view and update data only via views.
It is my understanding that the privileges of the view/rule creator do not
extend to sequences. Therefore, I have to give users permissions to
sequences, just to the extent that they could add records. What is the
minimum set of p
Title: postgresql 7.1.3
I just installed postgresql 7.1.3 on Linux Redhat 7.1. All is well except Postgresql will not start on Boot. I have added the -o '-i' to the postgresql.conf and done the chkconfig --add postgresql. Is there anything else that I am missing?
Debra Samsom
Bristol Aeros
On Tue, Sep 25, 2001 at 12:06:48AM -0400, Micah Yoder wrote:
> (sorry to reply to a week-old message. need to keep up with this list more!)
Ditto, but more so.
> I then wrote a daemon in C to do the work and store the results in RAM. The
> PHP script connected to the daemon via a socket, and
Here is from staroffice.com.support.starbase:
Mihai Gheorghiu wrote:
>
> I want to connect to a PostgreSQL database on a RH7.0 machine.
> I go File New Database, general "Test", Type "JDBC", JDBC
> "org.postgresql.Driver" "jdbc:postgresql:sales" "username" "password".
> I use the same strings to
On Tue, Oct 16, 2001 at 07:41:26PM +0900, Karen Ellrick wrote:
> Meanwhile, my first question is still valid - it's a spooky feeling to see
> your own domain name show up, married with someone else's username, as a
> return address on a message that you know neither you (nor anyone else in
> your
Ok, little language qui pro quo...
I'm sorry for the error...
Denis
At 15/10/01 17.00, Andrew Sullivan wrote:
>On Mon, Oct 15, 2001 at 10:40:17AM +0200, Denis Gasparin wrote:
> > >
> > >It's long since done.
> >
> > ==>> This means that it will not be included in 7.2? I've read 7.2
>
>No, it me
Hi
We are trying to rollback an update in postgres. But so far we have not
been able to do it.When we Rollback..it says:
ROLLBACK: No transaction in progress.
Same happens with commit.We are used to SQL PlUS
Without these facilities we really cannot go ahead with postgres db. Could
you
On Mon, 15 Oct 2001, Chris Cameron wrote:
> I'm having a bit of a problem managing users.
>
> I have a database owned by user joe. Joe has a bunch of tables in this
> database and is allowed to create databases but not users. All the
> tables are owned by joe.
> If I create another user withou
Gordan Bobic <[EMAIL PROTECTED]> writes:
> [ why is this slow? ]
> explain select jobs.title from jobs, jobs_description_fti,
> jobs_title_fti where (jobs_description_fti.string = 'linux' or
> jobs_title_fti.string = 'linux') and (jobs_description_fti.id = jobs.oid and
> jobs_title_fti.id = job
On Tue, 16 Oct 2001 19:41:26 +0900 Karen Ellrick <[EMAIL PROTECTED]> wrote:
> Meanwhile, my first question is still valid - it's a spooky feeling to see
> your own domain name show up, married with someone else's username, as a
> return address on a message that you know neither you (nor anyone el
Hi all,
I am having a problem with the "pg_views" view. It seems that the
internal function pg_get_viewdef() is the problem. See below.
This problem is preventing me from dumping the database (either as 1
export or 1 table at a time). I have recreated the database, but the
problem seems to
Hello!
I have got a view like:
create view consulta_material as
select
material.clave as clave,
referencia,
sede.nombre_es as nombre_sede, clave_sede,
soporte.nombre_es as nombre_soporte, clave_soporte,
area_materiales.nombre_
You are probably going to use ODBC. I don't know if there are VB
drivers for postgresql. I have been using RealBasic on the mac and
there are drivers to directly access postgresql. Connecting is very
easy.
Check out the ODBC availability for VB.
Ted
-Original Message-
From: "Evan Pa
27 matches
Mail list logo
