> On Apr 21, 2017, at 3:29 PM, Michael Paquier
> wrote:
>
>> On Sat, Apr 22, 2017 at 3:02 AM, Ian Harding wrote:
>> Am I misunderstanding how this works? I have WAL archiving set up, so the
>> files are available, but I wanted them included in the backup.
>
&g
I used this command to set up a streaming replica and it worked perfectly.
I tried to run it to create an online backup of the master on that replica
for backup purposes and it seems not to have worked as well.
I thought that streaming the WAL would eliminate the need to keep tons of
WAL around,
On Fri, Dec 5, 2014 at 4:55 PM, Ian Harding wrote:
> I have a function that returns bigint[] and would like to be able to
> compare a bigint to the result.
>
> freeload=> select fn_descendents('trip'::varchar,61::bigint);
&
I have a function that returns bigint[] and would like to be able to
compare a bigint to the result.
freeload=> select fn_descendents('trip'::varchar,61::bigint);
fn_descendents
---
{935,815,689,569,446,325,205,191}
(1 row)
freeload=> select 935::bigint i
Forgot to include the list! Sorry!
If you have a non-standard socket file location pg_upgrade will not work
for this upgrade.
On Fri, Apr 5, 2013 at 9:37 AM, Leonardo Carneiro wrote:
> Beside all notes, i recommend you to use pg_upgrade, to avoid a complete
> backup/restore in your transition.
Ack! Sorry. Bad list etiquette in so many ways...
-- Forwarded message --
From: Ian Harding
Date: Sun, Mar 3, 2013 at 8:26 PM
Subject: Re: [GENERAL] pg_upgrade
To: Bruce Momjian
It doesn't seem to though. Here's what I get when I leave it alone (no
iss unless the PGPORT
environment variable is set to match.
I'll try that tonight.
On Fri, Feb 15, 2013 at 10:09 AM, Ian Harding wrote:
> This is interesting, although I'm not sure it's relevant. From pg_ctl
> source.
>
>
> 00477
quot;\n%s: -w option is not supported when starting a pre-9.1 server\n"),
On Fri, Feb 15, 2013 at 9:45 AM, Ian Harding wrote:
>
> -
> pg_upgrade run on Fri Feb 15 05:09:34 2013
> -
.could
not start server
The funny thing is, the server starts instantly.
On Fri, Feb 15, 2013 at 9:19 AM, Jeff Janes wrote:
> On Fri, Feb 15, 2013 at 4:54 AM, Ian Harding
> wrote:
> > I don't think it would get any further... It fails and --retain say
he server, when run with the -w flag.
On Thu, Feb 14, 2013 at 10:41 PM, Ian Lawrence Barwick wrote:
> 2013/2/15 Ian Harding
> >
> >
> > On Feb 14, 2013, at 9:50 PM, Ian Lawrence Barwick
> wrote:
> >
> > 2013/2/15 Ian Harding
> >>
> >> When I
Old is 8.4, new is 9.2. I am not supplying an but the minimum options and
--check succeeds. My pg_ctl fails when run by hand with -w (although the
database does start) so I know that's the issue.
On Feb 14, 2013, at 9:50 PM, Ian Lawrence Barwick wrote:
> 2013/2/15 Ian Harding
>&
When I run pg_upgrade, it tries to start the old cluster with the -w flag,
which waits a while and declares failure, even though it starts the
server. If I start/stop without -w everything is great.
Can I tell pg_upgrade not to use that flag, or is there a reason it is not
working that I should l
On Tue, Nov 6, 2012 at 5:45 AM, Kevin Grittner wrote:
> Darren Duncan wrote:
> > Ian Harding wrote:
>
> >> It says everything is happy as normal...
> >>
> >> 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48
> >
> > Wha
On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman wrote:
> On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote:
> >
> >
> >
> > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman
> wrote:
> >>
> >> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding
> w
On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman wrote:
> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote:
> >
> >
> > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman
> wrote:
> >>
> >> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding
> wrote:
>
On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote:
> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote:
> > I had a 9.0.8 hot standby setup, one master, two slaves, working great.
> > Then, I tried to re-initialize by making a base backup, the way I've
> done it
>
I had a 9.0.8 hot standby setup, one master, two slaves, working great.
Then, I tried to re-initialize by making a base backup, the way I've done
it many times before, but for some reason I can't get the standby to accept
connections. I copied the postgresql.conf and recorvery.conf out of the
way,
On Thu, Oct 11, 2012 at 8:56 AM, Scott Mead wrote:
> Hey Ian,
>
>
> On Thu, Oct 11, 2012 at 10:52 AM, Ian Harding wrote:
>>
>> I know this is the wrong place, but I tried creating an account on
>> their site to contact them and it does not work.
>>
>
>
I know this is the wrong place, but I tried creating an account on
their site to contact them and it does not work.
The 9.0.10 package throws an error when I try to install it that it
has an unsatisfied dependency on libpython. Since it brings its own
libraries, I'm not sure why that would be, bu
On Sunday, May 20, 2012, Martijn van Oosterhout wrote:
> On Sun, May 20, 2012 at 12:26:26AM -0700, Ian Harding wrote:
> > I have a situation where an increase in volume of inserts into the
> > main transaction table causes a huge slowdown. The table has lots of
> > indexes a
I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys and a trigger.
Clearly, something is causing a resource contention issue, but here's
my main question:
I have log_lock_waits = on and
On Thu, Oct 20, 2011 at 11:42 AM, Raghavendra
wrote:
> On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce wrote:
>>
>> On 10/20/11 2:33 AM, Raghavendra wrote:
>>>
>>> Am assuming you are having $PGDATA (data directory) and their WAL
>>> Archives.
>>
>> he said he does not have the base backup ($PGDA
Well, they are actually streaming replication slaves, and I boogered
up the rsync command, so there they are. I diffed the directories
from the master to the slave, and think I will go ahead and delete all
the files that don't appear in both places and see what happens.
Worst case, I have to set t
If someone happened to accidentally end up with a lot of files that
were NOT part of their database in the data/base/X directory, how
could they go about getting a reliable list of files they could safely
delete? The files were there before the current incarnation of the
database, so have ctim
On Thu, Sep 29, 2011 at 5:32 PM, Fujii Masao wrote:
> On Fri, Sep 30, 2011 at 1:35 AM, Ian Harding wrote:
>> I updated the firewall rules on a streaming replication standby server
>> and thought nothing of it. I later happened to notice on the primary
>> that ps aux | gr
I updated the firewall rules on a streaming replication standby server
and thought nothing of it. I later happened to notice on the primary
that ps aux | grep stream didn't show streaming to that server
anymore. On the standby that command still showed the wal receiver
patiently waiting for new d
If you install using a package manager, you might only have to install
the postgresql-pltcl (or similarly named) package, then do
createlang pltcl mydatabase
from the command line and you are ready to go. If you build from
source, you have to worry about prerequisites yourself.
On Thu, Sep 15,
On Fri, Sep 16, 2011 at 8:35 AM, hubert depesz lubaczewski
wrote:
> On Fri, Sep 16, 2011 at 08:02:31AM -0700, Ian Harding wrote:
>> Oracle has a configuration option for its version of hot standby
>> (DataGuard) that lets you specify a time based delay in applying logs.
>>
Oracle has a configuration option for its version of hot standby
(DataGuard) that lets you specify a time based delay in applying logs.
They get transferred right away, but changes in them are only applied
as they reach a certain age. The idea is that if something horrible
happens on the master,
I have never had this particular problem in PostgreSQL, it seems to
"just know" when queries can be "flattened" and indexes used. I know
that takes tons of work. Thank you for that.
Here's the Oracle question.
http://stackoverflow.com/questions/1439500/oracle-index-usage-in-view-with-aggregates
On Wed, Sep 3, 2008 at 10:36 AM, William Garrison <[EMAIL PROTECTED]> wrote:
> When I attended the PostgreSQL East conference, someone presented a way of
> doing this that they used for http://www.mailermailer.com/ and they did
> this:
>
> SET constraint_exclusion = on;
> EXPLAIN
> SELECT
> *
>
On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Ian Harding" <[EMAIL PROTECTED]> writes:
>> Is there any way to tell if a trigger or triggers are disabled on a
>> table? I was updating some data a week or two ago and must have
>>
Is there any way to tell if a trigger or triggers are disabled on a
table? I was updating some data a week or two ago and must have
forgotten to re-enable the triggers. Took me a little while to figure
out. \d tablename didn't tell me, nor did \d+ tablename.
This is on 8.2.3.
Thanks,
- Ian
-
I accidentally formatted a string for tsearch before trying to cast it
to a date, and it worked!
select 'June&15&2007'::date
date
2007-06-15
(1 row)
Is this a happy accident, or is it OK to count on it continuing to
work this way?
Thanks,
Ian
---(end of
On 6/5/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
On Mon, Jun 04, 2007 at 08:25:22PM -0700, Ian Harding wrote:
> I know this is a question that gets asked a zillion times and is
> almost always pilot error.
I don't know much about this but the complaint is this:
I know this is a question that gets asked a zillion times and is
almost always pilot error.
I installed PostgreSQL 8.2.x and the Tsearch2 package on NetBSD which
went fine, but I can't get the tsearch2.sql file to run.
The usual error about "file does not exist" relative to
$libdir/tsearch2 gets
On 6/3/07, PFC <[EMAIL PROTECTED]> wrote:
> Yeah, it is awful ;^) However the existing system is equally awful
> because there is no way to enter NULL!
Consider this form :
First name :Edgar
Middle name : J.
Last name : Hoover
Now, if someone has no middle name, like "John Smith",
On 6/3/07, Alexander Staubo <[EMAIL PROTECTED]> wrote:
On 6/3/07, Ian Harding <[EMAIL PROTECTED]> wrote:
> > An empty string is not null! Null means the value is missing, which is
> > clearly not the case here. I would say Rails is exactly in the right
> > her
An empty string is not null! Null means the value is missing, which is
clearly not the case here. I would say Rails is exactly in the right
here. When an HTML form is posted, empty input boxes are declared as
empty strings, which what the user entered. The problem is not with
Rails/ActiveRecord b
On 6/2/07, Alexander Staubo <[EMAIL PROTECTED]> wrote:
On 6/2/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> I don't know if it's a general problem, but I've been involved in a
> using rails and it appears to have it's own way of declaring the
> database. It presumes to handle referentia
On 31 May 07 09:46:47 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello all -
I'm working on a site with PHP and Postgres, coming from a MySQL
background.
I was looking for an equivalent to the mysql_insert_id() function, and
a site recommended this:
Another option is INSERT...RETURNI
On 5/31/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Ian Harding wrote:
> tsearch indexes have to reside in the table where the data is, for the
> automagical functions that come with it to work. You can define a
> view that joins the tables, then search each of the index co
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values you are looking for.
In my experience, the LIKE searches are fast for relative
This keeps biting me. In a trigger function for INSERT OR UPDATE if you try
IF TG_OP = 'UPDATE' AND OLD.foo = 'bar' THEN
...
it will blow up on inserts because there is no OLD. I always expect
this to short circuit and am always disappointed. Easy fix, of
course...
IF TG_OP = 'UPDATE' THEN
?
+1 100% for having Postgres set this up and take a cut.
On 5/16/07, Ian Harding <[EMAIL PROTECTED] > wrote:
> Well, I didn't do that, but as an exercise I split the manual in 740
> page chunks (maximum size at lulu), which misses the last couple
> hundred pages (old release
On 5/14/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Rich Shepard wrote:
> On Mon, 14 May 2007, Bruce Momjian wrote:
>
> >How much would it be to email the PDF manual to someone like Kinkos and
> >get it printed? Effectively, that might be the cheepest solution because
> >it is print-on-demand.
Or use a SAVEPOINT. I don't know about the impact on resources if you
leave it hanging around for a long time, but I use these for exactly
the scenario you are talking about.
- Ian
On 4/16/07, Martin Langhoff <[EMAIL PROTECTED]> wrote:
On 4/17/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Seems ov
On 2/22/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Joshua D. Drake escribió:
> Andrej Ricnik-Bay wrote:
> > On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
> >> That depends greatly on what you're doing with it. Generally, as soon
> >> as you start throwing a multi-user workload at it, MySQL
On 2/21/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Ian Harding" <[EMAIL PROTECTED]> writes:
> I had views that used syntax like
> WHERE datecol < current_date and (otherdatecol is null or otherdatecol
> > current_date)
> Suddenly, this is ungodly inefficient
case you use that type of SQL and are upgrading to
8.2.X, it might be a problem.
- Ian
On 2/21/07, Ian Harding <[EMAIL PROTECTED]> wrote:
This whole thing strikes me funny since my application has run fine
for 6 years and now I have queries that simply take forever, and even
had one that t
case you use that type of SQL and are upgrading to
8.2.X, it might be a problem.
- Ian
On 2/21/07, Ian Harding <[EMAIL PROTECTED]> wrote:
This whole thing strikes me funny since my application has run fine
for 6 years and now I have queries that simply take forever, and even
had one that t
On 2/17/07, Rick Schumeyer <[EMAIL PROTECTED]> wrote:
This may be bad design on my part, but...
Not at all. Very common scenario
I have three tables of interest...Account, Employee, and
AccountEmployeeRelation. There is a many-to-many relationship between
accounts and employees. The join
On 2/18/07, Chris <[EMAIL PROTECTED]> wrote:
Toby Tremayne wrote:
> Hi all,
>
> I'm just experimenting with tsearch2 - I have it all working fine but I
> was wondering if there's a way to create indexes containing vector
> columns from multiple tables? Or if not, how do people usually manage
> t
On 2/16/07, Lou Duchez <[EMAIL PROTECTED]> wrote:
Like everyone else, I use pg_dump for backup purposes; I have a cron job
that runs a pg_dump whose output is then FTP'd elsewhere. Two things
that would make my life easier:
1) "grant select on database ..." or, hypothetically, "grant select on
c
On 2/16/07, Rafa Comino <[EMAIL PROTECTED]> wrote:
Hi from Spain,
I have a problem with TSearch2,
I have a table with more than a million registers (a table of books, for
example),
I made a tsearch2 index for one of my fields (the title of the books, for
example),
I make queries from that t
On 2/12/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
On Mon, Feb 12, 2007 at 10:53:53AM -0500, Merlin Moncure wrote:
> On 2/12/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> >> Can you describe in a little bit more detail about what you mean by
> >> 'Adjaceny LIst'?
> >
> >Adjaceny list is t
On 2/12/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
I'm looking for a little guidance in representing a file system --
well just the file and directory structure of a file system.
Often articles on representing a hierarchy discuss the advantages of
using Nested Sets (or nested intervals) it seem
What is this? I just upgraded from 8.1.3 to 8.2.3 and things are
blowing up a little bit.
I noticed something in postgresql.conf about max_stack_depth, is this related?
- Ian
---(end of broadcast)---
TIP 4: Have you searched our list archives?
A thousand words. I like the brevity of this post:
http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
Can't really argue with it.
- Ian
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
Brazil has been trying to get its ISPs to block access to a certain
video. I wonder if too wide a net was cast in that effort.
http://www.slate.com/id/2157399/?nav=navoa
On 1/17/07, Jorge Godoy <[EMAIL PROTECTED]> wrote:
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Be sure you aren't blockin
On 1/8/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
>
>
> On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of
> whatever queries are coming into the database.
in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
>
> There is no GUI tool that I know of, but there is EXPLAIN which gives
> the same information.
>
> - Ian
>
> On 1/8/07, guillermo arias <[EMAIL PROTECTED] > wrote:
> > is there a tracking
There is no GUI tool that I know of, but there is EXPLAIN which gives
the same information.
- Ian
On 1/8/07, guillermo arias <[EMAIL PROTECTED]> wrote:
is there a tracking trace tool in postgre? like the "SQL Analizer" in MS
sqlserver.
I have downloaded the PGAdmin III and i have not found any
If you have a dot in your gmail username, take it out. Gmail ignores
it and validation scripts often puke on it.
Then use that email as your reply to, not some nonexistent carp.
- Ian
On 12/13/06, wheel <[EMAIL PROTECTED]> wrote:
I seem to have a natural knack for hitting the ruts around here
On 11/13/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2006-11-13 at 15:36, novnov wrote:
> OK, thanks everyone, I gather from the responses that postgres performance
> won't be an issue for me then. If MS SQL Server and Postgres are in the same
> ballpark performance-wise, which seems to
If first period end and second period start dates are the same, I need that in
this case expression
returns true.
Is it possible to implement this using OVERLAPS operator ?
I think the best workaround is a function of some kind in whichever
language you choose. I think you could actually clo
On 11/2/06, louis gonzales <[EMAIL PROTECTED]> wrote:
Hey Brian,
Yeah I had considered this, using cron, I just feel like that is too dirty.
Actually I didn't see Andreas' post, can someone forward that?
I'm running this application on Solaris 9. Ultimately what I want to
know is, is there som
On 10/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Shane Ambler wrote:
>> The one thing worse than kill -9 the postmaster is pulling the power
>> cord out of the server. Which is what makes UPS's so good.
>>
>> If your server is changing the data file on
On 8/2/06, Flemming Frandsen <[EMAIL PROTECTED]> wrote:
Ian Harding wrote:
> NOTIFY interacts with SQL transactions in some important ways.
> Firstly, if a NOTIFY is executed inside a transaction, the notify
> events are not delivered until and unless the transaction is
>
On 8/1/06, Carlo Stonebanks <[EMAIL PROTECTED]> wrote:
I have been trying to figure out where to put my plTcl questions, and where
the people most knowledgable about that topic may be – either on these mail
lists or elsewhere.
TCL is dead. Long live TCL.
PLTCL was taken out of the core d
On 8/1/06, Christopher Browne <[EMAIL PROTECTED]> wrote:
Martha Stewart called it a Good Thing when "Carlo Stonebanks" <[EMAIL
PROTECTED]> wrote:
> I am interested in finding out a "non-religious" answer to which
> procedural language has the richest and most robust implementation
> for Postgres
On 8/1/06, Flemming Frandsen <[EMAIL PROTECTED]> wrote:
I have an application that does aggresive caching of data pulled from
the database, it even keeps the objects cached between transactions.
Normally this works very well and when the cache is warmed up about 90%
of the database time is saved
It's here now. I think it used to be in the main distro, but has been
moved out recently.
http://pgfoundry.org/projects/pgtcl/
On 24 Jul 2006 03:07:59 -0700, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Hello everybody,
I must replace an old server by a new one, and I decide to upgrade
postgr
I wasn't trying to fight it. It's just that the port disagrees with the
PG documentation and apparently most other ports. The maintainer said
it was for backward compatibility but it's apparently only a FreeBSD
"phenomenom" :-)
It may be a *BSD pheonomenon, since I know it applies in NetBSD as
postgresql_autodoc and dia.
On 28 May 2006 05:19:04 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
What open source tool do people here like for creating ER diagrams?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
There used to be a knob that would allow you to temporarily see
deleted tuples. Don't know if it's still there. Sounded kinda
dangerous.
http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php
Also, you could start (now) using PITR so you could simply restore to
the moment before the
You should look up the contrib module ltree which is made for this
sort of thing. If you reinvent the wheel like this, you will be stuck
with 2 levels. With ltree you can have as many as you need and add
more at any time. It lets you query for ancestors and descendants of
any item at any level.
This problem has been solved, by the use of sequences. If you can't
use them as a default, you can use them instead of
MAX(clipid)
You would use
NEXTVAL(clipid_seq)
assuming you had first done
CREATE SEQUENCE clipid_seq;
SELECT SETVAL('clipid_seq', (select MAX(clipid) from whatevertable));
T
The docs state that postmaster.pid is "A lock file recording the
current postmaster PID and shared memory segment ID (not present after
postmaster shutdown"
I never looked until now, but I see the number 5432001 where the pid
should be, and the real pid is in /tmp/.s.PGSQL.5432.lock, along with
th
This is interesting.
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/
There are a few bugs
1. In the graphic overview PostgreSQL == Progres
2. In description of PostgreSQL database cluster, "After
initialization, a database cluster contains a database called
pos
> A commonly overlooked comparison for "always on" systems is to compare
> what sorts of operations you can do to databases without needing to
> restart the server or drop tables, lock out users etc.
>
We use Sybase Adaptive Server Anywhere 8 here and the thing that
annoys me about it is exactly t
> >> I'm wondering if I could get some suggestions as to how implement
> >> this quickly and simply? I was thinking a web interface using PHP
> >> would be the fastest way of going about it.
> >
If you used Ruby on Rails, you'd be finished by now. It slices, it
dices, it makes julienne fries.
Se
On 3/29/06, David Bernal <[EMAIL PROTECTED]> wrote:
> I recently have been attempting to get my install of postgresql 8.1
> (running Win XP as OS) to listen on both 127.0.0.1 and my IP address,
> 192.168.0.100 (inside my network, obviously.) As such, I tried first
> setting listen_addresses = '192.
On 3/24/06, Ben <[EMAIL PROTECTED]> wrote:
> My understanding is that a stored procedure does an implicit begin/commit when
> it executes. Maybe my brain isn't working so well this morning, because I
> can't
> figure out how I would do:
>
> begin;
> call stored proc;
> call another stored proc;
>
> I discovered in the process of attempting to install Oracle 10g express
> edition that it is an extraordinary memory hog. One might have thought
> that one might have something that might have lower system requirements
> than the full version. However, this is not the case.
>
> The installation
On 3/16/06, Tomi NA <[EMAIL PROTECTED]> wrote:
>
>
> On 3/13/06, Claudio Tognolo <[EMAIL PROTECTED]> wrote:
> >
> > I can disable the Trigger?
> >
>
> I'd like to know how this could be done, as well. What I really need is a
> hold-off-all-triggers-untill-I-tell-you-to command, but
> hey, making a
>
> And it's been a while; but I thought transactions like that could
> overflow rollback segments in that other database.
>
ORA-01555: snapshot too old: rollback segment number string with name
"string" too small
Cause: Rollback records needed by a reader for consistent read are
overwritten
On 3/15/06, chris smith <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Just wondering which full text module is better & what the differences
> are between tsearch and fti ?
Having only used tsearch/tsearch2 all I can say that it works as
advertised and I am extremely happy with it.
- Ian
The big job is populating the index columns. I think you can only put
the full text index column in the same table as the referenced
columns. In other words, you will end up with 3 tables, each with a
ftidx column. I hope your docs show how to create and populate the
indexes and to create trigge
On 1/8/06, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Carlos Moreno wrote:
>
> > Any comments? If it is the first option above, then it feels like
> > by definition there is absolutely nothing that can be done, now or
> > ever :-(
>
> I got an IMAP account with BurntMail.com. I belong to a doze
On 1/7/06, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > A recent article about an Oracle worm:
> > http://www.eweek.com/article2/0,1895,1880648,00.asp
> > got me wondering.
> > Could a worm like this infect a PostgreSQL installation?
> > It seems to depend on default usernames and passwords - and
As I recall, the MS SQL Server draggy droppy diagrammer tool made it
seem trivial to rearrange columns did the same thing. It just
generated SQL statements to:
Begin transaction
select data in new order into a new table
drop dependent objects
drop old table
rename new table
re-create dependent ob
On 12/28/05, John McCawley <[EMAIL PROTECTED]> wrote:
> I am currently having a problem with a query never finishing (or at
> least not in a reasonable amount of time.) I have had similar problems
> to this in Postgres over the past several years, and I have always found
> workarounds. This time
On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
> > Dmitry Panov <[EMAIL PROTECTED]> writes:
> > > Yes, but if the server has crashed earlier the script won't be called
> > > and if the filesystem can't be recovered the changes will be lost.
On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote:
> > On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
> > > I'm currently considering setting up online backup procedure and I
> > > thought maybe it would be a useful
I have a file which is a long series of SQL commands. Creating
tables, copying in data, indexing, munging the data, intermittently
vacuuming to keep things moving.
I have usually run this big script like this:
nohup psql dbname < script.sql &
After upgrading to 8.0, the script to slow to a craw
On 11/1/05, Andrew Rawnsley <[EMAIL PROTECTED]> wrote:
>
> They actually did make _some_ strides. The installer actually works
> consistently (knock on veneer-covered-pressboard), which is something I
> haven't seen since the pre-8i text-mode installs...
>
> Doesn't quite compare to the 5 minute un
On 10/8/05, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
> I use PostgeSQL less than year. Before I worked with MS SQL Server
> 2000, MySQL 3&4, Oracle8i and Interbase. Also, I studied standards
> SQL:1999 and SQL:2003. So, after switching to PostgreSQL I've
> encountered with several things that
On 10/6/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> On Thursday 06 October 2005 18:20, Tom Lane wrote:
> >
> > No, there's no reason for 8.0 to be slower at this than 7.4, if all else
> > is equal. I'm betting that all else is not equal. Maybe you are using
> > a different encoding or loca
On 9/6/05, Jürgen Rose <[EMAIL PROTECTED]> wrote:
> I did some serious stuff with SQLServer and Interbase, and I had
> **never** those performance problems.
>
On a laptop? Under VMWare?
I have used MSSQL Server too, and find PostgreSQL to compare favorably
in most cases. You may have found
1 - 100 of 162 matches
Mail list logo
