On 1.4 and above, if you expand the table with the trigger
on it, you will see a grouping called "Triggers" that lists all the triggers on
that table and shows you the
CREATE TRIGGER ...
statement.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ezequias
Ro
You maybe had added data before and then deleted it.
You can go in and change the sequence start number via pgAdmin by expanding the
sequences node, selecting the sequence in question and changing the current
value to 1 and minimum to 1.
From: [EMAIL PROTECTED]
[mailto:[EM
I'm guessing float8 is deprecated since I don't see it in the list of
options when creating fields. I have an older table that has a field of
type float8.
I'm using PgAdmin III 1.6 Beta 1, Sep 12 2006, rev: 5353 on a windows
2000 machine.
When I try to edit data in this table -> editing the
Is there a way to show line numbers in the SQL window. I didn't see the
option available. I'm running 1.6.1 Nov 30, 06 build
Thanks,
Regina
-
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt
Is there a reason why we don't have the feature in PgAdmin to move a
table from one schema to another, yet that feature has been available
since
8.1 with the ALTER TABLE SET SCHEMA ddl command?
I think it would be a convenient feature, although I guess people would
need to understand that they
Guillaume Lelarge wrote:
>I sent a patch to allow this in the next release. See
> http://www.pgadmin.org/archives/pgadmin-hackers/2007-12/msg00124.php
>for more details.
>Anyways, I still need to work on this.
> I think it would be a convenient feature, although I guess people
would
> need to
I just upgraded to 1.8.4 (I think I was running 1.8.2) and have an even
older version running on the server (1.6.2).
Today I went to a view to give permissions to some Group Roles. The
only option I get now is public. I am running PostgreSQL 8.2. Before I
would see all the groups in the Privile
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2008 7:47 AM
To: Obe, Regina
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Can't assign Group role permissions in
1.8.4
On Wed, Jun 11, 2008 at 12:31 PM, Obe, Regina
&l
There used to be a time when the binary snapshots on the pgadmin site were the
latest and greatest and newer than the latest production build. Now it seems
only the binary snapshots for slackware are the latest and greatest and things
like windows date back to 2007, much older than even the pro
> The source and slackware builds are automated on
> developer.pgadmin.org. I've fixed the source builds which were broken
> by a typo in a Makefile.
> The OSX build was an automate build run by Florian - I don't know what
> happened to that. I can probably run it on a box in my office if
> Floria
> I've uploaded a new win32 build. Use at your own risk :-p
> It's at http://developer.pgadmin.org/snapshots/win32/, and will hit
> the main website in an hour or three.
Thanks. I'll give it a try soon.
Regina
-
The substance of this message, including a
egina
From: Obe, Regina
Sent: Tue 9/9/2008 10:13 AM
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Why are binary snapshots older than binary
production release versions?
> I've uploaded a new win32 build. Use at your own ris
I was using the inherit feature in snapshot build 9/8 rev: 7457:7458
It works fine if the table I am inheriting from is in the public schema,
but if its in any other schema, it seems to quote the schema incorrectly
so it fails to find the table.
Example
ALTER TABLE census_ma_2006.arealandmarks I
This may already be fixed, but I'm still running with the last Windows Snapshot
build of (september 9th).
If I create a new table from scratch and also try to inherit in a single step,
PgAdmin crashes.
Doesn't seem to be an issue if I create a table first and then go back and
inherit.
Thanks
o SQL tab - CRASH (Seems to do this both against an 8.2 and 8.3
PostgreSQL db)
It works fine if I have a table already created and I add inheritance.
Hope that helps,
Regina
-Original Message-
From: Guillaume Lelarge [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 10:44 AM
I'm using 1.10.0 beta 2 -- the one that comes with EnterpriseDB 8.4 beta1.
When I try to create a new database and specify the collations and character
type I get error something to the effect syntax error in collate.
Looking at the SQL its generating
CREATE DATABASE testpg84
WITH ENCODING='U
I see that the new version of PgAdmin now automatically puts in for
CREATE INDEX a
the new NULLS FIRST / LAST clause for PostgreSQL 8.4.
Unfortunately when you try to use this for a gist index -- it generates
something like this
CREATE INDEX mytable_idx_the_geom
ON mytable USING gist (poi_geo
I don't seem to be able to paste into the SQL Editor in the Beta 3 ast
least under Windows XP. I recall being able to do this in prior betas
though in those cut and paste would work for a while and then suddenly
stop working. In this one paste doesn't seem to work at all.
Don't have the issue wi
much older than the link above which ironically is harder to navigate
to.
Sorry if I sound like I'm whining.
Thanks for a great admin tool,
Regina
-Original Message-
From: Obe, Regina
Sent: Fri 5/29/2009 11:29 AM
To: pgadmin-support@postgresql.org
Subject: Can't paste into
Again only slackware ones are anywhere near up to date. The windows ones
aren't even as up to date as the latest release and there is no Mac one.
http://www.pgadmin.org/snapshots/
This makes it quite difficult for people who don't have a compile environment
for PgAdmin to be able to test driv
By the way thanks PgAdmin group for releasing a new version of PgAdmin :).
I assume this is already known, but current build doesn't work with the
PostgreSQL 8.5 alpha 2. But just in case
Gives error:
column "datconfig" does not exist
and then doesn't list databases
Of course this is not a b
I assume this is a PgAdmin III bug, but I could be wrong.
I'm using PgAdmin 1.10.1 on Windows, but seems to be an issue with even 1.8
since I tried on that too.
The upcoming PostGIS 1.5 has a new type called geography that uses the Typmod
functionality introduced in 8.3.
I'm guessing this is a
Is there no way to change the schema of a table with PgAdmin aside from the
obvious
ALTER TABLE ... set schema
I looked at 1.12.0 beta also and don't see that feature present. I was
expecting to see such a feature perhaps right above or below
the change tablespace option of the table designer.
I'm new to this list so I apologize if this has already been mentioned.
After creating a job in the Postgresql 8.1dev release, and then trying to
view the job, PgAdmin III Version 1.3.0 (Sep 13 2005) crashes with error
instruction at 0x0055bfd9 referenced memory at "0x0068".
I tried viewing
I'm using the 9/19/05 build of pgAdmin with PostgreSQL 8.1-beta2 and the
pgagent.sql that comes with pgAdmin that to build the pgagent tables.
When you try to create a batch job, it fails the pga_jobstep_check
constraint on the pga_jobstep table. It appears that the editor is trying
to stuff a nu
Just figured it out. I guess you can't have "Verbose" enabled in explain
options for it to work. That should probably be put in the documentation
somewhere.
-Original Message-----
From: Obe, Regina DND\MIS
Sent: Tuesday, November 08, 2005 11:04 AM
To: 'pgadmin-su
How do you get the Graphical Explain to show? I saw the snapshots on the
PgAdmin website of the graphical explain, but on my version my explain tab
seems to stay blank regardless of what I do.
I couldn't find any mention of it in the help guide.
I'm running 1.4 release Candidate 1 on windows 200
27 matches
Mail list logo
