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
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 ??!!
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 (
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: pgsql-admin@postgresql.org
Subject: Re: reset all sequences
On Thu, May 04, 2006 at 14:20:39 -0700,
Sriram Dandapani <[EMAIL PRO
"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 definitely would not have been pretty
J
From: Larry Rosenman
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 2:45 PM
To: Benjamin Krajmalnik;
pgsql-admin@postgresql.org
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:
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
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
"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?
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
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
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
13 matches
Mail list logo
