If you attempt to connect to a PostgreSQL server that doesn't respond,
you get a popup dialog with:
pgAdmin III Guru Hint - Server not listening
As the window title. However, the actual help page it displays is all
about Primary Keys.
---(end of broadcast)--
Latest bundled with what? That bug was fixed already:
2006-02-17 DP 1.4.2 Properly escape single quotes in connection
strings.
Ah bummer. Turns out I had 1.4.0...
Chris
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
pgAdmin version: latest bundled
OS: Windows XP
Description
---
Attempting to log into a database with pgAdmin using a password that
contains the apostrophe (') character causes this error:
"An error has occurred.
Error connecting to the server: missing "=" after "asdf" in connection
"ERROR: variable not found in subplan target lists"
After to accept that message I can work without problems with the database.
This error happens only once, the first time when I open the database. This
error doesn't appear with databases without a vacuum process seted up.
This is the information
In what way is it corrupted? Please give us all error messages and
stuff logged by PostgreSQL.
I suggest joining the irc.freenode.org IRC server and joining the
#postgresql channel if you want real time help.
Chris
Ramesh Yeligar wrote:
Hi,
We are using PGSQL for retail business server. Yester
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Is there a way to implement the pg_dump from within pgAdminIII? If
so, how?
Of course, all you need is a C++ compiler and some spare time :-)
You could code a graphical frontend for pg_dump/pg_restore, which is on
the pgadmin3 TODO list anyway.
Just do what we do with phpPgAdmin - we just ope
When I try to create a new column with the varchar datatype I obtain a
"varchar[]" type, and I cannot specify the max limit. What is the problem?
You are going VARCHAR[n] instead of the correct VARCHAR(n)
Chris
---(end of broadcast)---
TIP 8: expl
Shhh, didn't think of that. So we won't ever accept unique indices for
this.
What we do in phpPgAdmin is that rows with NULL values in the unique key
simply aren't editable - all other rows are though.
In order, we prefer to use a PK (since it is indexed), then oid column
(since it is complete)
Not true. Currently, you need either OID *or* a primary key. Obviously,
that id column should get a pk.
We'll extend the grid some time, to accept any other unique keys also.
Still, defining a PK on every table is best practice.
Defining a column as serial does *not* guarantee it's unique!
Rememb
In phpPgAdmin, we list them separately as well, however it did require
some thinking. In the end I decided to display things in the way the
SQL spec lays them out. All constraints together, etc.
And do you display indexes which are automatically generated by PRIMARY
KEY constraint?
No. The ind
I can't completely agree with you. I use only PostgreSQL, but I used to
help my colleague working with Oracle (he was a novice), and I looked at
his result of EXPLAIN (it was different from what PostgreSQL gives, but
quite clear). I am not sure that in every database engine PRIMARY KEY
constraint i
Hello, I am having problems connecting to my PG server from PG Admin
III ver 1.02 on a remote PC. I am getting an error saying that PG must
be version > than 7.3. Is there a way to bypass that?
yeah. you have 2 options:
1) Use PG AdminII for Postgresql <7.3
2) Upgrade your database to 7.3 or
It's the keyboard -- just got a new MS keyboard at work and didn't
notice it has an 'F Lock' key at the top, near Scroll Lock. I must
have hit wit inadvertently, and thereby disabled the F keys.
The F lock is the single most annoying keyboard development EVER. And I
thought over the last few
serial isn't a true datatype but a keyword that can be used only at
creation time. Still, pgAdmin3 should create the commands necessary for
this to make life easier; I added this as a TODO item.
The problem will be recording the dependency properly in pg_depend...
Chris
You cannot add a serial column after table creation time in PostgreSQL.
Chris
David Sigeti wrote:
Dear Pgadmin Folks,
I am using pgadminIII 1.0.2 with PostgreSQL 7.4 under W2K SP4 and Cygwin
(current as of 2 or 3 weeks ago). The server is running locally.
If I attempt to add an column of typ
We have Find Object in pga2, though it does little more than search the
object heirarchy (everything in pga2 is driven through pgSchema, which
is a self-building object hierarchy - basically what you see on the
treeview & listview, plus create() and drop() etc. in the relevant
places)
Ours is a gig
Actually, are you guys BSD licensed or GPL'd? phpPgAdmin is GPL'd.
Neither, we use the Artistic Licence, the same as Perl.
Does that mean our codebases are compatible or not? If so, to what degree?
Chris
---(end of broadcast)---
TIP 3: if posti
Yes, you're right, that's a bug; fixed in cvs.
Though I consider a table without PK or OID buggy too... :-)
We might expand pgAdmin3 to use a unique key as PK replacement.
phpPgAdmin does the following in order to find a unique row identifier:
1. Looks for a PK
2. Looks for a Unique index. If on
If you know how to encrypt the password, we certainly could
supply the option to enter it that way...
It's just an md5 hash prefixed with 'md5' isn't it?
???
Don't you just go ALTER USER blah ENCRYPTED PASSWORD 'asdf';
And postgres itself will encrypt it for you.
Your SQL view should show wh
mycolumn int4 DEFAULT nextval("'mycolumn_seq'"::text) NOT NULL
^^^^
this is the error -> ' "
and correct it should be:
mycolumn int4 DEFAULT nextval('myschema.mycolumn_seq'::text) NOT NULL
^^
I see your points. So how is the best way to implement this type of "set" idea
in something like postgres? Say I have a column named primary colors, and I
want to limit this to red, blue, and yellow. How is the best way to do this
without a mysql set?
CREATE TABLE foo (
color varchar(
Odd that it is a selectable datatype in pgadmin then huh?
That's a question for the pgAdmin guys, but I know that PostgreSQL has a
type called 'set', which is nothing to do with sets as you understand
them.
If there are no sets, then is there anythign else that can be used to
represent that ty
U...PostgreSQL doesn't support sets...
Chris
[EMAIL PROTECTED] wrote:
When I add a column a table I am able to choose the SET DataType, but there is
no obvious way to define the acceptable values for the set.
I'd like to use the gui that I use for creating all my other columns rather
than
Unfortunately this is not possible because PostgreSQL doesn't retain the
original SQL entered (see the many discussions about this on the
pgsql-hackers list for details).
Yes, and I had quite some fights to get this pretty-print functions into
the backend for guys like us that don't like dozens
I'm not sure what you mean here. Views don't have column defaults, only
the underlying relations do. How would you expect that to be expressed
in SQL (which pg_dump didn't do when I tried it btw)?
Not true, views can explicitly have defaults.
Chris
---(end of broadcast)
Fixed in head and branch. dlgIndexConstraint::GetSql() was
hard-coded to
"PRIMARY KEY" instead of
wxString(typeList[objectType].typeName).Upper().
Cool, thanks. Did you get the frogfrog thing as well? I noticed that
when adding a UNIQUE constraint from the table prop dialogue.
Regards, Dave.
1. When you change the statistics target of a column, eg:
ALTER TABLE foo ALTER COLUMN bar SET STATISTICS 1000;
It is not reflected in the 'code view' for the column object.
2. On WinXP, using pgAdmin 3 1.0.0 and connecting to Cygwin pgsql 7.3.4,
I get these message while connecting to the serv
28 matches
Mail list logo
