[SQL] alter table question

How do I alter a table to set a column to be not null? -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com

Re: [SQL] delete rows

On Thu, 30 Nov 2000, Astrid Hexsel wrote: > After trying for two weeks to delete more than one row at the time from a form > - checkbox input, I was told that the only way different rows would be inputed > or changed with the information from the form would be with the INSERT command. > > > T

[SQL] delete rows

Hello All, After trying for two weeks to delete more than one row at the time from a form - checkbox input, I was told that the only way different rows would be inputed or changed with the information from the form would be with the INSERT command. This way the best alternative I could think o

Re: [SQL] Subselect in join?

At 18:24 29/11/00 -0600, Kenn Thompson wrote: > >In english- is it not possible to to a subselect in a FROM clause? > In 7.1. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.

Re: [SQL] Rules with Conditions: Bug, or Misunderstanding

"Joel Burton" <[EMAIL PROTECTED]> writes: > create rule dev_ins as on update to dev_col_comments where > old.description isnull do instead insert into pg_description ( objoid, > description) values (old.att_oid, new.description); > create rule dev_upd as on update to dev_col_comments where > o

[SQL] Subselect in join?

Ok- Seems I've seen this somewhere, but can't seem to get it to work. Is my memory flawed, or is this just not an implemented feature? SELECT * FROM (SELECT foo, bar FROM tfoobar) In english- is it not possible to to a subselect in a FROM clause? Kenn

[SQL] subselects

I tried to do this: SELECT r , a , (SELECT u , re FROM dir WHERE u = a) , cdate FROM rep WHERE m IN(190); ... and I got: ERROR: Subselect must have only one field An explain shows that two subselects result in two queries, even thought they are accessing the same row. Why can subselects on

Re: [SQL] Cache lookup failure

Do you have any triggers, rules or check constraints defined on the table? If so, you may have fallen pray to the thing that you cannot drop and re-create a function that's used in a trigger without recreating the trigger as well. Stephan Szabo [EMAIL PROTECTED] On Wed, 29 Nov 2000, Najm Hashm

Re: [SQL] Cache look up failure

On 29 Nov 2000, at 17:56, Najm Hashmi wrote: > Hi All, I am trying to insert a tuple in the tuple, and i am getting > the follwoing error message: > > fliprdb=# insert into collection(name, artist_id) values('El Baile > Aleman',2); ERROR: fmgr_info: function 24011: cache lookup failed > > C

[SQL] Rules with Conditions: Bug, or Misunderstanding

Am I misunderstanding how to use rule w/conditionals, or is there a bug in this? -- I love to use Pgsql comments, but find the 'comment on field...' language a bit of a pain for documenting a large database at the last minute. So, I wrote a query that pulls together all the fields in a datab

[SQL] Cache lookup failure

Hi All, I am trying to do a simple insert, and I am getting cache look failure error. Could someone explain what causing it? My query and error are given below: fliprdb=# insert into collection(name, artist_id) values('El Baile Aleman',2); ERROR: fmgr_info: function 24011: cache lookup failed Tha

[SQL] Cache look up failure

Hi All, I am trying to insert a tuple in the tuple, and i am getting the follwoing error message: fliprdb=# insert into collection(name, artist_id) values('El Baile Aleman',2); ERROR: fmgr_info: function 24011: cache lookup failed Can someone help me out here. Thnaks in advance for your help.

Re: [SQL] is there a debian package for plperl?

Bruno Boettcher wrote: >Hello, >subject says it all, wanted to give plperl a try, but the lib doesn't >seem installed... now i installed all through debian packaging system, >and the lib surely is somewhere, but i didn't found it yet... > >so i anybody could point on on where to search