Hi All,
Is it possible to insert
n rows with 1 or 2 invalid rows
using copy command. I used it, it rollbacks everything even if 1 row
gets an error. Is their any other way to do it.
TIA
--
regards,
Deepa K.
Steve Lane <[EMAIL PROTECTED]> writes:
> Ron Johnson <[EMAIL PROTECTED]> writes:
>
> > > Dennis Gearon <[EMAIL PROTECTED]> writes:
> > >
> > > This doesn't provide what online backups do, of recovery to the minute of the
> > > crash. And I get nervous having only logical pg_dump output, no backu
There are a bunch of these in PG's log:
ERROR: Invalid page header in block 14 of
start_items_key
What does it mean? PG seems to be working fine -
anything I need to fix/adjust/worry about?
TIA,
CSN
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved prod
Hello,
just published 2.0.2b1, it was on the way from some time.
Please test it,
feel free to send patches.
Bruno BAGUETTE Scrive:
It cannot find the necessary pg header files. If you haven't
installed them you need to do so. If you've installed them
someplace other than /usr/local/pgsq
Relaxin wrote:
> Then there is a website of Bruce Momjian (can't remember the link) that
> gives you the status of the Windows port.
http://momjian.postgresql.org/main/writings/pgsql/win32.html
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Hi everybody,
i need a free tutorial on database design can any help ??
thx
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Hi,
I have a table, where one of the columns "extradata" is a gob of XML.
I'd like to be able to create an index on this function.. so i tried
this
CREATE INDEX actitemsXML_idx ON act_items
(pgxml_xpath(extradata,'//RequestInfo/refund_id/text()','',''));
And i got this nice little error
ERROR:
On Mon, 2003-10-06 at 16:52, Mike Mascari wrote:
> Nagib Abi Fadel wrote:
>
> > Hi everybody,
> >
> > i need a free tutorial on database design can any help ??
>
> How about "A Simple Guide to Five Normal Forms in Relational Database
> Theory, Communications of the ACM 26(2), Feb. 1983":
>
> h
[EMAIL PROTECTED] (Shridhar Daithankar) writes:
> And I also configured a system on laclinux.com, just for curiosity. 2x
> 1.8GHz/4GB/36GBx2 10K RPM SCSI/Adaptec 29320 for $4800/- is damn cheap
> a system. HP does not even start below $5K for 64 bit systems.
What is _most_ interesting about these
Hi Tom,
Thanks for the fast response. One learns something new everyday!
Cheers,
Jason
On Tue, 7 Oct 2003 12:14 am, Tom Lane wrote:
> Jason Godden <[EMAIL PROTECTED]> writes:
> > I'm in the process of moving a rather complicated plpgsql stored
> > procedure to a C module and I'm curious about
Nagib Abi Fadel wrote:
> Hi everybody,
>
> i need a free tutorial on database design can any help ??
How about "A Simple Guide to Five Normal Forms in Relational Database
Theory, Communications of the ACM 26(2), Feb. 1983":
http://209.197.234.36/db/simple.html
Mike Mascari
[EMAIL PROTECTED]
Two questions:
1) how would I go about doing that
2) is there any change that doing that could break other things?
thanks,
Rick Gigger
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Rick Gigger" <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 2:57 PM
Subject: Re: [GE
Relaxin wrote:
> But if you are a potential end-user of your product, you don't know this.
> I still think the Website should be the point of contact for potential user
> to be able to find out where things stand and how to find out other
> important information that an end user my what or need to
Is there any possiblity of adding an option for compatibilityes sake (or
does one already exist) to revert to the old behavior. This has currently
kept me from upgrading beyond 7.2.4 thus far in production as it will break
all of my apps. I can slowly update them but many of them don't get change
Has some one come up with a similar type script that could be used in a
Postgresql database?
The script below was created for a SQLServer database.
Thx,
-Martin
++
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci913717,00.html
In the early stages of
"Rick Gigger" <[EMAIL PROTECTED]> writes:
> What was it that changed in 7.3 that made this behavior change. (it worked
> in 7.2)
7.2 allowed implicit casts from text to smallint, I think.
regards, tom lane
---(end of broadcast)
I guess then I will switch to use COPY "tablename (fieldlist)" FROM. Will
this end up being faster anyway.
In case anyone was wondering here is a good example of how to do it in php
from:
http://us4.php.net/manual/en/function.pg-put-line.php
thanks,
Rick Gigger
- Original Message -
On Mon, 2003-10-06 at 11:59, Lamar Owen wrote:
> On Monday 06 October 2003 10:08 am, Marc G. Fournier wrote:
> > On Fri, 3 Oct 2003, Relaxin wrote:
> > > Unless you are one the core developers of Postgresql it's pretty hard to
> > > keep up with what is "really" going on with this product.
>
> > n
On Monday 06 October 2003 10:08 am, Marc G. Fournier wrote:
> On Fri, 3 Oct 2003, Relaxin wrote:
> > Unless you are one the core developers of Postgresql it's pretty hard to
> > keep up with what is "really" going on with this product.
> no it isn't, just read -hackers ...
That is the only way to
But if you are a potential end-user of your product, you don't know this.
I still think the Website should be the point of contact for potential user
to be able to find out where things stand and how to find out other
important information that an end user my what or need to know.
""Marc G. Fourni
As your new PostgreSQL "Master of Ceremonies", I will be posting occasional
opportunities for speakers and presenters.
In an effort to ensure quick placement for these positions, I would like to
endeavour to create a database of available individuals --and remember, we
need people from all parts
Ron Johnson wrote:
All that we basically need for PITR is to provide management code that
lets old WAL segments get archived off to tape (or wherever) rather than
deleted, plus some kind of control that lets the roll-forward process be
stopped at the desired point-in-time rather than necessarily ru
22 matches
Mail list logo
