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
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
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 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".
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
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
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
