Thank you very mutch.
On Wednesday 6 November 2002 14:46, Nick Fankhauser wrote:
> Fred-
>
> I'm not familiar with phppgsql, so I can't help with the specific problem
> there, but perhaps someone else on the list can help with the next step.
> You do seem to be getting a connection at this point,
When I try to create a new row in this table and do not explicitly
define a unique value for datadefindex I get the following error
message:
ERROR: Cannot insert a duplicate key into unique index datadef_pkey
Here is the INSERT statement that generated the error:
tmdb=# insert into datadef (
Andrew
1) Would you use erServer in a non-DBA environment?
2) Could you point me to further info on what type of failures could
possibly occur using the solution below with Rsync?
Initially when I read the article below, I was skeptical it would work,
as I said to myself how is that any differen
Tom Lane wrote:
>IIRC, there were some problems with sequences going backwards after a
>crash in 7.2. If you are on 7.2.x for x < 3, you are running a version
>with serious known bugs; you should update before complaining too much
>...
Crazy question, but how do I determine the version number?
"Stephane Charette" <[EMAIL PROTECTED]> writes:
> If I run "postmaster --version", I get told "postmaster (PostgreSQL)
> 7.2".
> Does that really mean "7.2"?
Yes, it does. You could double-check with "select version()" though.
regards, tom lane
-
I have the following situation:
when a new record is inserted in
to a psql table, i want to be able to update certain fields. the way i'm
doing it right now..to find the last record inserted...is by sorting the primary
key (serial) in descending order and taking the first item in the l
Has anyone used postgres w/ an external disk array? I'm sure a single
postgres instance would work fine with one.
While researching the server clustering techniques of other RDBMS I came
upon Oracle 9's "RAC" clustering. It appears to use a stand alone array for
the real storage and multiple "he
Hi, All
Could anyone tell me how could I get the source table & field name
from a view field?
Regards,
Ho.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
The sequence needs to be reset:
select setval('datadef_datadefindex_seq',(select max(datadefindex) from
datadef));
This will do it for you.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of Ben Kassel
> Sent: Monday, November 04, 2002
It would appear to me that you are really doing this the hard way.
If you are trying to set/change fields in the same row that you are
inserting (say to force an add date or userid) you could use an INSTEAD
rule to transform the insert passing through the fields you don't wish to
change and transf
Yes Roberto ,
Trigger are very relaible and are fired in intutive manner.
(trigger is fired for every insert )
read documentation of create trigger
regds
mallah.
regds
mallah.
> I have the following situation:
>
>when a new record is inserted in to a psql table, i want to be able to up
On Mon, Nov 04, 2002 at 21:05:17 -0600,
Roberto Benitez <[EMAIL PROTECTED]> wrote:
> I have the following situation:
>
> when a new record is inserted in to a psql table, i want to be able to update
>certain fields. the way i'm doing it right now..to find the last record
>inserted...is by
Who created the view ?
Are you talking about from a programming language interface, or from a psql
console?
\d view_name
will show you the fields and the view definition in the psql console is
that not what you want?
Sorry if I'm not helping - I may well not understand quite what it is you're
On Mon, 4 Nov 2002, Roberto Benitez wrote:
> when a new record is inserted in to a psql table, i want to be
> able to update certain fields. the way i'm doing it right now..to
> find the last record inserted...is by sorting the primary key (serial)
> in descending order and taking the first i
Naomi Walker wrote:
> Can we add unload/load functionality to the list, please?
>
>
>
> > > >Yes, agreed, it would be nice to have WHERE as part of COPY. In fact, I
> > > >like Informix's solution, which merges data in/out with INSERT/SELECT:
> > > >
> > > > UNLOAD TO '/tmp/x'
> > > >
Our client is running a large-ish database, and has infrequently been
getting the following messages:
Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 6 - fixing
Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 7 - fixing
Nov 6 04:17:09 dolidb-n
Timothy D McKernan <[EMAIL PROTECTED]> writes:
> Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
> page 6 - fixing
> I'd like to know what this means to our system - what causes an
> uninitialized page? What could cause it to be so infrequent?
"Uninitialized" means "page co
17 matches
Mail list logo
