That was the problem. Thanks =).
P.S Still a bit strange because "functions" IS in the search_path,
there is no reason for it not to find it from the vacuum.
On 4/16/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Vitaly Belman <[EMAIL PROTECTED]> writes:
> > My
4, int4, int4, float4) OWNER TO postgres;
-
Thanks =)
On 4/16/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Vitaly Belman <[EMAIL PROTECTED]> writes:
> > Failed to check book_picture in table public.books:
> > ERROR: function bayes(real, integer, integer, numeric) does not exist
&g
CREATE INDEX i_books_vote_rel_avg
ON public.books
USING btree
(bayes_books(vote_avg, vote_count));
---
I tried running the function as it is and it seems to working just
fine. Anyone has an idea what might the vacuum do to trigger such an
error?
On 4/15/05, Tom Lane <[EMAIL
I have quite a large database with lobs being referenced from a few
different table. While I made triggers/store procedures to unlink the
lob once the item is deleted, I am afraid there might be a glitch
somewhere in the code that leaving the LOBs dangling with no use
(except wasting the HD).
Is t
Is it possible to ALTER somehow an object and move it from schema to
schema? It really sucks to drop an object completely for such a change
(because of all the object relations forcing me to drop them first and
then to recreate).
--
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!:
eorge Essig <[EMAIL PROTECTED]> wrote:
> On Sat, 26 Feb 2005 16:47:38 +0200, Vitaly Belman <[EMAIL PROTECTED]> wrote:
> > So basically what I have is:
> >
> > public schema, in which there are two tables, A and B.
> > backup schema, in which there are two ta
I am allowing my users to delete data from certain tables. However, to
be able to do a rollback of user changes, I decided to create another
"backup" schema that most data tables will copy data to, upon delete.
So basically what I have is:
public schema, in which there are two tables, A and B.
ba
Good thinking, it works :)
Thanks.
On Sat, 19 Feb 2005 16:53:52 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Sun, 20 Feb 2005, Vitaly Belman wrote:
>
> > I have the following plpgsql function:
> >
> > CREATE OR REPLACE FUNCTION public."temp&q
I have the following plpgsql function:
CREATE OR REPLACE FUNCTION public."temp"(int4)
RETURNS public.books AS
$BODY$DECLARE
old_book books%rowtype;
BEGIN
select * into old_book from books
where book_id = var_book_id;
IF FOUND = false THEN
return
Doing an EXECUTE for a query which returns results still yields 'f'
for the FOUND variable. "GET DIAGNOSTICS" on the other hand, works
fine,
Using version 8 on Win32.
--
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end of broadcast)--
OTECTED]> wrote:
> On Sun, Dec 19, 2004 at 03:20:19PM +0200, Vitaly Belman wrote:
>
> > I noticed that when you do a constraint and tell it "cascade on
> > delete", it will do so only AFTER that the source is deleted. Can I
> > tell it somehow to cascad
I noticed that when you do a constraint and tell it "cascade on
delete", it will do so only AFTER that the source is deleted. Can I
tell it somehow to cascade BEFORE the source is gone?
--
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end
True. It does seem more proper.
Thanks.
On Sat, 11 Dec 2004 10:57:25 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sat, Dec 11, 2004 at 08:54:40AM -0800, Stephan Szabo wrote:
>
> > old.series_id IS DISTINCT FROM new.series_id may do what you want
> > depending on how you want NULLs to comp
COALESCE is good enough for me. Thanks.
On Sat, 11 Dec 2004 09:33:32 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sat, Dec 11, 2004 at 02:42:21PM +0200, Vitaly Belman wrote:
>
> > IF old.series_id<>new.series_id THEN
> > ...
> > The problem is that seri
I have the following code in one of my trigger functions
---
IF old.series_id<>new.series_id THEN
...
...
END IF;
---
The problem is that series_id can change to be NULL in whic
I'm looking for software that can generate PHP scripts from PostgreSQL
database that will allow for distant users to edit the data.
The idea is to let selected users have EASY access to edit the data
they see, I can't possibly give raw access with pgMyAdmin or anything
of sorts, as it is hardly ac
Even better. Thanks =).
On Sat, 21 Aug 2004 20:14:53 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
>
>
> Vitaly Belman <[EMAIL PROTECTED]> writes:
> > Is there a way to kill a session in PostrgeSQL? I ran a bad query by
> > mistake and I don't want to shut
Is there a way to kill a session in PostrgeSQL? I ran a bad query by
mistake and I don't want to shut the whole database just to quit using
the whole CPU.
--
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end of broadcast)---
In Oracle I was used to be able to search directly in code from SQL
Navigator (I'm not sure if it is a feature of the database or the
tool). It means that I could search if a certain string appears in one
of the functions (across different schemas/packages).
Is there some way to accomplish this in
ed.
>
> By the way the pgsql-performance list is probably a much better place to
> discuss this.
>
> Mike
>
> On Sat, 2004-07-10 at 05:57, Vitaly Belman wrote:
> > I ready somewhere that PostgreSQL is able to optimize SQL functions,
> > the same way it does
Hello Tom,
Thanks, that worked.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
Friday, June 11, 2004, 12:55:53 AM, you wrote:
TL> Vitaly Belman <[EMAIL PROTECTED]> writes:
>>> gcc -O2 -fno-strict-aliasing -Wall -W
t as the -I points =(.
Tips will be much appreciated.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
22 matches
Mail list logo
