Hai friends,
I have a sequence called raj_seq with max value 3000.
I have a table, with one field haveing
nextvalu('raj_seq') as default value.;
now i wanted to increase the max value of the raj_seq
to 999.
How to do this change?
If i drop and recreate the raj_seq, then i have to
recreate the t
On 4 Dec 2002 at 4:29, raja kumar thatte wrote:
> Hai friends,
> I have a sequence called raj_seq with max value 3000.
> I have a table, with one field haveing
> nextvalu('raj_seq') as default value.;
> now i wanted to increase the max value of the raj_seq
> to 999.
> How to do this change?
h
Hai friend,
Thanks. But I wanted to change the maximum value but
not current value. How to change the maximum value of
a sequence
raja
--- Dan Langille <[EMAIL PROTECTED]> wrote:
> On 4 Dec 2002 at 4:29, raja kumar thatte wrote:
>
> > Hai friends,
> > I have a sequence called raj_seq with max v
On 4 Dec 2002 at 5:20, raja kumar thatte wrote:
> Hai friend,
> Thanks. But I wanted to change the maximum value but
> not current value. How to change the maximum value of
> a sequence
I'm sorry. I shouldn't reply to questions first thing in the
morning.
That I don't know, but I'm sure it can
Drop the sequence and recreate with a min. value greater your last value and
the new max. value.
Egon
raja kumar thatte wrote:
> Hai friends,
> I have a sequence called raj_seq with max value 3000.
> I have a table, with one field haveing
> nextvalu('raj_seq') as default value.;
> now i wanted
I meant start value (inst. min.).
Egon Reetz wrote:
> Drop the sequence and recreate with a min. value greater your last value and
> the new max. value.
>
> Egon
>
> raja kumar thatte wrote:
>
> > Hai friends,
> > I have a sequence called raj_seq with max value 3000.
> > I have a table, with one
Thsnkd
--- Egon Reetz <[EMAIL PROTECTED]> wrote:
> I meant start value (inst. min.).
>
> Egon Reetz wrote:
>
> > Drop the sequence and recreate with a min. value
> greater your last value and
> > the new max. value.
> >
> > Egon
> >
> > raja kumar thatte wrote:
> >
> > > Hai friends,
> > > I have
Thanks
--- Egon Reetz <[EMAIL PROTECTED]> wrote:
> I meant start value (inst. min.).
>
> Egon Reetz wrote:
>
> > Drop the sequence and recreate with a min. value
> greater your last value and
> > the new max. value.
> >
> > Egon
> >
> > raja kumar thatte wrote:
> >
> > > Hai friends,
> > > I have
Hello,
ist there any way to cancel a user query as dba ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast)---
Andreas Schmitz <[EMAIL PROTECTED]> writes:
> ist there any way to cancel a user query as dba ?
Send a SIGINT to the backend process running that query, eg
kill -INT
This has the same effect as a user-requested cancel (eg ^C in psql).
regards, tom lane
Tom Lane wrote:
> Andreas Schmitz <[EMAIL PROTECTED]> writes:
> > ist there any way to cancel a user query as dba ?
>
> Send a SIGINT to the backend process running that query, eg
>
> kill -INT
>
> This has the same effect as a user-requested cancel (eg ^C in psql).
And finally documente
On 31 Oct 2002 at 10:18, Nick Sayer wrote:
> Andrew Perrin wrote:
>
> >- Do a formal backup more often
> >
> >
> >
> For what it's worth, the FreeBSD "port"
> (http://cvsweb.freebsd.org/ports/databases/postgresql7/) for
> PostgreSQL contains a most excellent daily maintenance script (as
> writ
hello list!
i want to use database names that are longer than 32 characters.
i found that in pg_database the field datname is responsible for this
how can i change the length?
i am using postgresql 7.2.1
greets
ralf praschak
---(end of broadcast)---
We have increased identifier length in 7.3, and in 7.2 you can alter
include/postgres_ext.h NAMEDATALEN and recompile everything, including
client applications/interfaces.
There is another limit, but one good thing is that in 7.2, I think,
SM_DATABASE in src/include/pqcomm.h is already 64, so if
Hi Bhuvan & Mallah,
Have you checked desabling of triggers. What reltriggers represent. If we
set it as '0' to enable by what value it has to be updated.
Sreedhar
- Original Message -
From: "Bhuvan A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 3:16 PM
Subj
To Connct database as the following parameters.
host : 'localhost'
username : 'xxx'
password : 'xxx'
database : 'xx'
What will be the entry in pg_hba.conf
I gave the entry as
host all 127.0.0.1 255.255.255.0 password.
Which is rejecting user xxx. User 'xxx' is already in pg_shadow.
Cheers,
Sr
On Wed, 2002-12-04 at 12:29, raja kumar thatte wrote:
> Hai friends,
> I have a sequence called raj_seq with max value 3000.
...
> now i wanted to increase the max value of the raj_seq
> to 999.
> How to do this change?
> If i drop and recreate the raj_seq, then i have to
> recreate the table a
On Wed, Dec 04, 2002 at 09:33:52AM -0800, Dustin Sallings wrote:
> Around 20:41 on Dec 4, 2002, Hannu Krosing said:
>
> What's wrong with this:
>
> dustin=# create sequence test_seq;
> CREATE SEQUENCE
> dustin=# select nextval('test_seq');
> nextval
> -
>1
> (1 row)
>
> du
On Wed, 2002-12-04 at 17:33, Dustin Sallings wrote:
> What's wrong with this:
>
> dustin=# create sequence test_seq;
> CREATE SEQUENCE
> dustin=# select nextval('test_seq');
> nextval
> -
>1
> (1 row)
>
> dustin=# select setval('test_seq', );
> setval
>
>9
Oliver Elphick wrote:
> On Wed, 2002-12-04 at 12:29, raja kumar thatte wrote:
> > Hai friends,
> > I have a sequence called raj_seq with max value 3000.
> ...
> > now i wanted to increase the max value of the raj_seq
> > to 999.
> > How to do this change?
> > If i drop and recreate the raj_seq,
Thanks everybody.
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Oliver Elphick wrote:
> > On Wed, 2002-12-04 at 12:29, raja kumar thatte
> wrote:
> > > Hai friends,
> > > I have a sequence called raj_seq with max value
> 3000.
> > ...
> > > now i wanted to increase the max value of the
> raj_seq
21 matches
Mail list logo
