Ezequias Rodrigues da Rocha a écrit :
> Now I am with the pgAdmin 1.6 Beta 2 and it shows some more fields I
> don't want to see,
>
> Could someone tell me why and how to hide it ?
>
Are you sure you didn't check menu View/System Objects ?
--
Guillaume.
---(end of br
Joe Kramer a ecrit le 06/10/2006 17:44:
I had similar problem with 1.6 b 1, It was possible to create tables
only with "character varying", not varchar.
And problem was when trying to insert/delete from such table I got
message about "character varying" type cannot be found. I can't
reproduce thi
Laurent ROCHE a ecrit le 07/12/2006 10:45:
Any news about this problem, anyone ?
Sorry I didn't had the time to work on this yesterday. I'll check this
tonight.
Regards.
--
Guillaume.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the post
Dave Page a ecrit le 05/12/2006 15:19:
Laurent ROCHE wrote:
Sorry, more details :
I am running PgAdmin III on Windows XP against a PosgreSQL 8.1 server
on Linux (Ubuntu 6.06).
I have downloaded PgAdmin from the PgAdmin web site.
I am indeed talking about the Query tool.
If I type in and run
Dave Page a écrit :
> Laurent ROCHE wrote:
>> And in French language, the options group box is too small: the text
>> for the checboxes labels is over the right side of the box.
>
> Guillaume; can that be fixed in the translation, or do we need to hack
> the dialogue about?
>
We can fix a string
Laurent ROCHE a écrit :
> Any news about that one ?
>
I still can't reproduce it. My databases are also in UTF-8. Some are in
LATIN1. I tried with en and fr pgAdmin. I have no problem. But I'm using
1.6.2. Perhaps Dave already fixed it ?
Regards.
--
Guillaume.
---(e
yychen a écrit :
> SERVER running postgresql on
> port 5432 for ver 7.1.14
> port 5439 for ver 8.2.0
>
> While PgAdmin 1.6.1 connecting to SERVER:5439 !
> Success connection ..but
> (1) show pg version is 7.1.14
> (2) show no database in it!
>
It works for me. I tried with
port 5432 wi
Andy Shellam (Mailing Lists) a écrit :
>
>> I still can't reproduce it. My databases are also in UTF-8. Some are in
>> LATIN1. I tried with en and fr pgAdmin. I have no problem. But I'm using
>> 1.6.2. Perhaps Dave already fixed it ?
>>
>> Regards.
>>
> I was wondering - where are you using 1.6
Marian POPESCU a ecrit le 20/12/2006 11:27:
Given the fact that it's such a pain to develop PgAdmin with wxWidgets, how
about a GPLd library written in C++ and that offers the same base for
Windows, Linux and Mac?
I don't understand why you think it is painful to develop with
wxWidgets. Can y
Marian POPESCU a ecrit le 20/12/2006 11:57:
Well, for me it seems that there were some serious efforts to overcome bugs
in wxWidgets; today there is no PgAdmin3 1.6.1 for Fedora available: wxW
2.8.x was not released ...
This is a package issue. A packager can compile pgAdmin with wxWidget
stat
Dave Page a ecrit le 10/01/2007 10:56:
Laurent ROCHE wrote:
But the problem is that using pg_dump does not produce the same file format
than PG Admin (re: SERIAL, see on of my previous post). So you are using the
pg_dump routine when I use the command line: it's different anyway with
differen
Dave Page a ecrit le 15/01/2007 17:46:
Did you get a chance to look at this Guillaume?
I already looked at this and wasn't able to reproduce it. I will try
again tonight. Perhaps I missed something.
Regards.
--
Guillaume.
---(end of broadcast)-
Laurent ROCHE a écrit :
> Thanks Guillaume, for having a look again.
>
> Last time, you looked: I had 1.6.1 and you were using 1.6.2 (kind of beta:
> from the source), and we thought it will be solved with the new version.
> But it's not !
>
> I have done a new test: I create a new db with UTF8,
Jessica Fendos a ecrit le 13/02/2007 17:04:
I used pgAdminIII about 10 days ago and today, when I tried to access, I
got an error: *The ordinal 2821 could not be located in the dynamic link
library LIBEAY32.dll. *
**
I advise how I can solve this problelm. Thanks for your time.
It seems som
Hi all,
We actually have 13 published translations for pgAdmin. And we have lots
of unmaintained and out of date translations.
9 of them are above 50%. It can be rather quick to update those. So, I'm
looking for people who can take care of these translations. For example,
we have serbian (54
Clodoaldo a ecrit le 21/02/2007 13:29:
I'm using 1.6.2 in FC5
I have created a pt_BR dir in /usr/local/pgadmin3/share/pgadmin3/i18n
and copied the pgadmin3.mo pt_BR file into it.
Perhaps /usr/local/pgadmin3/share/pgadmin3/i18n is not the right directory ?
It just tried on my windows machine.
Seb a écrit :
Hi,
I'm exploring ways to interact with postgresql through a GUI. I'm in a
Debian testing system (AMD64) and have found very few options. I really
like pgadmin for the administrative tasks with postgresql, but I'm looking
for something for day to day data entry, querying, and rep
Laurent ROCHE a écrit :
I though I had a pal ;-) ... I am on my own again (see Erwin answer below).
Guillaume have you managed to do more testing, on a Ubuntu machine ?
Yes. And I can't find a way to get the same issue as you.
I'm really sorry about this. What really bugs me is that I don't
Laurent ROCHE a ecrit le 09/03/2007 12:58:
Is there an easy way (in one go) to change the owner of all database objects
with PG Admin ?
I am creating a schema with a script that assign the objects owner to login (I
mean conection role) A .
Then I switch the schema owner to login (/conection r
Bonjour,
David BOCCOU a ecrit le 29/03/2007 10:03:
Dites le moi si je suis aveugle ou simplet, mais je ne parviens pas à
trouver le module d’import export de données (celui pour lequel on
trouve une belle capture d’écran dans l’aide), pouvez-vous m’aider s’il
vous plaît ?
Cette liste de di
Hi Erwin,
Erwin Brandstetter a écrit :
Testing pgAdmin III v1.6.3 rev: 6112, client Win XP, host: Debian Sarge,
PG 8.1.8.
A minor thing ..
In the dialogue window for the filter of the filtered table view, the
input field for the SQL filter has been shrunk in v1.6.3. As the
dialogue is otherw
shieldy a écrit :
after i have click the add server
and get the new server Registration dialogue
but I just didnot know how to fill the dialogue,
anyone can help me ? thank you!
btw: I have install postgresql 8.2 for windows on my computer.
Read this :
http://www.pgadmin.org/docs/1.6/conn
sami jan a écrit :
I wanted to write some code in pgAdminIII, just to learn the ropes,
but I am not sure where to start. Does pgAdminIII have a how-to kind
of document for newbies to its dev environment?
Not really. This link, http://www.pgadmin.org/download/source.php,
documents how to compi
Dave Page a écrit :
Guillaume Lelarge wrote:
sami jan a écrit :
For a start, how do you edit the widgets, is there a form designer?
I don't know of any form designer. You need to edit the xrc file
manually and I think you have to execute the embed-xrc.bat batch file
after your ch
Hi Laurent,
Laurent ROCHE a écrit :
As
I have managed to get error messages displaying correctly in PG-Admin
The correct spelling is pgAdmin :)
(thanks to a correct configuration on the PG Server), I have switched
to version 1.6.3, and I am sending this request feature list (I know
it's not
[EMAIL PROTECTED] a écrit :
Is there a way to change the order of the servers in the Servers list?
It'd be nice if they were alphabetically sorted.
The patch attached sorts them alphabetically. As it changes the
behavior, perhaps an option is needed to enable it. Dave, what do you
think ab
Dave Page a écrit :
Guillaume Lelarge wrote:
I can take care of this :
- update the button's title ;
- grow the Replace button.
Dave, do you agree on this ?
Sure, go ahead.
Here it is.
Regards.
--
Guillaume.
Index: pgadmin/ui/dlgFindReplac
Dave Page a écrit :
Guillaume Lelarge wrote:
[EMAIL PROTECTED] a écrit :
Is there a way to change the order of the servers in the Servers list?
It'd be nice if they were alphabetically sorted.
The patch attached sorts them alphabetically. As it changes the
behavior, perhaps an opti
Dave Page a écrit :
Guillaume Lelarge wrote:
Dave Page a écrit :
Guillaume Lelarge wrote:
I can take care of this :
- update the button's title ;
- grow the Replace button.
Dave, do you agree on this ?
Sure, go ahead.
Here it is.
Please run the embed-xrc script and commit.
I
Dave Page a écrit :
> [...]
> BTW; did you fix that SQL formatting error that Erwin reported?
>
Here is the patch that fixes it.
Regards.
--
Guillaume.
Index: pgadmin/schema/pgTable.cpp
===
--- pgadmin/schema/pgTable.cpp (révis
Dave Page a écrit :
> Guillaume Lelarge wrote:
>> I didn't change the CHANGELOG file. Should I edit it for such small
>> commits ?
>
> Nah, I wouldn't bother.
>
Sorry, I did it this morning with the "Sort servers' list
alphabetically." patch.
Laurent ROCHE a écrit :
> Another feature request:
> I would like to be able to rename a database by right clicking on a database
> and choosing Rename from the context menu (which does not exist right now).
>
> I know I can do the same thing by opening a query window and writing a ALTER
> DATAB
Hi,
Andreas Kutschke a écrit :
> on Linux i cannot open the attached SQL-File in the "PgAdmin III Query".
> On Windows (XP) there are no problems.
> I choose the directory (nfs-mounted) and then the file. On "open" the
> file selection box closes, but nothing happens.
> Other sql-Files from the sa
Raymond O'Donnell a écrit :
> On 18/06/2007 17:50, Laurent ROCHE wrote:
>
>> However my server is PG 8.1 and this is 8.2 syntax. I understand
>> pgAdmin runs a standard pg_dump but I would expect it to run a
>> version compatible with my server ! ? !
>
> I run the Windows version of pgAdmin, and
Laurent ROCHE a écrit :
> Just to clarify what I mean.
> I am quite happy (or should I say: not too unhappy) to juggle with different
> version of pg_dump in my scripts.
> If that's the way it has to be, that's the way it has to be.
> See point A, below.
>
> But to me pgAdmin is a tool that must
Francis DOGBE a écrit :
> Voudriez-vous bien me fournir un support sur le PgAdmin III ?
>
Cette liste de discussion est en anglais uniquement.
De plus, j'avoue ne pas avoir bien compris votre question. Pouvez-vous
expliquer plus précisément ce que vous voulez ?
Merci.
--
Guillaume.
---
CaptainBalrog a écrit :
[...]
So i got a web host, IX their called, that supports pgsql but when i looked
at the database tools on their control panel it was a php interface with no
backup or restore options just your basic tables, sequences, functions.
So i connected to the IX database through p
Rosiński Krzysztof 2 a écrit :
> After change "databases" checkbox view can`t be restored.
> Default button not works.
>
Can you explain a bit more ?
Regards.
--
Guillaume.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Jason L. Buberel a écrit :
> I am running this on an updated Ubuntu Feisty with the following
> wxWidgets installation:
>
> [EMAIL PROTECTED] ~/d/pgadmin3-1.8.0-beta1> wx-config --list
>
> Default config is gtk2-unicode-release-2.8
>
> Default config will be used for output
>
> Alternat
Hi Pavel,
Pavel Stěhule a écrit :
> I am testing new beta. I found small bug. Button Ok is disabled in
> function property dialog when language plpgsql is chosen.
>
When you add a new function, before pgAdmin enables the OK button, you
need to specify the name, the return type, the language and
Pavel Stěhule a écrit :
> I would to test debugger with postgresql. Is possible somewhere download
> server debugger support?
>
I don't think it's available for native PostgreSQL. AFAIK, it's only
available with EnterpriseDB Advanced Server. Or perhaps Dave can share
with us a really good news ?
Olivier Bouiron a écrit :
> The problem only happen when I edit just the 100 last lines of the table.
> This is how i do:
> 1)I edit just the 100 last lines of the table using the popup menu
> 2)Click on the cell I want to edit
> 3)Tape the new value
> 4)'Enter'
> 5)Then I can close the frame or cl
Guillaume Lelarge a écrit :
> Olivier Bouiron a écrit :
>> The problem only happen when I edit just the 100 last lines of the table.
>> This is how i do:
>> 1)I edit just the 100 last lines of the table using the popup menu
>> 2)Click on the cell I want to edit
>>
Dave Page a écrit :
> Jack wrote:
>> Hi, all
>>
>> I tried to use "set search_path to x1, x2, public" for postgreSQL
>> when doing a connection. After that, I won't specify schema for
>> any database object in sql, or plpgsql for postgreSQL will search it by
>> the order I set at the connection.
Henry Valéry TEGUIAK a écrit :
> bonjour,
> j'utilise pgAdmin III et j'aimerai avoir un support pouvant m'aider à
> bien l'utiliser.
>
Ceci une liste de discussion en anglais seulement. Merci d'utiliser
l'anglais dans vos messages. Si vous ne parlez pas anglais,
contactez-moi directement.
De qu
Hi,
Taras Kopets a écrit :
> When I select functions which returns SETOF in "Object browser" to get
> their definitions I have 2 duplicating lines with text RETURNS SETOF.
> See examples below.
> [Version 1.8.0 Beta 2 (Jul 25 2007, rev: 6486)].
>
> CREATE OR REPLACE FUNCTION ...
> RETURNS S
Derrick Betts a écrit :
> Using Postgres 8.2 on Linux based system.
> Using PgAdmin III Beta 3 on Windows XP SP2.
>
> I utilize the following process to login to the 8.2 database with
> PgAdmin III Beta 3 from Windows XP.
>Open PuTty.exe to create a secure connection to the database.
>Open
Sebastiaan van Stijn a écrit :
> I just downloaded and installed pgAdmin III 1.8 beta 3, however, when I
> connect to a database, I get the following error:
>
>
> ERROR: Syntax error at or near "pg_get_userbyid"
> LINE 1: ...T ts.oid, spcname, spclocation, '' AS description pg_get_use...
>
>
>
Harald Armin Massa a écrit :
> trying the new 1.8 Beta 3 with german locale, on connecting to a
> PostgreSQL 8.1.4 Server the followin error gets reported:
>
> ERROR: syntax error at or near "pg_get_userbyid"
>
> Line 1: ...T ts.oid, spcname, spclocation, '' as description pg_get_use...
>
> the
Marcin Zajączkowski a écrit :
> On 2007-08-20 16:40, Milen A. Radev wrote:
>> Marcin Zajączkowski написа:
>>> While editing text in a scratch pad (in a edit data window) delete key
>>> doesn't work (does nothing).
>>> Tested with snapshot 2007-06-19.
>>
>> Wow - that's a pretty old snapshot. Works
Laurent Yaish a écrit :
> upon connecting to the database I get:
>
> An error has occured:
>
> ERROR: syntax error at or near "pg_get_userbyid"
> LINE 1: ... T ts.oid, spcname, spclocation, " AS secription pg_get_use...
>
> I am running postgresql 8.1.2 on redhat
> Let me know if you need more i
Cedric Job a écrit :
> Il apparemment possible d’obtenir un support sur pgAdmin. Si tel est le
> cas merci de m’indiquer une url de téléchargement.
Ceci une liste de discussion en anglais seulement. Merci d'utiliser
l'anglais dans vos messages. Si vous ne parlez pas anglais,
contactez-moi directem
Laurent Yaish a écrit :
> Hi Rob,
>
> In your insert, do not explicitly specify a value for the primary key,
> instead use NEXTVAL('client_alerts_seq') which will return the next
> valid value and increment the sequence.
>
> i.e:
> insert into clients_alerts (id, client_id, alert_message,
> aler
Jérôme Steffe a écrit :
> Serait-il possible de m’envoyer un support sur l’utilisation de Pgadmin.
>
Ceci une liste de discussion en anglais seulement. Merci d'utiliser
l'anglais dans vos messages. Si vous ne parlez pas anglais,
contactez-moi directement.
De quel type de support avez-vous besoin
Olivier Bouiron a écrit :
> I've found a mistake using PGADMIN 1.6 or PGADMIN 1.8 beta5:
> When I make a sequence with negative values, it works but PGADMIN is not
> able to show me the correct values.
>
> This is an exemple:
> PGADMIN shows me this:
>
> CREATE SEQUENCE dsi.dsi_pha_molecule_id_se
Guillaume Lelarge a écrit :
> Olivier Bouiron a écrit :
>> I've found a mistake using PGADMIN 1.6 or PGADMIN 1.8 beta5:
>> When I make a sequence with negative values, it works but PGADMIN is not
>> able to show me the correct values.
>>[...]
>
> Well, they
George Pavlov a écrit :
> this might be a bug or me misunderstanding how things work (in which
> case please help). in pgadmin 1.6.* selecting view/system objects
> results in system objects (such as the information_schema and pg_catalog
> schemas) showing in the tree view. i am guessing that for 1
[EMAIL PROTECTED] a écrit :
> to go with INSERT, DELETE, etc.
I don't see much interest in a TRUNCATE script because there's nothing
more to add on the script. How about a simple "Truncate" or "Empty
Table" menu in the contextual menu ? For exemple, just before the
"Delete" menu ? It would execute
Hi,
Rikard Pavelic a écrit :
> I'd like to report a bug with PgAdmin 1.8 beta 5
>
Thanks.
> If function has in and out parameters like this
> function function_name(out,in,in,out)
>
> PgAdmin will create wrong DDL commands
> It will create command
> ALTER FUNCTION function_name(,in,in);
> inst
Hi Andrew,
Andrew Lazarus a écrit :
> Wednesday, October 3, 2007, 1:12:52 AM, you wrote:
>
> GL> [EMAIL PROTECTED] a écrit :
>>> to go with INSERT, DELETE, etc.
>
> GL> I don't see much interest in a TRUNCATE script because there's nothing
> GL> more to add on the script. How about a simple "Tru
Kieran McCusker a écrit :
> Another report - I couldn't find an earlier report (although I only had
> a quick look).
>
> Do the following :-
> 1. Menu -> Tools -> Query tool
> 2. type any character
> 3. Menu -> File -> Recent file -> then choose any file in the list
>
> pgadmin throws up a dialog
Kieran McCusker a écrit :
> Sorry I sent the mail too soon!
>
> There is an extra behaviour whereby if you cancel the dialog and then
> try to close the window it prompts you to overwrite the recent file you
> tried to open.
>
My previous fix takes care of this too.
Regards.
--
Guillaume.
h
Jürgen Spatz a écrit :
> I’m testing the Beta 2 of PG-Admin 1.8 and I have the Problem that I
> cannot see my aggregate functions. In the 1.6.3 I could see them direct
> under the public schema, but in the 1.8 I don’t have that section.
>
Did you enable its display on File/Options, display tab ?
Hi,
Rolf A. de By a écrit :
> I am running on a PG server 8.2, Windows XP, trying the following and
> getting a run time error plus crash of pgadmin
>
> 1. open my database, navigate to Tables
> 2. right click, to New Table option
> 3. Fill out table name, owner, inherit from one already existing
Ariel R. Giomi a écrit :
> Hello, I speak little English language but try to understand me.
>
> I am running "PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC
> gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)" on a remote server
> and running pgadminiii 1.8.0 RC1 on windows xp (ES)
>
>
Albin Blaschka a écrit :
> I just discovered the following problem with PGAdmin 1.8 RC1 (on WinXP)
> I have a server where still PostgreSQL version 7.4.7 is running (Debian
> Sarge). I created a table with PGAdmin, finished (which went fine) and
> added a little bit later some more columns.
> PGAdm
Horvath Gabor a écrit :
> On 9/24/07, Dave Page <[EMAIL PROTECTED]> wrote:
>> Horvath Gabor wrote:
>>> pgAdminIII v1.8-Beta5
>>> Windows XP
>>> PostgreSQL 8.1, linux
>>>
>>> I tried to adjust the Minimum value in the properties dialog of a sequence.
>>> I wanted to adjust the range so that the pres
Dave Page a écrit :
> Guillaume Lelarge wrote:
>>> I guess the general ordering of the statements should be as follows:
>>> 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the range
>>> 2 SETVAL
>>> 3 Any ALTER SEQUENCE MIN/MAXVALUE statements tha
Dave Page a écrit :
> Guillaume Lelarge wrote:
>> Dave Page a écrit :
>>> Guillaume Lelarge wrote:
>>>>> I guess the general ordering of the statements should be as follows:
>>>>> 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the ran
Dave Page a écrit :
> Laurent ROCHE wrote:
>> * Translation Errors
>>
>> - Sequence Start in French Version
>> When editing a SEQUENCE the START value is translated by "Valeur
>> Actuelle" which roughly translated would be "Last value", I would think
>> a better translation should be "Prochain
frank_lupo a écrit :
I'm usign *pgAdmin1.6.3 (Mar 23 2007, rv: 6112), *when press copy button
toolbar a empty table pgAdmin crash.
Here is a patch to fix this in 1.8.
Dave, can you apply it ? I don't have access to the svn server because
I'm on the PostgreSQLfr booth at the JDLL (a free sof
Anton Andreev a écrit :
> It could be my fault, but I continue not to see the timestamp type when
> I am creating a new column in PgAdmin3?
>
You don't see "timestamp with timezone" and "timestamp without timezone"
types ? BTW, "timestamp without timezone" and "timestamp" are the same.
What do yo
Gabriel Giroux a écrit :
> I'm using GNU/Linux Ubuntu Gutsy Gibbon distribution on a Laptop where
> PostgreSQL 8.2.5 has been isntalled.
>
> I'm a newbie on Gnu/Linux OS and I would like to know if anybody in
> there has tested the new pgAdmin3 release on GNU/Linux Ubuntu Gutsy
> Gibbon distributi
zoran a écrit :
> Hi,
>
> Do buttons Add and Remove in Parameters tab have purpose?
>
They have when you're connected to a PostgreSQL 8.3 server.
Dave, do you think we should hide the parameters' tab when used with
pre-8.3 servers ? I can write a patch for this.
Regards.
--
Guillaume.
http
Laurent ROCHE a écrit :
> I would like to generate with a request a SQL order like
> UPDATE tab1
> SET col_a = ?, col_b = ? ...
> WHERE pk = ?
>
> for each table of a given schema (in fact what I want is slightly more
> complicated but if I can write the above, I will be able to get the rest).
>
Dave Page a écrit :
> Guillaume Lelarge wrote:
>> zoran a écrit :
>>> Hi,
>>>
>>> Do buttons Add and Remove in Parameters tab have purpose?
>>>
>> They have when you're connected to a PostgreSQL 8.3 server.
>>
>> Dave, do yo
Dave Page a écrit :
> Guillaume Lelarge wrote:
>> Dave Page a écrit :
>>> Guillaume Lelarge wrote:
>>>> zoran a écrit :
>>>>> Hi,
>>>>>
>>>>> Do buttons Add and Remove in Parameters tab have purpose?
>>>>&g
Dave Page a écrit :
> Guillaume Lelarge wrote:
>> Dave Page a écrit :
>>> You cannot change foo(int, int) to foo(int, int, int) because it would
>>> become a whole new function. Thus you can only add/remove parameters at
>>> initial design time.
>>>
>
Magnus Hagander a écrit :
> On Fri, Nov 16, 2007 at 12:47:36PM +, Raymond O'Donnell wrote:
>> On 16/11/2007 12:24, Dave Page wrote:
>>> Should we consider dropping official support for PostgreSQL 7.x in the
>>> next major version of pgAdmin?
>> I'd be against dropping support before 7.x is off
Hi,
Patrick Rodies wrote:
> I have installed the new version of pgadmin. I have seen that you
> display catalogs separately from schemas, and don't treat them as system
> objects any longer.
>
> My question is how can I see in your gui the procedural languages as in
> version 1.6?
>
You have
Alexander Kirpa wrote:
> [...]
> Situation:
> 1. Start PgAdmin
> 2. Connect to DB 8.2.4
> 3. Disconnect from DB
> 4. Stop 8.2.4 DB
> 5. Start 8.3beta1 instead 8.2.4
> 6. Connect to DB 8.3beta1
> 7. Try refresh DB info
> PgAdmin still display old 'Version string'
> and 'Version number' for 8.2.4 ver
Hi,
Edward Leung wrote:
> I am a fresh learner of PostgreSQL 8.2 under Windows 2000 and
> use PgAdminIII to manage the system.
>
> I wonder why I need to double-quote the table name to get
> the table result or I get the ErrorCode: 42P01 without double-quotes.
> Under the standard SQL syntax, t
Andy Shellam wrote:
I've noticed a small bug in 1.8.1 on Windows XP (SP2).
If I create a new table, and add a new serial column to it before OK'ing
the "create table" dialog, the "sequence" drop-down remains disabled for
the column.
If I create a table, and OK the dialog without any columns
Dave Page wrote:
On 14/01/2008, Andy Shellam <[EMAIL PROTECTED]> wrote:
Hi Dave,
I see your point about it not doing anything after the column is created, as
a serial column is just an integer column with a new default value. I liked
the idea of being able to specify a different sequence to us
Laurent ROCHE wrote:
So nobody is doing any reporting on the PG tables with pgAdmin ... or
even something else ?
postgresql-autodoc is an easy tool to use with many output formats. See
http://www.rbt.ca/autodoc/ for details.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
-
Mike Blackwell wrote:
Would it be possible, perhaps as an option, to display the relation
name, and possibly the type, in the Server Status Lock display?
It already does this but you only have relation names for relations
belonging to the database you're connected to (ie your maintenance
da
Mike Blackwell wrote:
Guillaume Lelarge wrote:
Mike Blackwell wrote:
Would it be possible, perhaps as an option, to display the relation
name, and possibly the type, in the Server Status Lock display?
It already does this but you only have relation names for relations
belonging to the
Mike Blackwell wrote:
Guillaume Lelarge wrote:
It's a PostgreSQL security feature. When you're connected to a
database, tables from other databases are not available (even their
names).
It's curious that
the oids are available but not the names. I should really brush off
Hi,
Josh wrote:
I have a question about the behavior of PGAdmin (or perhaps this is PG)
in creating databases.
If I create a DB while logged in as postgres, and indicate the database
owner is another login role, then PG creates the database with that
login role being the owner but everything
Obe, Regina wrote:
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 sent a patch to allow this in the next release. See
http://www.pgadmin.org
Magnus Hagander a écrit :
Dave Page wrote:
On Feb 12, 2008 9:12 PM, Peter Gagarinov <[EMAIL PROTECTED]> wrote:
1) create a simple table with two columns :
create test_table(a integer, b integer);
2) go to 'New Table.." menu, type in some table name,
3) go to 'Columns' tab, typ
Dave Page a écrit :
On Feb 13, 2008 2:56 PM, Guillaume Lelarge <[EMAIL PROTECTED]> wrote:
That's something I already heard at Solutions Linux 2008. I talked with
someone who has this kind of issues. This guy has lots of tables, so his
type combo box is really huge, and becomes actual
Glenn White a écrit :
When I try to start pgAdmin on my Fedora 8 machine it hangs at the
startup slash screen.
Rename your $HOME/.pgadmin3 configuration file and try again to launch
pgAdmin. Is it better ?
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
--
Joe Moyle a écrit :
[...]
I only see Domains, Functions, Sequences, Tables, Trigger
Functions, and Views in my schema but not my Types. Is this something
I’m just not configuring to display properly or is this type of schema
object not supported by pgAdmin III yet?
Take a look
Dave Page a écrit :
On Fri, Mar 14, 2008 at 10:28 AM, Bruce Bruen <[EMAIL PROTECTED]> wrote:
Can someone please tell me where (su) make install is installing the PgAdmin3
1.8.3 exec by default.
/usr/local/pgadmin3/bin if memory serves.
And you should have the configure command in config.lo
Julius Tuskenis a écrit :
I use Zeos components for delphi and they act the strange way.
In Server Status window (in pgAdmin) I see Exclusive lock on my server
(using pgAdmin) but cant understand what is locked, because Database and
Relation fields are left blank. What does it mean? (Attaching
Hi,
Константин Попов a écrit :
I have found some invalid translated objects in object browser.
pgAdminIII v 1.8.2 rev 7029:7030
Language ru_RU
Here are these translations^
"Group Roles"
translated as "Gruppa roley"
but should be "Gruppovie roly"
"Group Role"
translated as "Gruppa roly"
but sh
[EMAIL PROTECTED] a écrit :
Hello, how to create an index with an operator class in pgAdmin3 1.8.2 ?
On the command line i do:
CREATE INDEX idx1 ON mytab (mycolumn text_pattern_ops);
But in pgAdmin i cant find any place to add the "text_pattern_ops".
Anyone help?
In pgAdmin's "Create Index"
Melvin Davidson a écrit :
*PgAdmin III 1.8.2***
I have statistics enabled on my server. However, when I do a VACUUM
ANALYZE on my database, the count [ Rows (counted) ] is set to “not
counted”.
Now I can right click on the individual tables and select “Count” to
manually update it, bu
Stephen Denne a écrit :
Melvin Davidson a écrit :
*PgAdmin III 1.8.2***
I have statistics enabled on my server. However, when I do a VACUUM
ANALYZE on my database, the count [ Rows (counted) ] is set to “not
counted”.
Now I can right click on the individual tables and select
“Count” to
m
1 - 100 of 1487 matches
Mail list logo
