Have a look here
http://bucardo.org/wiki/Check_postgres
Regards
On Wednesday, February 19, 2014 5:51 PM, Alejandro Carrillo
wrote:
Hi,
PostgreSQL have a way to put alerts about number of connections, tablespace
used, etc like the DBMS_SERVER_ALERT package of Oracle?
Thanks you
014 at 07:28:38AM -0800, salah jubeh wrote:
> Hello,
>
> I am looking for a tool that could help me in analyzing the pg_hab.conf file.
> For example , detecting duplicates, unused entries, and overlaping entries.
We are in the process of talking about this:
http://www.post
Hello,
I am looking for a tool that could help me in analyzing the pg_hab.conf file.
For example , detecting duplicates, unused entries, and overlaping entries.
Regards
Hello ,
The case Syntax is not correct , have a look here
http://www.postgresql.org/docs/current/static/functions-conditional.html
Furthermore; I think, this will not ensure the order of root 3, root 4 and
root 5 as well as scene1,...
Regards
On Monday, February 3, 2014 7:55 PM, Susan Ca
Hello,
For backup restore solution, one could create a snapshot and use it as a
template for later use. For example, if the changes can not be revoked, and
something wrong went with the tests; creating a a database form a template is
much faster than backup and restore.
Regards
On Thursday
Sparx architect
Regards
On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert
wrote:
On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote:
> Is there any free or cheap software that will read in DDL and output a
> graphic display of it? Preferably showing links for foreign key
sted by another mail thread - andy colson -.
Also here another option:
1. Disable the unique constraint 'ALTER ABLE .. DROP CONSTRAINT'
2. Remove duplicates , have a look here
http://wiki.postgresql.org/wiki/Deleting_duplicates
3. Enable the unique constraint.
Regards
On Monday, Decem
>On 12/13/2013 4:46 AM, rob stone wrote:
>> The only fly in the ointment with this is a rain gauge. If you don't
>> empty it each day the actual rainfall is the difference between
>> readings.
>(somewhat off topic)
>The electronic rain gauges I've seen have all been tip-bucket. they
>measure eac
ere is data inconsistency, I have queried in
the past for example pg_class to determine if a table has no index to determine
misusage or bad designs.
Regards
On Wednesday, December 11, 2013 4:50 PM, Tom Lane wrote:
salah jubeh writes:
> create table a (id int primary key);
>
salah jubeh wrote:
>>> http://www.postgresql.org/docs/current/static/catalog-pg-class.html
>>> relhastriggers bool True if table has (or once had) triggers
>>
>>> This is what is queried when you try to convert the table into a view.
>>> So there
, I need to refactor b, but keep it for backward compatability as
updatabale view.
Regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday, December 11, 2013 2:18 PM,
Hello Guys,
ERROR: could not convert table "b" to a view because it has triggers
HINT: In particular, the table cannot be involved in any foreign key
relationships.
** Error **
ERROR: could not convert table "b" to a view because it has triggers
SQL state: 55000
Hint: In parti
Hello,
I have a question regarding streaming replication:
When pg_xlog needs to be shipped in streaming replication and when not? I
have faced a different issues in two existing setups, in the first setup, when
shipping the pg_xlogs a time line issue has arisen, and in another setup, when
Hello,
Use a view
Regards
From: Janek Sendrowski
To: pgsql-general@postgresql.org
Sent: Friday, August 16, 2013 11:55 AM
Subject: Re: [GENERAL] devide and summarize sql result (all)
Thanks for your Answers,
my problem is, that there is no column wit
From: Muhammad Bashir Al-Noimi
To: salah jubeh
Cc: "pgsql-general@postgresql.org"
Sent: Tuesday, July 16, 2013 5:50 PM
Subject: Re: [GENERAL] Upgrading from Pg 9.1 to 9.2
On Tue, Jul 16, 2013 at 5:20 PM, salah jubeh wrote:
> Have a look on
> http://www.postgre
Hello,
Have a look on
http://www.postgresql.org/docs/9.1/static/upgrading.html
and
http://www.postgresql.org/docs/9.1/static/pgupgrade.html
Regards
From: Muhammad Bashir Al-Noimi
To: "pgsql-general@postgresql.org"
Sent: Tuesday, July 16, 2013 5:08 PM
Sub
Is this a bug ?, the new.a_id in my opinion should not be replaced here with
nextval () function but with the actual value returned by the sequence. Please
have this minimal example .
CREATE TABLE a
(
a_id serial primary key
);
CREATE TABLE b
(
b_id serial Primary key
);
CREATE
Hello,
I have just found this post
http://grokbase.com/t/postgresql/pgsql-hackers/10ces3w9kz/alter-table-replace-with/nested/page/2#responses_tab_top
and it helped a lot
Thanks
From: salah jubeh
To: pgsql
Sent: Thursday, June 20, 2013 5:58 PM
Subject
Hello,
I have a database server which do a complex views calculation, the result of
those views are shipped to another database servers via a simple replication
tool which have a high client loads.
The tool is creating a table, and indexes based on predefined conf., then
drop the t
I find the do block a nice enhancement; for example, it allows me to do many
administration tasks quickly without adding a procedure to the database.
Imagine that I need to truncate all the tables in a schema for development
purposes in order to fill it with test data. I could do like this
D
Hello,
You can have the list of table names from pg_class such as
SELECT c.relname as "Name" ,
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r') AND n.nspname NOT IN ('pg_toast', 'pg_catalog',
'information_schema') ;
So, if you
the restore performance.
I have re-indexed one table and the size dropped to again 700 MiB. So what
could be the problem here?
Thanks
From: Tom Lane
To: Sergey Konoplev
Cc: salah jubeh ; pgsql
Sent: Thursday, March 28, 2013 5:08 AM
Subject: Re
Hello,
I have a database which is bloated because of vacuum full, so you find indexes
bigger than the table itself.
I have dumped this database and restored it without reindixing and it was
extremely slow. So, my question what is the relation between bloated database
and pg_restore.
Rega
point me to the
appropriate developer guide.
Regards
From: Tom Lane
To: Kevin Grittner
Cc: salah jubeh ; pgsql
Sent: Friday, January 18, 2013 2:02 AM
Subject: Re: [GENERAL] SELECT DISTINCT
"Kevin Grittner" writes:
> salah jubeh wrote:
&
Hello Guys,
During my work, I have seen a common practice of using DISTINCT . Some will
argue that developer should know the effect of using it, but keep in mind not
all developers are gurus in RDBMs. Normally, developers work in a narrow
domain. Using DISTINCT might lead to a huge performance
Hello,
Did you try to set the constraints as deferrable
i.e.
begin;
set constraints all deferred;
...
commit;
Also, you can set this by forign key , have a look on
http://www.postgresql.org/docs/9.0/static/sql-createtable.html
Regards
From: jo
To: p
Hello Guys;
Today, I have noticed that my dumps are not working due to bad practice in
writing SQL queries.
In the past, I there was a scenario where I there are two tables, one of them
is completely dependent on the other. i.e. the foreign key and the primary
key constraint assigned to
Hello David,
Well, I think this is normal you can t assign null to a variable without a
proper cating in your example you can do somthing like this
c1 cursor FOR SELECT 1 as shipmentid, null::bigint as olmid;
Regards
From: David Greco
To: "pgsql-genera
Hello,
I have the following scenario, I would like to upgrade a database server from
8.3 to 9.1. The upgrade includes also a hardware upgrade.
I would like to have the following
1. Make sure that the upgraded server and the old server have the same snapshot
of data.
2. Make sure that the old
Greetings,
I have a binary replication as follow:
1. The primary is used for the write operation
2. I am interested in optimizing a query of one of the tables which has a daily
partitions with around 8 GB in size.
3. The server is used mainly for write and the average data write for all
tables
Hello,
I think you might need to have a look on a binary replication and Pgpool ii
Regards
From: Mino Haluz
To: pgsql-general@postgresql.org
Sent: Wednesday, October 24, 2012 2:28 PM
Subject: [GENERAL] Postgresql high available solution
Hi,
we would lik
yes , it is . i forget how to do it . you just need to a connection information
in the wms configuration file
From: José Pedro Santos
To: Postgres Ajuda
Sent: Friday, October 12, 2012 5:46 PM
Subject: [GENERAL] PostgreSQL and WMS
Dear all,
I would like
Hello David,
Thanks for the quick response, I will follow up with the performance group
after preparing some case scenarios.
Regards
From: David Johnston
To: 'salah jubeh' ; 'pgsql'
Sent: Wednesday, September 26, 2012 4:41 PM
S
Hello,
I know that the optimizer, uses the number of rows to calculate the total
query execution time. In complex queries, it is very difficult to know the
number of rows in the expected result. This certainly affects the optimizer to
very great extent. I have a view and it should return aro
un the
analyze, and its fixed.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Friday, September 21, 2012 3:01 PM
To: salah jubeh
Cc: pgsql
Subject: Re: [GENERAL] 9.1 vs 8.4 performance
On Fri, Sep 21, 2012
Hello,
I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, both
are fresh installs and both has the same configuration files and databases.
I am running queries sequentially on each machine using a database dumped from
a life server , and 9.1 server is much slower than 8
Another solution would be to create a view based on a function and pass the
schema name to the function.
But, I think you have to rethink your server configuration and may be whole
development environment. One server for live data and staging, testing ,
training ... I found that really dange
OIDS=FALSE
);
insert into test_update (id, value) values (1,5), (2, 10);
update test_update as b
set percentage = (Select a.value/(select sum(value) from test_update) from
test_update as a where a.id = b.id)
From: Robert Buckley
To: salah jubeh ; &quo
,ges_kw_zgb, (SELECT round(100 * (ges_kw_zgb / (select
sum(ges_kw_zgb) From energie.tennet_auswertung_2010)),2)) FROM
energie.tennet_auswertung_2010;
Regards
From: Robert Buckley
To: salah jubeh ; "pgsql-general@postgresql.org"
Sent: Monday, September
I am wondering why do not you write it like this
select name,ges_kw_zgb, select round(100 * (ges_kw_zgb / (select
sum(ges_kw_zgb) From energie.tennet_auswertung_2010)),2) ..
Regards
From: Robert Buckley
To: "pgsql-general@postgresql.org"
Sent: Mond
Hello,
I think database security is quite complex issue depends on the
institution requirements. I have worked with elections and voting and we had an
extreme polices for security not only for authorization, authentication, and
password policies. We was obligated to use database auditing to rec
Hello,
you need to use execute command
i.e.
execute 'alter table ' || newcol || ';'
Regards
From: "Gauthier, Dave"
To: "pgsql-general@postgresql.org"
Sent: Wednesday, August 29, 2012 4:56 PM
Subject: [GENERAL] using vars in ddl in procedure ca
:47 PM
Subject: Re: [GENERAL] function depend on view
salah jubeh wrote:
> Hello Guys,
>
> I am having a scenario close to the one below, I have defined a function which
> depends on a view. I am able to drop the view, but my server did not complain
> about the dependency.
>
Hello Guys,
I am having a scenario close to the one below, I have defined a function which
depends on a view. I am able to drop the view, but my server did not complain
about the dependency.
In the scenario below, one can drop the views a2 and a1 respectively, and when
executing a3(), certa
Hello guys,
In some cases when I cast the oid to relation names (''::regclass::text) I
get schemaname.tablename and in some cases I just get tablename. I thought at
the beginning, this is due name duplication of tables in different schemas but
it seems not. Also, this seems as a schema o
Hello,
you need to use quotes because open and close are sql key words
http://www.postgresql.org/docs/9.1/static/sql-keywords-appendix.html
row."open"
row."close"
Regards
From: fv967
To: pgsql-general@postgresql.org
Sent: Sunday, April 22, 2012 11:34
Hello Dave J.
You are right. I used explain analyse and the last operation was unique and
that means remove all duplicates and I select distinct * from view1 and I get
233.
Regards
From: David Johnston
To: 'salah jubeh' ; 'pgsql
Hello,
Today, I have encounterd a strange result and I want to trace it but I do not
know how. I have two views having union as in q3. q1 returns 236 rows, q2
returns 0 rows. I expected q3 to return 236 rows but I get 233 ...
q1: select * FROM view1 -- reurns 236 rows
q2: select * FROM view2
Hello,
When creating a serial, a sequence is created automatically.
CREATE TABLE tablename ( colname SERIAL
);
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename ( colname integer NOT NULL DEFAULT
nextval('tablename_colname_seq')
);
ALTER SEQUENCE tablename_colname_seq OWNED BY tablen
From: Tom Lane
To: salah jubeh
Cc: Volodymyr Kostyrko ; pgsql
Sent: Thursday, January 26, 2012 5:47 PM
Subject: Re: [GENERAL] How to push predicate down
salah jubeh writes:
> Sorry, The scenario, that I posted was not correct. I have traced it and the
>
Hello ,
if you need to construct view with the columns math, physics , I think what
you need is crosstab function
Regards
From: David Johnston
To: 'Sebastian Tennant' ; pgsql-general@postgresql.org
Sent: Thursday, January 26, 2012 8:50 PM
Subject: Re: [G
(cost=60.52..62.67 rows=860
width=64) (actual time=0.010..0.012 rows=1 loops=1)"
" Sort Key: tr.col1, tr.col3"
" Sort Method: quicksort Memory: 25kB"
" ->
Hello Guys,
In the past I had a view defined as follows
CREATE view abcd as
SELECT whatever .. --- query1
Some business requierments came up and I had to change it like this
CREATE view abcd as
SELECT whatever .. --- query1
UNION
SELECT whatever .. query2
Now I have
|| privilegeType ||' ON TABLE '
|| quote_ident ($2) ||' TO '|| roleName || E';\n' ;
END LOOP;
END LOOP;
--Execute ALL
EXECUTE grantSQL;
END
$$ LANGUAGE 'plpgsql' ;
____
From:
I found this view
information_schema.table_privileges
Regards
From: salah jubeh
To: pgsql
Sent: Wednesday, January 18, 2012 2:48 PM
Subject: [GENERAL] Table permessions
Hello,
I have create a table from another table such as
CREATE TABLE
Hello,
I have create a table from another table such as
CREATE TABLE tmp_XXX AS SELECT * FROM XXX;
The tmp_XXX tables has no permissions assigned to it and I want to assign it
with the same owner and access privileges of XXX table. I had a look on pg
catalog tables http://www.postgre
From: C Klaver
To: pgsql-general@postgresql.org; salah jubeh
Sent: Monday, January 16, 2012 3:52 PM
Subject: Re: [GENERAL] psql - TYPE DEFINITION
On Monday, January 16, 2012 6:38:49 am salah jubeh wrote:
> Hello
>
>
> I tired \dT and dT+ to
Hello
I tired \dT and dT+ to see the type related information but I am interested
about the definition , Is there a way to see the type definition in psql
Regards
values (3,4);
SELECT num1, num2, num1 + num2 FROM numbers
SELECT num1 as a, num2 as b, a + b as c FROM number
SELECT num1 as a, num2 as b, num1 + num2 as c FROM numbers
From: Simon Tokumine
To: salah jubeh
Cc: pgsql
Sent: Wednesday, December 21
Hello,
Why I can not do something like this in Postgres.
SELECT 1 as a , 2 as b , a + b as c ;
Regards
Can someone please direct me where I can find documentation about ALL and ANY
functions. I searched postgresql documentation but I did not find the
appropriate pages
Thanks in advance
Thanks guys as you have pointed , I think the best solution is to go for CAT
and set the appropriate options for psql.
Regards
From: Merlin Moncure
To: Cédric Villemain
Cc: salah jubeh ; "andr...@a-kretschmer.de"
; pgsql
Sent: Tuesday,
causing the error.
Regards
From: "andr...@a-kretschmer.de"
To: salah jubeh
Sent: Tuesday, October 18, 2011 2:23 PM
Subject: Re: [GENERAL] many sql file and one transaction
Zitat von salah jubeh :
> Hello,
>
>
> I have ma
Hello,
I have many SQL script files to update schema, delete data, unit test etc.
I want to run all the files in one transaction using shell script to ease the
installation procedure. I can do that from the psql client by using the \i
option
BEGIN;
\i / .../ module1.sql
\i / .../
@postgresql.org
Sent: Tuesday, October 11, 2011 9:55 PM
Subject: Re: [GENERAL] libpq 8.3 and 8.4 interfaces
John R Pierce wrote:
> On 10/11/11 12:42 PM, salah jubeh wrote:
> >
> > Could someone point me, where I can find the difference between libpq
> > 8.3 and 8.4, I have seen the ne
Thanks for the quick support
Best Regard
From: John R Pierce
To: pgsql-general@postgresql.org
Sent: Tuesday, October 11, 2011 9:52 PM
Subject: Re: [GENERAL] libpq 8.3 and 8.4 interfaces
On 10/11/11 12:42 PM, salah jubeh wrote:
>
> Could someone po
Hello,
Could someone point me, where I can find the difference between libpq 8.3 and
8.4, I have seen the new features of the 8.4, but I want to know about the
API interface changes
Thanks in advance
Create a temp table that will store all the foreign kez constraints
then create a function that add an entry to this table
then write a plpgsql function that reads the constraints and disable them
write another function to read the constraints from the temporary tables and
create them again
Hello,
I had the same issue before and I used the PostgreSQL statistics to
see weather the tables are used or not. One thing that I could not solve is how
to check if the schema design and semantics are good. i.e. table a references
table b, table c references table b, and table c referen
Hello Guys,
I have the following problem and I solved it in the following way, I need to
see if there are a better approaches to do that. any suggestion is welcome
The problem
I have function have this logic
FOR record1 in SELECT LOOP
FRO record2 in SELECT ... LOOP
.
Regards
From: Chris Travers
To:
Cc: salah jubeh ; pgsql
Sent: Wednesday, September 28, 2011 5:09 PM
Subject: Re: [GENERAL] tubles matching
Is something like this what you are trying to do?
somedb=# create table a (a int, b text, c date);
CREATE TABLE
somedb
Hello,
I have two views both contain identical column names , order and types except
the primary keys. I want to match these two views - return the pk pair of the
rows which match from these views - by comparing all the column values. I want
to write a pgplsql function to do this Job by ite
Hello.
This might be the wrong place to post my question, but any help is appreciated.
Did any one used Jenkins for Postgresql unit testing, and what are the
available unit testing plug-ins?, is there is a tutorial for that ?
Thanks in advance
Hello Thom.
what is the meaning of
select table_name from table_name
Also is this a common behavior of all Databases i.e. oracle , Microsoft ,...etc
. i.e is this is the standard behavior
I think this is a good way to find duplicates in general, I will write a
routine to compare all t
Hello,
I have a lookup table I want to delete which is referenced as a foreign key in
another table. Is there is a way to find all of the tables depends on this
column (foreign key) but not the whole table or view.
Thanks in advance
get the text file in the Pgadmin editor.
Kind regards
From: Guillaume Lelarge
To: salah jubeh
Cc: pgsql
Sent: Thursday, August 18, 2011 10:48 PM
Subject: Re: [GENERAL] Pgadmin plugins
On Thu, 2011-08-18 at 08:22 -0700, salah jubeh wrote:
> Hello,
>
Hello,
I find pgadmin a nice software, but I think it lacks some fundamental
functionalities mainly repositories support including git and cvs. Also, some
enhancement on the editor would be nice such as auto completion, code ordering,
coloring, etc. I have seen that pgadmin have a menu call
Thanks for the help, and for different design options it really helped me. I
had
a look on vertical design and horizontal design and this is some cons and pros
in general for vertical design
Advantages:
•Avoid null values and utilize storage
•Avoid constant schema changes due to adding
@postgresql.org
Sent: Tue, July 26, 2011 7:10:47 PM
Subject: Re: [GENERAL] variant column type
On 07/26/11 10:02 AM, salah jubeh wrote:
> and using ANSI compliant design
American National Standards Institute? they have an ANSI standard on database
schema design or something?
-- john r pie
Hello,
suppose the following scenario
the car speed is 240
the car has an airbag
Here the first value is integer and the second value is boolean. Consider that
I
have this table structure
feature (feature id feature name)
car (car id, )
car_feature (car id, feature id, value). the val
Hello,
I do not know if your clients are superusers on their machines, one thing you
can do is to remove psql client from these machines. In general, for example in
a company, the users do not have administration privileges.
Regards
From: Kurt Buff
To: Lon
Hello,
I would like to know the effect of alter table rename, I know that the some
things are changed automatcally such as views dependencies and forign keys and
some things remain the same such as function defenesions.
Is there is a place where can I find the exact effect of rename
Regards
From: Bruce Momjian
To: salah jubeh
Cc: pgsql
Sent: Mon, July 18, 2011 11:09:37 PM
Subject: Re: [GENERAL] Documentation issue
salah jubeh wrote:
> #include "postgres.h" #include #include "fmgr.h" /* by value */
> PG_FUNCTIO
Computer Science
P.O. Box 198
Mobile:++97259369122
Tel:++9754680
From: Bruce Momjian
To: salah jubeh
Cc: pgsql
Sent: Mon, July 18, 2011 10:58:19 PM
Subject: Re: [GENERAL] Documentation issue
salah jubeh wrote:
> Hello,
>
> In http://www.p
Hello,
I do no have any experience with oracle, try to dump the oracle database in
plain format and then try to execute the DDL and DML statements. It might be
cumbersome to fix all the errors you might get. But as an initial solution give
it a shot.
Regards
__
Hello,
In http://www.postgresql.org/docs/8.4/static/xfunc-c.html, there is a missing
include to the utils/geo_decls.h which leads to compilation errors. i.e
#include
"utils/geo_decls.h"
needs to be added to the code.
Kind regards
Hello,
I have two databases, I need to insure that both databases has the same roles.
tables, schemas, views must have the same permissions and privileges. you can
say and Identical clones. I can synchronize the roles using these statements
SELECT DISTINCT 'CREATE USER '||usename||';' FRO
I have two databases, I need to insure that both databases has the same roles.
tables, schemas, views must have the same permissions and privileges. you can
say and Identical clones. I can synchronise the roles using these statments
SELECT DISTINCT 'CREATE USER '||usename||';' FROM pg_user
Hello,
This is an ugly hack. Try to have a temporary holder that carries the maximum
value. for example create a table with a one columnn and certainly one row
and synchronize this value with your sequence
Regards
From: Dmitry Koterov
To: Postgres Gener
Hello Guys,
It was about some firewall rules setup by the system administrator.
Thanks
From: salah jubeh
To: pgsql
Sent: Mon, June 20, 2011 12:39:51 PM
Subject: [GENERAL] connection time out
Hello Guys,
I have a database server and I have
Hello Guys,
I have a database server and I have created another replica of it on another
machine. The new replica is running fine locally, but I can not access it from
another clients, the pg_hba.conf file is the same as the original database
server.
when I try to connect to the server I
Hello,
There is something strange with the views definitions, I have "order by"
statement amended to the views where the view is ordered by all the columns in
the view. Is this a common behavior?
Ps: I am using postgresql 8.3
Regards
Hello,
I think, one good thing to do is partionning, you have already mentioned that
in
your mail,
http://www.postgresql.org/docs/current/static/ddl-partitioning.html
try to run also vaccuum command it might help in increasing the performance.
create a boolean flag i.e. active and create an i
, new.account_status_id, now());
I do not know what is happing here, but this is a strange behavior.
Regards
From: Merlin Moncure
To: salah jubeh
Cc: pgsql-general@postgresql.org
Sent: Wed, June 1, 2011 4:54:36 PM
Subject: Re: [GENERAL] currval
I have the following SQL statements
BEGIN;
-- account_id is a sequence
INSERT INTO account (name) VALUES ('test customer'||random()::text);
-- account_id is a foreign key
INSERT INTO account_detail (account_id,..) VALUES ((SELECT * from
currval('account_acccount_id_seq')), );
COMMIT;
Hello,
I hope that I am not wasting your time, I tried to restore a part of a
database
and I faced couple of obstacles. First of all, I tried to restore a certain set
of schemas without restoring a certain relations. I wanted to do that in order
to create some automated dummy data for testing
Please Have a look on pg_stat_user_tables, there is a field called n_live_tup
.
But I think in some cases this might not hold the actual row number
Regards
From: Carlos Sotto Maior (SIM)
To: David Johnston ; pgsql-general@postgresql.org
Sent: Mon, May
Hello,
I have a view which is a result of the cross product of three tables, I want to
test how much time is required to populate this view. Also, I want to test the
scalability of this view in the future. Since, I have already live data I am
wondering if I can do that without creating an autom
Hello Adrian,
I have changed the permission of one table where view B depend on and my
problem
is over. Still; the whole issue is confusing me.
Regards
From: Adrian Klaver
To: pgsql-general@postgresql.org
Cc: salah jubeh
Sent: Tue, May 24, 2011 4:13:38
I have two views A and B such that A depend on B. Both of them has the same
permissions.
when I excute
SELECT * FROM A;
ERROR: permission denied for relation B
** Error **
ERROR: permission denied for relation B
SQL state: 42501
However, I can do
SELECT * FROM B;
H
1 - 100 of 129 matches
Mail list logo
