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

2003-10-14 Thread Andreas Pflug
Christopher Kings-Lynne wrote: 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

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

2003-10-13 Thread Christopher Kings-Lynne
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

2003-10-13 Thread Christopher Kings-Lynne
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] View column defaults in pgAdminIII

2003-10-13 Thread Andreas Pflug
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

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

2003-10-13 Thread Dave Page
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

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

2003-10-13 Thread Donald Fraser
- 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 a

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

2003-10-13 Thread Dave Page
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 > gre

[pgadmin-support] View column defaults in pgAdminIII

2003-10-13 Thread btober
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