hould be vacuumed soon. In any case, there's
nothing that leads me to believe autovac is broken; I think you just
need to set it to be more aggresive (such as using -V 0.2).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.co
imezone
> -
> 1970-01-01 00:00:00
> (1 row)
>
> loses the time zone as well. I'm a bit reluctant to use tricks like
> manually appending the "Z" as literal text so that it would "look like" a
> valid UTC time stamp.
>
&
> DBA
> GlobeXplorer LLC
On a side note, is GlobeXplorer using PostgreSQL? Would they be willing
to let us publicize that fact? Better yet, would they be willing to do a
case study?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com
roadcast)-------
> 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 cleanly
>
--
Jim C. Nasby, Sr.
On Fri, Dec 16, 2005 at 11:25:22PM +0100, Martijn van Oosterhout wrote:
> On Fri, Dec 16, 2005 at 03:18:04PM -0600, Jim C. Nasby wrote:
> > BTW, if you wanted a more integrated solution, you could build a custom
> > type that would store the timestamp info. There's a good
tion and other components?
> Is there a better way to do schema versioing to the level of tables, stored
> procedures and views?
>
> thanks,
> vish
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com
... AFAIK you can
always get the same behavior just by reversing the sort order, so I'd
lean towards not allowing negative offsets.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net
in contrib, but for other
stuff we should support a doc directory. tsearch2 currently has 100k of
HTML in docs, I really don't think we want to cram all that into the
README.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork:
reated as
seconds). I don't recall ever seeing an email on the lists from someone
expecting time/timestamp + bare number to mean 'add X hours' or 'add X
fractional seconds', but people do ask about adding X seconds pretty
often.
Another option would be creating a set o
pdated rows:
See also
http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.v
want to have
> downtime on other applications that are not using person sub-system.
Well, then setup a table so that you can store version info for specific
components/schemas/what-have-you.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.c
they only take memory until the command that
fired the triggers completes.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
e you some google search terms, but the book's worthy buying
anyway. Apparently he's also got a book that's dedicated to hierarchies
and graphs, but I don't know how good it is.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://perv
ncy goes a long way towards offsetting
that in the real world, but it would be a Good Thing if we could get
some form of tuple visibility into indexes, as has been discussed in the
past.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com
tty bogus use case.
SELECT count(*) FROM table WHERE field = blah; isn't though, and people
often depend on that being extremely fast. When you can do index
covering, that case usually is very fast, and PostgreSQL can be much
slower. Of course, there are ways around that, but it's more work (
chine. Generally recommended
settings are 10-25% of server memory, but keep in mind that
shared_buffers is in 8K pages.
You should also take a look at
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
for what different postgresql.conf parameters do. And
http://www.powerpostgresql.com/Pe
quickly tell it doesn't
contain values that are in the small table. Or, in 8.1 you could use a
constraint. You could also do this with inherited tables instead of
views.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-
-write the WHERE as:
WHERE start_date < now() - time_to_live
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
s
adding arbitrary types to the system. I suspect this user is trying to
port some code over...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---
the block size.
And as others have said, this is almost certainly a horrible schema that
needs to be fixed, badly. Luckily, thanks to views and rules, you could
probably fix it without actually changing any of the client code.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Perv
PostgreSQL != Access
> PostgreSQL ~ MS SQL Server
Note that many people have had good results by using Access as a
front-end to PostgreSQL.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-
one. Typing them all on one
> line as depicted is just a waste of finger motion.
How would syncsync differ from sync;sync? The second
case will wait for the first command to return, or is there a race
condition that's reduced by typing by hand?
--
Jim C. Nasby, Sr. Engineering Consultant
On Thu, Dec 22, 2005 at 05:16:16PM +0100, Peter Eisentraut wrote:
> Jim C. Nasby wrote:
> > Some (most?) database's idea of 'creating a type' is actually what we
> > consider creating a domain,
>
> Which databases do such a thing?
IIRC, Oracle, DB2, Sybase
databases and CamelCase don't mix too well;
you'll probably be happier doing something like ip_from and ip_to.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.v
error_verbosity to 'verbose' doesn't log the query itself either
>
>
> Is there a way to get the failed query into the log, or should it have been
> there in the first place?
>
>
>
>
>
> --
> Best,
>
>
>
>
> Frank
d Postgres 8.1.1.
> Thanks,
>-M@
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com
ge and setting it to STABLE), the optimizer should inline the
fuction, giving you the same performance as the 1st query but without
all the typing (btw, isn't that first query missing person_id as part of
the WHERE clause in the EXISTS subqueries?)
--
Jim C. Nasby, Sr. Engineering Consultant
among others) and is actively
> developed. There are also other replication solutions, some of them
> proprietary.
>
> -Doug
>
> ---(end of broadcast)-------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasb
/insert block. Ironically I just submitted a patch today to fix
that (see -patches archive), but in a nutshell you want to use the code
from example 34-1.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: ht
to become a valid primary key)
>
> I tried:
>
> ALTER TABLE product_price
>ADD CONSTRAINT product_price_pkey6 PRIMARY KEY
> (product_id,product_price_type_id,currency_uom_id,product_store_group_id,from_date,product_price_purpose_id);
>
> without having any luck.
Wh
And A,B come from sequences.
>
> Could anyone please let me know how I can upload the complete dataset into
> the table?
COPY table (b, c, e) FROM file?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vca
le.
Are you seeing deadlock errors? How often are you vacuuming?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
_owner on test (cost=0.00..96.56 rows=28
> > > width=11)"
> > > " Index Cond: (("Owner")::text = 'blah'::text)"
> >
> > The planner estimates that this query will return 28 rows, which
> > makes it more likely that an index
versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, ple
re-use that definition), but I think a lot of what you're proposing is
too difficult to understand without an example. (At least it's over my
head! :)
Also, keep in mind that what you're proposing appaers to be a heck of a
lot of work. The odds of it ever being
ies function
> would make for a really good head start... I wonder if the newsysviews
> provides anything like that.
The closest it comes is pg_*_foreign_key*. Listing other dependancies
would be damn cool to add, though.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
d honesly rather we drop that nonsense so I can at least cut
and paste email addresses when needed.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-94
7;re doing a lot of
inserts/updates/deletes (graphs) or need a lot of levels (ltree).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
lpful. How can dead tuples leak?
http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Nov.asp#3
is an article I wrote that might clear things up.
http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Dec.asp#2
might also be an interesting read, though it's ju
t; do this?
Many system operations completely bypass the 'normal' access methods for
touching the system tables, so generally you can't do things like
triggers or rules.
Depending on what you need to do there may be other ways to accomplish
it, though. For example, it's trivial to ge
ons. Why
> can't I SELECT FROM cursor JOIN some_table?
I'm not quite following what you're trying to do here, but there may be
a more practical way if you want to post a concrete example. Or maybe
Tom's reply does what you need...
--
Jim C. Nasby, Sr. Engineering Consultant
t; Very Thanks
>
>
> ---(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
errors occurred, then Jaime supplied a
> solution to that.
I suspect http://lnk.nu/postgresql.org/7ma.html will be of use to the
original poster, in particular FOUND.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6
one of the duration logging options for this.
But AFAIK that won't provide any information on IO used, or even blocks
read. Not to mention that parsing the logs is a PITA.
Plain and simple, it would be damn nice if query execution stats could
be easily logged to a table.
--
Jim C. Nasby, Sr. Eng
gt; wondering if you might be able to use it in certain circumstances.)
It strikes me that if we had a way to abort a statement on another
backend, you could abort anything that's been waiting more than x
seconds for a lock via an external process watching pg_locks. Of course,
that would
ld help. Showing what kind of test coverage there is wouldn't hurt.
Performance tests would be good.
In other words, if promoting replication is important to you, there's
plenty of things you can do that will help on that front. But as others
have said, the various replication sol
On Fri, Jan 13, 2006 at 02:59:47PM -0700, Michael Fuhr wrote:
> On Fri, Jan 13, 2006 at 03:40:48PM -0600, Jim C. Nasby wrote:
> > It strikes me that if we had a way to abort a statement on another
> > backend, you could abort anything that's been waiting more than x
> >
isn't trivial to install in it's own right. And afaik there's
still no way to find out how much IO each query did, how much CPU was
spent, if any sorts overflowed, etc., etc.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive
solutely nothing to do with the order in which rows are
stored in a table, unless you cluster the table on an index (which is
still only temporary).
Without knowing what your normal access patterns on tbl_c will be it's
impossible to say if clustering on an index on tbl_a_id would help or
n
hackers
about 6 months ago. IIRC the decision was that the only reason to put
something in contrib was if it was either dependant on specific backend
code or if it was targeted for inclusion into the backend.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
tially running vacuum on
> I'm doing "psql dbname" and it hangs for a while. I'm still waiting. Any
> ideas?
What's the logfile say about it?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comw
On Mon, Jan 16, 2006 at 11:57:35AM +0100, Francesco Formenti - TVBLOB S.r.l.
wrote:
> Jim C. Nasby wrote:
>
> >On Thu, Jan 12, 2006 at 06:11:32PM +0100, Francesco Formenti - TVBLOB
> >S.r.l. wrote:
> >
> >
> >>I put an ACCESS EXCLUSIVE LOCK on the table
Not directly related to PostgreSQL, but an interesting read:
http://www.informationweek.com/news/showArticle.jhtml?articleID=175801775
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net
or are there restrictions on the max value for one of the
fields?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---
um
> the client (psql) takes longer than usual to connect.
> Thanks all
> sally
Well, that certainly sounds like a bug... can you come up with a test
case that others could reproduce? Can you reproduce it consistently?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
t;
> I was speaking directly about OSS replication.
Correct me if I'm wrong, but AFAIK Slony is the only OSS replication
that isn't statement based, which as Josh mentioned has some serious
ramifications.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive
#x27;ll now have to roll by hand.
Personally, I'd just go with option 1. If you're worried about the code
repetition you could easily create a plpgsql function that would handle
the DDL for an arbitrary table for you, so you could do:
SELECT create_image_many_many('categories')
..]
> > But When I am trying to build the dynamic sql string to a refcursor it is
> > not able to identify the syntax
>
> Could you post a complete function instead of just excerpts? That
Complete error message would be helpful too...
--
Jim C. Nasby, Sr. Engineering Consult
them to a very strict format.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)--
eing at the end of the table.
Another consideration is that the best order for people isn't the best
order for the database. For example, grouping fields of the same
alignment together will save space (and depending on the table that
savings can really start to add up).
It would definately
e returned
> and then, loop through the rows and update the column and then return
> it.
>
> Q1) Which way is better?
> q2) How does one get access to the rows just selected in the CREATE
> RULE computation?
Via NEW and OLD. Read Chapter 34 of the documentation.
--
Jim C. Na
e most files will cover a fairly small number of tracks,
so head positioning time will be minimal compared to rotational delay.
It would be interesting to modify the test code that was posted (see
attached) so that it read randomly instead of just skipping random
amounts.
Just for grins, I just ra
does its WAL writes in small chunks or
> page-at-a-time.
It's done in pages, but remember that every commit requires an fsync of
WAL.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim
> into the cluster as time and cash permit and need demands.
Actually, it doesn't need to be read-only for that to work, though it
does simplify things. But if you make your application smart enough to
know that read queries go to one set of hosts while updates have to go
to one specific hos
PostgreSQL?
VACUUM is as close as it comes to fast=true. If you don't do it your
database is almost guaranteed to become dog slow after a while.
http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Dec.asp#2
will probably be enlightening for you...
--
Jim C. Na
ld be
able to find that online somewhere.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of
On Fri, Jan 20, 2006 at 02:06:18PM -0800, Bricklen Anderson wrote:
> Jim C. Nasby wrote:
> >I would highly recommend taking a look at how Oracle is handling
> >encryption in the database in 10.2 (or whatever they're calling it).
> >They've done a good job of thinkin
I ran across http://www.vldb.org/conf/2004/DEMP14.PDF while googling for
something else; I haven't seen this before so I thought I'd post it.
Anyone dealing with XML data should take a look, though it might have
other uses too.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL
Software Design
> Home of PG Lightning Admin for Postgresql
> http://www.amsoftwaredesign.com
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasby, Sr. Engineering Consultant
> beginners (unless of course I don't know that there is an existing ones).
>
> Thanks :)
>
>
> Regards,
>
> Leonard Soetedjo
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
ctually, someone has written some system-level triggers, but I can't
find a reference to it right now. :( I know it was mentioned on one of
the mailing lists in the past month.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork
ould be...
Aside from the cluster case, are there any issues with how page splits
in the b-tree are done that could lead to better performance after a
REINDEX?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard
nd_pid() should sufficiently disambiguate now() to make obove
> touple unique.
That doesn't provide very good protection against the system clock
moving backwards though. I suspect you'd be better doing a tuple of
now() and a 2 byte sequence.
--
Jim C. Nasby, Sr. Engineering Consultant
-
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/p
ollback yet.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 6: expl
to the best of my knowledge
> a bytea or varyiing bitarray is the most space efficient method to
> store my information(???).
It is if it's truely variable in length. If you know it's limited to say
4 bytes, you'd probably be better off with an int4, which doesn'
en you could use fink (http://
> fink.sourceforge.net). Fink is apt-get for Mac. It looks like 8.1
> is still in their unstable branch. Hopefully it will be moved to
> stable soon.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-
to handle a situation like this? I can't imagine that
> dropping and recreating the trigger is the ideal solution. Thanks.
>
>
> Justin Pasher
>
>
> -----------(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>
ied
> various syntax attempts, calculations and casts but haven't
> found any returning an interval of infinite length. The docs
> and Google don't help, either.
I suspect that you could create either a domain or a custom type that
would handle this they way you wanted.
--
Jim C
for analyze. You might also want to drop the thresholds;
something closer to 200-300 for vacuum.
Another option given the size of that table is to vacuum just it every
minute or so from crontab.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervas
oking there.
I've been bitten by this before as well. I'd be in favor of adding an
option such that postmaster would refuse to start if TZ was something
other than UTC; I'd much rather that then have a bunch of data get
screwed up...
--
Jim C. Nasby, Sr. Engineering Consultant
On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote:
> On Wed, Feb 22, 2006 at 06:35:55PM -0600, Jim C. Nasby wrote:
> > On Wed, Feb 22, 2006 at 04:46:35PM -0600, Scott Marlowe wrote:
> > > Sounds like a time zone issue. I'd start looking there.
>
ill present less load on the system.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)-
ariable:
date < now() - ( 13 * '1 minute'::interval )
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
On Thu, Feb 23, 2006 at 03:49:50PM -0700, Michael Fuhr wrote:
> On Thu, Feb 23, 2006 at 04:21:19PM -0600, Jim C. Nasby wrote:
> > On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote:
> > > Alternativly you could just set the "timezone" param
I visit a mosque, I show my respect by taking off my shoes. I follow
> the customs, just as I do in a church, synagogue or other holy place. But if
> a believer demands that I, as a nonbeliever, observe his taboos in the
> public domain, he is not asking for my respect, but for my submiss
uld construct an lquery
> like '*.o.r.l.*' and use the "~" operator in the where clause. I would link to
> the table "items" by the item_id ...
Is there some reason you can't use tsearch2? I suspect it would probably
work better; if nothing else you&#x
Have you looked at using timelines in PITR for stuff like this?
Depending on your needs, it might be less work to do it this way.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervas
nd Postgres on http://sourceforge.net and you'll get
some hits back. I don't know of anyone running a commercial ERP system
on PostgreSQL, but that doesn't mean someone isn't doing it.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software htt
me offlist
> as well.
Actually, I suspect it's puking on the #'s in the email addresses.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-94
then something downstream (ie one of the forwarders) is puking on the
> funny addresses? Not sure why you'd not be seeing bounce-backs if that
> were it, but ...
Another possibility is that the subscription code in majordomo has a
different idea on valid emails than the code that
version 8.0.3. If interested, please respond to this email
> with your contact information and a rough idea of how much it would cost and
> how long it would take to get the job done.
Have you tried vacuuming more frequently?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
P
ompany - Command Prompt, Inc.
>
> ---(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
>
--
Jim C. N
s are found
> identical since the postfix is 0100 for bouth of them.
>
> What can be done so the second instert does not fail?
>
> Anakreon
> --
> Three words describe our society:homo homini lupus
>
>
> -----------(end of broadcast)--
via a tablespace.
That way you won't lose the box if drive 1 fails. You also probably
don't want raid5, if you were thinking about that...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwor
ema.
> If I connect as postgres user and do select * from
> betteridea.zfunc_get_employee('1234');
> or
> select * from zfunc_get_employee('1234');
>
> with no schema in front of it.
> It is returning the data from the public.employee_list in both cases
> ---(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 cleanly
>
--
Jim C. Nasb
ng
something like perl.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)--
I'm in Brussels until Wednesday; should anyone be interested in grabbing
a beer or 3 somewhere drop me an email.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasiv
ys if you do them this way:
>
> Yep. I filed the bug report on it.
>
> http://bugs.mysql.com/bug.php?id=13301
Submitted to the gotchas page...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http:
401 - 500 of 647 matches
Mail list logo
