Okay, yep, seems like a garden variety bug to me...
What's happening is that the update trigger is checking to make sure
that there are no rows referencing the one that was changed, but that's
not sufficient for the deferred no action case possibly. It's got to be
that there are no rows that no
Can you send the full schema of the tables you are using for
this?
On Tue, 16 Jan 2001, Michael Richards wrote:
> Hi.
>
> I'm having trouble with committing a transaction. Intuitively it
> should work but does not.
>
> I've got a table with 2 foreign keys, minrev and maxrev. They refer
>
Hi,
In Postgres, which one should be the best data type to be used as
primary/foreign key considering query performance: INT or CHAR? Is there
any "remarkable" difference between them?
Thank you and regards,
--
Renato
Sao Paulo - SP - Brasil
[EMAIL PROTECTED]
Hello Sharmad,
Once, Wednesday, January 17, 2001, 12:24:11 AM, you wrote:
SN> I wanted to compile python will an installed postgres package ...can i do it .How?
SN> TIA
SN> Sharmad
There are 2 known python postgresql modules - PyGreSQL and PoPy.
PyGreSQL is in Postgresql distribution, PoPy you
I have a database and a table with 7 records (which i dont think it's
too much)
I join this table with another of about the same size and put a record
restriction (WHERE) and everything works out fine, but when I put two SUMs
over a couple of fields and add a GROUP BY I keep getting this erro
I fixed it!, it just added an index!
Thanks anyway...
"Ligia M. Pimentel" <[EMAIL PROTECTED]> wrote in message
944kbb$114p$[EMAIL PROTECTED]">news:944kbb$114p$[EMAIL PROTECTED]...
> I have a database and a table with 7 records (which i dont think it's
> too much)
> I join this table with anot
Hi all,
It is a very simple but I am not able to recall how to do it I
just need to find out the current value of a seq. It is very simple
select statement but I can't recall it... Help me please before I get
myself get fired -:).
Regards, Najm
Najm
CURRVAL('sequence_name')
For this and other sequence and serial functions, please see the online
version of Bruce's book.
BTW, O'Reilly's "SQL in at Nutshell" also catalogs all PGSQL functions
from ver. 6.5.
-Josh Berkus
--
Najm Hashmi wrote:
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
>
Try:
SELECT last_value FRO
> Najm
>
> CURRVAL('sequence_name')
>
> For this and other sequence and serial functions, please see the online
> version of Bruce's book.
>
> BTW, O'Reilly's "SQL in at Nutshell" also catalogs all PGSQL functions
> from ver. 6.5.
It does, or only the standard SQL functions?
Najm Hashmi wrote:
>
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
> Regards, Najm
select nex
See my book on sequences:
http://www.postgresql.org/docs/awbook.html
currval() is probably what you need.
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can'
how to run "select from databaseA:tabl1 ,databaseB:table2 "
thanks
Thank you all for your help.
Najm
Clayton,
> > Hi all,
> > It is a very simple but I am not able to recall how to do it I
> > just need to find out the current value of a seq. It is very simple
> > select statement but I can't recall it... Help me please before I get
> > myself get fired -:).
> > Regards, Najm
>
> select
Hi,
I have a table with a column (int4), and I want to know how many
different numbers there are. In an example book I saw the query
SELECT COUNT (DISTINCT data ) FROM media;
by then I get
ERROR: parser: parse error at or near "distinct"
Is the query in error or does PostgreSQL not support
Bruce,
> > BTW, O'Reilly's "SQL in at Nutshell" also catalogs all PGSQL functions
> > from ver. 6.5.
>
> It does, or only the standard SQL functions? Do they have
> PostgreSQL-specific stuff.
Both. The book is set up to cover 1) the SQL99 standard, and 2)
Specific variants for SQL Serve
Whoever wrote this is putting the PostgreSQL community in a bad light:
http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
Maybe someone can change the document, or make the author change it?
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Data
hi,there,
I don't see the problem except extra space, try:
SELECT COUNT(DISTINCT data) FROM media;
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.ipinc.com
On 17 Jan 2001, Mikael Hedin wrote:
> Hi,
>
> I
Mikael Hedin <[EMAIL PROTECTED]> writes:
> SELECT COUNT (DISTINCT data ) FROM media;
> ERROR: parser: parse error at or near "distinct"
This is supported since 7.0. I suspect you are running an old release.
regards, tom lane
What version are you using? I believe this was added in 7.0.x, but
I could be wrong about that. A query of this sort works on my
7.1beta3 system.
On 17 Jan 2001, Mikael Hedin wrote:
> I have a table with a column (int4), and I want to know how many
> different numbers there are. In an exampl
I realized that an error will abort a transaction all the time.
Unfortunately I usually send millions of rows of INSERTs in a transaction
and if there is some error in the middle of the code I got the message
if I try to INSERT a new row:
NOTICE: current transaction is aborted, queries ignored u
"Ligia M. Pimentel" <[EMAIL PROTECTED]> writes:
>> I have a database and a table with 7 records (which i dont think it's
>> too much)
>> I join this table with another of about the same size and put a record
>> restriction (WHERE) and everything works out fine, but when I put two SUMs
>> over
Kaare Rasmussen <[EMAIL PROTECTED]> writes:
> Whoever wrote this is putting the PostgreSQL community in a bad light:
> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
> Maybe someone can change the document, or make the author change it?
(Rolls eyes...) See the archives for past discu
Hello,
I do not see how it puts the Postgres community in a bad light, although I
do see how the author is a moron.
J
On Thu, 18 Jan 2001, Kaare Rasmussen wrote:
>Whoever wrote this is putting the PostgreSQL community in a bad light:
>
>http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.ht
On Thu, 18 Jan 2001, Kovacs Zoltan Sandor wrote:
> I realized that an error will abort a transaction all the time.
> Unfortunately I usually send millions of rows of INSERTs in a transaction
> and if there is some error in the middle of the code I got the message
> if I try to INSERT a new row:
> I do not see how it puts the Postgres community in a bad light, although I
> do see how the author is a moron.
People think that it's an official PostgreSQL document. It turned up in a
discussion (PostgreSQL vs. MySQL round 1000) as "the PostgreSQL docs".
--
Kaare Rasmussen--Lin
Kaare Rasmussen wrote:
>
> Whoever wrote this is putting the PostgreSQL community in a bad light:
>
> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
it seems that the author of this HOWTO is a little bit mad in brain:
from http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-11.
> Hello,
>
> I do not see how it puts the Postgres community in a bad light, although I
> do see how the author is a moron.
Many of use fell is puts Linux in a bad light. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-30
On Thu, 18 Jan 2001, Kaare Rasmussen wrote:
> > I do not see how it puts the Postgres community in a bad light, although I
> > do see how the author is a moron.
>
> People think that it's an official PostgreSQL document. It turned up in a
> discussion (PostgreSQL vs. MySQL round 1000) as "the Pos
On Fri, 19 Jan 2001 09:46, Kaare Rasmussen wrote:
> Whoever wrote this is putting the PostgreSQL community in a bad light:
>
> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
>
> Maybe someone can change the document, or make the author change it?
Most of that HOWTO document is distin
Hello,
I am the Webmaster of the LDP... What should I know?
Joshua Drake
On Thu, 18 Jan 2001, Tom Lane wrote:
>Kaare Rasmussen <[EMAIL PROTECTED]> writes:
>> Whoever wrote this is putting the PostgreSQL community in a bad light:
>> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
>|> Best web-scripting (and compiling) language is PHP+Zend compiler
>|> PHP is extremely powerful as it combines the power of Perl,
>|> Java, C++, Javascript into one single language and it runs on
>|> all OSes - unixes and Windows NT/95.
>
>it seems that the author never used any other think the
> from http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-11.html
>
>> Best web-scripting (and compiling) language is PHP+Zend
>> compiler PHP is extremely powerful as it combines the power of
>> Perl, Java, C++, Javascript into one single language and it
>> runs on all OSes - unixes and Windows
> Hello,
>
> I am the Webmaster of the LDP... What should I know?
OK, just read a little bit of it. After you stop laughing, come on back
and we can talk. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your
> Is everyone sure that this HOWTO is not a work of fiction sort of
> like that report on the computer virus that will cause your
> motherboard to catch fire and burn down your house in the middle of
> the night?
The HOWTO author really reminds me of Jesus Monroy, if anyone remembers
him from
On Wed, 17 Jan 2001, [EMAIL PROTECTED] wrote:
> E.g.
>
> create table mytable (created datetime);
> insert into mytable values ('01-01-2001');
> ...
> insert into mytable values ('01-31-2001');
>
> select created from mytable where date_part('dow', created) = 7 and
>date_part('month', created
On Thu, 18 Jan 2001, Michael Richards wrote:
> As I understand Zend is a compiler/interpreter that uses a optimised
> bytecode to run a little faster than the normal apache/php. It shares
> few of the features of perl, even fewer of Java. C++? Last time I
> checked, PHP couldn't do OOP. Next thin
On Thu, 18 Jan 2001, Poet/Joshua Drake wrote:
> >it seems that the author never used any other think then PHP ...
>
> I am afraid I would disagree. I have used all of the languages he metions
> and for the Web, PHP is the best.
I think it all depends on what you are building. PHP is good for sm
>>> Best web-scripting (and compiling) language is PHP+Zend
>>> compiler PHP is extremely powerful as it combines the power of
>>> Perl, Java, C++, Javascript into one single language and it
>>> runs on all OSes - unixes and Windows NT/95.
>>
>> it seems that the author never used any other think
Folks,
Fascinating as this thread is, is the SQL Developers list really the
appropriate place for it? Don't we have a Policy list or something?
-Josh Berkus
--
__AGLIO DATABASE SOLUTIONS___
Hi,
Poet/Joshua Drake wrote:
>
> >it seems that the author never used any other think then PHP ...
>
> I am afraid I would disagree. I have used all of the languages he metions
> and for the Web, PHP is the best.
hmm, i guess it's not a good place for a PHP/Perl war here ;) but:
The author wrot
Hello,
I have temporarily removed the PostgreSQL HOWTO, pending peer review.
Joshua Drake
On Thu, 18 Jan 2001, Brett W. McCoy wrote:
>On Thu, 18 Jan 2001, Poet/Joshua Drake wrote:
>
>> >it seems that the author never used any other think then PHP ...
>>
>> I am afraid I would disagree. I hav
On Tue, Jan 16, 2001 at 01:42:45PM -0700, Diehl, Jeffrey wrote:
> I'm having difficulty writing a query which I really can't live without...
>
> I need to get a list of records from table A for which there are
> corresponding records in table B. I've tried to use the intersect clause,
> but it
44 matches
Mail list logo
