I'm looking for a way to create a trigger function that gets
called once per transaction as an AFTER EVENT.
Because there is no option for creating such
a trigger function I was looking at the "create constraint trigger"
command.
My approach would be to check the current transaction id to
The PostgreSQL manual explain that from 8.1 the default behavior
(governed by default_with_oids system parameter) is to create user
tables "without oids".
Well, at the page
http://www.postgresql.org/docs/8.1/interactive/datatype-oid.html , the
manual report this:
"Object identifiers (OIDs) ar
The following query, give six differents kind of context presents on the
system view pg_settings, that list all postgresql current parameters
setting.
postgres=# select distinct context from pg_settings;
context
backend
internal
postmaster
sighup
superuser
user
(6 rows)
What's
"Francesco Dalla Ca'" <[EMAIL PROTECTED]> writes:
> What's the mean for 'backend', 'postmaster' and 'sighup' context of a
> parameter? How i can know if a parameter is modifiable only with a
> server restart, rather than a 'pg_ctl reload' (sighup?) or a "SET/ALTER
> USER/ALTER DATABASE" command?
On Mon, May 08, 2006 at 12:09:13PM +0200, Francesco Dalla Ca' wrote:
> The PostgreSQL manual explain that from 8.1 the default behavior
> (governed by default_with_oids system parameter) is to create user
> tables "without oids".
>
> Well, at the page
> http://www.postgresql.org/docs/8.1/intera
I was looking at the files inside my database and came
across files which have the same OID number as the filename but some had
extensions (in my case .1 and .2).
What are these files? Can they be safely deleted?
In my case, they are quite large (over 1GB each).
Regards,
Benja
Thanks.
That definitely would not have been pretty
J
From: Larry Rosenman
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 2:45 PM
To: Benjamin Krajmalnik;
[email protected]
Subject: RE: [ADMIN] PostgreSQL
8.1.3/Windows
They are the 1GB segments of your
tabl
They
are the 1GB segments of your tables. You should NOT delete
them.
LER
--Larry Rosenman
Database Support
EngineerPERVASIVE SOFTWARE. INC.12365B RIATA TRACE
PKWY3015AUSTIN TX 78727-6531Tel: 512.231.6173Fax:
512.231.6597Email: [EMAIL PROTECTED]Web: www.pervasive.com
From:
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> writes:
> I was looking at the files inside my database and came across files
> which have the same OID number as the filename but some had extensions
> (in my case .1 and .2).
You might care to read
http://www.postgresql.org/docs/8.1/static/storag
Thanks..that really helped!!
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 7:44 PM
To: Sriram Dandapani
Cc: [email protected]
Subject: Re: reset all sequences
On Thu, May 04, 2006 at 14:20:39 -0700,
Sriram Dandapani <[EMAIL PRO
Title: Synchronized Replication
Hello. I have been reading up on Sony Replication, and at first I thought Master/Slave between two offices would be perfect for my situation. After I got more info though I believe it may not suit my needs. If I want the two databases to be in synchronization (
Hi
How
can I reset the sequence to “1”
If
I use the following statement
Select
setval('mytable_id_seq',1);
I
put the last value as 1
So
when I insert a new row the value will be “2”
and not “1” as it
should be
I
cannot put Select setval('mytable_id_seq',0);
What
should I do ??!!
On Tue, 9 May 2006, Pascal Tufenkji wrote:
> How can I reset the sequence to "1"
>
> If I use the following statement
>
> Select setval('mytable_id_seq',1);
>
> I put the last value as 1
>
> So when I insert a new row the value will be "2" and not "1" as it should be
>
> I cannot put Select setval
13 matches
Mail list logo
