Hi all pg admins,
here is the problem we're encountering now. We've got a pgsql database server,
logging informations (such as alarms, week-events and so on) for a measure system.
This database is mainly fed by a collect daemon which inserts/update values in tables
and generate
Hello,
How can I reset a sequence number back to 0 ?
Regards
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> How can I reset a sequence number back to 0 ?
>
SELECT setval('sequence_name', 0);
In order for this to work, the sequence must have been created with
a MINVALUE of 0 (the default MINVALUE is 1)
CREATE SEQUENCE sequence_name MINVALUE 0;
---(end of broadcast)---
Hi Jason,
I installed "CygWin" on my windows 2000 system. If i click cygwin prompt
just it is refershing.
Downloaded cygipc-1.09-2.tar.gz and i could not get where I have to put that
file.I your document you gave it as "/" directory.
where can i run all unix like commands on my windows system.
Would somebody kindly post a functional CallableStatement.java file here?
I got postgres7.2 installed, but the pgjdbc2.jar file doesn't support
callable statement as well. please, if someone knows where to find such a
file, give me some light.
Henry
---(end of broadcas
> One use of replication can be point-in-time recovery. The log of
> replication messages can be played back against a nightly backup to
> restore the system to the current state. It would be nice to hit both
> of these at the same time.
WAL currently has all that is needed for full instance m
On Sat, Feb 23, 2002 at 05:07:34PM +,
Lee Harr <[EMAIL PROTECTED]> wrote:
> > How can I reset a sequence number back to 0 ?
> >
>
> SELECT setval('sequence_name', 0);
>
>
> In order for this to work, the sequence must have been created with
> a MINVALUE of 0 (the default MINVALUE is 1)
>
Hi!
How does postgres deal with RBAC (Role Based Access Control), does it have
good support for it?, Isn't there any auxiliary tool to deal with it?, where
can I find more info about RBAC in postgres?
Thanks in advance.
Regards,
Denis
--
GMX - Die Kommunikationsplattform im Internet.
http://w
I have recently upgraded to postgresql 7.2.
When I try to take backup with pg_dump, one of the database is
generating
the following error.
pg_dump: query to obtain procedure name for trigger
"ins_extranet_cspm_bug" did not return exactly one result
I checked the for the trigger "ins_extranet_cs
On 25 Feb 2002, Srinivasa Rao Chava wrote:
> I have recently upgraded to postgresql 7.2.
> When I try to take backup with pg_dump, one of the database is
> generating
> the following error.
>
> pg_dump: query to obtain procedure name for trigger
> "ins_extranet_cspm_bug" did not return exactly on
[EMAIL PROTECTED] (Srinivasa Rao Chava) writes:
> pg_dump: query to obtain procedure name for trigger
> "ins_extranet_cspm_bug" did not return exactly one result
The most likely bet is that there's no function at all that matches the
OID stored in the trigger. Have you done any deletion/recreati
I use truncate table $table_name.
This will delete all data from that table and reset the sequense number.
- Original Message -
From: "Marc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 23, 2002 6:37 PM
Subject: [ADMIN] Reset sequence number
> Hello,
>
> How can
12 matches
Mail list logo
