y dumbing
it down. It works, but then you have OS login enabled for the "postgres"
user.)
My JPY 2.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ich might have
something to do with it.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
the recent vulnerabilities.
War stories? Things to watch out for?
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Tue, 26 Oct 2004 13:30:49 +0200
Ian Barwick <[EMAIL PROTECTED]> wrote
> On Tue, 26 Oct 2004 18:22:55 +0900, Joel <[EMAIL PROTECTED]> wrote:
> > I seem to remember reading a post on this, but searching marc does not
> > seem to bring it up immediately.
> >
>
On Thu, 28 Oct 2004 01:01:20 -0400
Tom Lane <[EMAIL PROTECTED]> wrote
> Joel <[EMAIL PROTECTED]> writes:
> > Any thoughts on the urgency of the move?
>
> How large is your pg_log file? 7.1 was the last release that had the
> transaction ID wraparound limitati
require group [EMAIL PROTECTED]
(And, yes, I'll also try an apache mailing list.)
Apologies in advance if the noise is not appreciated.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Sorry for the noise. We resolved it:
On Fri, 29 Oct 2004 12:36:54 +0900
Joel <[EMAIL PROTECTED]> wrote
> ...
>
> We get the following error:
>
> > Auth_PG_grp_group_field takes one argument, the name of the group-name field.
>
> on the directive
>
> niutil -createprop . /users/pgsql passwd \*
> niutil -createprop . /users/pgsql home /Users/pgsql
> niutil -createprop . /users/pgsql shell /bin/tcsh
>
>
> gid and uid can be set to some non-conflicting number of your choice. I believe
> that numbers over 5000 do not
ether Marc (all by himself?)
would be appropriate, particularly on the usenet side, perhaps it would
be good to set up a group of moderators? Ideally, they could be spread
around the globe and take shifts, to get good time coverage.
Oh, and thanks, Mike, for stirring up the hornets' nes
ss for a day. There's no rush. And it really
isn't all on your back. If you insist on keeping it that way, the vote
will fail, and we'll be back where we were.
Are you needing a co-proponent?
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)--
robably do need someone from the mail list to go co-proponent
with Mike.
Unless, of course, the majority of the list would prefer to keep the
status quo.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: if posting/reading throug
Richard Huxton wrote
> Joel wrote:
> >
> > But we probably do need someone from the mail list to go co-proponent
> > with Mike.
> >
> > Unless, of course, the majority of the list would prefer to keep the
> > status quo.
>
> I must admit I'm n
s. What I see in news.groups
indicates to me they are just trying to see how many people they can get
to gag. Ignore them and pretty seen they get bored and go look for other
prey.
> ...
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ld be a bit slow, but that
might actually be an advantage.)
(And, BTW, Mike, thanks for trying.)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Long and rambling question, here -- we have a customer with a database
(Bthat is outgrowing their original storage, and they want to upgrade
(Bstorage as cheaply and smoothly as possible.
(B
(BPresently, they have one 120G or so RAID 5 unit, and the entire system
(Band data are stored on that
As long as the web page maintainers are going to the trouble of taking a
(Bsurvey, might I (at the risk of being tarred and feathered :-p) suggest
(Ba more thorough survey?
(B
(BSuggested questions:
(B
(B(1) If there were a USENET newsfeed, under comp.databases.postgresql.*,
(Bof one or more
(From someone else who doesn't know what doesn't know, ... :-/)
(B
(B>sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster [...]
(B...
(B
(B> >> note that my cmd line refers to the conf file, which has the external
(B> >> PID id'd in it:
(B> >
(B> >> external_pid_file = '/
> % cd /var/data/pgsql
(B> still reports the absolute path
(B> --> /Volumes/data/pgsql
(B
(BIt looks to me like you are attempting to mount a few volumes under /var?
(B
(BI think that's going to wrinkle your handkerchief in Darwin.
(B
(B--
(BJoel Rees <[EMAIL PROTECTED]>
(Bdigitcom, inc
t any hardware, but,
especially where reliability and performance are
required, it is wise to research your
hardware options thoroughly.
(where/when)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 9
world grammars, back to the cold,
cruel world of mechanical parsers. ;)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Tue, 24 Aug 2004 01:34:46 +0200
(BIan Barwick <[EMAIL PROTECTED]> wrote
(B
(B> ...
(B> wild speculation in need of a Korean speaker, but:
(B>
(B> [EMAIL PROTECTED]:~/tmp> cat j.txt
(B> $Bec,e$;ec(B
(B> $ByyPl%$%9wd!"(B
(B> $Bx"(l%$(Bl$B%i(B
(B> $Bw{%1v.%/wd(B
(B>
data models.) But PostGreSQL does have
tables, and you can use tables to model a family tree.
My JPY 2.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
dy done, or maybe
an option? (Not that it would in any way solve Wes's company's current
problem, ...)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ewrite 192095 i
a <-- pg_type 192094 i
a <-- pg_rewrite 192099 n
a <-- pg_type 192094 i <-- pg_type 192093 i
(6 rows)
-- Same query for b:
tree
-----
b
b <-- pg_rewrite 192099 n
b <-- pg_rewrite 192099 i
b <-- pg_type 192098 i
b <-- pg_type 192098 i <-- pg_type 192097 i
(5 rows)
--
Best regards,
Joel Jacobson
Glue Finance
It appears to me it's necessary to join the object type specific tables,
such as pg_rewrite, to build a complete tree?
If so, that's fine, I just wondered if I had missed something making it
possible to avoid it.
--
Best regards,
Joel Jacobson
Glue Finance
2011/1/3 Tom Lane :
> select refobjid ... where objid matches and deptype = 'i'
> then it'd be easy, but you only get one UNION ALL per recursive query.
Ah, I see! Thanks for explaining. Now I get it.
--
Best regards,
Joel Jacobson
Glue Finance
--
Sent via pgsql
re defined, i.e. other classes
the given class depend on.
For instance, is it correct to assume constraints always can be
dropped, i.e. no other class (nor other constraints) can depend on
them?
--
Best regards,
Joel Jacobson
Glue Finance
--
Sent via pgsql-general mailing list (pgsql-general@pos
Hoping someone will be kind enough to share how to write a query that
uses 9.0's string_agg with a subselect, something like...
select
m.id,m.subject,m.from_address,m.date_sent,m.size,string_agg((select
address as to_address from recipient r inner join message_recipient mr
on r.id=mr.recipien
rease if I do a normal vacuum at that point, but that's not germane to my
question AFAICT.
Can I use the relation size like this to determine whether or not compression
is happening for these toast columns? If not, is there a way that I can
confirm that it is or isn't active? The res
On Apr 12, 2011, at 10:33 AM, Bill Moran wrote:
> In response to Joel Stevenson :
>
>> select pg_total_relation_size('obj1') as o1, pg_total_relation_size( (select
>> reltoastrelid from pg_class where relname = 'obj1' ) ) as otoast1,
&
process is
averaging 80% of IO. If I stop the slave, then IO utilization on the master
drops to ~20%. Is there something that I am doing wrong? I have
wal_keep_segments at 2048, checkpoint_segments at 96.
Thank you,
Joel
.
Thank you,
Joel Avni
It 9.3.5 and I did the manual vacuum to try to see where the problem might
be.
On 9/22/14, 4:04 PM, "Adrian Klaver" wrote:
>On 09/22/2014 01:42 PM, Joel Avni wrote:
>> I noticed that tables on my master PostgreSQL server were growing, and
>> running vacuum full anal
might be visible at the slave¹s last replayed transaction? I
didn¹t think the master was aware of the slave¹s state, and why locks
can¹t be coordinated between the master and slave.
On 9/22/14, 4:04 PM, "Adrian Klaver" wrote:
>On 09/22/2014 01:42 PM, Joel Avni wrote:
>> I notice
_random(n int) RETURNS SETOF foo AS $$
import random
for i in xrange(n):
m =3D random.randint(1,12)
d =3D random.randint(1,28)
b =3D random.choice(('red', 'blue'))
yield '2009-%d-%d' % (m, d), b
$$ LANGUAGE plpythonu;
DELETE FROM foo; INSERT IN
t random
for i in xrange(n):
m = random.randint(1,12)
d = random.randint(1,28)
b = random.choice(('red', 'blue'))
yield '2009-%d-%d' % (m, d), b
$$ LANGUAGE plpythonu;
DELETE FROM foo; INSERT INTO foo (SELECT * FROM make_random(100));]
I hope th
larly
done in PL/SQL but it seemed more sensible to just do the whole thing
rather than using GROUP BY after enumeration.
- Joel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Jan 21, 2014 at 1:34 AM, Maciej Szopinski wrote:
> Hello,
>
> Does PostgreSQL provide any notation/method for putting a constraint on
> each element of a JSON array?
>
> An example to illustrate:
>
>
> [...]
> I know that this can be done by extracting products to a separate table
> with
d it speed things up to make the float array a custom data type backed by C
code?
Thanks in advance, Joel
[1] http://en.wikipedia.org/wiki/Kullback%E2%80%93Leibler_divergence
---
CREATE DOMAIN topics AS float[150];
CREATE DOMAIN doc_id AS varchar(64);
CREATE TABLE docs
(
id serial
untu 10.10, e.g.
Linux ... 2.6.35-28-virtual #50-Ubuntu SMP Fri Mar 18 19:16:26 UTC 2011 x86_64
GNU/Linux
Thanks, Joel
--
- for hire: mac osx device driver ninja, kernel extensions and u
_connections set to?
I have the default settings, e.g. work_mem = 1MB and max_connections = 100.
I'm looking to process 400 requests per second, though. What should I use for
the above?
Thanks, Joel
--
- for hir
Tom,
On Apr 26, 2011, at 5:00 PM, Tom Lane wrote:
> For another couple orders of magnitude, convert the sub-function to C code.
> (I don't think you need
> a whole data type, just a function that does the scalar product.)
That's a 30x speedup, from 12 minutes down to 38s. Thanks Tom!
Thanks for the help with that, Noah. Indeed the sizes do look like I'd expect
them to if I force deflation of the bytea value before inserting it into the
EXTENDED column.
On Apr 21, 2011, at 2:02 PM, Noah Misch wrote:
> On Mon, Apr 11, 2011 at 03:19:23PM -0700, Joel Stevens
I have a column of 2 million float values from 0 to 1.
I would like to figure out how many values fit into buckets spaced by 0.10,
e.g. from 0 to 0.10, from 0.10 to 0.20, etc.
What is the best way to do this?
Thanks, Joel
Thank you Thomas!
Is there a way for the code below to determine the number of rows in the table
and use it?
Thanks, Joel
On Apr 30, 2011, at 5:48 PM, Thomas Markus wrote:
> Hi,
>
> try something like this:
>
> select
>trunc(random() * 10.)/10.
>
What is the meaning of
group by 1 order by 2
e.g. what to the numbers 1 and 2 stand for?
What would change if I do the following?
group by 1 order by 1
On Apr 30, 2011, at 5:48 PM, Thomas Markus wrote:
> Hi,
>
> try something like this:
>
> select
>trunc(random(
I think this should do what I want
select trunc(distance * 10.)/10., count(*)
from doc_ads
group by 1 order by 1
Thanks, Joel
--
- for hire: mac osx device driver ninja, kernel extensions and usb
I'm trying the new 9.1b2 release and got a weird problem with the \s
command to show the latest history, for some reason it's trying to
write to /dev/tty instead of printing out to stdout:
Joel-Jacobsons-MacBook-Pro:~ joel$ uname -a
Darwin Joel-Jacobsons-MacBook-Pro.local 10.7.4 Dar
even if the actual table wasn't being replicated.
Does anyone know if this is a valid concern and whether or not the temp table
will be replicated (regardless of the use of file-based continuous archiving)?
Thanks in advance,
Joel
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
t where there is a conflict.
Would it be possible to somehow automatically scan through all functions
and getting a list of the functions which have this problem?
Thanks!
Best regards,
Joel Jacobson
check constraint "i_i_check"
# insert into i values (ARRAY[0,1,2,3,1024]);
ERROR: new row for relation "i" violates check constraint "i_i_check"
Joel
On Sat, Sep 8, 2012 at 8:31 AM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> test=# create or replace f
would otherwise affect the quality of the ranking. You should set
up a test group of documents and make sure your mechanism ranks that group
properly on test queries.
Joel
On Tue, Sep 25, 2012 at 11:16 AM, W. Matthew Wilson wrote:
> I want to run a query like to_tsquery("A | B | C") an
tions always
return the same results in the same transaction, this is of course what you
usually want to happen, but in my case I want the ability to override this.
Thankful for any ideas.
--
Best regards,
Joel Jacobson
Glue Finance
E: j...@gluefinance.com
T: +46 70 360 38 01
Postal address:
Hi,
I am trying to formulate a checklist for securing or securely configuring
the PostgreSQL DB. Wondering if you already have some thing in place or
perhaps a hardening document. Could you point me to some place where i could
find this.
Thanks,
Joel
s-- running on the server
machine, and --is-- listening on 5432.
I am sure I am leaving something out, so please write if you need more info.
Any thoughts?
Thanks!
Joel.
--
+---
Tom Lane wrote:
Joel Alpers writes:
New system: Fedora 11, PostgreSQL 8.4
Fedora 11 enables selinux by default ...
*** Error - Can't connect to database "photodb" - could not connect to server:
Permission denied
Is the server running on host &quo
s --on-- a postgres
list --- sorry,
it's been a long few days fighting software.
I meant to say I would check on the Fedora forum!
Joel.
--
+----+
| Joel K. Alpers
| Expressive Black and White Images
| http://w
y advice!
Best regards,
Joel Jacobson
Trustly Group AB (former Glue Finance AB)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Feb 15, 10:09 pm, pg wrote:
> I am involved with a SQL server project. The server would be used in a
> very heavy duty environment, with hundreds of thousands, if not
> millions of database enquiries per minutes.
>
> The server would run Linux or one of the BSD variant, with at least
> 32GB of
On Feb 16, 11:12 am, Paulie wrote:
> On Feb 16, 5:51 pm, joel garry wrote:
>
> > Check out Oracle XE and apex. No cost to you, and you can pay to
> > scale as appropriate.
>
> Before rushing to download Oracle XE, check out
>
> http://www.oracle.com/technology/pu
I have Pg installed on i386 NetBSD from the NetBSD package manager. I
then installed tsearch2 and used its default installation.
I then also got the source and built from it, with debugging enabled.
Again I installed tsearch2 but my results were the same.
Created a new database, added a table with
Ah ok. I must have copied it incorectly. I am using 8.0.1 from the
latest binary build from NetBSD. The source I used was
postgresql-8.0.1.tar.bz2 stable release.
I will try the CVS release to see if it's fixed.
--Joel
On Apr 7, 2005 12:26 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
t;
So, the only conclusion I can reach is this problem is some OS
dependant bug, which apparently has been fixed in 8.0.2beta.
--Joel
On Apr 7, 2005 9:04 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Joel Leyh <[EMAIL PROTECTED]> writes:
> > Same problem, same function causing t
insert the result, but is this the
best way of doing it? I need the trigger to be plperl since there is
some additional foo I am doing.
Thanks! --Joel
---(end of broadcast)---
TIP 8: explain analyze is your friend
the data correctly.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
[EMAIL PROTECTED]
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,
Title: Determining caller of a function (due to a cascaded FK constraint?)
Greetings,
For reasons a little too complicated to get into off the bat, I am wondering what the most effective way is to determine by whom or how a particular action or function call was initiated. To shed more light
I'd like to create a trigger function whose use can extend to multiple
tables by employing the special variables available (e.g., TG_RELNAME).
Below is a simple version of such a function that ought to prevent
insertion of greater than 4 total records in the table that calls it.
I'm not sure that I
Howdy,
I'm trying to create a schema in which there will be simple a view for
each table that will have the same columns and can be acted on in the
same way as the underlying table
An example of one table and its view would be:
CREATE TABLE test (id int, text_field varchar(100));
CREATE VIEW _te
I tried to post this the other day, but didn't get any responses and
never saw it show up in the digest. Here it is again if anyone can
offer any insight:
I'm trying to create a schema in which there will be simple a view for
each table that will have the same columns and can be acted on in the
Greetings,
I was wondering if it's possible to get any of the metadata from the NEW
and OLD constructs in a trigger or view rule? Specifically, I'd like to
get the column name or identifier anywhere the new record differs from
the old record (i.e. NEW.column_X <> OLD.column_X). Any advice would
Greetings,
Could somebody shed any light on the error message below that came from
trying to call a simple pltcl test function? I am running Postgres 8.1
on WinXP and just recently added the pltcl language by copying Tcl84.dll
into my system directory (C:/Windows/System32) and successfully issui
I've been using a product called HappyFish, which does reverse
engineering on Postgres and has proven to be a great DB development
tool. While it's not free, it is very low cost and you can easily get a
full-featured evaluation version to try out. I've been running it
through its paces with a pre
shed on this peculiarity would be
great. Once I get past this hurdle the function will, of course, go on
to do more and make better use of the temp table, but for now I just
need to figure out why it's failing. Is this an improper or ill-advised
use of a temp table?
Thanks much,
Joel
keep the list
and me informed if you have oneThanks, Joel
Code excerpt from within on delete trigger function for foobar.
-- Disable triggers on table foobar
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
'foobar'::pg_catalog.regclass';
-- Perform update
UP
most of all
how to correct it? Below is the buffer from a recent session with a \d
on Item and the only other thing I can offer is that several tables have
Item.id as a foreign key. Please advise and thanks in advance for the
help.
- Joel
postgres=# select * from item;
ERROR: too many trigg
limited
connectivity, we are definitely more tolerant of the delayed performance
this synchronization strategy will cause than most users/companies would
be. The important thing for us is that the data integrity is maintained
and that everyone at each site can access and change the data.
Regard
schema? That way it could cascade if the name was changed,
but I'm not sure what kind of ugliness might result if you tried to drop
the table and it still had a referencing record. Any opinions on that
or any other ways to approach this challenge?
Thanks in advance,
Joel
--
s?
Sorry if this has been discussed before - in which case please point me to
that discussion.
Thanks.
- Joel
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joinin
n the master of a cluster using asynchronous
replication, assuming we don't need to recover the data from the master
when it fails?
Thanks.
- Joel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Thanks for your response, Andrew.
On Tue, 8 May 2007, Andrew Sullivan wrote:
On Fri, May 04, 2007 at 08:54:10AM -0600, Joel Dice wrote:
My next question is this: what are the dangers of turning fsync off in the
context of a high-availablilty cluster using asynchronous replication?
My real
relies on
asynchronous replication and automatic failover.
- Joel
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ould use
the primary key index on test when finding
referencing records in the test1 table.
Pierre, I seen the advice to use an additional
where condition in certain cases to induce an
index scan; how is this done?
my 1.2 pennies,
-Joel
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
my question is this: What does this error indicate? I can't
seem to find much about it on the net and to be honest, I have become
rather illiterate in C over the past several years, so reading the
source is not really a viable option.
Any info would be appreciate
lved. I've disabled the offensive code until I can more
closely investigate in a controlled environment. Give that we didn't
really need it, turning it off is an adequate solution for a
production server.
--Joel
On Feb 4, 2006, at 1:16 AM, Tom Lane wrote:
Joel Richard <[E
what will work.
I can't have my clients losing faith in my ability to solve their
problems, so I get to track this down. :)
Thanks,
--Joel
On Feb 4, 2006, at 1:16 AM, Tom Lane wrote:
Joel Richard <[EMAIL PROTECTED]> writes:
... we occasionally get the following message in our a
hed
tar: Sorry, unable to determine archive format.
Cheers ! - Joel
On Monday, December 8, 2003, at 05:39 , Oleg Bartunov wrote:
On Mon, 8 Dec 2003, Joel Rodrigues wrote:
Hi,
I seem to recall once coming across & using functionality in PostgreSQL
that allowed for some flexibility in the spelling
hed
tar: Sorry, unable to determine archive format.
Cheers ! - Joel
On Monday, December 8, 2003, at 05:39 , Oleg Bartunov wrote:
On Mon, 8 Dec 2003, Joel Rodrigues wrote:
Hi,
I seem to recall once coming across & using functionality in PostgreSQL
that allowed for some flexibility in the spelling
Error 2
make[2]: *** [access-recursive] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
-
I found this, which may be relevant:
http://www.simdtech.org/apps/group_public/email/altivec/msg00663.html
I don't have much of a clue with regard to C programmi
Hi,
In light of no responses to the make error question -
Has anyone succeeded in installing PostgreSQL 7.4 on Mac OS X
(10.1/10.2/10.3) ?
Until now PostgreSQL was always just a ./configure, make, make install
away.
- Joel
On Friday, December 12, 2003, at 10:02 , Joel Rodrigues wrote
such file or directory
pgxml_dom.c:12:25: libxml/tree.h: No such file or directory
pgxml_dom.c:13:30: libxml/xmlmemory.h: No such file or directory
... followed by several errors & warnings
Any ideas ? I never had any trouble compiling it on OS X 10.1.5
- Joel
The files do exist, for exam
Thank you ! that did it. - Joel
On Aug 1, 2004, at 11:15, Peter Eisentraut wrote:
Joel Rodrigues wrote:
The files do exist, for example:
/usr/include/libxml2/libxml/xpath.h
Try
make all CPPFLAGS=-I/usr/include/libxml2
--
Peter Eisentraut
http://developer.postgresql.org/~petere
igger get a hold of data
from an insert? Thanks in advance for your comments.
Joel Dudley
Unix Admin
DevelopOnline.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [
d the same way:
DROP table foo;
DROP sequence foo_id_seq;
DROPDB dbname will *always* delete everything in a database, assuming
you have permissions to use it.
--
Joel Burton <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington
---(
more than a
> hour. My database has 6 MB.
>
> I can backup my database directory on Windows (using ZIP) and put it on Linux?
Might want to try pg_dump (rather than dumpall), perhaps even using the
-t option to pick just one table. This could let us find out if you can
dump *anything* or n
On Wed, 10 Oct 2001, Ian Barwick wrote:
> I'm doing some work for a smallish company which conducts
> its business largely online. Currently they have a legacy
> mishmash of Oracle and MySQL databases which they wish
> to unify one one platform (RDBMS with client access via
> browser and custom s
ngs.
Two conditions I really want on the use of heuristics -- I want the date
itself to include some "fuzzy" flag, and I want some way to reconstruct
the original string. That way, if I want to design an application with
tools for getting operator attention, etc., there are hooks in
On Wed, Aug 06, 2003 at 12:55:52PM -0400, Joel Burton wrote:
Reposting, with some clarification to my request. Thanks to the several
responses I received originally.
Yes, I know that a perfectly vaild PGSQL SQL file could contain only
ANSI SQL and therefore not be recognized as PG-related. In
is smart enough to copy any output
(such as the RAISE NOTICE), my fear is that it is actually running
the function a second time.
Does anyone know if this caching actually happens yet, or is this a
future feature?
Thanks.
--
Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED]
Support Center of Washington (www.scw.org)
On 19 Jul 2000, at 14:30, Tom Lane wrote:
> "Joel Burton" <[EMAIL PROTECTED]> writes:
> > I have a function that always returns the same answer given the same
> > input (no database lookups, etc.). The pg Users' Manual documents
> > the attribute
mn should be
different for each record *from the moment of inception*, this gives
Access something really unique to hang its hat on.
Works for me; let me know if it doesn't work for you.
--
Has anyone ever collected a FAQ of Access-on-Postgresql? I've got
a
few tips (nothing heavy, jus
1 - 100 of 184 matches
Mail list logo
