Hi All,
I think there is a bug in "CREATE" script for ENUM types created in public
schema.
When You execute command:
CREATE TYPE public."MyEnum" AS ENUM
('first','second', 'middle', 'last');
and You use "Create Script" functionality in pgAdmin, the script looks like
this:
-- Type: " MyEnum "
-- D
, September 26, 2011 09:02 AM
Do: bdmyt...@eranet.pl
Kopia: pgadmin-support@postgresql.org
Temat: Re: [pgadmin-support] ENUM type script in pgAdmin 1.14.0
On Sun, 2011-09-25 at 23:13 +0200, bdmyt...@eranet.pl wrote:
> Hi All,
> I think there is a bug in "CREATE" script for ENUM types
o]
Wys?ane: Monday, September 26, 2011 09:12 AM
Do: bdmyt...@eranet.pl
Kopia: pgadmin-support@postgresql.org
Temat: Re: [pgadmin-support] ENUM type script in pgAdmin 1.14.0
On Mon, 2011-09-26 at 09:07 +0200, bdmyt...@eranet.pl wrote:
> Thanks for reply,
> Maybe my post was not clear, but this bug
Hello all,
I have noticed there is no possibility to add/check/revoke TRUCNATE privilege
on table using GUI flags.
There is no flag TRUNCATE in privilege list and it is not visible in SQL script
window too.
The only way to see TRUNCATE privilege is to check table properties and look
for "D" priv
Hi all,
I think there is a bug in refresh table stats functionality.
Scenario is:
1. Click on "Tables" node in DB objects tree
2. Click on "Stats" tab - You can see correct stats for all tables in schema
3. Click on particular table in DB objects tree (stats has been changed to
present selected ta
Hello All,
I found problem with dynamic filtering of column types during tabele
creation/column modification using GUI.
It is impossible to start typing column type, it is only possible to select
column type form the drop down menu. Field is not "read only", but it is not
possible to type any le
HI All,
I think it is good idea to implement object comparer. It could be used to
compare objects definitions in developer enviroment and production enviroment.
Right now I need to manually extract definitions to separete sql files (or use
pg_dump) and then comapre files with external tool. Inte
HI all,
I think, there is little bug in column privilage mechanism. The bug occures
when You try to set column privilages using user name who has no rights to do
this.
For table there is no tab "Privilages", for columns it exists and accepts
configuration. Even when You accept Your configuration
ssue a warning message if no grant options are
held, while the other forms will issue a warning if grant options for any of
the privileges specifically named in the command are not held. (In principle
these statements apply to the object owner as well, but since the owner is
always treated as holdi
ds,
Bartek
--- Oryginalna wiadomo?? ---
Od: Guillaume Lelarge [mailto: guilla...@lelarge.info]
Wys?ane: Wednesday, January 25, 2012 11:11 PM
Do: bdmyt...@eranet.pl
Kopia: pgadmin-support@postgresql.org
Temat: Re: [pgadmin-support] column level privilages error
On Wed, 2012-01-25 at 13:01 +0
January 26, 2012 10:14 PM
Do: bdmyt...@eranet.pl
Kopia: pgadmin-support@postgresql.org
Temat: Re: [pgadmin-support] column level privilages error
On Thu, 2012-01-26 at 08:20 +0100, bdmyt...@eranet.pl wrote:
> Thanks,
> I manually edited table script (there was DEFAULT nextaval...) so
ARNING, so maybe it is good idea to treat WARNINGS in the same way
as ERRORS?
Hope You will find elegant solution.
Regards,
Bartek
--- Oryginalna wiadomo?? ---
Od: Guillaume Lelarge [mailto: guilla...@lelarge.info]
Wys?ane: Monday, January 30, 2012 05:17 PM
Do: bdmyt...@eranet.pl
Kopia: pgadmin-suppo
Hi,
I executed SQL like this one:
ALTER TABLE "public"."tblTest" SET (
autovacuum_vacuum_scale_factor = 0.002,
autovacuum_analyze_scale_factor = 0.001
);
to set custom autovacuum parameters. pgAdmin in table property tab shows 0 for
vacuum and analyze scale factors instead of 0.002 and 0.001. Scri
autovacuum .
PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit on Windows Serwer
2008 R2 Standard.
Regards,
Bartek
--- Oryginalna wiadomo?? ---
Od: Guillaume Lelarge [mailto: guilla...@lelarge.info]
Wys?ane: Wednesday, February 1, 2012 09:58 AM
Do: bdmyt...@eranet.pl
Kopia: pgadmin-support
Hi,
I found strange GUI behaviour during enabling/disabling trigger.
When You disable trigger under the table node (trigger node is extended to
prestent trigger function) then the trigger function node is duplicated, when
You enable this trigger again (trigger node is still extended) then the tri
15 matches
Mail list logo
