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
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
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 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
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/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
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",
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/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 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
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
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);
&
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
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
>&
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
.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
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
> -
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
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
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.
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 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 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
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,
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.
>>
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,
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
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 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 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 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 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 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 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
>
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 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 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
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
-
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
>>
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
> *
>
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
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
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
I think you have created a statement level trigger (If they existed in
7.4.7...) by not including FOR EACH ROW in your create statement. In
statement level triggers, there is no OLD or NEW.
>>> Rick Casey <[EMAIL PROTECTED]> 02/24/05 1:22 PM >>>
Hello all,
I am trying to a simple thing: create
I do option 3. A generic trigger writes the tablename, field name, type
of change (insert/update/delete) and the old and new values for columns
that were affected. It is kind of a hog, but it works very well. I
have cron delete old entries so it doesn't eat my whole disk.
I haven't tried to ge
Or, according to Babelfish, if "Postgres" is a Spanish word, it
translates to "poststoneware" in English.
Nonsense of course, but I thought it was funny.
On 4/19/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 19, 2005 at 05:24:22PM +0200, Daniel Schuchardt wrote:
> >
> > What means Pos
One thing I can think of is some kind of inadvertent SQL injection.
Somebody put
; begin;
into a string that got sent to the server unescaped?
The only other thing I can think of is if there was a hole in the
logic in one of your explicitly started transactions that allowed the
handle to be re
I haven't tried many of them, but I didn't like how they scribbled on
my database. Hopefully now they are creating/using their own either
database or at least schema for all their data.
On 4/29/05, John DeSoi <[EMAIL PROTECTED]> wrote:
>
> On Apr 29, 2005, at 4:27 AM, Stephane Bortzmeyer wrote:
I don't think you can do that. While savepoints let you roll a
transaction back to a specified point, each sql statement is still
atomic and the only way to call a function is within a sql statement.
>>> "Mahesh S." <[EMAIL PROTECTED]> 4/30 3:08 am >>>
Ian,
I want to use a separate fu
MS SQL Server has what used to be called "Linked Servers" which could
use ODBC to connect directly to other data sources. Your tool talking
to MS SQL Server would need to use fully qualified table names,
including the name of the "Linked Server" but it might work.
On 5/9/05, Guy Rouillier <[EMAIL
In my experience, there is no way to tell an embedded carriage return
from and end-of-record carriage return other than counting intervening
tabs.
What I do, is fix it in access with a query for (believe it or not)
"*" & chr(13) & "*"
which returns all records that contain a CR. I then just del
I just noticed that SRA has English language certification now,
available at a nationwide testing center. That's cool. Only the
"Silver" is in English so far, the Gold looks more interesting.
There is no syllabus or books that I could find, but I am taking the
test next wednesday. I'll let you
I just took the test. It did for me what I thought it would do, it
made me read the docs from cover to cover (very quickly, and not the
appendices) with a firm deadline. If I hadn't scheduled the test, I
would not have done that. I learned some things.
Here are my comments on the test as an eva
> Are PG admins experienced in determining and killing such zombi-sessions?
> I mean, may be script or something to do this job exist in nature?
> > Thanks.
>
#statement_timeout = 0 # 0 is disabled, in milliseconds
I think if you give this item in postgresql.conf a value, it will kill
l
The client has to read the incoming data stream for indications of the
type of data that is coming next, then further read a description of
each field name, type, and nullabillity in the event it is a dataset.
It is not pretty. I don't know how the higher level interfaces handle
it, but here is s
Can the client application be modified? It seems like it might
need to be, since if it is expecting its connection to be open whenever
it's running, the server killing the connection might lead it to
crash.
- IanOn 8/1/05, Len Walter <[EMAIL PROTECTED]> wrote:
Hi,I'm looking to solve a problem
Brand X simulates this in their GUI diagrammer by tracking
dependencies and dropping and recreating dependent views on schema
changes. This might be a better job for one of the GUI tools for us
too, rather than trying to put it in the back end. Brand X doesn't do
it in their backend either.
On
My first idea when this was mentioned was more like
ALTER TABLE CASCADE
where CASCADE meant recompile all the views that depend on that table.
Not that I think any of this is a good idea, but if it was going to be
done, that's what would make the most sense to me.
- Ian
-
Mine in similar, and the only thing I have changed from defaults is
work_mem. It made certain complex queries go from taking forever to
taking seconds. I have a database connection pool limited to 10
connections, so I set it to 10MB. That means (to me, anyway) that
work_mem will never gobble mor
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
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 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 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
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 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 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
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/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 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
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
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
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.
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
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
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?
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
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/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/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/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/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
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/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
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
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 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.
?
+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
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
list instead of a real column name that ignores the data.
Something like
copy mytable (col1, col2, ignore(), col3) from '/tmp/dump';
Not a big deal, but kind of handy.
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED]
Phone: (253) 798-3549
Pager:
CREATE UNIQUE INDEX uidx_thename ON names(the_name);
Should prevent duplicates.
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED]
Phone: (253) 798-3549
Pager: (253) 754-0002
>>> Scott Frankel <[EMAIL PROTECTED]> 12/01/04 10:11 AM >&g
The second is shorthand for the first. you get to choose the index name
in the first one.
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED]
Phone: (253) 798-3549
Pager: (253) 754-0002
>>> Scott Frankel <[EMAIL PROTECTED]> 12/01/04 10:48 AM
mers"; and you will be happy again.
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED]
Phone: (253) 798-3549
Pager: (253) 754-0002
>>> Simon Wittber <[EMAIL PROTECTED]> 12/02/04 7:01 PM >>>
I'm evaluationg PostgreSQL 8.0
I have a homegrown userid/password system in a database table, and on
tables I audit, I keep the id of the last person to touch that record,
and have a trigger write the changed values out to an audit table. It
works fine, but of course there is some overhead involved.
You can't involve postgres
Numbers as text are ordered like that. Integers are ordered as you would like.
The best hack I have seen if you are stuck with text is
...order by length(numbers_as_test), numbers_as_text
which sorts first by number of "digits" then by text order.
Ian Harding
Programmer/Analyst
I didn't see the post asking about NetBSD, but I can answer it a bit:
I think NetBSD is like other BSD in that:
1. untar, cd, ./configure, make, install doesn't usually work. They
put stuff in different places and not everyone in the Linux world cares
enough to account for them.
2. Out of the
You can use a functional index. Something like
CREATE INDEX foo ON bar (substring(blah,1,200))
Should work I think.
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED]
Phone: (253) 798-3549
Pager: (253) 754-0002
>>> Christoph Pingel <[EMA
in the shell script that loads data after tables are
created and before the other objects are created.
The scripts are in a revision control system, so if I have to restore
old data, I use the old schema.
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED
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
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.
1 - 100 of 162 matches
Mail list logo
