[pgadmin-support] Inverse Constraints

I am very new to postgresql and would like to express my appreciation for the wonderful work you have done with pgadminIII. One feature I would like to find is the ability to list all the constraints that refer to a given table or column. Is this feature present in pgadmin? If it isn't what wo

Re: [pgadmin-support] View column defaults in pgAdminIII

Unfortunately this is not possible because PostgreSQL doesn't retain the original SQL entered (see the many discussions about this on the pgsql-hackers list for details). Yes, and I had quite some fights to get this pretty-print functions into the backend for guys like us that don't like dozens

Re: [pgadmin-support] View column defaults in pgAdminIII

I'm not sure what you mean here. Views don't have column defaults, only the underlying relations do. How would you expect that to be expressed in SQL (which pg_dump didn't do when I tried it btw)? Not true, views can explicitly have defaults. Chris ---(end of broadcast)

Re: [pgadmin-support] pgAdminIII bug

Villy Dachev wrote: Hello, pgAdminIII 1.0.0 release (win32) crashes when I do the following: 1. create a user with NOCREATEDB CREATEUSER 2. connect to a server with this user 3. open any database's properties dialog / security tab 4. click somewhere in the ACL area sorry, no time to check it wit

Re: [pgadmin-support] View column defaults in pgAdminIII

Dave Page wrote: Hi, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 14:13 To: [EMAIL PROTECTED] Subject: [pgadmin-support] View column defaults in pgAdminIII I recently installed pgAdmin III and am happy to see the great work done by the

Re: [pgadmin-support] pgAdminIII bug

Hi Villy, Running a CVS build from a couple of days ago, I cannot recreate this error. One of the TODO items is to make dialogues read only for users with insufficient privileges though - it's possible theat Andreas committed some early work for this that has fixed the problem you see (certainly I

FW: [pgadmin-support] View column defaults in pgAdminIII

Forgot to CC the list... > -Original Message- > From: Dave Page > Sent: 13 October 2003 15:49 > To: 'Donald Fraser' > Subject: RE: [pgadmin-support] View column defaults in pgAdminIII > > > > > -Original Message- > > From: Donald Fraser [mailto:[EMAIL PROTECTED] > > Sent: 13

Fw: [pgadmin-support] View column defaults in pgAdminIII

- Original Message - From: "Dave Page" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 3:17 PM Subject: Re: [pgadmin-support] View column defaults in pgAdminIII >> b) Include in the view definition DDL any column defaults. >> When I do a

Re: [pgadmin-support] PGAdmin 3 on Debian Testing: Failure

(oouppps, I forgot to CC to the list) Hi Erwin, Thank you for downloading pgadmin, this message is typical of a general display problem. I think tha t you may have launched pgadmin from a window where you didn't get right to open any X applications (not only pgadmin3). Could you please c

[pgadmin-support] PGAdmin 3 on Debian Testing: Failure

Hi Group! I have installed pgAdmin III on a Debian Testing System (Kernel 2.4.22). I have followed the instructions on by Raphaël Enrici. The programm seemed to install without any problems. When I try to start with "pgadmin3" however, I get the foll

Re: [pgadmin-support] View column defaults in pgAdminIII

Hi, > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 13 October 2003 14:13 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] View column defaults in pgAdminIII > > I recently installed pgAdmin III and am happy to see the > great work done by the team.

[pgadmin-support] pgAdminIII bug

Hello, pgAdminIII 1.0.0 release (win32) crashes when I do the following: 1. create a user with NOCREATEDB CREATEUSER 2. connect to a server with this user 3. open any database's properties dialog / security tab 4. click somewhere in the ACL area sorry, no time to check it with the CVS version, b

[pgadmin-support] View column defaults in pgAdminIII

I recently installed pgAdmin III and am happy to see the great work done by the team. Thank you very much for so great a software tool! Especially of interest to me are the facts that 1) the view definition DDL code is now presented with some CRLF's, i.e., more "pretty" than as in II, where it w

Re: [pgadmin-support]bug reporting

Hi Alexandr, please do not post only to persons, but at least cc the list to avoid messages being lost. Hi -In console: CREATE DATABASE mydb WITH ENCODING = 'KOI8'; CREATE TABLE mytable ( моя_колонка varchar ) WITH OIDS; Then I open pgadmin, open View Data and insert into mytable text_s