All,
I've just been trying to setup some updateable views using standard views
and associated rules. Is there any possibility of when you open a view in
the SQL editor the SQL for the associated rules also show up. It would seem
to make sense. When a view is dropped the rules are silently dr
novnov wrote:
My 1.4.2 pgAdmin was installed with the windows version of postgres 8.1. I
pointed the 1.6.0 installer at the location that 1.4.2 was installed but
somehow both versions are still alive. I don't see a way to specifically
undo the 1.4.2 installation that came with pgsql. I don't see
My 1.4.2 pgAdmin was installed with the windows version of postgres 8.1. I
pointed the 1.6.0 installer at the location that 1.4.2 was installed but
somehow both versions are still alive. I don't see a way to specifically
undo the 1.4.2 installation that came with pgsql. I don't see a need to have
Hi developers! Hi Dave!
Testing 1.6.1 rev: 5646:5664M, client Win XP. Host Debian Sarge, PG 8.1.4
I noticed that primary key and unique constraints (both create an index)
are listed twice in the object tree, under "Indexes" and "Constraints".
In 1.4.3 those were only listed under "Constraints".
I was under the impression that pgsql supported calculated columns in tables,
but don't see a way to implement via pgAdmin and can't find anything on the
subject in the pgsql docs. Are calculated columns supported?
--
View this message in context:
http://www.nabble.com/Can-tables-have-calculated
Hi, Ezequias,
Ezequias Rodrigues da Rocha wrote:
> I need to create some jobs on my database but I can't find out the
> pgagent (executable). Can someone help me in this challenger ?
At least on debian, pgagent has its own package, and is compiled out of
the pgadmin3-sources.
HTH,
Markus
--
M
Andrus wrote:
To reproduce:
create table foo ( bar char(20));
CREATE UNIQUE INDEX bar_pattern_idx ON foo(LOWER(bar) text_pattern_ops);
Observed in pgAdmin 1.6 post beta-1 table definition pane:
CREATE UNIQUE INDEX bar_pattern_idx
ON foo
USING btree
(lower(bar::text));
Expected:
text_pa
