Hi,
On Tue, 2008-03-04 at 00:34 -0500, Tom Lane wrote:
> Karl Denninger <[EMAIL PROTECTED]> writes:
> > Anyone know where the magic incantation is to find the crypto
> libraries?
>
> If the RPM layout is the same as Fedora (which it surely oughta be)
> openssl is what provides libcrypto.so.
I th
Harald,
Thanks for the response.
>1.) you should prefer windows 2003 for your first PostgreSQL install
> on windows. Installation on Windows 2000 is a lot more challenging.
> BTW: main stream support for 2000 by Microsoft ended on 2005-06-30, so
> unless you have contracts with MS for extended s
Karl Denninger <[EMAIL PROTECTED]> writes:
> Anyone know where the magic incantation is to find the crypto libraries?
If the RPM layout is the same as Fedora (which it surely oughta be)
openssl is what provides libcrypto.so.
regards, tom lane
---(e
Scott Marlowe wrote:
> On Feb 19, 2008 11:39 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > > and since postgresql functions cannot return cursor to the
> > > calling applications,
> >
> > Likewise a false statement.
>
> Yeah, I remembered there being a section on returning cursors. I went
> to t
Tom Lane wrote:
> "hernan gonzalez" <[EMAIL PROTECTED]> writes:
> > test=# create view vchartest as
> > select encode(convert_to(c,'LATIN9'),'escape') as c1 from chartest;
>
> Hmm. This isn't a very sensible combination that you've written here,
> but I see the point: encode(..., 'escape') is br
Jorge Godoy wrote:
Em Monday 03 March 2008 13:17:03 você escreveu:
My understanding is no password is sent in the clear with md5 per:
http://www.postgresql.org/docs/8.3/interactive/auth-methods.html#AUTH-PASSW
ORD
But the MD5 hash is. This page states that the password can't be directly
sni
Em Monday 03 March 2008 13:17:03 você escreveu:
>
> My understanding is no password is sent in the clear with md5 per:
>
> http://www.postgresql.org/docs/8.3/interactive/auth-methods.html#AUTH-PASSW
>ORD
But the MD5 hash is. This page states that the password can't be directly
sniffed, but one c
I was slightly confused. I'm really trying to identify what type
of support the project should provide to array types. Just from
the input so far, it looks like more needs to be done. If 100's to
1000's of elements are in an array type, the application is going
to have some problems. Presently it
Scara Maccai <[EMAIL PROTECTED]> writes:
> Is there a "specific" reason why views can't be part of an inheritance tree?
> I mean: it's that we "don't want" it or it would be just difficult to
> implement?
It would certainly require a lot of rethinking of assumptions, in the
planner and elsewhere.
> > >> You should have. The system enforces (or tries to) that a view can't be
> > >> part of an inheritance hierarchy, but you seem to have managed to find a
> > >> sequence of operations that avoids those checks. Turning a table into a
> > >> view with a manual CREATE RULE operation has always
Ray
> have you had a trawl through the archives?
Thanks for the response. Yes, I did. I tried a few things but did not find
anything that seemed to apply. Though it's possible I may have missed
something.
Dee <[EMAIL PROTECTED]> wrote: What are the permissions required to install
postgre
I use arrays of integers, double or numeric, and text.
They are 1 or 2 dimensional.
They are usually limited to <100 elements in
one dimension and <10 in the other.
TJ O'Donnell
http://www.gnova.com
---(end of broadcast)---
TIP 1: if posting/readin
> 1. What Size, <10 or 100's, 1000's of elements?
< 100 elements
> 2. Single or Multi-Dimensional?
2-dimensional
> 3. What data types?
integers
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello - Curious if anyone has any experience with the new UUID type in
8.3? We are currently using sequences for all of our keys and ids.
However using a UUID instead of a sequence would make some parts of the
application easier. However we have a few concerns about performance
issues surroundi
On Mar 3, 2008, at 2:05 PM, Josh Trutwin wrote:
On Mon, 3 Mar 2008 20:48:55 +0100
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
Where are you getting this information.
IMO the OP wanted to know how people *use* arrays, not how
one *c
On Mon, 3 Mar 2008 20:48:55 +0100
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
>
> > Where are you getting this information.
> IMO the OP wanted to know how people *use* arrays, not how
> one *can* use arrays.
That was my thought, sort
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
> Where are you getting this information.
IMO the OP wanted to know how people *use* arrays, not how
one *can* use arrays.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
On Mar 3, 2008, at 12:42 PM, Josh Trutwin wrote:
On Mon, 03 Mar 2008 10:42:50 -0700
dmp <[EMAIL PROTECTED]> wrote:
Hello,
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to e
Swaminathan Saikumar wrote:
> Thanks for telling me that Postgres doesn't support cross-database joins.
> I know MS Sql Server does. And one of the companies I worked for used it, to
> sometimes have a secure database with sensitive info behind a firewall join
> queries with a less secure database.
Hello list,
We are looking for someone with experience on the as/400 (running
os/400) platform, particularly in legacy environments. We are porting
an application to as many architectures as possible. We know very
little about as/400, but we have had some customers request support.
Does anybody
Thanks for telling me that Postgres doesn't support cross-database joins.
I know MS Sql Server does. And one of the companies I worked for used it, to
sometimes have a secure database with sensitive info behind a firewall join
queries with a less secure database.
Is this something worth considerin
On Mon, Mar 3, 2008 at 6:13 PM, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Dave Page wrote:
>
> > A postgresql.org wiki to replace techdocs is being worked on, per
> > recent discussion on -www, however it takes a little more effort than
> > a standalone one as we need to integrate it properly into
On Mon, 03 Mar 2008 10:42:50 -0700
dmp <[EMAIL PROTECTED]> wrote:
> Hello,
> The project MyJSQLView will provided basic support
> for array types in PostgreSQL at the next release.
> Information is desired from anyone that uses arrays
> in PostgreSQL to effect this support. Just a couple
> of ques
On Mon, Mar 03, 2008 at 10:42:50AM -0700, dmp wrote:
> The project MyJSQLView will provided basic support
> for array types in PostgreSQL at the next release.
> Information is desired from anyone that uses arrays
> in PostgreSQL to effect this support.
> 1. What Size, <10 or 100's, 1000's of ele
Dave Page wrote:
A postgresql.org wiki to replace techdocs is being worked on, per
recent discussion on -www, however it takes a little more effort than
a standalone one as we need to integrate it properly into the existing
infrastructure.
Dave, what is the intention of this wiki, as opposed t
Andrei Kovalevski <[EMAIL PROTECTED]> writes:
> Does anybody ever measured performance slowdown for SSL connections?
It's pretty significant percentage-wise on a local-loopback connection,
but for a connection over the open Internet I doubt it'd be an issue.
Unless your data is completely not pri
Hello,
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to effect this support. Just a couple
of questions.
1. What Size, <10 or 100's, 1000's of elements?
2. Single or Multi-Dim
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Scara Maccai <[EMAIL PROTECTED]> writes:
> >>> I got that there should be no difference... plus, I don't get any
> >>> errors,
> >>
> >> You should have. The system enforces (or tries to) that a view can't be
> >
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Scara Maccai <[EMAIL PROTECTED]> writes:
>>> I got that there should be no difference... plus, I don't get any
>>> errors,
>>
>> You should have. The system enforces (or tries to) that a view can't be
>> part of an inheritance hierarc
Hello,
Jorge Godoy wrote:
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only
Tom Lane wrote:
> Scara Maccai <[EMAIL PROTECTED]> writes:
> > I got that there should be no difference... plus, I don't get any
> > errors,
>
> You should have. The system enforces (or tries to) that a view can't be
> part of an inheritance hierarchy, but you seem to have managed to find a
> seq
But make it "hostssl" instead of "host", to require some cryptography
in the channel used, specially to authenticate the connection.
Opening your access to everyone without crypto sounds like something
you don't want to do. Specially if users can change their own
passwords...
My underst
Collin wrote:
But make it "hostssl" instead of "host", to require some
cryptography in the channel used, specially to authenticate the
connection.
Opening your access to everyone without crypto sounds like something
you don't want to do. Specially if users can change their own
passwords
Jorge Godoy wrote:
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only by usern
Thanks for the help! Stupid error,
Shad
On Feb 28, 7:04 am, [EMAIL PROTECTED] (Michael Fuhr) wrote:
> On Wed, Feb 27, 2008 at 04:59:07PM -0800, shadrack wrote:
> > This may seem like a very simple question...it is...but I can't find
> > documentation on it to help. I've seen some posts about lat/
Karl Denninger wrote:
I can reproduce this as I have the dump from "before conversion" and can
load it on a different box and "make it happen" a second time.
Would you like it on the list or privately?
Privately, unless you can boil it down to a small schema fragment.
--
Richard Huxton
A
I can reproduce this as I have the dump from "before conversion" and can
load it on a different box and "make it happen" a second time.
Would you like it on the list or privately?
Karl Denninger ([EMAIL PROTECTED])
http://www.denninger.net
Richard Huxton wrote:
Karl Denninger wrote:
Richa
Michael Meskes wrote:
I just committed the attached small fix to CVS HEAD and the 8.3 branch.
This should fix your problem.
Michael
diff --exclude CVS -ru /home/postgres/pgsql-ecpg/preproc/type.c preproc/type.c
--- /hom
Michael Meskes wrote:
On Fri, Feb 29, 2008 at 11:27:25AM -0500, Steve Clark wrote:
Actually it appears to work in 8.2.5 but be broken in 8.2.6 and 8.3.0.
Are you really sure? It appears to me that there was no change between
8.2.5 and 8.2.6 that could affect ecpg's handling of arrays of varc
Karl Denninger wrote:
Richard Huxton wrote:
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the
table with a GIST index on that column. This fails horribly under
8.3; it appears to be ok on the reload but as there is a trigger on
updates any update or i
Richard Huxton wrote:
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the
table with a GIST index on that column. This fails horribly under
8.3; it appears to be ok on the reload but as there is a trigger on
updates any update or insert fails immediately
Maciej Sieczka wrote:
Isn't there a ready to use sort of addon for PgSQL which could intercept
the CREATE TABLE that eg. Base (or any other client) issues, appdend
GRANT to it and forward such a modified instruction to the server?
I looked a lot in list archives, PgFoundry, Google and can't
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
> On 03/03/2008 11:01, dfx wrote:
> > The question il: Is there a method to avoid to insert the addesses of
> > the clients in the pg_hba.conf and to allow connections from internet
> > with security assured only by username and password?
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only by username and password?
Yes, that's what people have been explaining: you insert a line
somet
am Mon, dem 03.03.2008, um 11:59:36 +0100 mailte Magnus Hagander folgendes:
> > > How I have to configure pg_hba.conf (and/or eventually my router, where
> > > the
> > > server is located)?
> >
> > Set the CIDR to 0.0.0.0/32.
>
> That should be 0.0.0.0/0, I beleive.
>
> //Magnus
Magnus, right
On Mon, Mar 03, 2008 at 11:33:17AM +0100, A. Kretschmer wrote:
> am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes:
> > Dear Sirs,
> >
> > it is possible to connect to PostgreSQL server from a client with a dynamic
> > IP (or from an unknown IP)?
>
> Of course, yes.
>
>
> >
> > H
I apologize for my confuse exposition.
My server has a static, well known IP.
The problem is that I don't know the IP of my customers (client side) and
then
I cannot insert those addresses in pg_hba.conf file.
The question il: Is there a method to avoid to insert the addesses of the
clients
in t
am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes:
> Dear Sirs,
>
> it is possible to connect to PostgreSQL server from a client with a dynamic
> IP (or from an unknown IP)?
Of course, yes.
>
> How I have to configure pg_hba.conf (and/or eventually my router, where the
> server i
Em Monday 03 March 2008 07:01:17 dfx escreveu:
> it is possible to connect to PostgreSQL server from a client with a dynamic
> IP (or from an unknown IP)?
>
> How I have to configure pg_hba.conf (and/or eventually my router, where the
> server is located)?
You'll have to make PostgreSQL accept co
yes, it is possible if you use a service like dyndns: http://www.dyndns.com/
to "convert" your dynamic ip. If you use this service you connect your
dynamic
ip to a hostname, which is dynamically updated by this service.
after that you can change your windows hosts file to add the hostname
you have
Dear Sirs,
it is possible to connect to PostgreSQL server from a client with a dynamic
IP (or from an unknown IP)?
How I have to configure pg_hba.conf (and/or eventually my router, where the
server is located)?
I have no possibility to change the settings of clients (my customers)
Thank you.
D
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the table
with a GIST index on that column. This fails horribly under 8.3; it
appears to be ok on the reload but as there is a trigger on updates any
update or insert fails immediately with a data mistype co
On Mon, Mar 3, 2008 at 5:47 AM, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Greg Smith wrote:
>
> > Thanks to Joshua Drake and Command Prompt for providing hosting space
> > and even having an appropriate domain. To cut off one question I expect
> > to pop up, yes it would be nice to have this inte
53 matches
Mail list logo
