On 18-Aug-2010 1:20 AM, Guillaume Lelarge wrote:
> Hi,
>
> Le 16/08/2010 08:18, Sim Zacks a écrit :
>> I am using pgAdmin 1.10.3
>>
>> Query Tool.
>>
>> When I am working in the scratch pad and hit the tab button, it does a
>> tab on the last place I
I am using pgAdmin 1.10.3
Query Tool.
When I am working in the scratch pad and hit the tab button, it does a
tab on the last place I was in the SQL Editor.
This can be very confusing as when I hit delete after I realize what it
did, it deletes from the scratch pad.
The behavior that I would
I stopped the query this morning after 24 hours of running, restarted
pgadmin and restarted the postgresql server.
I ran the query again and it went relatively quickly (only 1.3 hours).
I don't know what went wrong, but apparently something did.
Sim
Sim Zacks wrote:
> I am running a
I am running a query in PGAdmin.
I changed the storage on a bytea field from External to Main and then ran
update dbmail_messageblks set messageblk=messageblk || '';
so that it would move all the rows to the new storage.
This is a very large table, so I actually expect it to take a long tim
> The design is intended to allow you to modify options and try again, or
> to cancel the whole operation. I'm not sure how that's any different
> from any of the other dialogues - click the OK button and an attempt is
> made to create an object for example - if an error occurs you can change
> opt
This is a bug I reported a number of versions back, but it is still
here.
1.6 Beta 1
If you restore a database and there are warnings when you click OK it
tries to do the backup again. You have to click Cancel, which is
counter intuitive.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145
f the servers that I have defined in PGAdmin show up in the list,
but none of the databases.
I am really enjoying the new version. Keep up the good work.
Sim Zacks
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I can think of numerous examples where someone might want to run a
query against databases on different databases or servers.
I don't think it has anything to do with design.
You might think it is better to move the data together before running
the query, but that takes a lot more time and effort
try:
select case sex when 'M' then 'Male when 'F' then Female' end from std
Sim
Hi,
I have knowledge in Oracle.Now we are using postgresql...,
In oracle...
select decode(sex,'M','Male','F','Female') from std;
It r
I like the connection drop down menu.
I use it all the time.
Thank You
Sim
>
> 2. Connection pull down menu too wide and need too rare.
Maybe for you.
> IMHO best solution move it in 'File' menu for making
> butt
Sim Zacks wrote:
> Version 1.4.0
> When you restore a database and there are no problems the Ok button
> turns into a Done button. Clicking on this closes the window.
> When there are errors or warnings, t
Version 1.4.0
When you restore a database and there are no problems the Ok button
turns into a Done button. Clicking on this closes the window.
When there are errors or warnings, the OK button stays an ok button
and clicking on it attempts to do the restore again.
To get out of the window you must
tless.
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Joost Kraaijeveld Askesis.nl> writes:
> Does this work (replace the names according to your schema)?
>
> BEGIN;
> ALTER TABLE t
.
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Folks,
Version of pgadmin3 : 1.2.2
Version of postgresql : 8.0.3
Operating Platform : SuSE 9.3 Professional IA-32
Summary: Triggers subtree
1) You don't have a Begin. The format is Declare then Begin and then
lastly End
2) My understanding is that these error messages would come directly from the
server and not the query tool. Have you tried running the same query
using psql?
Sim
I personally prefer it the way it is. I am not migrating from Oracle,
which could be the reason. If I want a transaction, I specify it. If I
don't want a transaction I don't specify it.
I think a lot more people would have issues if they run a couple dozen
queries and then turn it off and forget t
James,
I was unaware that you could BCP data from SQL server to PostGreSQL. I
will have to look into that for the future.
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Hi Sim / Dheeman
I'd use DTS
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Hi,
I'm a new user of postgres. Earlier my database was sqlserver . now i want
to perform BULK IMPORT of data from Sq
If you have a function that returns a recordset instead of just a
value then you would have to do a select * from functionname
You can also try reading the documentation on functions. I believe
section 35 discusses the various pl languages.
Sim
_
PostGreSQL 8.0 beta1
PGAdmin 1.2.0 Beta 2
I can call it a plpython bug, if that is the problem. I just figured
to send it to you because that's where I experienced the issue.
Also I don't "know" that is the problem, just an assumption based on
behavior.
Thank You
Sim Zacks
IT
he problem appears to be do to the windows CRLF as opposed to the
*NIX LF.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index sc
21 matches
Mail list logo
