Re: [pgadmin-support] Newbie questions, diff between functions and

Dave Page wrote: Milen A. Radev wrote: I consider the decision to distinguish between functions and procedures in pgAdmin's UI very unfortunate. (..) I'm happy to discuss re-engineering that if people want (can't guarantee I'll actually get time to change anything myself though). As I have

Re: [pgadmin-support] pgAdmin Funciton Code

On 28 Nov 2006 at 22:06, Raymond O'Donnell wrote: > Don't you need to declare pCentreGroupPolicyID first? - Oops, my mistake - you don't of course, because it's an INOUT parameter. --Ray. -- Raymond O'Donnell Director of Mu

Re: [pgadmin-support] pgAdmin Funciton Code

On 28 Nov 2006 at 8:45, kenp wrote: > SELECT INTO >"pCentreGroupPolicyID" Don't you need to declare pCentreGroupPolicyID first? - .etc $body$ declare pCentreGroupPolicyID bigint; begin ..etc This would cause the function not to run..what error me

[pgadmin-support] Running backups with jobs

Hi list, It is possible to run backups in PostgreSQL using Jobs ? If yes what SQL statement could be used ? There is two options on pgAdmin (SQL or Batch) what does batch option means ? Regards ... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: [pgadmin-support] Newbie questions, diff between functions and

I just found out the same thing, running a test install on another pc. I must have skipped that step with my screenshots. Sorry for taking up so much bandwidth on this. Raymond O wrote: > > On 28 Nov 2006 at 10:29, novnov wrote: > >> I've not actually reinstalled pgsql (8.1). What I did is to

Re: [pgadmin-support] Feature Request - sql result pane column auto-sizing

Another problem is for each new sql statement the column resize to shrinks. If the statement is the same the pgAdmin could keep the column size and just shows the sql result. I could see it in "Select now()" statement. Please put it on the feature request if it is not added. Ezequias 2006/11/28

Re: [pgadmin-support] Newbie questions, diff between functions and

On 28 Nov 2006 at 10:29, novnov wrote: > I've not actually reinstalled pgsql (8.1). What I did is to review the > screenshots I took of my installation process, and there wasn't any > step (at least that I captured) for contrib modules. Also, in the I've had to do that at times, and have never ha

Re: [pgadmin-support] Feature Request - sql result pane column auto-sizing

Erwin wrote on 11/24/2006 07:50:21 PM: > Maybe this is not what Mike has been thinking of, but I'd like to > propose an improvement in this context: cycle all columns at once by > double clicking the top left corner of the grid. That's exactly what I'm looking for. Clicking on indivdual columns

Re: [pgadmin-support] Newbie questions, diff between functions and

Thanks for haning in there with me on this. I know the contrib modules stuff is pgsql, not pgAdmin, but pgAdmin could probably be extended to allow for simpler access to the template1 db. I'd guess that it could be loaded just like any db and altered, though of course should only be exposed by spe

Re: [pgadmin-support] Newbie questions, diff between functions and

On 28 Nov 2006 at 9:42, novnov wrote: > I will resort to ininstalling pgsql and reinstalling. I have to say > that this aspect of pgsql is rather difficult to work with. Starting > with why cube and g_cube modules are included by default and ending > with the difficulty of manipulating template1..

Re: [pgadmin-support] Newbie questions, diff between functions and

I've tried to follow the instructions on the pgsql site for replacing template1 with template0. It gets pretty complicated, because you can't delete a template db, so you have to convert it to a non-template, then delete, then proceed with the replacement. So, I did all of that and as far as I cou

Re: [pgadmin-support] pgAdmin Funciton Code

kenp wrote: The code displayed by pgAdmin, for a function I have created, does not allow me to recreate the function as I would like. If I run :- Thanks Ken - I've fixed this for 1.6.1. Regards Dave ---(end of broadcast)--- TIP 3: Have you che

[pgadmin-support] pgAdmin Funciton Code

The code displayed by pgAdmin, for a function I have created, does not allow me to recreate the function as I would like. If I run :- CREATE SCHEMA "Security" AUTHORIZATION postgres; CREATE TABLE "Security"."CentreGroupPolicy" ( "CentreGroupPolicyID" bigint NOT NULL ) WITHOUT OIDS; CREATE OR

Re: [pgadmin-support] Treatment of views with associated rules -

Ben Trewern wrote: All, I've just been trying to setup some updateable views using standard views and associated rules. Is there any possibility of when you open a view in the SQL editor the SQL for the associated rules also show up. It would seem to make sense. When a view is dropped the

Re: [pgadmin-support] Constraint or index or both?

Erwin Brandstetter wrote: Hi developers! Hi Dave! Testing 1.6.1 rev: 5646:5664M, client Win XP. Host Debian Sarge, PG 8.1.4 I noticed that primary key and unique constraints (both create an index) are listed twice in the object tree, under "Indexes" and "Constraints". In 1.4.3 those were only