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
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.
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
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
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
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
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
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.
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
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
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
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
"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
13 matches
Mail list logo
