Zakkr,
I love you. It worked!! Your help should keep me busy this weekend..
;-)
Thanks a lot.. I shall bug you again for sure.. j/k.. ;-)
Henrique Pantarotto
Sao Paulo, SP - Brazil
On sex, 20 ago 1999, Zakkr wrote:
> On Fri, 20 Aug 1999, Henrique Pantarotto wrote:
>
> > I would like to kno
Hello!
When I run first createdb I get:
>Segmentation Fault - core dumped
>createdb: database creation failed on dgchtch.
The postmaster gives following debug info:
/home/dgchtch/pgsql/bin/postmaster: BackendStartup: pid 28832 user dgchtch
db template1 socket 4
FindExec: found "/home/dgchtch/p
Mark,
The error you are experiencing was discussed on the hacker's list
last week. Oliver Elphick and Tom Good worked out a patch for SQL to
solve the problem. You're right that the pg_vlock is getting created and
then getting deleted during the vacuuming of the last table. This ends
up boink
The Hermit Hacker <[EMAIL PROTECTED]> wrote:
>Try now?
OK. Thanks again.
F.J.Cuberos
Sevilla - Spain
On Fri, 20 Aug 1999, Henrique Pantarotto wrote:
> I would like to know how, from a trigger C function, can I get the "old" and
> "new" value for an updated field. Is this possible? How do I do that?
>
> For example, if I do:
>
> update users set username = "clinton" where id = "2400"
examp
It is possible. But I do not know how :-) I Know it because PL/pgSQL
can do it, and spi/C can do more than PL/pgSQL.
in the doc, seems a lot stuff on spi (server programming interface ?).
also, since the syntax of PL/pgSQL is not difficult at all, it can
serve as the psudo-code for most purpose,
Bruce Momjian wrote on Mon, 16 Aug 1999 14:24:57 EDT
>> [. . .]
>> Currently, pgsql 6.5.x breaks up the files containing
>> tables into roughly 1 GB chunks. My question is: will
>> pgsql do the same for the files containing the indices?
>>
>> Correction to info in my previous post: my index fil
So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1:
[csmaster@kamet release0]$ psql cs1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
I've been trying to find where the order of evaluation for SQL is
defined. In short, I wounder if the following always gives the same
result:
CREATE SEQUENCE counter
start 1 increment 1 cache 1
minvalue 1
maxvalue 214748364
Zakkr,
I wonder if you read my message. I am aware of the examples in the contrib/spi
directory, but they aren't enough for me. I'm looking for a more specific
trigger documentation, or more trigger examples.
I would like to know how, from a trigger C function, can I get the "old" and
"new" va
Try now?
On Fri, 20 Aug 1999, F J Cuberos wrote:
> I´ve a problem with CVS to get the source, when trying to login I get
>
>
> bash-2.02$ cvs -d :pserver:[EMAIL PROTECTED]:/usr/local/CVSROOT login
> (Logging in to [EMAIL PROTECTED])
> CVS password:
> cvs [login aborted]: authorization failed:
On Thu, 19 Aug 1999, Henrique Pantarotto wrote:
> Hello PostgreSQL friends!
>
> I'm new to PostgreSQL, but I've been using MySQL/mSQL for a long time now. I
> switched to PostgreSQL mostly because of it's features: triggers, specially.
>
Trigger examples ... why not:
..see a /postgresql-6.5
I´ve a problem with CVS to get the source, when trying to login I get
bash-2.02$ cvs -d :pserver:[EMAIL PROTECTED]:/usr/local/CVSROOT login
(Logging in to [EMAIL PROTECTED])
CVS password:
cvs [login aborted]: authorization failed: server postgresql.org rejected
access
With password postgresql I
-Mensaje original-De:
Pablo Sentis <[EMAIL PROTECTED]>Para:
PostgreSQL mailing list Fecha:
viernes, 20 de agosto de 1999 11:59Asunto: Serial
fields
Hi All!
Working with PostgreSQL 6.5.1 on Intel
platf.
I´m trying to migrate an Acces database to
postgress . First of all I´v
14 matches
Mail list logo
