[EMAIL PROTECTED] wrote:
> Hi everybody,
>
> I'm a PG newbie, and I'm trying to write a function that returns a
> set of records.
> These records come from 2 or more tables (joined).
>
> When I have only 1 table, the return type of the function can be SETOF
> mytable.
> When I have 2 tables or mo
Hi, how can i know the values generated by a column of type serial?
I mean, i have the following table
productos
(
id serial,
desc varchar(50)
)
select * from productos;
+-++
| id | desc |
+-++
| 1 | ecard1 |
| 2 | ecard2 |
| 3 | ecard3
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
>> Hi, iam running postgresql on two identical dl380 2.4 Xeon with 3gb
>> RAM, i have recently upgraded one of then from redhat 7.3 (kernel
>> 2.4) to gentoo (kernel 2.6), at the same time i upgraded postgres
>> from 7.3 to 8.1, im very disapointed, all t
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
>> LOG: redo starts at F1/A0A4E09C
>> PANIC: Invalid page header in block 68122 of 17006
>> LOG: startup process (pid 1959) was terminated by signal 6
>> LOG: aborting startup due to startup process failure
>
> Which PG version is this exactly? If i
Hi, iam running postgresql on two identical dl380 2.4 Xeon with 3gb RAM, i
have recently upgraded one of then from redhat 7.3 (kernel 2.4) to gentoo
(kernel 2.6), at the same time i upgraded postgres from 7.3 to 8.1, im very
disapointed, all the querys are 20-25% slower using the new versions, the
Hi , my server crashed this morning, aparently by a power failure, postgres
refeses to start, this is the boot log
LOG: database system was interrupted being in recovery at 2005-04-29
14:10:43 CST
This probably means that some data blocks are corrupted
and you will have to use th
>PostgreSQL 8.0 introduced PL/pgSQL exception handlers.
>http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-structures.h
tml#PLPGSQL-ERROR-TRAPPING
>Regardless of whether the trigger is BEFORE or AFTER, an untrapped
>error will abort the insert.
>CREATE FUNCTION trigfunc() RETURNS tr
Hi ppl,
i have a specific question about insert triggers, in the docs i found that
you can change the value of an inserted column using the following syntax:
NEW.column_name := value
and then if you return NEW the new value is stored instead of the original.
this is true if it is a before insert
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Brent Wood
> Sent: Monday, April 25, 2005 8:20 PM
> To: Uwe C. Schroeder
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] UltraSPARC versus AMD
>
>
>
>
> On Sat, 23 Apr 2005, Uwe C. Schroed
On Thu, 2005-04-21 at 10:51, [EMAIL PROTECTED] wrote:
> > These are the details, i have these table
> >
> > name| start| end
> > ---+---+-
> > general | 266 | 266
> > specific | 2660124 | 2660124
> > (2 rows)
> >
> >
> >
Hi people, is there a swtich or something to instruct a between statement
hat it must perform a most specific match ?
These are the details, i have these table
name| start| end
---+---+-
general | 266 | 266
specific | 26601
> CREATE PROCEDURE do_something
> @song_id int,
> @user_id int,
> @method int,
> @length int = 0,
> @date_exact datetime,
> @default_country int = null
> AS
>-- temporary variables
>DECLARE
> @artist int,
> @sample int,
> @date varchar(32),
>
>> Can I expect that a software developed on Linux will run and compile
>> on FreeBSD (since both use GCC)?
>>
> In general yes. Sometimes they do require some tweaks though.
Specially if they rely heavily on threads (i.e mysql, freeradius, etc)
I have some implementation issues with this (i.e.
I disagree on number 1, in fact , untar, cd, ./configure, make, make install
is all you have to do on BSD, not RPM nightmares, at least on Freebsd and
OpenBSD, not sure of NetBSD, I agreee on all others comments
---
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Beha
14 matches
Mail list logo
