--- Tom Lane <__> wrote:
> "Riccardo G. Facchini" <[EMAIL PROTECTED]> writes:
> > I'm trying to understand where the "[ ON COMMIT { PRESERVE ROWS |
> > DELETE ROWS | DROP } ]" is stored when defining a temporary table.
>
> I don
Hi all,
I'm trying to understand where the "[ ON COMMIT { PRESERVE ROWS |
DELETE ROWS | DROP } ]" is stored when defining a temporary table.
whenever a table is created, a record in the pg_class is stored with
the info regarding the table, but I haven't been able to locate where
the info regardin
Hi All,
PostgreSQL 7.4.5
assume this script:
---
create table test_table
(
id serial,
test_value text
) without oids;
insert into test_table
(test_value)
values ('A');
insert into test_table
(test_value)
values ('B');
insert into test_table
(test_value)
values ('C');
insert into test_table
--- Michael Fuhr <__> wrote:
> On Wed, Nov 17, 2004 at 06:25:25AM -0800, Riccardo G. Facchini wrote:
> >
> > --- Richard Huxton <__> wrote:
> > >
> > > Add a new sequence to your database:
>
> [snip]
>
> > Good idea, but it won&#x
--- Richard Huxton <__> wrote:
> Achilleus Mantzios wrote:
> > O Richard Huxton Ýãñáøå óôéò Nov 17, 2004 :
> >
> >
> >>Riccardo G. Facchini wrote:
> >>
> >>>hi all,
> >>>
> >>>is there a way to determine the
--- Achilleus Mantzios <__> wrote:
> O Richard Huxton Ýãñáøå óôéò Nov 17, 2004 :
>
> > Riccardo G. Facchini wrote:
> > > hi all,
> > >
> > > is there a way to determine the session id on a database session?
> > >
> > > I would ne
--- Richard Huxton <__> wrote:
> Riccardo G. Facchini wrote:
> > hi all,
> >
> > is there a way to determine the session id on a database session?
> >
> > I would need to have a unique number whenever a session is started,
> and
> > have this av
hi all,
is there a way to determine the session id on a database session?
I would need to have a unique number whenever a session is started, and
have this available as a function or view result.
thanks.
---(end of broadcast)---
TIP 8: explain
Sorry, but I understand that your example is not really about nested
transactions, but about sequential transactions.
so, the primary question remains:
how to commit/rollback them ?
--- Michael Fuhr <__> wrote:
> On Wed, Nov 10, 2004 at 09:23:02AM +0300, sad wrote:
> > On Tuesday 09 November 20
That depends on the use you plan to... as a backup, useless, as a
documentary tool, very (at least, for what I need).
Our way of developing things is to set up a development box, and set up
the tables, functions, etc etc etc using a set of tools... the only
problem is that these do not provide an
check pg_dump options, is there
--- Kenneth Gonsalves <__> wrote:
> hi,
> is there anyway to backup/restore a specfic schema in a database?
> --
> regards
> kg
>
> http://www.onlineindianhotels.net - fastest hotel search website in
> the world
> http://www.ootygolfclub.org
>
> ---
--- Kenneth Gonsalves <__> wrote:
> On Thursday 26 August 2004 04:48 pm, Philip Warner wrote:
> > At 08:43 PM 26/08/2004, Riccardo G. Facchini wrote:
> > >If you know of something even similar to what I'm looking for, let
> me
> > >know.
> >
&g
--- Philip Warner <__> wrote:
> At 08:43 PM 26/08/2004, Riccardo G. Facchini wrote:
> >If you know of something even similar to what I'm looking for, let
> me
> >know.
>
> My thinking is to modify pg_dump to add a new output format, but I'd
> like
&g
--- Philip Warner <__> wrote:
> At 08:04 PM 26/08/2004, Riccardo G. Facchini wrote:
> >Does somebody know of a script that does this job?
>
> No, but a very useful idea.
>
> Sounds like another dump format to me -- so long as a well-defined
> structure that is l
Hi All,
Does somebody know of a script that is capable of creating a CVS tree
based on the structure of a given schema or database?
I have a development DB that is structured with a lot of tables,
functions, views, indexes... I've been asked to publish all the changes
under a CVS tree, separating
c_codigo
from aca_m_cicloaniolectivo
where ent_codigo = $1 and
sec_codigo = $2 and
ani_codigo = $3)
else cic_codigo = $4
end
[]
regards,
=
Riccardo G. Facchini
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
offer.
>
> Regards,
>
> --Phil.
>
> ---(end of
> broadcast)---
> TIP 7: don't forget to increase your free space map settings
regards,
=
Riccardo G. Facchini
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--- Tom Lane <__> wrote:
> "Riccardo G. Facchini" <__> writes:
> > declare my_new_complex complex_number;
>
> > select * from complex_to_complex(my_new_complex) into my_result;
>
> > ERROR: column "my_new_complex" does not exist
lex) into my_result;
return my_result;
end;'
LANGUAGE 'plpgsql' VOLATILE;
--- version 2
CREATE or replace FUNCTION public.really_really_complex(complex_number)
RETURNS complex_number AS
'declare my_complex alias for $1;
declare my_result complex_number;
begin
my_result :=
ite what's expressed above...
is there somebody that can provide some help and/or some examples?
thanks in advance,
=====
Riccardo G. Facchini
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
s
nderstand it, NEW (and OLD) is a variable of
type record, so you should be able to pass it to a function and get it
as a return value, but it seems that there is a bug reported for
version 7.2.1 that inhibits the use of record as type to be passed to a
function.
any suggestion?
=
Riccardo G. Facchini
---(end of broadcast)---
TIP 8: explain analyze is your friend
I find that's helpful.
> --
> Richard Huxton
> Archonet Ltd
>
> ---(end of
> broadcast)---
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
So, If I have to do a rec
22 matches
Mail list logo
