In response to Thomas Kellerer :
> Bill Moran wrote on 16.04.2009 22:20:
> >> I'm by far not an expert, but my naive attempt would be to store the the
> >> database files in an encrypted filesystem.
> >
> > That was the first suggestion when we started brai
In response to Steve Atkins :
>
> On Apr 16, 2009, at 12:40 PM, Bill Moran wrote:
>
> (This is the traditional "you're asking the wrong question" response).
>
> >
> > What are folks doing to protect sensitive data in their databases?
>
>
Thomas Kellerer wrote:
>
> Bill Moran wrote on 16.04.2009 23:06:
> >> which only talks about someone getting hold of the contents of the
> >> server's
> >> harddisk.
> >
> > Not really. You're making an assumption that a pg_dump can onl
128 symmetrical
encryption. In addition, we've purchased two different hardware
accelerators for crypto to find that both of them are slower than the
CPU itself, and they're both the high-end "enterprise" class cards.
--
Bill Moran
http://www.potentialtech.com
--
Sent via pgs
roblem we're having is the speed of access when an administrator
needs to search through the encrypted data.
--
Bill Moran
http://www.potentialtech.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
red with the ciphertext,
much the same way that crypt() stores the salt with the password hash.
As a result, if you have the key, you then have all the data required
to decrypt the field, but you can't easily brute force it or do any
pattern analysis.
--
Bill Moran
http://www.potentialtec
"Jonathan Bond-Caron" wrote:
>
> On Thu Apr 16 05:06 PM, Bill Moran wrote:
> >
> > The problem comes when the company head wants to search through the
> > database to find out which employee has a specific SSN. He should be
> > able to do so, si
gains us anything over
the DB. Also, if we use something different than the DB, we then have
to come up with a way to replicated it to the backup datacenter. If
we put the data in the DB, slony is already set up to take care of that.
> Also, how secure are you communication channels, what
In response to Sam Mason :
> On Thu, Apr 16, 2009 at 05:06:13PM -0400, Bill Moran wrote:
> > I disagree. We're already addressing the issues of security on the
> > application level through extensive testing, data validation out the
> > wazoo (to prevent SQL Injec
here it needs to be. The goal is to have as
many layers as possible while keeping the system as performant as
the client expects.
We only get one shot at this. If there's a data leak, a lot of
people are going to be very upset and we're going to be out of
business, so we're implementi
; ON distances.client_id = clients.id GROUP BY clients.id
>
> Thanks in advance!
Something like this should work, (assuming I understand your tables):
SELECT clients.id, stores.id,
min(sqrt(power(clients.x-stores.x)+power(clients.y-stores.y))
FROM clients, stores
GROUP BY clients.id, sto
Do I have to install anything in addition to the ODBC driver on my PC
in order to connect to a PostgreSQL server on another PC on my network?
Bill
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
s software
but the error persists.
Any suggestions? I am new to PostgreSQL so assume I have done something
really dumb.
Bill
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e an array column than to do an additional one-to-many table.
Whether or not it's good design is highly dependent on the nature of
the data.
In psql, do \d on the table, if the field type is postfixed with a
[], then it's an array datatype:
http://www.postgresql.org/docs/8.3/static/arrays.htm
s to me that you're trying get the people on this mailing list
to help you justify being angry with your database designer.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In response to Eric Schwarzenbach :
> Bill Moran wrote:
> > In response to "Robert Pepersack" :
> >
> >
> >> I read the document on array data types. Do they have anything at all to
> >> do with PostgreSQL being "object-oriented"
ng things in SVN because:
a) provides some sense of backup
b) maintains history of all your work
c) allows multiple developers to work together more easily
However, if you have other ways to solve those problems, or if
they're not important to you, you may not need SVN.
--
Bill Moran
http
t;
> > tcp0 0 localhost.localdom:postgres *:*
> > LISTEN
> >
>
>
> How to "listen" only in local socket?
Uncomment the listen line and fill it with a comma separated list of
IPs to listen on. Or take Jasen'
reign keys) and I'm still getting a deadlock.
In general, do the constraints need to be deferrable and then defer
constraints at the start of the transaction?
What else can I do to debug?
Thanks,
--
Bill Moseley
mose...@hank.org
Sent from my iMutt
--
Sent via pgsql-general mailing list (
You don't want your database to send out "invoice
> > #1" or "customer #1" after all.
Most of the systems I've seen like this do one of a few things:
* Start with an arbitrary # like 1000
* Prepend the date (pretty common for invoice #s) like 20090501001
* Just s
In response to Craig Ringer :
> Bill Moran wrote:
>
> > Sounds like you're reinventing message digests ...
[snip your comments about why I was wrong about MDs working]
> So long as I don't call it "xor encryption" ... sigh.
>
> > Most of the system
I'm seeing below.
On Thu, Apr 30, 2009 at 10:30:26AM -0700, Bill Moseley wrote:
>
> I need a bit of help understanding what might be causing a deadlock.
>
> To duplicate the problem I'm running a test script that forks two
> child processes. Each child runs the same
On Sat, May 02, 2009 at 11:48:21AM -0400, Tom Lane wrote:
> Bill Moseley writes:
> > Not getting any nibbles, so allow me to try a short question:
> > If I have a deadlock situation (that will be reported as such by
> > Postgresql once the deadlock_timeout passes), does pg_s
lock to use and on
what? SHARE ROW EXCLUSIVE on the account table before issuing the update?
--
Bill Moseley.
mose...@hank.org
Sent from my iMutt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In response to Bill Moseley :
> On Sun, May 03, 2009 at 09:08:29PM -0400, Tom Lane wrote:
> > > There are no other updates to that account table in the transaction, so
> > > I'm
> > > confused how that is causing a deadlock.
> >
> > Is there more
In response to Bill Moran :
> In response to Bill Moseley :
>
> > On Sun, May 03, 2009 at 09:08:29PM -0400, Tom Lane wrote:
> > > > There are no other updates to that account table in the transaction, so
> > > > I'm
> > > > confused how t
ct results.
Someone with a more expensive education than me may jump in with
more details, but I'm pretty sure this behaviour is mandated by
the SQL standard. I mean, PostgreSQL _could_ behave the same way
as MySQL, but he designers chose this way because it's more
reliable.
> Sorry, i kn
. Oddly, it didn't and the deadlock was reported
then on the LOCK itself, plus my deadlock_timeout (60 seconds) didn't seem to
apply in that case. A mystery.
Thanks for the help,
--
Bill Moseley.
mose...@hank.org
Sent from my iMutt
--
Sent via pgsql-general mailing list (pgs
is going to depend on the amount of procedures to convert.
Of course, I did it all by hand. If someone out there has a program
to convert, it would probably reduce the cost. But I also had the
ability to optimize some of the SPs as I converted them.
--
Bill Moran
http://www.potentialtech
at most people expect but will never get from consumer DSL and
cable connections. If you're budget is so tight that $150/month
is too much, then you'll have to fall back on one of the "magically
keep my DNS updated" solutions that others can surely give you
detai
> longest time to exec, duration of session, etc.
pgFouine
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
will be sorry that you did."
You're trying to run a modern database on a operating system that was
a piece of crap 11 years ago when it was new.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-general mailing list (pgsql
probably start working.
* You _may_ be able to get the application to start working without
granting superuser privs, simply by setting the value of log_statement
to "none" in the postgresql.conf. This is assuming the application is
smart enough to check the value and only
uot; btree (foobarid)
> "chit_foobar_log_key" btree (chit)
>
>
> The table consists of approximately 2.4 million entries.
>
> Any help is appreciated.
What is the output of VACUUM VERBOSE foobar_log?
--
Bill Moran
http://www.potentialtech.com
http://people.coll
tm <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> Woodchuck Bill <[EMAIL PROTECTED]> wrote:
>
>> The proponent certainly left a bad taste in my mouth after his
>> little ...
>
> Too much information.
>
LOL. Get your
third party. Questions about
the proposed group should be directed to the proponent.
Proponent: Mike Cox <[EMAIL PROTECTED]>
Votetaker: Bill Aten <[EMAIL PROTECTED]>
RATIONALE: comp.databases.postgresql
To provide a Big-Eight usenet group for users of the PostgreSQL
Relational Databas
rarchy. I'm no longer sure if it
would be a good thing or not.
The proponent certainly left a bad taste in my mouth after his little
crossposting stunt - but I will still vote on the *proposal*, and not
the *proponent*.
--
Bill
---(end of broadcast)
he second INSERT is not
executed if the first fails, but the function is always called.
So ... I'm a little fuzzy on this. Is there a doc that details this
behaviour?
TIA.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
---(end of broadcast)-
Tom Lane <[EMAIL PROTECTED]> wrote:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > Let's take the following fictional scenerio:
>
> > BEGIN;
> > INSERT INTO table1 VALUES ('somestring');
> > INSERT INTO table1 VALUES ('anotherstring
never attempt to minipulate the
sequence/index for the column in any way.
Short of the client mucking around with the column in
an unauthorized manner, can anybody think of a reason
how things might get confused and an already used
'evt_id' value is used again?
Regards,
Bill
___
For what its worth, the command is being issued via
JDBC app.
If the exact command is important I could have them
turn on logging and I could get that for you.
Bill
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Bill Chandler <[EMAIL PROTECTED]> writes:
> > Client is getting the
;10.25', 1, 739950991)
Bill
--- Ragnar Hafstað <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-04-11 at 11:03 -0700, Bill Chandler
> wrote:
>
> > ERROR: duplicate key violates unique constraint
> > event_tbl_evt_id_key
>
> > EVENT_TBL
> > evt_id
the pg_dump output conatins explicit
evt_id values for each row added so after creating the
database from the pg_dump output the sequence is still
at 1 when it should really be at 23040.
How does one find out the current sequence value? Is
there a way to change it?
Bill
--- Bill Chandler
Is that not correct?
Bill
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 12, 2005 at 07:59:55AM -0700, Bill
> Chandler wrote:
> > I'm sorry, was working on little sleep yesterday.
> You
> > are right, the table was created with the columns
> i
not specify 'evt_id' values directly. Does
anybody have any ideas about how this could have
gotten out of sync?
thanks,
Bill
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 12, 2005 at 08:48:15AM -0700, Bill
> Chandler wrote:
>
> > How does one find ou
All,
Is there a way to determine cardinality (size) of an
index? In general how to you query the 'attributes'
(for lack of a better word) of an index.
thanks,
Bill
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protect
up in the sort order relative to others.
SELECT id FROM __TABLE__
WHERE
sort_order <= (SELECT sort_order FROM __TABLE__ WHERE id = ?)
AND id != ?;
If that returns any rows then I know I can call the UPDATE to move the
item up.
Again,
e SELECT and then *only* do
an UPDATE if the SELECT returns at least one row.
So, I should do:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Before the SELECT. And when I UPDATE I need to be prepared to do a
ROLLBACK if I get an error and repeat the process. (And, I assume,
take some precauti
so I'm thinking of just manually updating all the
rows in sequence to adjust the order when needed -- to make things a
bit more simple. But it is a problem that I am curious about how best
to solve in a scalable way.
Thanks very much for your feedback.
--
Bill Moseley
[EMAIL PROTECTED
until either a
COMMIT or ROLLBACK.
Is it common for applications using Postgresql to set a timer on
updates and abort?
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, Aug 16, 2005 at 08:25:25PM +0200, Martijn van Oosterhout wrote:
> On Tue, Aug 16, 2005 at 11:05:35AM -0700, Bill Moseley wrote:
> > I've read over the docs on Concurrency Control but still not clear
> > about when transactions block other updates, and how to deal
is not allowing SELECTS.
What I did in my code was if ping fails, call rollback and then try
ping one more time. But, I'm not clear if that works in a more
general case or what might happen if the connection really is broken.
--
Bill Moseley
[EMAIL PROTECTED]
us classes. There also needs to be a link between the two.
For example, you might want to show a list of courses, and then see
what classes are scheduled for a given course, so a class should
reference its parent course.
Thanks very much,
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
selects are always going to have something like WHERE
type = 'course' added onto the WHERE. That's extra processing for no
good reason.
> I'm sure there are many ways to get there. To me, the way I've
> described is the most-direct way to represent the relationships y
27;s that. I'm not really sure why there's a need for a ping
-- and I've heard others question it, too.
Perl's DBI has a connect_cached() function that is suppose to return a
cached connection if it's still alive. So that is one place "ping" is
used. If ping fail
unset when the next connection
> uses the DB...
You mean other than setting "alarm 0;"?
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscri
ably faster for my client application
to parse epoch from the database, though.
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ExecNestLoop ()
#4 0x08102ceb in ExecProcNode ()
#5 0x081093a4 in ExecAgg ()
#6 0x08102c79 in ExecProcNode ()
#7 0x08101ecc in ExecutorRun ()
#8 0x0816f58b in PortalSetResultFormat ()
#9 0x0816f8c7 in PortalRun ()
#10 0x0816da9f in PostgresMain ()
#11 0x08148b4e i
k. I suspect I'm missing
something obvious.
Thanks,
Oh BTW -- If I do a count(*) and a WHERE that only includes columns in
the "class" table on the VIEW, will Postgresql still do the joins? Or
will it only do the select on the "class" table. I
ass_time | instructor
-++
544 | 2005-08-31 09:00:00-07 | Cheryl
555 | 2005-09-30 09:00:00-07 | Cheryl
737 | 2005-08-30 09:00:00-07 | Cynthia
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Thu, Aug 25, 2005 at 08:05:36AM -0500, Bruno Wolff III wrote:
> On Wed, Aug 24, 2005 at 23:12:17 -0700,
> Bill Moseley <[EMAIL PROTECTED]> wrote:
> > I need a little SQL help:
> >
> > I'm trying to get a subselect working inside a view.
>
> Unfort
And about being efficient:
On Thu, Aug 25, 2005 at 08:01:26AM -0700, Bill Moseley wrote:
> DROP VIEW cl;
> CREATE VIEW cl (id, class_time, instructor)
> AS
> SELECT DISTINCT ON(class.id)
>class.id, class.class_time, pe
't really
care), but class_time is a column in the "class" table which I'm using
DISTINCT ON on, so that should be unique as well. So I assume you
meant random choice of first_name, not class_time.
Thanks,
--
Bill Moseley
[EMAIL PROTECTED]
---(end o
rouped columns except within aggregate
functions, since there would be more than one possible value to
return for an ungrouped column.
Frankly, I cannot see how it might change results of a select between
the two views. Am I missing something?
--
Bill Mosele
81..707.90 rows=437 width=8)
Sort Key: instructors.person
-> Hash IN Join (cost=656.65..687.64 rows=437 width=8)
Hash Cond: ("outer"."class" = "inner".id)
-> Seq Scan on instructors (cost=0
ACUUM (or
> both) or tweaking the statistics parameters of the columns.
I did wonder about the planner stats, so I had run ANALYZE on the
database with no change. I just now ran VACUUM (and VACUUM ANALYZE),
and again see no change. Perhaps my table is just too small for this
test.
--
Bill Mo
On Fri, Sep 16, 2005 at 10:02:28AM -0500, Thomas O'Connell wrote:
>
> On Sep 16, 2005, at 9:18 AM, Bill Moseley wrote:
>
> >First question is why the planner is not using an index scan when I
> >use "now()" or CURRENT_TIMESTAMP?
>
> It also used to be
UP BY
clause or be used in an aggregate function
Is there a reason Postgresql doesn't just add the column
automatically? It does in other cases (like a missing table in a
join).
Thanks
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
SELECT *
FROM
(SELECT person.id AS person_id, first_name
FROM person) p
INNER JOIN
(SELECT class.id AS class_id, class_time
FROM class) c
INNER JOIN
(SELECT person, count(class) AS class_count
e-normalize the data.
Maybe I can just create three views (future, recent, old) and live
with that.
The temporary table is another possibility I'll look into.
Thank you very much for spending time on this. I really appreciate
it.
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
integer | not null
Indexes:
"person_role_pkey" primary key, btree (person, role)
Foreign-key constraints:
"$2" FOREIGN KEY (role) REFERENCES role(id) ON DELETE RESTRICT
"$1" FOREIGN KEY (person) REFERENCES person(id) ON DELETE CASCADE
Thanks,
--
Bil
[snipped]
> May not be the best choice on Windows for production use, though for
> development, it should be adequate.
Are there known issues with the Windows version for production use, or
is this simply because of the relative newness of the Windows-native
version?
a new platform: most of the time they'll
go with the safer solution rather than the riskier one -- there's always
one eye on future consulting business.) No, this obviously won't always
be the case, but it's inevitable that at least some portion of the
projects that would have chosen Pos
Cygwin is v7.4.5.
There is v8.x code available in CVS, but you'll have to compile it
yourself. I'm also planning on doing this too, but I haven't had the
time.
- Bill
Bill Bartlett
meridianEMR, Inc.
http://www.meridianemr.com/
> -Original Message-
> From: [EMAIL PROTE
>
> Bill Bartlett wrote:
>
> >I hit this exact same problem, and my initial reaction was
> the same as
> >yours -- psql was "hanging". After much head-banging, I discovered
> >that it is not in fact hanging, but is instead getting confused by
>
ed,
and so far everything seems to be working properly. Or is just a matter
of my not having bumped into a problem yet?
- Bill
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
begin_reg_time |
@@ -27 +27 @@
-register_cutoff_time| 2005-12-11 19:00:00-08
+register_cutoff_time| 2005-12-24 19:15:00-08
Thanks,
--
Bill "stabbing in the dark" Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
; Index Scan using
instructors_class_index on instructors (cost=0.00..52.00 rows=1000 width=8)
-> Hash (cost=20.00..20.00 rows=1000
width=142)
-> Seq Scan on "location"
(cost=0.00..20.00 rows=1000 width=
On Wed, Nov 16, 2005 at 10:53:21AM -0500, Tom Lane wrote:
> Bill Moseley <[EMAIL PROTECTED]> writes:
> > The first plan below returns the correct number of rows, the second plan
> > does
> > not. These are after I did the reindex, btw.
>
> Bizarre. What are t
On Wed, Nov 16, 2005 at 07:48:06PM -0500, Tom Lane wrote:
> Bill Moseley <[EMAIL PROTECTED]> writes:
> > [ strange behavior ]
>
> Oh, duh, it's not a PG bug: the problem is that the view is
> underspecified. You have
>
> SELECT DISTINCT ON (class.id)
>
On Wed, Nov 16, 2005 at 11:34:21PM -0500, Tom Lane wrote:
> No, I'm saying that the underlying data (the join result before applying
> DISTINCT ON) looks like this:
>
> bill=# select "class".id, person.id AS person_id
> bill-#FROM "class", "
class = class.id ),
person_role
WHERE person_role.person = person.id
AND person_role.role = 3
GROUP BY person.id, last_name;
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading throug
On Mon, Nov 21, 2005 at 11:45:34AM -0600, Bruno Wolff III wrote:
> On Mon, Nov 21, 2005 at 05:40:10 -0800,
> Bill Moseley <[EMAIL PROTECTED]> wrote:
> >
> > Here's where I'm missing something. Trying to do an outer join on
> > to bring in the class
0 |4
31 | 4 | 4 | 0 |4
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Mon, Nov 21, 2005 at 02:06:35PM -0800, Bill Moseley wrote:
> The now working query (thanks to you!) is:
No that doesn't work. It's dropping the people that have never
been assigned a class to teach (i.e. don't have a row in the
"instructors" link table).
>
ll you include it in the main tree?
OSS: We'll include any code in the tree, if it's _good_.
There are some subtle differences in the way things are approached there,
but they can be showstoppers when it comes to OSS and business working
together. And the simple fact is that Windo
they can sue.
>
> Good luck attempting to sue Microsoft, Oracle or IBM for deficiencies in
> their database products.
Suing someone is not the real reason. It's the excuse given to one's
boss. The real reason is the "Nobody ever got fired for using IBM"
mentality. If
w overhead
> - no trickers
>
> Cons:
> - binary alike master slave
- No reliability. On slow days, WAL logs could take a long time to
rotate, so small but important transactions might not be replicated
for a long time.
--
Bill Moran
Collaborative Fusion Inc.
-
ted scripting to make it work (no idea
> how much 8.2 will help here, didn't try yet).
That will be some neat stuff. I didn't know that was coming up.
--
Bill Moran
Collaborative Fusion Inc.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
mplate. See the docs for
details.
--
Bill Moran
Collaborative Fusion Inc.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
le checksums in tandem. Don't know the math, though -- if
both the SHA256 and the MD5 match, what are the chances that it's
changed?
You also hit diminishing returns ... after calculating so many
checksums, you might be better off just checking the data itself,
unless that
d, so we don't have to regenerate the thumbnail each
time it's needed.
BTW: our reason for keeping the thumbnails in fields is so they can be
replicated with Slony along with the rest of the database.
--
Bill Moran
We meddle. People don't like to be meddled
y time someone brings this up it reminds me of:
>
> Are you Josh or Joshua...
>
> It doesn't matter people.
To some it does. I've had a number of people ask me whether I want
Bill, William, or Will. The first two are fine, I prefer that the
third not be used.
I had an al
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
> Bill Moran wrote:
> > In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
> >>>> Scenario 1: While installing PostGRE 8.0, we got an logon failure at the
> >>>> end
&g
you're already doing a lot of work to tease out the x and y
points from various tables, it simplifies your query if you can do a
function call.
I can't tell from what have read about user defined functions and user
defined aggregates whether this kind of function is possible.
Bil
t it's not that easy to remember
either. And if you're already
> doing a lot of work to tease out the x and y points from various
tables, it simplifies your query
> if you can do a function call.
>
> I can't tell from what have read about user defined functions and
user
nd checked
> it, that the files are NOT the same.
Try sha1 or sha256.
--
Bill Moran
Collaborative Fusion Inc.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Wed, 11 Oct 2006, Bill Eaton wrote:
I just notice that multiple inputs to aggregates are allowed in the
upcoming 8.2 release. This gives me a great incentive to play with
the beta and upgrade from 8.0.
One question remains: how about multiple outputs? Can I have a ROW as
a return
,
etc. but nothing is formatted properly.
Bill Hawes
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
gging in
postgresql.conf and try again. If you get messages but aren't sure what
they mean, post them to the list.
Fourthly, be more specific. It would be worthwhile to show the snippit
of code that connects, so people know whether you're using IP sockets are
unix domain sockets.
F
801 - 900 of 1196 matches
Mail list logo
