Re: [SQL] comment on COLUMN, broken or misunderstanding?

2008-02-17 Thread Michael Fuhr
On Sun, Feb 17, 2008 at 06:18:26PM -0800, Bryce Nesbitt wrote: > I'm expecting COLUMN comments to work much like table comments, but I'm > getting nothing back. Is this a reportable bug, or a misunderstanding? > > # comment on column sched.days is 'Bitmask 0=Sunday,7=Holiday, 8=School > day, 9=Sp

Re: [SQL] comment on COLUMN, broken or misunderstanding?

2008-02-17 Thread Milen A. Radev
Bryce Nesbitt написа: I'm expecting COLUMN comments to work much like table comments, but I'm getting nothing back. Is this a reportable bug, or a misunderstanding? [...] Misunderstanding I would say - "\dd" is for objects and they are: '"Object" covers aggregates, functions, operators, types

Re: [SQL] comment on COLUMN, broken or misunderstanding?

2008-02-17 Thread Markus Bertheau
2008/2/18, Bryce Nesbitt <[EMAIL PROTECTED]>: > I'm expecting COLUMN comments to work much like table comments, but I'm > getting nothing back. Is this a reportable bug, or a misunderstanding? Try \d+ sched Markus ---(end of broadcast)--- TIP 5: d

Re: [SQL] comment on COLUMN, broken or misunderstanding?

2008-02-17 Thread Tom Lane
Bryce Nesbitt <[EMAIL PROTECTED]> writes: > I'm expecting COLUMN comments to work much like table comments, but I'm > getting nothing back. Is this a reportable bug, or a misunderstanding? > # comment on column sched.days is 'Bitmask 0=Sunday,7=Holiday, 8=School > day, 9=Special'; > COMMENT > # \

[SQL] comment on COLUMN, broken or misunderstanding?

2008-02-17 Thread Bryce Nesbitt
I'm expecting COLUMN comments to work much like table comments, but I'm getting nothing back. Is this a reportable bug, or a misunderstanding? # comment on column sched.days is 'Bitmask 0=Sunday,7=Holiday, 8=School day, 9=Special'; COMMENT # \dd sched.days; Schema | Name | Object | Description -

Re: [SQL] Backward compatibility psql 8.1 to 8.2

2008-02-17 Thread Peter Eisentraut
Scott Marlowe wrote: > Does anyone who know about packaging know if this a limitation of the > packaging spec in rpm, or is there a relatively simple way to get an > rpm based machine to run >1 ver of pgsql at a time? The difference is merely that the packaging doesn't support that setup. -- Pet

Re: [SQL] PostgreSQL does not support updateable cursors

2008-02-17 Thread Peter Eisentraut
Premsun Choltanwanich wrote: >      I found some information on internet about the PostgreSQL does not > support updateable cursors so I change my code to be read only cursors as >  'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", > connSystem, adOpenForwardOnly, adLockReadOnly'

Re: [SQL] Usage of UUID with 8.3 (Windows)

2008-02-17 Thread Peter Eisentraut
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Figure out how to build ossp-uuid on Windows ... > > > > I think Windows has its own UUID generator, so the best bet would be to > > make that work. > > Only if it can be made to present the same SQL-level API as