Re: [pgadmin-support] pgadmin3 cores on FreeBSD 5.3

2005-01-13 Thread Hiroshi Saito
Dear Dan. Thank you for the report. - Original Message - From: "Dan Langille" <[EMAIL PROTECTED]> > Hi folks, > > I'm just wondering if I'm just special and I'm the only one that is > having pgadmin3 core dump when it starts on. > > I'm running pgadmin3-1.2.0 under FreeBSD 5.3-stable

[pgadmin-support] Error Message: ERROR: pg_aclcheck: class "tmp_041206_131204" not found

2005-01-13 Thread Amr fuzzy
-- System Information -- Platform:       Version:        5.2 Build:      3790 -- Application Information -- Name:       pgAdmin II Version:        1.6.0 Descripton:     Name:       pgSchema Version:        1.6.0 Descripton:     Postg

[pgadmin-support] pgadmin tunnel problem

2005-01-13 Thread Dave
Hi, I have a couple of postgresql servers running and they work great with putty and ssh tunneling combined with pgadmin. I have one problem server though and I am looking for help. My public IP is firewalled, and I port forward port 5432. My server IP at 192.168.100.18 works fine with code resi

[pgadmin-support] pgadmin3 cores on FreeBSD 5.3

2005-01-13 Thread Dan Langille
Hi folks, I'm just wondering if I'm just special and I'm the only one that is having pgadmin3 core dump when it starts on. I'm running pgadmin3-1.2.0 under FreeBSD 5.3-stable. Any ideas? suggestions? thanks -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - htt

[pgadmin-support] Bugs in PgadminIII 1.3.0 beta (7.1.05)

2005-01-13 Thread KÖPFERL Robert
Maybe I'm telling old stories... if so, it's just the case. I enountered couriosities while working with DOMAINS When defining an aditional CHECK-constraint, the generated SQL looks like that: > -- Domain: msisdn_type -- DROP DOMAIN msisdn_type; CREATE DOMAIN msisdn_type AS varchar(32) CHEC

Re: [pgadmin-support] pgadmin Bogus Varno: 3

2005-01-13 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote SELECT c.oid, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition FROM pg_class c LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0) WHERE ((c.relhasrules A

Re: [pgadmin-support] pgadmin Bogus Varno: 3

2005-01-13 Thread laurie . burrow
[EMAIL PROTECTED] wrote: > AFAICT the function is objecting to the scalar select. The original query definition causing the Pgadmin problem was: CREATE OR REPLACE VIEW full_product_view AS SELECT slimprdmgrrspperid AS _prd_slimprdmgrrspperid_, ( SELECT (rspper.lstnme::text || ' '::text) || rspp

Re: [pgadmin-support] pgadmin Bogus Varno: 3

2005-01-13 Thread laurie . burrow
[EMAIL PROTECTED] wrote >> SELECT c.oid, c.relname, pg_get_userbyid(c.relowner) >> AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS >> definition >> FROM pg_class c >> LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and >> des.objsubid=0) >> WHERE ((c.relhasrules AN

Re: [pgadmin-support] pgadmin Bogus Varno: 3

2005-01-13 Thread Andreas Pflug
Please stay on the list! [EMAIL PROTECTED] wrote: Andreas, Here are the results of my tests Test 1 --- This query run interactively gives ERROR: bogus varno: 3 SELECT c.oid, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definitio

Re: [pgadmin-support] pgAdmin Firewall, SSH problem

2005-01-13 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Lazar > Sent: 13 January 2005 02:24 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] pgAdmin Firewall, SSH problem > > Hi, > > I have a couple of postgresql servers running an

[pgadmin-support] adding column with sequence

2005-01-13 Thread Benjamin Indermühle
Hey there i am using pgadmin3 V 1.2.0 I have a question about your tool. id like to add a column to a table with a sequence, but adding a sequence in the column window is always grayed out, what am i doing wrong ? thanks for you help. Greets Ben -- *~*~* *~*~* We are connecting the world ! *~*