On Tue, Jun 14, 2005 at 07:28:22AM +0200, Hortschitz, Stefan wrote:
>
> sometimes if i'm adding new rows to the table with statements like
> this:
>
> insert into (name,value) ('xy','xy');
>
> the database only returns an 'duplicate key on primary key', which
> should be prevented by the s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I would normally just set minimum value to something greater than what
> already in the table,
That's the way to go.
> but the manually keyed values are all over the place, and I guess I'd
> really like to remove the gaps in the current values.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> and sometimes if i'm adding new rows to the table with statements like
> this:
> insert into (name,value) ('xy','xy');
Show us the actual SQL, not something "like" it. The above is not valid.
> CREATE SEQUENCE session.preferences_id_seq
> START
On Mon, Jun 13, 2005 at 21:58:37 +0200,
"Hortschitz, Stefan" <[EMAIL PROTECTED]> wrote:
>
> CREATE TABLE session.preferences
> (
> id serial NOT NULL,
> name varchar(50),
> value varchar(255),
> CONSTRAINT session_preferences_pkey PRIMARY KEY (id)
> )
> WITHOUT OIDS;
> ALTER TABLE sess
On Tue, Jun 14, 2005 at 11:15:33 -,
Marcos <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have one server postgresql in my home computer, and now I have the
> necessity of access it of my work, the question is. How I liberate the
> access remote of postgresql with password?
You want to edit
On Thu, Jun 16, 2005 at 11:41:00 +0200,
Stefan Bayer <[EMAIL PROTECTED]> wrote:
> I want to create the postgresql service user unattended (in a batch
> process). How can I do that? Especially I couldn't create the right to logon
> as service.
>
> What is the correct procedure to create a service
