Hi.
I propose new feature.
Before flushing page of table to disk it may be scanned to reclaim
deleted rows. And assigned as partially vacuumed or vacuumed.
It may reduce bloat in frequently updated tables and make normal
(auto)vacuum faster.
Additional scan adds overhead to cpu (for update/delete),
In a partitioned table, is it possible to specify the partition for a
query to search using a variable instead of a constant?
EXAMPLE: Join another table to the partitioned one
Table: clu (partitioned by state)
ogc_fid bigint
cluid char(16)
state bpchar(2)
constraint: state='mi' (or 'co', 'k
We use some SQLserver databases that have stored procedures for all
C.R.U.D. functions so the same code is used no matter what language the
developer is working in. The procedures are built by a master package that
reads the table structures and creates the CRUD procedures. Then we modify
the CRUD
Kevin Grittner wrote on 04.02.2011 23:27:
PL/pgSQL seems tantalizingly close to being useful for developing a
generalized trigger function for notifying the client of changes. I
don't know whether I'm missing something or whether we're missing a
potentially useful feature here. Does anyone see
PL/pgSQL seems tantalizingly close to being useful for developing a
generalized trigger function for notifying the client of changes. I
don't know whether I'm missing something or whether we're missing a
potentially useful feature here. Does anyone see how to fill in
where the commented question
2011/2/4 Carlos Mennens
> On Fri, Feb 4, 2011 at 2:18 PM, David Johnston wrote:
> > Not to be smart about it but you could just logon as carlos (or a
> different
> > superuser you create for this purpose) and issue "Create Database xxx"
> and
> > "Create Role xxx" statements and see whether they
On Fri, Feb 4, 2011 at 1:18 PM, Tom Lane wrote:
> Jon Nelson writes:
>> I thought 'character varying' (aka varchar) sans length was an alias
>> for text. Is it not?
>
> It has the same behavior, but it is a distinct type, so dummy coercions
> are needed.
Are there any performance implications fo
On Fri, Feb 4, 2011 at 2:18 PM, David Johnston wrote:
> Not to be smart about it but you could just logon as carlos (or a different
> superuser you create for this purpose) and issue "Create Database xxx" and
> "Create Role xxx" statements and see whether they work. A superuser should
> (imo) be
It appears from my GUI admin program that:
REVOKE group-role FROM user-role;
Should do the trick.
>From the documentation for "REVOKE":
http://www.postgresql.org/docs/9.0/static/sql-revoke.html
REVOKE [ ADMIN OPTION FOR ]
role_name [, ...] FROM role_name [, ...]
[ CASCADE | RESTRICT ]
Not to be smart about it but you could just logon as carlos (or a different
superuser you create for this purpose) and issue "Create Database xxx" and
"Create Role xxx" statements and see whether they work. A superuser should
(imo) be able to do everything (including dropping) without any addition
Jon Nelson writes:
> I thought 'character varying' (aka varchar) sans length was an alias
> for text. Is it not?
It has the same behavior, but it is a distinct type, so dummy coercions
are needed.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@p
I am upgrading a Windows install for a client of mine from 8.2.x to
9.0.3 and understand the pginstaller does not provide plperl for this
version. ActivePerl 5.8 was already installed and after uninstalling 8.2
and installing 9.0.3, there is no plperl.dll in the lib folder. I
thought this was due t
Let's say I have a database with two tables, a and b.
Each has one column. 'a' has a column 't' of type text. 'b' has a
column 'v' of type 'varchar' (no length specified).
If I join the two tables, I see in the plan something that looks like this:
Merge Cond: (a.t = (b.v)::text)
I thought 'char
I created a role named 'carlos' which is my current user account with
'superuser' grants but my question is when I look at 'postgres'
account, he has additional grants that I don't understand.
List of roles
Role name | Attributes | Member of
---+-+---
car
On 2011-02-03 18:41, Wappler, Robert wrote:
On 2011-02-02, matty jones wrote:
I am looking for a good book on the math and/or theory behind
relational databases and associated topics.. I am looking
some works on set theory, algebra, or any other books/papers
on the mechanics that databases are
I've been searching the documentation and I've tried ALTER ROLE,
REVOKE, etc etc etc & can't seem to find anything that shows me how to
remove membership roles from a particular user / role. I've granted a
user name 'david' a member of 'finance' role but how do I remove the
role membership from 'da
Wim Bertels wrote:
>
> \qecho doenst interpret parameters it just echo text, in this case 'ECHO
> queries'
Seems like you had two problems and I didn't see any reference to the second
one initially. The first was the output of \echo going to the wrong place
which is fixed by using \qecho.
The s
One last question. Are there any pitfalls if I roll my own ability to check
for duplicate calls?
Since I am using my own defined data type, and my own function, I could
do this by:
1. in my data type X, adding fields for: a table oid, a row oid, a copy
of a reference to the last 2nd argument,
On Friday, February 04, 2011 4:35:22 am Andreas Laggner wrote:
> Hi list,
>
> i did a dump (one table)
> pg_dump -t tempo.lucas_p1000 -Fc -o -h 134.110.37.20 -p 5432 -U andi -W
> gis > /disk2/samba/exportdb/postgres/lucas_p1000_test.out
>
> and when a want to restore the table
> pg_restore -d g
Hi list,
i did a dump (one table)
pg_dump -t tempo.lucas_p1000 -Fc -o -h 134.110.37.20 -p 5432 -U andi -W
gis > /disk2/samba/exportdb/postgres/lucas_p1000_test.out
and when a want to restore the table
pg_restore -d gis -t tempo.lucas_p1000 -Fc -v -h 134.110.37.20 -p 5432
-U andi -W /disk2/sa
On 3 February 2011 13:58, Thom Brown wrote:
> On 3 February 2011 13:32, Thom Brown wrote:
>> Actually, further testing indicates this causes other problems:
>>
>> postgres=# SELECT x FROM generate_series(1, 9,-1) AS a(x);
>> x
>> ---
>> 1
>> (1 row)
>>
>> Should return no rows.
>>
>> postgres=#
Hi,
I have following issue: I have several users with one role (and may have new
users with the same role in the future so the role creation is justified).
So I created:
ALTER ROLE MY_ROLE SET search_path='my_schema';
But after doing it my_user (either existing or newly created) still cannot see
On Fri, 2011-02-04 at 03:23 -0800, Bosco Rama wrote:
> Wim Bertels wrote:
> > On Wed, 2011-02-02 at 12:49 -0800, Bosco Rama wrote:
> >> Wim Bertels wrote:
> >> >
> >> > --user2
> >> > SET SESSION AUTHORIZATION user2;
> >> > \pset format latex
> >> > \echo ECHO queries
> >> > \o report/test_user2.t
Wim Bertels wrote:
> On Wed, 2011-02-02 at 12:49 -0800, Bosco Rama wrote:
>> Wim Bertels wrote:
>> >
>> > --user2
>> > SET SESSION AUTHORIZATION user2;
>> > \pset format latex
>> > \echo ECHO queries
>> > \o report/test_user2.tex
>> > \i structure/test_user2.sql
>> > "
>> >
>> > This doenst seem
On Wed, 2011-02-02 at 12:49 -0800, Bosco Rama wrote:
> Wim Bertels wrote:
> >
> > --user2
> > SET SESSION AUTHORIZATION user2;
> > \pset format latex
> > \echo ECHO queries
> > \o report/test_user2.tex
> > \i structure/test_user2.sql
> > "
> >
> > This doenst seem to work,
> > as the ECHO queries
25 matches
Mail list logo