The transistor has existed in homes now for 30 years. That means new
homes should be built to withstand direct lightning strikes without
damage. Such earthing is not difficult. But it requires the builder
to plan for the lightning protection 'system' before the footing are
poured. It is an ol
blackwater dev wrote:
In MySQL, I can use the replace statement which either updates the
data there or inserts it. Is there a comporable syntax to use in
postgreSQL?
I need to do an insert and don't want to have to worry about if the
data is already there or not...so don't want to see if it the
Steve Crawford wrote:
I'm having difficulty installing 8.0.4. Server is SuSE 8.2 without PG
installed. However some client libraries are Yast installed due to
dependency reconciliation.
I'm doing the standard install (./configure, make, make install) and
have created the postgres user and ap
Steve Crawford wrote:
I'm having difficulty installing 8.0.4. Server is SuSE 8.2 without PG
installed. However some client libraries are Yast installed due to
dependency reconciliation.
I'm doing the standard install (./configure, make, make install) and
have created the postgres user and ap
blackwater dev wrote:
In MySQL, I can use the replace statement which either updates the
data there or inserts it. Is there a comporable syntax to use in
postgreSQL?
I need to do an insert and don't want to have to worry about if the
data is already there or not...so don't want to see if it th
Ok,
so I decide to migrate from postgresql 8.0 to 8.0.4 and, as you do,
go to backup my database. On trying to navigate to my bin directory I
get an error message saying the directory doesn't exist. So I check
the pgsql folder and true enough the directory doesn't exist.
So how in the good
In MySQL, I can use the replace statement which either updates the
data there or inserts it. Is there a comporable syntax to use in
postgreSQL?
I need to do an insert and don't want to have to worry about if the
data is already there or not...so don't want to see if it there, if so
do update if n
Thanks to all who answered this question!
From: Brent Wood <[EMAIL PROTECTED]>
To: basel novo <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] newbie question: reading sql commands from script
Date: Wed, 26 Oct 2005 10:36:34 +1300 (NZDT)
On Tue, 25 Oct 2005, basel n
Miguel wrote:
Tom Lane wrote:
Increasing the WAL start address might help (see the pg_resetxlog man
page). Realize that you're probably going to be dealing with corrupted
data, however :-(
regards, tom lane
Ops, foget the last email, i reread the man, this is what i have to
Steve Crawford <[EMAIL PROTECTED]> writes:
> Note, the directories shown for libdir, bindir, includedir and such
> are not where the files were actually installed.
>
> Now I could just start shuffling files around till things work but
> since I've installed/upgraded many PG installations without
Tom Lane wrote:
Increasing the WAL start address might help (see the pg_resetxlog man
page). Realize that you're probably going to be dealing with corrupted
data, however :-(
regards, tom lane
Yeah, i know, but i only want to be able to finish the dump, i must
exec
I'm having difficulty installing 8.0.4. Server is SuSE 8.2 without PG
installed. However some client libraries are Yast installed due to
dependency reconciliation.
I'm doing the standard install (./configure, make, make install) and
have created the postgres user and appropriate data directory
Miguel <[EMAIL PROTECTED]> writes:
> ERROR: xlog flush request 98/E3E83848 is not satisfied --- flushed only
> to 98/C364344
> what can i do?
Increasing the WAL start address might help (see the pg_resetxlog man
page). Realize that you're probably going to be dealing with corrupted
data, howev
Hi, i had a server crash and after that , postgres refused to start, i
read on the list that pg_resetxlog could help me, indeed, after i run
pg_resetxlog dir_data, postgres started again, but i look a lot of these
errors:
CONTEXT: writing block 1 of relation 1663/17231/69118230
WARNING: coul
FYI, here is a map of my PostgreSQL trips, using Google:
http://candle.pha.pa.us/main/writings/map.html
---
Claire McLister wrote:
> I took a look at your map, this is great wonderful that you were
> already think
On Fri, Oct 28, 2005 at 01:47:49PM -0700, Benjamin Smith wrote:
> 1) Any problem with running "Analyze" hourly via cron?
Probably not. Analyze usually only reads a small portion of the table.
> 2) Does "Vacuum analyze" also do the actions performed by "Analyze"?
Yes, it does.
> 3) What's the
On Fri, 28 Oct 2005, David Gama Rodr??guez wrote:
Hello List
I' ve installed tsearch2 and is working perfectly
but I get this thing, I want to index more than 4 fields in one tsvector
so I think to use the setweight but it can only accept ABCD y need to have 5
letters or more
Is there any wa
Hello List
I' ve installed tsearch2 and is working perfectly
but I get this thing, I want to index more than 4 fields in one tsvector
so I think to use the setweight but it can only accept ABCD y need to
have 5 letters or more
Is there any way to change that? or changing the source code, but I
CG <[EMAIL PROTECTED]> writes:
> Thanks to the great suggestions I've at least gotten it to not hang...
>
> Martijn's hint about blocking led me to open up those filehandles in
> a non-blocking mode. It appears that write() will write, at a
> maximum, only 4096 bytes when it is called from within
I have a rapidly growing database with a very complex schema, and I'm looking
to improve performance. It's typical to have 2-4 foreign keys in each table,
and there are currently 113 tables, and queries with 5-10 tables with
combined inner/outer joins are pretty typical. (I avoid subqueries anyw
Thanks to the great suggestions I've at least gotten it to not hang...
Martijn's hint about blocking led me to open up those filehandles in a
non-blocking mode. It appears that write() will write, at a maximum, only 4096
bytes when it is called from within PostgreSQL. I've tried to push data int
Andrus wrote:
Can you use Postgres savepoints from VFP ?
sqlexec('ROLLBACK TO mysavepoint') and even sqlexec('ROLLBACK') cause C5
error.
I have no experience w/ savepoints yet. However, I will say that
sometimes ODBC will hijack your commands and alter them so you may want
to try turnin
Message-ID: <[EMAIL PROTECTED]>
Date: Fri, 28 Oct 2005 13:22:43 -0500 (CDT)
From: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: IMP/PHP IMAP webmail program 2.2.8
X-Originating-IP: 200.34.166.34
Hi
This is postgresql 7.
Martijn van Oosterhout writes:
> The things that have screwed me up in the past with pulling tricks like
> this are:
>
> 1. Program has registered atexit() handlers. _exit() avoids this.
> 2. Pending stdio output that gets flushed. The backend doesn't use
> stdio much so you might be fine here.
>
On Fri, Oct 28, 2005 at 11:59:03AM -0400, Douglas McNaught wrote:
> Dennis Jenkins <[EMAIL PROTECTED]> writes:
>
> > Is it safe for the postgres engine to fork()? Would
> > the child need to close down anything immediately in
> > its main() to avoid corrupting the parent?
>
> I *think* (Tom may
Dennis Jenkins <[EMAIL PROTECTED]> writes:
> Is it safe for the postgres engine to fork()? Would
> the child need to close down anything immediately in
> its main() to avoid corrupting the parent?
I *think* (Tom may correct me) that as long as you don't call into the
backend code at all in the c
--- CG <[EMAIL PROTECTED]> wrote:
>
> There's no other way to load data into the toolkit!
> (Can you /feel/ the
> insanity?)
>
> Does this give you any more insight into an
> alternate method of getting this
> thing done?
>
Write a completely seperate process to process your
FDF stuff. Have th
--- Douglas McNaught <[EMAIL PROTECTED]> wrote:
> CG <[EMAIL PROTECTED]> writes:
>
> > Does this give you any more insight into an
> alternate method of getting this
> > thing done?
>
> I would fork(), set up file descriptors
> appropriately, then have the
> child call the Adobe library and th
--- Martijn van Oosterhout wrote:
> On Fri, Oct 28, 2005 at 07:24:12AM -0700, CG wrote:
> Not entirely sure, but I'm sure the size of the write matters. For
> example, if your test rpogram, did you check that the write actually
> wrote everything?
There's beginning and ending tokens in the FDF f
On 10/28/05, alessandra de gregorio <[EMAIL PROTECTED]> wrote:
What function should I use to get a serial number, together with my results,from a query?Ex. Of output I want:1 ooo pp ij2 hou joo iu3 bhi ft yhBasically, I would like to have one column with
On Fri, Oct 28, 2005 at 07:24:12AM -0700, CG wrote:
> So it might be a kernel thing. What is different when the function is called
> from within PostgreSQL that is different that the function being called in a
> standalone program?
Not entirely sure, but I'm sure the size of the write matters. For
Destructive surges seek earth ground. Do you think a protector is
going to stop what 3 miles of non-conductive sky could not? And yet
that is exactly what some protectors manufacturers hope you will
assume.
Effective protectors don't stop, block, or absorb typically
destructive transients.
CG <[EMAIL PROTECTED]> writes:
> Does this give you any more insight into an alternate method of getting this
> thing done?
I would fork(), set up file descriptors appropriately, then have the
child call the Adobe library and the parent feed the data to it.
Once the document is loaded in the chil
My ref:
http://developer.postgresql.org/docs/postgres/plpgsql-declarations.html
WHAT AM I MISSING in my ORACLE to PG Port?
--1) I write
CREATE FUNCTION func1( var_1 INOUT T_TABLE1.C_COL1%TYPE, var_2 IN
INTEGER) AS.
--2) It works but,
NOTICE: type reference T_TABLE1.C_COL1%TYPE converted to
One of the many problems with FAT32 was that files on the drive can
be deleted if power is lost. This is why FAT was obsoleted by HPFS
which in turn was obsoleted by NTFS.
Power loss should not cause data loss which is why we stopped using
FAT even before Windows 95 was released.
Program t
Hi,
What function should I use to get a serial number, together with my results,
from a query?
Ex. Of output I want:
1 ooo pp ij
2 hou joo iu
3 bhi ft yh
Basically, I would like to have one column with integers, from 1 onwards, no
matter how man
huh never heard of that - I'll hold out testing it for now but thats
good info. (how does it know which partition - if there's 2?)
Troy H
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresq
Jim C. Nasby wrote:
SELECT * FROM pg_stat_activity;
Note that if you turn on stats_command_string you'll also be able to see
what each connection is doing if you're connected as a superuser.
Just as a little FYI, on 8.1 pg_stat_activity will show the IP address
and port as well, but onl
Michael Schuerig <[EMAIL PROTECTED]> schrieb:
>
> I'm looking for information on learning how to write stored procedures
> and server-side programming in general. The docs provide a reference,
Falls Du in der Nähe von Dresden wohnst: dort ist morgen Linux-Info-Tag
und ein paar Leute der deutsc
--- Martijn van Oosterhout wrote:
> On Fri, Oct 28, 2005 at 06:38:29AM -0700, CG wrote:
>
> Umm, what *are* you trying to do? Is this running in the backend?
Yes, running on the back-end. I'm trying to utilize Adobe's FDF toolkit to
parse the FDF files stored in my database. They distirubte a C
I'm looking for information on learning how to write stored procedures
and server-side programming in general. The docs provide a reference,
of course, but that only tells what one can do, not what one should do.
In particular, I'm interested in how server programming fits in with
system archi
I have read it before - it's a _fantastic_ resource, and I will
probably make every junior tech I ever hire read it too.
On 10/28/05, Bruce Momjian wrote:
> Alex Turner wrote:
> > Of course not counting the Western Digital Raptor SATA drive, which
> > are priced more like SCSI drives also, and ha
Alex Turner wrote:
> Of course not counting the Western Digital Raptor SATA drive, which
> are priced more like SCSI drives also, and have many of the features
> of a SCSI drive including NCQ
>
Well, the PDF talks about several aspects of server drives, including
concurrency, performance, and rel
Of course not counting the Western Digital Raptor SATA drive, which
are priced more like SCSI drives also, and have many of the features
of a SCSI drive including NCQ
Alex
On 10/28/05, Bruce Momjian wrote:
> Andrus wrote:
> > >> QUANTUM FIREPALLP LM20.5 is a widely used ATA IDE drive.
> > >>
> >
On Fri, Oct 28, 2005 at 06:38:29AM -0700, CG wrote:
> PostgreSQL 7.4 ...
>
> Essentially, I've written a function in C for use with PostgreSQL. The
> debugger
> shows that the program is hanging on the part of the program that is writing
> data into it's own STDIN.
Umm, what *are* you trying to
Le 2005 10 26 09:36, Martijn van Oosterhout a ecrit:
> On Tue, Oct 25, 2005 at 11:25:22AM -0700, Cosmopo wrote:
> > Hello,
> >
> > We are presently experimenting with Postgresql schemas... We used basic
> > commands like \d to list info from all tables/sequence/owner in a
> > db... The schema info
PostgreSQL 7.4 ...
Essentially, I've written a function in C for use with PostgreSQL. The debugger
shows that the program is hanging on the part of the program that is writing
data into it's own STDIN.
[snip]
// Open up and hijack STDIN
int pipe_pair[2];
int pipe_rv = pipe(pipe_pair);
i
Andrus wrote:
> >> QUANTUM FIREPALLP LM20.5 is a widely used ATA IDE drive.
> >>
> >> Where do find information does it implement write caching properly or not
> >> ?
> >
> > I don't think the manufacturers bother to make this sort of information
> > available.
> >
> >> Is there IDE drive compati
>> QUANTUM FIREPALLP LM20.5 is a widely used ATA IDE drive.
>>
>> Where do find information does it implement write caching properly or not
>> ?
>
> I don't think the manufacturers bother to make this sort of information
> available.
>
>> Is there IDE drive compatibility list for Postgres ?
>
> N
49 matches
Mail list logo
