Re: [pgadmin-support] tutorial for starting development
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 changes. I use XRCeD to hack forms. It's far from perfect, but is a lot easier that manual hacking when you get used to its quirks. I run the CVs version so I can just 'cvs update' every now and again to get the latest set of bug fixes. You still need to run embed-xrc after making any changes. Regards, Dave ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Position of "New Server Registration" Window
Jochen wrote: Hi pgAdmin displays the "New Server Registration" at the very right top so that the window decoration is hidden behind the MacOSX menubar. I've already deleted the preferences file, but that didn't help. Does anyone has an idea? I cannot reproduce this on my MBP, with or without a clean preferences file - in fact, I'm slightly confused as the new server reg button is at the far left of the menu bar, not the right. The first thing to try though is the Default View option on the view menu. If that doesn't work, I'd appreciate a screen shot to show what you're seeing exactly, and a copy of your preferences file to examine. Thanks, Dave. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-support] tutorial for starting development
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 changes. I use XRCeD to hack forms. It's far from perfect, but is a lot easier that manual hacking when you get used to its quirks. I run the CVs version so I can just 'cvs update' every now and again to get the latest set of bug fixes. Great to know. I'll try it ASAP but I wonder how it can handle our custom widgets ? You still need to run embed-xrc after making any changes. I had some problems yesterday with xrc files. I changed dlgTable.xrc, ran embed-xrc, make, make install... and nothing. I didn't see any of my changes. I finally found that I had to manually copy the dlgTable.xrc file in the installation directory to get it working. If i'm correct, we need XRC files on linux and they are embedded with the binary on the windows platform. I wonder why "make install" didn't install my customized copy of the dlgTable.xrc file. FYI, I'm working on adding fill factor support. Oh and I found a SIGSEG on the options window. I need to investigate this. Regards. -- Guillaume. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-support] tutorial for starting development
Guillaume Lelarge wrote: Great to know. I'll try it ASAP but I wonder how it can handle our custom widgets ? It depends how they are used. In some cases it bleats about them, but usually works well enough. You still need to run embed-xrc after making any changes. I had some problems yesterday with xrc files. I changed dlgTable.xrc, ran embed-xrc, make, make install... and nothing. I didn't see any of my changes. I finally found that I had to manually copy the dlgTable.xrc file in the installation directory to get it working. If i'm correct, we need XRC files on linux and they are embedded with the binary on the windows platform. I wonder why "make install" didn't install my customized copy of the dlgTable.xrc file. The rules are the same on Windows, Mac and *nix. Debug builds use the XRC files, release builds use xrcDialogs.cpp. We don't even install the xrc files with release builds any more (I wonder if that might have confused things on your machine?) FYI, I'm working on adding fill factor support. Cool - need to be quick though - I hope to go to beta in a week or so! Oh and I found a SIGSEG on the options window. I need to investigate this. :-s Regards, Dave. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] ALTER TABLE ALTER COLUMN in view
Hi all,
I have a scenario like follow (script generated with pg_dump) :
CREATE TABLE teste (
id integer NOT NULL,
ds character varying(20),
n2 character varying(10)
);
CREATE SEQUENCE teste_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE teste ALTER COLUMN id SET DEFAULT nextval('teste_id_seq'::regclass);
ALTER TABLE ONLY teste
ADD CONSTRAINT pk_teste PRIMARY KEY (id);
ALTER SEQUENCE teste_id_seq OWNED BY teste.id;
CREATE VIEW vteste AS
SELECT teste.id, teste.ds, teste.n2 FROM teste;
ALTER TABLE vteste ALTER COLUMN id SET DEFAULT
nextval('teste_id_seq'::regclass);
Well this last line make a change on a view column and it works.
I do it because when inserting a row in the view vteste, I got a message error
like "teste.id does not accept NULL values"
Searching in the internet, I found a message where Tom Lane suggest to do this.
Well, I don´t found anything in Postgresql manual saying that we can do it in
views, but I don´t found anything saying that we don´t must do it too.
Since pg_dump generates the script with this definition, I think that they
must be supported by PostgreSQL
The only thing that I have a objection is because this don´t appear in pgadmin
views definition. And we don´t mind that this "ALTER COLUMN" exists in the
Database structure.
I want to request/suggest that views script generates a complete script in the
sqlpane like when select a table (with index,triggers creation sql scripts) or
with at least this DDL, since we can´t see it anywhere.
May we have a icon for this alter columns in the view definition tree too ?
I´m using pgAdmin 1.6.3 in a winXP pro SP2 with Postgresql 8.2.4
Thanks in Advance
Luiz
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
[pgadmin-support] Recent Files menu item and Searching in Query tool
Hi list, I have 2 propositions: 1 - ask if user wants to save previously opened file, when changing currently opened file using menu [File]->[Recent Files]. At this time the opened file is just closed (no save) and new file is opened. 2 - after entering text in "What to find" edit in [Find and Replace] dialog, start searching on [Enter] key press and close [Find and Replace] dialog, it will be also great if there will be a hotkey for Find Next, maybe F3? Taras Kopets
