Hola Fabian,
Este lista es solamente en ingles.
Hay sitios en español para PostgreSQL aqui :
. http://www.postgres-arg.org
. http://www.postgresql.org.pe
Y hay una lista en español :
http://archives.postgresql.org/pgsql-es-ayuda/
Hay más aqui :
http://www.postgresql.org/community/lists/
H
Still in my case (I assume other people too) pl/pgsql functions would not help
as I work on a remote server from a workstation: I want the files on my
workstation and not on a remote server that I only access for the database !
Cheers,
l...@u
The Computing Froggy
_
Hi,
I am running pgAdmin III 8.1.4 on WinXP on a PG server 8.3.3.
I am trying to backup a single table. When doing right-click on the table and
"backup" command, it will fail because pgdump considers there's a mismatch
between the server version (8.3.3) and the pgdump version (8.3) version.
I g
Serge,
you emailed many mailing lists ... except the one you should have the
PostgreSql mailing list "[EMAIL PROTECTED]".
... and I can not help you about the mentioned problem ... sorry !
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
De : "[EMAIL PROTEC
Hi,
If you do a lot of data migration, I would recommend using an ETL tool.
I am using Talend Open Studio, which is an Open Source software. It's based on
the Eclipse framework, you define your jobs with a graphical tool (drag & drop
components : DB tables, files -Excel, CSV, XML, ...-) and the
Hi,
I have made an install of PostgreSQL on Ubuntu 7.10 with package: it installs
PG 8.2.
I have installed pgAdmin too but it installs pgAdmin 1.4 ... is this normal ?
Is there a way to get pgAdmin 1.8.x by a package on Ubuntu 7.10 ?
Just looking at http://www.pgadmin.org/download/ubuntu.php,
i
Hola Luis,
Esto es una mailing lista en ingles solo !
Ademas, se trata solo del programo pgAdmin III aquí y no de PostgreSQL Server.
Tienes un problema de conexión a PostgreSQL y no es un problema de pgAdmin pero
de configuración de PostgreSQL.
Probablemente que tienes que modificar el data/pg_h
Hi,
I have posted this on the pg main list ... and as I had no sensible answers, I
am trying here.
Also, it's likely someone knows the answer as you need to get this info to
display it in pgAdmin !
I would like to write a request where I would get the table name and column
name of a sequence.
Hi,
There is a little anomaly in the way adding an extra column is treated in
pgAdmin III 1.8.2.
... particularly if this is a NOT NULL column.
When adding the column my_col with a DEFAULT value, the code generated will be:
ALTER TABLE my_table ADD COLUMN my_col boolean;
ALTER TABLE my_table ALT
>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Jeudi, 6 Mars 2008, 17h17mn 46s
Objet : Re: [pgadmin-support] Comments on column
On Thu, Mar 6, 2008 at 3:58 PM, Laurent ROCHE <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>
> There is a li
Hi,
A Feature Request: as we can perform a DROP ... CASCADE on some objects, it
will be nice to be able to do so on columns as well.
I am talking of adding a new entry on th right clikc on columns that will
generate code like:
ALTER TABLE my_table DROP COLUMN my_column CASCADE
Have fun,
[EMAI
Hi,
There is a little bug in pgAdmin III 1.8.2 on Windows XP (at least).
If one creates a new column with comments by opening the properties of an
existing table, then going to Columns tab and clicking the Add button, the
comments will NOT be saved.
However, by adding a column directly (e.g. ri
Mike,
If I were you (actually that's what I did whne I had the same problem), I will
convert the pg_dump file from LATIN1 charset to UTF8, then copy back into the
new UTF8 database. And all should work fine.
On windows you will find that text editors like TextPad and Scite (which runs
on Linux
]
The Computing Froggy
- Message d'origine
De : Guillaume Lelarge <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Vendredi, 25 Janvier 2008, 10h31mn 18s
Objet : Re: [pgadmin-support] Re : Reporting ?
Laurent ROCHE w
Hi Dave,
I understand you have plenty of things to do as it is.
But may be being able to generate a report on many objects instead of only one
would not be such a big work.
Anyway autodoc does a good job at generating report.
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'or
Hi,
So nobody is doing any reporting on the PG tables with pgAdmin ... or even
something else ?
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Laurent ROCHE <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Envoyé le : Mercredi, 23 Janvier 20
Hi,
I am trying to generate reports for my database.
I have never used this before so I might be mising the obvious.
I would like to generate what I would call a full report : for each table of
the database, the comment on the table and for each field the definition, the
comments and dependenc
Hola Ángela,
Esto es una mailing list en Ingles solo.
This is a mailing list in English only.
La mailing list en Castellano es pgsql-es-ayuda !
Aqui esta la documentacion para PostgreSQL
http://www.postgresql.org/docs/
click a la derecha en la version que utilizas
Pero la documentacion para pgA
The only time when I have seen this (including for views), is when a data
window has been opened then the data linked object (table or view) has been
re-created(i.e. drop + create) then when doing a refresh on the data window, I
don't see the colum names any more (even if they are identical), da
Hi,
My 2€: as long as the last version supporting PG 7.x is easily downloadable
from the web ... I don't think that till be a problem; for the users.
It's just for you guys (and the PG people), to know whether this is acceptable
considering pgAdmin is packaged with PG (Windows version).
In tha
Hi,
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).
Will anyone be kind enough to sh
Hi All,
Following quite a few days using pgAdmin III (1.6.2 or 1.6.3 not sure) in a
location with no internet connection, I have a few remarks ... plus a couple of
questions about pgAgent which I have experimented for the first time.
I know this is not really good timing considering you are busy
Hi,
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 be easy to use.
Hence, as it seem
ne
De : Guillaume Lelarge <[EMAIL PROTECTED]>
À : [EMAIL PROTECTED]
Cc : Laurent ROCHE <[EMAIL PROTECTED]>; pgadmin-support@postgresql.org
Envoyé le : Lundi, 18 Juin 2007, 23h53mn 13s
Objet : Re: [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Raymond O'Donnell a éc
Hi All,
I have a table with a sequence.
When I backup the table I get the following code (among other things):
...
ALTER SEQUENCE documents_doc_id_seq OWNED BY documents.doc_id;
...
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
>> 3) column headers are blank with no indication of the column name in the
>> edit grids.
> Wierd.
I have seen this when the connexion to the database has been lost.
_
Ne gardez plus qu'une seule adresse
Hi,
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
DATABASE ... RENAME TO ...
command,
- Message d'origine
De : Bob <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Envoyé le : Jeudi, 24 Mai 2007, 2h52mn 23s
Objet : [pgadmin-support] Improvement to Dropped DB Connections
In other words --- EVEN IF the DB connection is closed by accident,
pgAdmin should not requi
Hi,
(While talking of connection names, see other post "Edit Data windows title")
I just realised the connection name was not used at all in the Query window.
That's more than a shame because if I want to use another connection, a little
window pops up and offer to change database with a dropdow
]
The Computing Froggy
- Message d'origine
De : "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Cc : [EMAIL PROTECTED]
Envoyé le : Mercredi, 23 Mai 2007, 19h11mn 14s
Objet : Re: [pgadmin-support] List to Father Christmas
On May 22, 3:06 pm,
Hi,
As
I have managed to get error messages displaying correctly in PG-Admin
(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 Christmas anymore, Easter is already gone passed ... but I
always hope).
Hi,
what about having a 1.6.3 build in the backports of Dapper Drake (6.06 LTS) as
it is long term support I would not expect people using it to move to a newer
OS version ... but would apreciate a more recent pgAdmin (than 1.4.3).
Just a suggestion !
Cheers,
[EMAIL PROTECTED]
The Computing F
Hi Dave, Guillaume and All,
Some of you (Dave & Guillaume) may remember I had a problem with PG Admin III
1.6, that did not display error messages (only the code but not the message it
self) when PG Admin III 1.4 and psql will display the full error message.
After a bit of investigation with Gu
Hi David,
I have not seen any replied to that ... so here I go.
No, there's no other option than psql AFAIK when using the COPY order with the
data in the same file (COPY ... FROM STDIN).
Dave explained before, that COPY uses the console and the PG Admin III edit
tool is not a console app but a
>>If you use PostgreSQL 8.2, you can
>> REASSIGN OWNED BY A TO B;
Good but I am using 8.1
>>We aren't sure that all objects in this schema are owned by the same
>>user. But perhaps we can add some code to "emulate" REASSIGN OWNED for
>>older PostgreSQL releases.
That will be great !
Hav
Hi,
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 role) B.
But the objects are still owned
I second that !
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : jws <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Envoyé le : Jeudi, 8 Mars 2007, 23h32mn 18s
Objet : [pgadmin-support] Request for better visual feedback in the event of
errors
It would
Albin ,
I suspect you are having the same problem as I have.
For me, when the db is set with UTF8 charset I get only error numbers, but on
the same server but with db set with other charset (say LATIN1) I do see error
messages.
Let us know.
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
-
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 ?
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Erwin Brandstetter <[EMAIL PROTE
Hi,
my two cents on that interesting thread:
I come from a database developer background.
I have used quite a few tools in the past years on different RDBMs (mainly
Sybase, MS SQL-Server, and a bit of Oracle).
When I have started using PG at the end of last year, I looked at the tools
around.
I
Hello Erwin,
I am interested in the part "I get an error message with only the error code".
I have the same problem, however in the rest of your message you do have an
error message with the error code
" FEHLER: Fehler »Syntaxfehler« bei »loc«
SQL state: 42601
Character: 1"
How do you
ssage d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Vendredi, 26 Janvier 2007, 9h50mn 59s
Objet : Re: Re : Crash at closing [was: Crash and sending report !]
Laurent ROCHE wrote:
> Just
]
The Computing Froggy
- Message d'origine
De : Laurent ROCHE <[EMAIL PROTECTED]>
À : Dave Page <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Vendredi, 19 Janvier 2007, 13h33mn 15s
Objet : Crash at closing [was: Crash and sending report !]
I am closing it,
ne
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org; [EMAIL PROTECTED]
Envoyé le : Vendredi, 19 Janvier 2007, 17h24mn 56s
Objet : Re: [pgadmin-support] Copy from Edit data, Paste into OpenOffice
Spreadsheet
Laurent ROCHE wro
Hi Gals & Guys,
Any of you has achived to copy Copy from Edit data window and then Paste into
OpenOffice Spreadsheet ?
I have tryed to change the field separators parameter (File ==> Preferences,
Request tab) but I still get everything into one column !
It's probably an OOo bug, but I wondered
Hi,
Guillaume, (or whoever is in charge of French localisation for
Preferences),
There's a problem when selecting "Tabulation" as field
separator, the separator is ... "Tabulation" I mean the string not the
actual Tab character: probably too much translation here ! ;-)
Have fun,
[EMAIL PROTECT
d
the log.
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>; pgAdmin Support
Envoyé le : Vendredi, 19 Janvier 2007, 12h31mn 28s
Objet : Re: Re : [pgadmin-support] Crash and send
Hi,
When ever there's a crash (it's about every other time ... when I close PG
Admin ... so no big deal ;-) !) is it worth me sending the report to Microsoft ?
Does it get to the PG Admin people in the end ?
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
Hi,
I am working on an import of databases, so I keep dropping and re-creating
schemas, and then populating tables.
Even, if I do a VACUUM ANALYSE on the entire DB, PG Admin will prompt me to
perform a VACUUM when I use one of the tables populated.
Is this normal ?
I would have thought that con
Hi,
I am trying to run a COPY my_table FROM STDIN from pgAdmin ... but I can not
manage to get it to work !
It runs with psql !
Here is a short version of the command:
COPY xfrt.import_cpts FROM STDIN;
1DG 16930 7 JAN 071
2DG 25430 7 JAN 072
3DG 34617
- Message d'origine
De : Guillaume Lelarge <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Mardi, 16 Janvier 2007, 0h41mn 48s
Objet : Re: Re : [pgadmin-support] Re : Still no text for error messages
Laurent ROCHE a écrit :
&
PROTECTED]>
À : Dave Page <[EMAIL PROTECTED]>
Cc : Laurent ROCHE <[EMAIL PROTECTED]>; pgadmin-support@postgresql.org
Envoyé le : Lundi, 15 Janvier 2007, 18h47mn 34s
Objet : Re: [pgadmin-support] Re : Still no text for error messages only
Dave Page a ecrit le 15/01/2007 17:46:
> Did y
racter set database, I get:
ERREUR: erreur de syntaxe sur ou près de «sdfghsdfh»
État SQL :42601
Caractère : 37
Let me know, if I can help some more.
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Christophe Chauvet <[EMAIL PROTECTED]>
À : Laurent ROCHE &
Hi,
Can anyone help me, on this one ?
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Laurent ROCHE <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Cc : [EMAIL PROTECTED]
Envoyé le : Mardi, 9 Janvier 2007, 15h39mn 57s
Objet : Still no tex
CTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Mercredi, 10 Janvier 2007, 10h56mn 47s
Objet : Re: Re : Re : [pgadmin-support] Backup file not UTF-8 (introduced bug
Laurent ROCHE wrote:
> Hi,
>
> But the problem is that using pg_dump
uting Froggy
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>; "pgadmin-support@postgresql.org"
Envoyé le : Mercredi, 10 Janvier 2007, 9h46mn 16s
Objet : Re: Re : [pgadmin-support] Backup file not UTF-8 (introduced
Hi,
A bug has been introduced in the version 1.6.2: when backing up in a file, the
file produced is not in UTF-8 format even though it is specified in the
preferences.
That used to work in 1.6.1
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
ws XP SP2) and for the Server (Ubuntu 6.06, PG 8.1).
Let me know if you need more info about this.
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Laurent ROCHE <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Cc : [EMAIL PROTECTED]
Envoyé le : Je
the same results)
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Mercredi, 27 Décembre 2006, 10h07mn 18s
Objet : Re: [pgadmin-
Hi,
I would like to automate the generation of a backup script of a schema (which I
used to perform with PG Admin backup command).
I looked into pg_dump command: it does the job BUT not correctly for me as it
does not create SERIAL column but INTEGER and then it creates SEQUENCES (I have
script
Well, that I would not know till 1.6.2 is realeased ! ;-)
Thanks for trying.
I will see how it goes when 1.6.2 goes out.
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Guillaume Lelarge <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]
Any news about that one ?
Have fun,
[EMAIL PROTECTED]
The Travelling Froggy
TravellingFroggy.info
- Message d'origine
De : Laurent ROCHE <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Cc : [EMAIL PROTECTED]
Envoyé le : Jeudi, 14 Décembre 2006, 16h33mn 25s
Objet : R
.
Any estimates for the roll-out of 1.6.2 ?
(I have read the the particulary annoying bug of empty tables not being
editable is fixed in 1.6.2)
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Guillaume Lelarge <[EMAIL PROTECTED]>
À : Laurent RO
Hi,
I assume this has been told before ... but as I did not find anything about it
in the mailing list archive !
With PgAdmin III 1.6.1 on WinNT SP2.
The Backup dialog window (that pops up when doing Tools ==> backup ...) is
sized too small: the "..." button (to browse for a file) is not visib
Any news about this problem, anyone ?
Have fun,
[EMAIL PROTECTED]
The Travelling Froggy
TravellingFroggy.info
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org; Guillaume Lelarge <[EMAI
s anything I can do, to get my error messages in clear
text ... in the mean time, I'll stop making errors ! ;-)
Thanks again for your help,
[EMAIL PROTECTED]
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc
essage d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Mardi, 5 Décembre 2006, 14h03mn 00s
Objet : Re: [pgadmin-support] No text for error messages only numbers
Laurent ROCHE wrote:
> Hi,
>
&
Hi,
Since I have upgraded to version 1.6.1, I do not get error messages text any
more, only error numbers ! ? !
Is there something to configure to get the text too ?
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
_
68 matches
Mail list logo
