I write some functions inPL/pgSQL. If I drop a function B , which is called
by function A, and create function B again, then function A won't work
unless I drop function A and re-create again. How about if there are lots
functions call to function B, is there any way to search system table to
find
Daryl Herzmann <[EMAIL PROTECTED]> writes:
> akrherz=# create table test (day date);
> CREATE
> akrherz=# insert into test values('2000_04_02');
> INSERT 13166281 1
> akrherz=# insert into test values('2000_04_01');
> INSERT 13166282 1
> akrherz=# insert into test values('2000_04_03');
> INSERT 13
version 7.0.3
binary_data=# select day, date_part('day', day) AS day from test;
day | day
+-
02/04/2000 | 2
01/04/2000 | 1
03/04/2000 | 3
(3 rows)
binary_data=#
Why does everyone reply to the person as well as CC to the list when the
person is on the list anyho
pgsql 7.1 beta.. NOT USE Delphi "Ttable" component
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing l
I have postgresql-7.0.3
I'm trying to do following :
test=> create table test (col1 int,col2 int);
test=> grant select on test (col1) to user1;
ERROR: parser: parse error at or near "("
I'm trying to use GRANT with SQL92 extentions,(set permissions on
the individual column) but it dosn't work
With 7.1beta, I get:
day | day
+-
2000-04-02 | 2
2000-04-01 | 1
2000-04-03 | 3
(3 rows)
> HI,
> I am running postgres version 7.0 and I do this...
>
> akrherz=# create table test (day date);
> CREATE
HI,
I am running postgres version 7.0 and I do this...
akrherz=# create table test (day date);
CREATE
akrherz=# insert into test values('2000_04_02');
INSERT 13166281 1
akrherz=# insert into test values('2000_04_01');
INSERT 13166282 1
akrherz=# insert into test values('2000_04_03');
INSE
Hi, all,
Is there any way for a tcl function to return rows (after selct within the
function) ?
Sorry if this has been answered previously.
Best Regards,
Jae
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgr
Tom Lane writes:
> Cedar Cox <[EMAIL PROTECTED]> writes:
> > Added note: The trigger is a BEFORE trigger.
>
> AFAIK the "triggered data change" message comes out of the AFTER trigger
> code. You sure you don't have any AFTER triggers on the table? Perhaps
> ones added implicitly by a foreign-k
> A "triggered data change violation" happens everytime you change twice
> within a transaction a value (column) that is part of a foreign key
> constraint (don't recall exactly which part).
>
> This error shouldn't really happen, but I recall there were some
> implementation and definition probl
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Is this a TODO item? Seems we should match MySQL, seeing as we took the
> > feature syntax from them.
>
> Question is, will more people be inconvenienced if we change it than if
> we leave it alone? Seems like someone gets screwed either way ...
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Is this a TODO item? Seems we should match MySQL, seeing as we took the
> feature syntax from them.
Question is, will more people be inconvenienced if we change it than if
we leave it alone? Seems like someone gets screwed either way ...
Is this a TODO item? Seems we should match MySQL, seeing as we took the
feature syntax from them.
[ Charset ISO-8859-1 unsupported, converting... ]
> On Mon, Mar 12, 2001 at 09:21:58PM -0500, Tom Lane wrote:
> > Spy <[EMAIL PROTECTED]> writes:
> > > Tom Lane a ?crit :
> > >> Is that actually ho
Added note: The trigger is a BEFORE trigger.
-- Forwarded message --
To: [EMAIL PROTECTED]
Date: Tue, 20 Mar 2001 20:43:59 +0200 (IST)
Subject: triggered data change violation
ERROR: triggered data change violation on relation "tblstsc2options"
What is this? It doesn't happ
Rachel,
See below:
> Examples :
>
> table CATEG :
> ida categ
> 1X
> 2Y
> 3Z
>
> table SUBCATEG :
> idb subcateg ida
> 1 x1 1
> 2 x2 1
> 3 x3 1
> 4 x4 1
> 5
> I have two tables : the first for categories and the second for
> subcategories.I want to get a result like Yahoo! For each category ,
> the sql
> query must return maximum 3 subcategories. I can't use "limit" in a
> subquery
> because I use Postgresql 7.0.
Examples :
table CATEG :
ida ca
Rachel,
> I have two tables : the first for categories and the second for
> subcategories.I want to get a result like Yahoo! For each category ,
> the sql
> query must return maximum 3 subcategories. I can't use "limit" in a
> subquery
> because I use Postgresql 7.0.
I can think of several ways
Hi everybody
I found the needed install package for postgres 7.0.3 for win32.
Installation worked. When I try to start the postmaster in the cygwin bash
shell with
postmaster -D /data
I get the error as documented in the attached gif.
It says something about shared memory problem and semaphore
>
>That 'count(*)' is going to be slow.
>Try counting a column that's indexed (p.doc might work?)
That is not the case, you can convince yourself with explain - you get the
same plan(s) :
e.g : ( table dim0 with indexed column d0key ) ...
explain select count(*) from dim0 where d0ke
Hi,
I have two tables : the first for categories and the second for
subcategories.I want to get a result like Yahoo! For each category , the sql
query must return maximum 3 subcategories. I can't use "limit" in a subquery
because I use Postgresql 7.0.
Any help?
Regards,
Rachel
-
20 matches
Mail list logo
