Have a look here
http://bucardo.org/wiki/Check_postgres
Regards
On Wednesday, February 19, 2014 5:51 PM, Alejandro Carrillo
faster...@yahoo.es wrote:
Hi,
PostgreSQL have a way to put alerts about number of connections, tablespace
used, etc like the DBMS_SERVER_ALERT package of Oracle?
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
, 2014 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.postgresql.org/message-id
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
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
Sparx architect
Regards
On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert
karsten.hilb...@gmx.net 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
CONSTRAINT'
2. Remove duplicates , have a look here
http://wiki.postgresql.org/wiki/Deleting_duplicates
3. Enable the unique constraint.
Regards
On Monday, December 30, 2013 4:47 PM, Janek Sendrowski jane...@web.de wrote:
Hi Salah Jubeh,
My files don't have this format. Could it make sense
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 each 0.01
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
:
salah jubeh wrote:
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
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 is no way to convert your table to a view unless you
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 t...@sss.pgh.pa.us wrote:
salah jubeh s_ju...@yahoo.com writes:
create table a (id int primary key);
create
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 jane...@web.de
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
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 mbno...@gmail.com
To: pgsql-general@postgresql.org
From: Muhammad Bashir Al-Noimi mbno...@gmail.com
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql-general@postgresql.org 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
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
);
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 s_ju...@yahoo.com
To: pgsql pgsql-general@postgresql.org
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
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
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 t...@sss.pgh.pa.us
To: Sergey Konoplev gray...@gmail.com
Cc: salah jubeh s_ju...@yahoo.com; pgsql pgsql
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.
point me to the
appropriate developer guide.
Regards
From: Tom Lane t...@sss.pgh.pa.us
To: Kevin Grittner kgri...@mail.com
Cc: salah jubeh s_ju...@yahoo.com; pgsql pgsql-general@postgresql.org
Sent: Friday, January 18, 2013 2:02 AM
Subject: Re: [GENERAL
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
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
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
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
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 mino.ha...@gmail.com
To: pgsql-general@postgresql.org
Sent: Wednesday, October 24, 2012 2:28 PM
Subject: [GENERAL] Postgresql high available
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 zpsant...@hotmail.com
To: Postgres Ajuda pgsql-general@postgresql.org
Sent: Friday, October 12, 2012 5:46 PM
Subject:
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
Hello David,
Thanks for the quick response, I will follow up with the performance group
after preparing some case scenarios.
Regards
From: David Johnston pol...@yahoo.com
To: 'salah jubeh' s_ju...@yahoo.com; 'pgsql' pgsql-general@postgresql.org
Sent
To: Scott Marlowe scott.marl...@gmail.com; salah jubeh s_ju...@yahoo.com
Cc: pgsql pgsql-general@postgresql.org
Sent: Friday, September 21, 2012 9:40 PM
Subject: Re: [GENERAL] 9.1 vs 8.4 performance
One thing I sometimes forget to do after loading up an empty DB with data is to
run analyze. I usually
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
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
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 robertdbuck...@yahoo.com
To:
,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 robertdbuck...@yahoo.com
To: salah jubeh s_ju...@yahoo.com; pgsql-general
);
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 robertdbuck...@yahoo.com
To: salah jubeh s_ju
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
Hello,
you need to use execute command
i.e.
execute 'alter table ' || newcol || ';'
Regards
From: Gauthier, Dave dave.gauth...@intel.com
To: pgsql-general@postgresql.org pgsql-general@postgresql.org
Sent: Wednesday, August 29, 2012 4:56 PM
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(),
: Monday, August 20, 2012 2:47 PM
Subject: Re: [GENERAL] function depend on view
salah jubeh s_ju...@yahoo.com 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
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
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 fv...@hotmail.com
To: pgsql-general@postgresql.org
Sent: Sunday, April
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
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 pol...@yahoo.com
To: 'salah jubeh' s_ju
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
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
From: Volodymyr Kostyrko c.kw...@gmail.com
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql pgsql-general@postgresql.org
Sent: Thursday, January 26, 2012 3:49 PM
Subject: Re: [GENERAL] How to push predicate down
salah jubeh wrote:
Hello Guys,
In the past I had a view
Hello ,
if you need to construct view with the columns math, physics , I think what
you need is crosstab function
Regards
From: David Johnston pol...@yahoo.com
To: 'Sebastian Tennant' seb...@smolny.plus.com; pgsql-general@postgresql.org
Sent: Thursday,
From: Tom Lane t...@sss.pgh.pa.us
To: salah jubeh s_ju...@yahoo.com
Cc: Volodymyr Kostyrko c.kw...@gmail.com; pgsql
pgsql-general@postgresql.org
Sent: Thursday, January 26, 2012 5:47 PM
Subject: Re: [GENERAL] How to push predicate down
salah jubeh s_ju...@yahoo.com
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
I found this view
information_schema.table_privileges
Regards
From: salah jubeh s_ju...@yahoo.com
To: pgsql pgsql-general@postgresql.org
Sent: Wednesday, January 18, 2012 2:48 PM
Subject: [GENERAL] Table permessions
Hello,
I have create a table
;
--Execute ALL
EXECUTE grantSQL;
END
$$ LANGUAGE 'plpgsql' ;
From: A.M. age...@themactionfaction.com
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql pgsql-general@postgresql.org
Sent: Wednesday, January 18, 2012 5:44 PM
Subject: Re: [GENERAL] Table
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
From: C Klaver adrian.kla...@gmail.com
To: pgsql-general@postgresql.org; salah jubeh s_ju...@yahoo.com
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
Hello,
Why I can not do something like this in Postgres.
SELECT 1 as a , 2 as b , a + b as c ;
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 si...@vizzuality.com
To: salah jubeh s_ju...@yahoo.com
Cc
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
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 /
causing the error.
Regards
From: andr...@a-kretschmer.de andr...@a-kretschmer.de
To: salah jubeh s_ju...@yahoo.com
Sent: Tuesday, October 18, 2011 2:23 PM
Subject: Re: [GENERAL] many sql file and one transaction
Zitat von salah jubeh s_ju...@yahoo.com
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 mmonc...@gmail.com
To: Cédric Villemain cedric.villemain.deb...@gmail.com
Cc: salah jubeh s_ju
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
Thanks for the quick support
Best Regard
From: John R Pierce pie...@hogranch.com
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
...@hogranch.com
Cc: pgsql-general@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
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 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
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
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
.
Regards
From: Chris Travers chris.trav...@gmail.com
To:
Cc: salah jubeh s_ju...@yahoo.com; pgsql pgsql-general@postgresql.org
Sent: Wednesday, September 28, 2011 5:09 PM
Subject: Re: [GENERAL] tubles matching
Is something like this what you are trying to do
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
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
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
in and
get the text file in the Pgadmin editor.
Kind regards
From: Guillaume Lelarge guilla...@lelarge.info
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql pgsql-general@postgresql.org
Sent: Thursday, August 18, 2011 10:48 PM
Subject: Re: [GENERAL] Pgadmin plugins
On Thu
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
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
To: pgsql-general@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
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
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
P.O. Box 198
Mobile:++97259369122
Tel:++9754680
From: Bruce Momjian br...@momjian.us
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql pgsql-general@postgresql.org
Sent: Mon, July 18, 2011 10:58:19 PM
Subject: Re: [GENERAL] Documentation issue
salah jubeh
From: Bruce Momjian br...@momjian.us
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql pgsql-general@postgresql.org
Sent: Mon, July 18, 2011 11:09:37 PM
Subject: Re: [GENERAL] Documentation issue
salah jubeh wrote:
#include postgres.h #include string.h #include fmgr.h
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 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
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
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||';'
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 dmi...@koterov.ru
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 Guys,
It was about some firewall rules setup by the system administrator.
Thanks
From: salah jubeh s_ju...@yahoo.com
To: pgsql pgsql-general@postgresql.org
Sent: Mon, June 20, 2011 12:39:51 PM
Subject: [GENERAL] connection time out
Hello
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 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')), );
, new.account_status_id, now());
I do not know what is happing here, but this is a strange behavior.
Regards
From: Merlin Moncure mmonc...@gmail.com
To: salah jubeh s_ju...@yahoo.com
Cc: pgsql-general@postgresql.org
Sent: Wed, June 1, 2011 4:54:36 PM
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) cso...@sistemassim.com.br
To: David Johnston pol...@yahoo.com;
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
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
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;
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 adrian.kla...@gmail.com
To: pgsql-general@postgresql.org
Cc: salah jubeh s_ju
1 - 100 of 129 matches
Mail list logo
