ng standby."
Are you able to configure a cascading replica by using streaming
replication on your 9.3 system, without WAL archiving on the standby?
-Jeremy
--
http://about.me/jeremy_schneider
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
urself - I would love to read them and pass
them along to other new users! And if you find any errors in the
official PostgreSQL documentation, by all means let us know and we
will address them.
Looking forward to hearing more from you!
-Jeremy
--
Sent via pgsql-general mailing list (pgs
primary keys and unique
> constraints.
Given that indices are an implementation wart on the side of the
relational model, it'd be nice if RDBMS' did create them for one.
--
Cheers,
Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
ms
Are you sure the customers table was the same?
--
Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
- if the set truly is unique.
--
Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Subject: Re: [GENERAL] HTTP user authentication against PostgreSQL
On 1/30/2015 12:31 AM, Jeremy Palmer wrote:
The PostgreSQL DB is currently setup with Kerberos for Windows SSO, as well
as MD5 password authentication for another pool of other PostgreSQL users who
are not part of our Active
David G Johnston wrote
Personally, I would consider having both Apache and PostgreSQL talk to a
LDAP database if you really need to have a single point of identity
definition.
The PostgreSQL DB is currently setup with Kerberos for Windows SSO, as well as
MD5 password authentication for
system.
Thanks
Jeremy
This message contains information, which may be in confidence and may be
subject to legal privilege. If you are not the intended recipient, you must not
peruse, use, disseminate, distribute or copy this message. If you have received
Sorry to ask again, but I still have not got any reply to this. Maybe this
indicates it’s a bad option?
On Tue, Jan 13, 2015 at 5:15 AM, Jeremy Palmer
jpal...@linz.govt.nzmailto:jpal...@linz.govt.nz wrote:
Hi All,
I'm just investigating the option for configuring SSO for windows clients
Anybody have an help on this topic?
Thanks
Jeremy
From: Guillaume Lelarge [guilla...@lelarge.info]
Sent: Wednesday, 14 January 2015 8:20 p.m.
To: Jeremy Palmer
Cc: PostgreSQL General; raghuchenn...@gmail.com
Subject: Re: [GENERAL] SSO Windows-to-unix
Le
I think PgAdmin is just a client that uses libpq and does not specifically help
with SSO.
From: Raghu Ram [mailto:raghuchenn...@gmail.com]
Sent: Tuesday, 13 January 2015 10:22 p.m.
To: Jeremy Palmer
Subject: Re: [GENERAL] SSO Windows-to-unix
On Tue, Jan 13, 2015 at 5:15 AM, Jeremy Palmer
jpal
/Deploying%20PostgreSQL%20in%20a%20Windows%20Enterprise.pdf,
but I see it's dated 2008. Could someone confirm that this is still the best
how-to guide for this subject and if there are any other considerations with
newer versions of PostgreSQL?
Many thanks,
Jeremy
This message contains
END;
$$ LANGUAGE plpgsql;
Cheers
Jeremy
This message contains information, which is confidential and may be subject to
legal privilege. If you are not the intended recipient, you must not peruse,
use, disseminate, distribute or copy this message. If you have received this
message in error
I load and dump text files with currency values in it. The decimal in these
input and output formats in implied. The V format character works great for
outputing numeric data:
# select to_char(123.45, '999V99');
to_char
-
12345
(1 row)
However, when importing data, the V doesn't do
anyone know of a way to override stemming of particular words in the
full text searching?
Example: 'organic' and 'organization' both stem to 'organ'.
If i'm searching for 'organic' I don't want a bunch of results that
contain 'organization' and 'organized'.
TIA
--
*jeremy ashcraft*
//
Hi Devrim,
Thank you for pointing these facts out. Very helpful and I now have my
installations working without issue.
Changing the scripts as you have done is very useful for parallel
installations. It will make my work easier.
Regards,
Jeremy
On 12/09/12 16:57, Devrim GUNDUZ wrote:
Hi
of these files in the RPM ?
Regards,
Jeremy
--
Jeremy Whiting
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
To: Craig Ringer
Cc: Jeremy Palmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows SIngle Sign On - LINUX Server
In real world deployment, LDAP and Kerbero are often combined for
authentication and authorization.
The link below is a well documented howto:
https://help.ubuntu.com/community
are using a WIndows server 2008 for the domain control. However I know
little about it's setup or configuration, I only know it's our windows domain
realm.
Regards,
Jeremy
This message contains information, which is confidential and may be subject to
legal privilege. If you are not the intended
.
Regards,
Jeremy
__
This message contains information, which is confidential and may be subject to
legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate
,
land_district VARCHAR(100) NOT NULL,
issue_date TIMESTAMP NOT NULL,
guarantee_status TEXT NOT NULL,
estate_description TEXT,
number_owners INT8 NOT NULL,
part_share BOOLEAN NOT NULL,
shape GEOMETRY,
);
CREATE INDEX shx_title_shape ON titles USING gist (shape);
Thanks,
Jeremy
, the subsequent function involving the cursor
query completes and the transaction also runs to completion.
Is there any way that ST_Collect could be leaking memory into a context that
does not get cleaned up after the query runs? Or do I have two leaks going on
here?!
Cheers,
Jeremy
CREATE TEMP
be greatly appreciated.
Regards,
Jeremy
From: Jeremy Palmer
Sent: Tuesday, 5 April 2011 9:50 p.m.
To: pgsql-general@postgresql.org
Subject: Out of memory
Hi,
I've been having repeated troubles trying to get a PostgreSQL app to play
nicely on Ubuntu. I recently
be s much appreciated.
Thanks again,
Jeremy
PS. My config:
The OS I'm running is:
Linux TSTLHAPP01 2.6.32-29-server #58-Ubuntu SMP Fri Feb 11 21:06:51 UTC 2011
x86_64 GNU/Linux.
It's a running on VMWare and, has 2 CPU's and 8GB of RAM. This VM is dedicated
to PostgreSQL, not much else
the
hardware and database utilization.
2) Can anyone help me make sense of the top transaction memory error to help
track down the issue?
Any other suggestions would be greatly appreciated.
Thanks
Jeremy
From: Jeremy Palmer
Sent: Saturday, 26 March 2011 9:57 p.m
.
Regards,
Jeremy
__
This message contains information, which is confidential and may be subject to
legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate
differences need to be calculated
and then applied to the table. See the LDS_ApplyTableDifferences function on
line 353.
Regards,
Jeremy
__
This message contains information, which is confidential and may
time.
Thanks,
Jeremy
-Original Message-
From: Jeremy Palmer
Sent: Saturday, 26 March 2011 9:57 p.m.
To: Scott Marlowe
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Out of memory
Hi Scott,
It was the work_mem that was set too high. I reduced it to 32mb and the
function
the memory after each sort operation has
completed.
Thanks,
Jeremy
From: Scott Marlowe [scott.marl...@gmail.com]
Sent: Friday, 25 March 2011 5:04 p.m.
To: Jeremy Palmer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory
On Thu, Mar 24, 2011
effective_cache_size = 4094MB
I have also try lowering the shared_buffers down to 1GB but it still ran out
of memory.
Cheers,
Jeremy
__
This message contains information, which is confidential and may
PostgreSQL didn't support named function parameters? Really
drives me crazy when naming variables in pl/pgSQL!
Best Regards,
Jeremy
__
This message contains information, which is confidential and may
On 2011-01-03 06:29, Karen Springer wrote:
We are running RHEL 4.1 which is why the newer version did not install with
RHEL.
RHEL 4.1 should be offering pgsql 8.1.15 in the apps channel
(Red Hat Application Stack v1).
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general
On 2011-01-02 08:31, Karen Springer wrote:
We are using PostgreSQL 8.1.4 on Red Hat, Microsoft Access 2002
psqlodbc_09_00_0200.
You don't say which RedHat.
RHN offers 8.1.22 for RHEL5 currently.Are you not running regular updates?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql
that full-table-scan plus sort, which your
query is doing anyway?
Cheers,
Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that
the DBA
knows about indexing.
I see in another thread you suggest merely placing hints in the log. That's a
fine
first step - but I'll then be wanting to auto-parse that log to auto-create
Cheers,
Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
this magic just for a limited time
after the DB goes live.
Here what I said:
track those that actually get re-used and remove the rest.
Which part is confusing?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Bugger I got another crash on the server today even after setting the
temp_buffers to 512MB. Has anyone got any suggestions to fix this issue?
Should I just compile the source using MS visual studio, then debug and get a
stack trace for someone to diagnose on this list?
Thanks
Jeremy
session can create large temp tables.
Thanks
Jeremy
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, August 25, 2010 5:11 PM
To: Jeremy Palmer
Cc: Magnus Hagander; Tom Lane; pgsql-general@postgresql.org; Alvaro Herrera
Subject: Re: [GENERAL] Win32
Yeah that's what stated here:
http://technet.microsoft.com/en-us/library/ms189334.aspx
But only if I add /3gb switch to the kernel boot parameters
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, August 25, 2010 5:28 PM
To: Tom Lane
Cc: Jeremy
Thanks for the tips. I would move to LINUX if it was an option :(
I will bring the numbers down and do some benchmarking and tests to find out
what I can get away with on this system.
Thanks again,
Jeremy
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent
willing provide more information to help diagnose this.
Regards,
Jeremy
-Original Message-
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Friday, August 20, 2010 1:46 AM
To: Tom Lane
Cc: Jeremy Palmer; pgsql-general@postgresql.org; Alvaro Herrera
Subject: Re: [GENERAL] Win32
No they all got killed off.
-Original Message-
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Wednesday, August 18, 2010 8:06 PM
To: Jeremy Palmer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Win32 Backend Cash - pre-existing shared memory block is
still in use
for another crash. Should I set the
level to 'debug5'? The cluster is for development purposes, so I don't mind the
overhead.
Cheers,
Jeremy
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, August 19, 2010 4:07 AM
To: Alvaro Herrera
Cc: Jeremy Palmer; pgsql-general
the backend crashes?
I'm running PostgreSQL 8.4.4 on Windows server 2003 Standard.
Much Appreciated,
Jeremy
Postgresql.log:
2010-08-17 16:57:22 NZSTLOG: unexpected EOF on client connection
TopMemoryContext: 268428304 total in 26 blocks; 5528 free (22 chunks);
268422776 used
Local Buffer Lookup
,Q,R as columns. None of the tables have a column which can be used as a
key.
The resulting table should have N number of rows and X,Y,Z,P,Q,R as columns.
You haven't said what you want the result to mean.
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
in implementation practicalities and
any cost for people _not_ using the feature.
Could not pgsql *measure* these costs (on a sampling basis, and with long
time-constants)?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
that has a ton of features that I don't really need, just what's described
above in particular.
P.S. The log would just need the user, time, and query.
TIA,
Jeremy Brown
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Jacek Becla wrote:
create table t(d real, check(d=0.00603));
insert into t values (0.00603);
ERROR: new row for relation t violates check constraint t_d_check
Because equality is not well-defined for real values?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
index rebuild time onto the end of any recovery.
Forgive me for being stupid, but isn't a time when all the data for
a table is being streamed in, during restore, the *perfect* time
to build an index? Why wait until after the restore?
Cheers,
Jeremy
--
Sent via pgsql-general mailing list
Gregory Stark wrote:
So, what do people say? Is Postgres perfect in your world or does it do some
things which rub you the wrong way?
As a further take on the auto-tuning others have mentioned,
how about some auto-indexing?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general
wal_buffers = 1MB
commit_delay = 1
checkpoint_segments = 128
effective_cache_size = 10GB
autovacuum = off
Can anyone give me tips to get from 8.2 to 8.3 faster ?
--
Jeremy Kister
http://jeremy.kister.net./
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
search the mailing list archive before posting.
Thanks in advance.
==
Jeremy Milarsky
,
Jeremy Harris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
into (inherited) tables?
Thanks,
Jeremy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
into active_users and inactive_users allows me to
tell the database (indirectly) that the active users index should stay
in memory, while the inactive users can relegated to disk.
-Nathan
On Thu, May 1, 2008 at 6:02 AM, Jeremy Harris [EMAIL PROTECTED] wrote:
Gurjeet Singh wrote:
One
Chander Ganesan wrote:
Jeremy Harris wrote:
Version:
PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070418 (Red Hat 4.1.2-10)
We have one problematic table, which has a steady stream of entries
and a weekly mass-delete of ancient history. The bloat query from
getting so bloated?
Thanks,
Jeremy
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Christopher Browne wrote:
Is it possible that this table didn't see many updates, today?
Nope; about 24000 (according to the id sequence).
- Jeremy
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
. But otherwise its
quite good (ZFS and Cool Thread servers being among the other good
things out of Sun's shop).
Anybody here running postgresql on a T1000? What OS, and how is it?
Cheers,
Jeremy
---(end of broadcast)---
TIP 1: if posting/reading
Is this possible? I'm attempting to create a function like this and I'm
getting the following error:
ERROR: RETURN NEXT cannot have a parameter in function with OUT
parameters at or near myRecord.
--
__
Jeremy Nix
Senior Application Developer
Southwest
AS
$BODY$
TotalRecords := 10;
TotalPages := 1;
FOR myRecord IN
SELECT cols FROM searchResults
LOOP
RETURN NEXT myRecord;
END LOOP;
Thanks,
__
Jeremy Nix
Senior Application Developer
Southwest Financial Services, Ltd.
(513) 621-6699
rebuild or not?
Cheers,
Jeremy Harris
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
, everything in this thread is theoretical.
Cheers,
Jeremy Haile
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Will do - thanks Magnus! I'll test it for a while and post the results
here.
Jeremy Haile
On Sat, 27 Jan 2007 17:21:23 +0100, Magnus Hagander
[EMAIL PROTECTED] said:
Jeremy Haile wrote:
Using standard build (none of the things you mentioned) on 8.2.1
currently.
I really appreciate
to assist.
Jeremy Haile
On Sat, 27 Jan 2007 11:23:39 -0500, Jeremy Haile [EMAIL PROTECTED]
said:
Will do - thanks Magnus! I'll test it for a while and post the results
here.
Jeremy Haile
On Sat, 27 Jan 2007 17:21:23 +0100, Magnus Hagander
[EMAIL PROTECTED] said:
Jeremy Haile wrote
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
May be, problem is related to fixed bug in pgwin32_waitforsinglesocket() ?
WaitForMultipleObjectsEx might sleep
We have had lots of reports of issues with the stats collector on
Windows. Some were definitly fixed by the patch by OT, but I don't
think all.
Here were a couple of other reports I found:
http://archives.postgresql.org/pgsql-hackers/2006-09/msg00415.php
it into
another DB - but as Tomi said, when you have to do primary key
generation, row merging, data cleanup, and data transformations - I
would use some sort of ETL tool over just SQL.
My 2 cents,
Jeremy Haile
On Fri, 26 Jan 2007 15:14:22 +, Tomi N/A [EMAIL PROTECTED] said:
Besides being easy
This utility is useful for creating junctions in Windows:
http://www.microsoft.com/technet/sysinternals/FileAndDisk/Junction.mspx
I am using this to symlink my pg_xlog directory to another disk and it
works great.
Jeremy Haile
On Fri, 26 Jan 2007 18:27:04 +, Roman Neuhauser
[EMAIL
provide me with a patched exe for Win32? If not, I could try
to get my system setup to build for Windows, but I'm not sure what all
that would involve.
Thanks,
Jeremy Haile
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Using standard build (none of the things you mentioned) on 8.2.1
currently.
I really appreciate it!
On Fri, 26 Jan 2007 21:24:09 +0100, Magnus Hagander
[EMAIL PROTECTED] said:
Jeremy Haile wrote:
Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go
green, we should
Tom,
Did this information shed any light on what the problem might be? Any
solution or workaround?
Thanks!
Jeremy Haile
On Wed, 24 Jan 2007 14:19:05 -0500, Jeremy Haile [EMAIL PROTECTED]
said:
pgstat.stat was last updated 1/22 12:25pm - there is no pgstat.tmp.
Coincidentally (I think
if there is anything else I can do to help debug this
problem.
Do you know of any workaround other than restarting the whole server?
Can the collector be restarted individually?
Thanks,
Jeremy Haile
On Thu, 25 Jan 2007 12:42:11 -0500, Tom Lane [EMAIL PROTECTED] said:
Jeremy Haile [EMAIL
process, it does gets restarted, although
sometimes it takes a minute.
Since it only seems to update pgstat.stat once after restarting, I'd
need to kill it once-a-minute to keep my statistics up to date =) So,
unfortunately it's not a great workaround to my problem.
Jeremy Haile
PROTECTED] said:
Jeremy Haile [EMAIL PROTECTED] writes:
Unfortunately I don't have any debugging tools installed that would work
against postgres - although I'd be glad to do something if you could
tell me the steps involved. I can reproduce the issue quite easily on
two different Windows machines
AFAIR (Magnus can surely confirm) there were some other tables that
weren't showing stats as all zeros -- but there's no way to know whether
those numbers were put there before the collector had frozen (if
that's really what's happening).
Yeah - I have numbers that updated before the stats
I've noticed that my tables are not being auto vacuumed or analyzed
regularly, even though I have very aggressive autovacuum settings.
The stats collector appears to still be running, since I can see a
postgres.exe process with -forkcol. However, I never notice it using
I/O or CPU usage.
pgstat.stat was last updated 1/22 12:25pm - there is no pgstat.tmp.
Coincidentally (I think not) - the last auto-analyze was performed at
2007-01-22 12:24:11.424-05.
The logs for 1/22 are empty - so no errors or anything like that to give
clues...
Thanks!
Jeremy Haile
On Wed, 24 Jan 2007 14
involved in these - did you ever figure out how to
resolve the issues of the stats collector getting stuck in Windows?
Thanks, Jeremy Haile
On Wed, 24 Jan 2007 14:19:05 -0500, Jeremy Haile [EMAIL PROTECTED]
said:
pgstat.stat was last updated 1/22 12:25pm - there is no pgstat.tmp
But there are ways that we could optimize count(*) queries for specific
circumstances right? Obviously this isn't trivial, but I think it would
be nice if we could maintain a number of rows count that could be used
when performing a count(*) on the whole table (no where clause).
I don't know
Is it feasible to add a reindex concurrently that doesn't lock the
table for the rebuild, then locks the table when doing a second pass to
pickup rows that were changed after the first pass? Or something like
that
On Fri, 19 Jan 2007 12:45:03 -0500, Tom Lane [EMAIL PROTECTED] said:
Ed L.
That's interesting. So if you have a composite index on two columns, is
there much of a reason (usually) to create single indexes on each of the
two columns? I guess the single indexes might be slightly faster
depending on the number of different values/combinations, so probably
it depends eh?
I second the desire for a UUID type in PostgreSQL! I'm aware of the
pguuid project, but it's not the same as having it in core and isn't
very well maintained.
This is such a common database paradigm that it seems reasonable to
promote it to first-class citizen status in PostgreSQL.
I
Yeah, but it's not going to be added to core until there's some
agreement about *what* needs to be added. The point of the external
project is that once it has acheived a level of support *then* it can
be incorporated.
That's fair. In truth, I only found that pguuid existed fairly recently
I have a process that appears to hang every night. I ran the following
query and results, and it looks like an autoanalyze and query are
waiting on a lock that's being exclusively held by a transaction that is
IDLE. Any ideas? Any additional queries I should run to shed light on
the issue?
Note that things will go faster if you do your initial data load using
copy from stdin for the initial bulk data load. individual inserts in
postgresql are quite costly compared to mysql. It's the transactional
overhead. by grouping them together you can make things much faster.
copy from
I wonder why this HTTP cache headers argument didn't surface in this
heated debate.
I mentioned this earlier as well. Although you could do it in the app
layer - it would be easier to just let the web server handle it.
---(end of broadcast)---
). I try to avoid BLOBs whenever possible.
Cheers,
Jeremy Haile
On Fri, 5 Jan 2007 17:18:10 -0200, Clodoaldo
[EMAIL PROTECTED] said:
5 Jan 2007 06:59:18 -0800, imageguy [EMAIL PROTECTED]:
I think I know the answer,
If you know the answer please tell it as I have read some discussions
How does it make it easier to control access and security? If your web
app makes a decision about allowing access to the database, it can just
as easily make a decision about allowing access to the filesystem.
Storing the images on the file system doesn't mean that there isn't a
piece of code
Nope - the other way around. The vacuumdb tool simply executes the
VACUUM command through postmaster.
On Fri, 05 Jan 2007 15:05:44 -0600, Erik Jones [EMAIL PROTECTED] said:
Quick question, when running a VACUUM query through the postmaster,
does it use the external vacuumdb tool?
--
Yeah - it can make it easier to implement transactional semantics by
storing them in the database, although for simple operations it wouldn't
be hard to replicate this manually. And you are going to incur a
performance penalty by storing them in the database.
Another thing to consider is that
clearly superior - but I don't think
we know enough details to make that call)
My two cents,
Jeremy Haile
On Fri, 05 Jan 2007 20:24:05 -0200, Jorge Godoy [EMAIL PROTECTED]
said:
Jeremy Haile [EMAIL PROTECTED] writes:
Another thing to consider is that storing them in the file system makes
it much
repository at the
moment... Not quite sure what I'm going to do about this and the
PgFoundry project yet.
Regards,
-Jeremy
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
You don't give a pg version.
It looks legal to me as of 8.1.
Try replacing all the {0,1} with ? - but
check the manual for regex_flavor too.
Is there any chance you're in basic mode?
- Jeremy
---(end of broadcast)---
TIP 5: don't forget
it!
Thanks for all the tips, Jeff and Tom.
Jeremy (Reposted this to the list; I accidentally replied only to Tom
the first time).
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
in application logic
instead of database logic.
I learned a helluva lot about PG though! Thanks!
Jeremy
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
apologize if my question is dumb. FWIW,
I am trying to use this method to implement a Class-Table Inheritance
scheme.
Thanks,
Jeremy
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
. Thanks for your help!
Jeremy
On 11/16/06, Jeremy Smith [EMAIL PROTECTED] wrote:
On 11/16/06, Jeff Davis [EMAIL PROTECTED] wrote:
create rule child_with_parent_explicit_insert as
on insert to child_with_parent_explicit do instead (
insert into parent(id, foo) values(COALESCE
( new.id ,NEXTVAL
1 - 100 of 121 matches
Mail list logo
