[SQL] Selecting empty columns

How can I retrieve empty columns from a table? The affected column is int4, some row do have values, others are empty - how can those empty ones be retrieved and updated to 0 Hans

Re: [SQL] Persistent Connects (pg_pconnect)

Thanks guys and gals, for your quick responses to my query about persistent connections (you know who you are). It was much appreciated. I am posting the results the results of our investigations in case you are interested and also if it might help someone else... Our investigations of the pro

Antw: [SQL] Selecting empty columns

>>> Hans-Jürgen Schönig <[EMAIL PROTECTED]> 28.11.2000 12.39 Uhr >>> > How can I retrieve empty columns from a table? > The affected column is int4, some row do have values, others are empty - > how can those empty ones be retrieved and updated to 0 > >Hans try: update tablename set columnna

Re(2): [SQL] 7.0.3 BUG

Thanks to you Tom and Thomas. Now I know. - sherwin [EMAIL PROTECTED] writes: >Ah ha (or rather, ha ha ha)! I'd suggest using the RPMs posted on the >postgresql.org ftp site, which include a sample .rpmrc file which fixes >disasterous bugs in Mandrake's default compiler settings for building >RP

Re: [SQL] Damaged table "pg_access"

Jens Hartwig <[EMAIL PROTECTED]> writes: > when I try to access the system-table "pg_class", I get the following > error: > zeda=# select * from pg_class; > NOTICE: get_groname: group 1 not found > pqReadData() -- backend closed the channel unexpectedly. Evidently you had created a group with s

Re: [SQL] Selecting empty columns

On Tue, Nov 28, 2000 at 12:39:50PM +0100, Hans-Jürgen Schönig wrote: > How can I retrieve empty columns from a table? > The affected column is int4, some row do have values, others are empty - > how can those empty ones be retrieved and updated to 0 UPDATE foo_table SET bar_column = 0 WHERE bar_c

Re: [SQL] Damaged table "pg_access"

Hello, yes, you were completely right, thank you very much, you saved me from spending much time on this problem! The recreation of the groups 1, 2, 3 and 4 resolved the problem :-) My next question is: how can I (as a workaround till version 7.1) permanently remove a group without facing this pr

Re: [SQL] Damaged table "pg_access"

Jens Hartwig <[EMAIL PROTECTED]> writes: > My next question is: how can I (as a > workaround till version 7.1) permanently remove a group without facing > this problem? Can I rudely remove the granted permissions by any command > (e.g. deleting it manually from the system catalogue)? There isn't

[SQL] Re: a script that queries db periodically

Thank you for all your response. Not only do I benefit from your response, but hopefully others benefit as well. Thanks again. - Bernie begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700