pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: your mail
25+ messages / 12 participants
[nested] [flat]
* Re: your mail
@ 1998-03-04 14:45 Andreea Gheorghe <andi@sri.ziua.ro>
0 siblings, 0 replies; 25+ messages in thread
From: Andreea Gheorghe @ 1998-03-04 14:45 UTC (permalink / raw)
To: pgsql-interfaces
Hello all,
I have installed postgresql-6.2.1-7 on Red Hat 5.0(Hurricane).
I need to insert a large object into a data base.
I found in "Postgres User Manual", in section "Large Object", the sample
example "testlo.c" - test using large object with libpq.
I compiled this example, and there are some strange things:
- if I try to insert in the data base a file with size smaller
the 1K, the thinhs are Ok.
- but, if I try to insert a larger file, I get the message:
"broken pipe". Then, if I execute again, this program, I get the message:
"can't create large object", this mean that "lo_creat" function failed.
To insert the file in the date base is used: "lo_import" function
from libpq.
Did anyone have this problem? Can anybody help me?
Thanks a lot!
########################
Friendly Andi
http://www.ziua.ro/~andi
########################
Trust everybody...
then cut the cards!
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1998-11-23 14:11 The Hermit Hacker <scrappy@hub.org>
0 siblings, 0 replies; 25+ messages in thread
From: The Hermit Hacker @ 1998-11-23 14:11 UTC (permalink / raw)
To: gfchelp@gflesch.com; +Cc: pgsql-interfaces
Redirected to -interfaces vs -admin
On Mon, 23 Nov 1998, Ken Wills wrote:
> Hi!
>
> I have an annoying problem, that I just haven't been able to get around yet. When I parse the
> input from a form and go to insert it eveything works fine as long as the user doesn't use
> the ' character in the input. I've tried using qw{} and qq{}, which either don't interpolate
> or give me errors. Anyone have any suggestions? Postgres 6.4, Apache 1.3, mod_perl 1.16.
> The insert statement is below.
>
>
> my $query_string=qq{INSERT INTO CALLS (ca_service_id, ca_org_name, ca_phone_number, ca_status,
> ca_product, ca_problem, ca_resolution, ca_contact_name, ca_assigned, ca_date) VALUES ('$service_id',
> '$org_name', '$phone_number', '$status', '$product', '$problem', '$resolution', '$contact',
> '$assigned', '$time_now')};
escape your imput strings first...something like:
$phone_number =~ s/'/\\'/g;
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1998-12-10 09:51 Marcio Macedo <marciom@conectiva.com.br>
0 siblings, 0 replies; 25+ messages in thread
From: Marcio Macedo @ 1998-12-10 09:51 UTC (permalink / raw)
To: Laurent DELVAUX <bs243537@skynet.be>; +Cc: pgsql-interfaces
Yes,
Serach for pgAccess
On Thu, 10 Dec 1998, Laurent DELVAUX wrote:
> Hello everybody!
>
> What is the best graphical interface to use with postgres?
> The most simply and easy to use?
>
> Thanks
> Laurent
>
--Marcio Macedo
Conectiva
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1999-05-13 00:00 Brett W. McCoy <bmccoy@lan2wan.com>
0 siblings, 0 replies; 25+ messages in thread
From: Brett W. McCoy @ 1999-05-13 00:00 UTC (permalink / raw)
To: Ilhuicatzi Cortes J. Henry <ic94006@solar6.ingenieria.uatx.mx>; +Cc: pgsql-interfaces
On Wed, 12 May 1999, Ilhuicatzi Cortes J. Henry wrote:
> Im trying to run this CGI.
>
> #!/usr/bin/perl -w
>
> use Pg;
I recommend using the CGI module for perl CGI. It'll make your life a
lot easier (you don't need to use the here documents).
> I think that all it's O.K and then i try to run it in a browser and i
> get the next result.
>
> Conectado a la base de datos: henric
> ERROR: FATAL 1: SetUserId: user 'nobody' is not in 'pg_shadow'
>
> What's wrong?
>
> Im using Pg in the new Style.
Your web server typically intiates connections under user 'nobody', for
security reasons (nobody usually has no default shell, so crackers can't
use it to break into your system). You need to create a user in Postgres
also called 'nobody' so it cann access your database. You will then need
to grant whatever rights you need for 'nobody' to use your database (at
least give SELECT rights). I'm guessing you are using Apache and some
flavour of Unix, be it Linux, FreeBSD, etc.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Admiration, n.:
Our polite recognition of another's resemblance to ourselves.
-- Ambrose Bierce, "The Devil's Dictionary"
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1999-08-02 16:12 ` J. Michael Roberts <mirobert@cs.indiana.edu>
1999-08-02 16:40 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-09 09:43 ` Re: [ANNOUNCE] Re: your mail Alex P. Rudnev <alex@Relcom.EU.net>
3 siblings, 2 replies; 25+ messages in thread
From: J. Michael Roberts @ 1999-08-02 16:12 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: pgsql-announce@postgreSQL.org
You people are harsh *and* devious.
(Yes, I've now voted. Solaris is kind of like Linux. At least I use a
lot of GNUware.) It's now 28 to 35 out of 93 votes.
On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> out of 84 votes, while MySQL is in first with 33...
>
> Even if you aren't using Linux, take a minute and make your vote...we like
> to see PostgreSQL on top, no? :)
>
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
>
>
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
1999-08-02 16:12 ` Re: your mail J. Michael Roberts <mirobert@cs.indiana.edu>
@ 1999-08-02 16:40 ` The Hermit Hacker <scrappy@hub.org>
1 sibling, 0 replies; 25+ messages in thread
From: The Hermit Hacker @ 1999-08-02 16:40 UTC (permalink / raw)
To: J. Michael Roberts <mirobert@cs.indiana.edu>; +Cc: pgsql-announce@postgreSQL.org
On Mon, 2 Aug 1999, J. Michael Roberts wrote:
> You people are harsh *and* devious.
>
> (Yes, I've now voted. Solaris is kind of like Linux. At least I use a
> lot of GNUware.) It's now 28 to 35 out of 93 votes.
66 to 37 last I checked...and why devious? :)
>
> On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> >
> > LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> > http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> > out of 84 votes, while MySQL is in first with 33...
> >
> > Even if you aren't using Linux, take a minute and make your vote...we like
> > to see PostgreSQL on top, no? :)
> >
> >
> > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> > Systems Administrator @ hub.org
> > primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
> >
> >
> >
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [ANNOUNCE] Re: your mail
1999-08-02 16:12 ` Re: your mail J. Michael Roberts <mirobert@cs.indiana.edu>
@ 1999-08-09 09:43 ` Alex P. Rudnev <alex@Relcom.EU.net>
1 sibling, 0 replies; 25+ messages in thread
From: Alex P. Rudnev @ 1999-08-09 09:43 UTC (permalink / raw)
To: J. Michael Roberts <mirobert@cs.indiana.edu>; +Cc: The Hermit Hacker <scrappy@hub.org>; pgsql-announce@postgreSQL.org
Nothing strange - MySQL is the best free (and not only free) tool for the
fast search engines (when you do not need the full SQL), and PSQL is the
only stable free full (almost full) SQL DBA.
On Mon, 2 Aug 1999, J. Michael Roberts wrote:
> Date: Mon, 2 Aug 1999 11:12:16 -0500 (EST)
> From: J. Michael Roberts <mirobert@cs.indiana.edu>
> To: The Hermit Hacker <scrappy@hub.org>
> Cc: pgsql-announce@postgreSQL.org
> Subject: [ANNOUNCE] Re: your mail
>
> You people are harsh *and* devious.
>
> (Yes, I've now voted. Solaris is kind of like Linux. At least I use a
> lot of GNUware.) It's now 28 to 35 out of 93 votes.
>
> On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> >
> > LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> > http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> > out of 84 votes, while MySQL is in first with 33...
> >
> > Even if you aren't using Linux, take a minute and make your vote...we like
> > to see PostgreSQL on top, no? :)
> >
> >
> > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> > Systems Administrator @ hub.org
> > primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
> >
> >
> >
>
>
>
Aleksei Roudnev, Network Operations Center, Relcom, Moscow
(+7 095) 194-19-95 (Network Operations Center Hot Line),(+7 095) 230-41-41, N 13729 (pager)
(+7 095) 196-72-12 (Support), (+7 095) 194-33-28 (Fax)
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1999-08-02 17:47 ` Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
3 siblings, 1 reply; 25+ messages in thread
From: Diana Eichert @ 1999-08-02 17:47 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: pgsql-announce@postgreSQL.org
hi
i'm not a Linux user, but an OpenBSD user. recently Louis
Bertrand posted some requests for assistance in getting ODBC support to
work on the postgres port to openbsd. i didn't see many responses to his
requests, though I saw lots of discussions re: Linux problems.
I'd like to use PostgreSQL, but it doesn't seem like there is
much interest from this community in assisting an OpenBSD developer.
I'll change databases before I change OS's.
Sorry if this sounds like sour grapes, just call 'em like I see them
Diana Eichert
Network Systems Analyst
Sandia National Laboratories
On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> out of 84 votes, while MySQL is in first with 33...
>
> Even if you aren't using Linux, take a minute and make your vote...we like
> to see PostgreSQL on top, no? :)
>
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
>
>
>
Diana Eichert
deichert@wrench.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
@ 1999-08-02 17:56 ` The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 25+ messages in thread
From: The Hermit Hacker @ 1999-08-02 17:56 UTC (permalink / raw)
To: Diana Eichert <deichert@wrench.com>; +Cc: pgsql-interfaces
Moved off of -announce ...
On Mon, 2 Aug 1999, Diana Eichert wrote:
> hi
>
> i'm not a Linux user, but an OpenBSD user. recently Louis
> Bertrand posted some requests for assistance in getting ODBC support to
> work on the postgres port to openbsd. i didn't see many responses to his
> requests, though I saw lots of discussions re: Linux problems.
I'm not much into ODBC myself, so can't help much, but could you have
Louis repost his problem. The problem is that the 'Linux community' makes
up a very very large chunk (sadly *grin*) of our user base...but not
necessarily a large chunk of the developers.
I don't know if there are any OpenBSD "developers" right now...I'm
FreeBSD, as I believe Vadim is, Bruce is BSD/OS, and Thomas is Linux...I
don't know what anyone else is...except D'Arcy, who's Net/BSD ... Vince, I
believe, is FreeBSD also ... so there is a pretty good proportion of *BSD
users out there, but I don't think any of us use ODBC vs 'straight
interfaces'...
Basically, if you are non-Linux in this world nowadays, you have to learn
to be a little more pushy to get your point across :(
> I'd like to use PostgreSQL, but it doesn't seem like there is
> much interest from this community in assisting an OpenBSD developer.
> I'll change databases before I change OS's.
>
> Sorry if this sounds like sour grapes, just call 'em like I see them
>
> Diana Eichert
> Network Systems Analyst
> Sandia National Laboratories
>
> On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> >
> > LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> > http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> > out of 84 votes, while MySQL is in first with 33...
> >
> > Even if you aren't using Linux, take a minute and make your vote...we like
> > to see PostgreSQL on top, no? :)
> >
> >
> > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> > Systems Administrator @ hub.org
> > primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
> >
> >
> >
>
>
> Diana Eichert
> deichert@wrench.com
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
@ 1999-08-02 18:28 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
0 siblings, 1 reply; 25+ messages in thread
From: Tom Lane @ 1999-08-02 18:28 UTC (permalink / raw)
To: Diana Eichert <deichert@wrench.com>; +Cc: The Hermit Hacker <scrappy@hub.org>; pgsql-interfaces
The Hermit Hacker <scrappy@hub.org> writes:
> Basically, if you are non-Linux in this world nowadays, you have to learn
> to be a little more pushy to get your point across :(
Or, go and do it yourself. I think the real problem here is that the
people who use OpenBSD *and* ODBC *and* Postgres probably form a pretty
small group. Sitting back and waiting for someone else to fix problems
seen only (?) in that combination may be a long wait. Roll up your
sleeves and help make it better, instead.
regards, tom lane
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-08-02 19:36 ` Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 19:57 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 20:52 ` Re: [INTERFACES] Re: your mail The Hermit Hacker <scrappy@hub.org>
0 siblings, 2 replies; 25+ messages in thread
From: Louis Bertrand @ 1999-08-02 19:36 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Diana Eichert <deichert@wrench.com>; The Hermit Hacker <scrappy@hub.org>; pgsql-interfaces
Hello all,
I'm the guy trying to build the 6.5.1 port for OpenBSD. I agree there is a
limited target audience for this port, but that audience won't get any
bigger if nobody does anything about it. Like Diana, I chose my OS first
and my database engine second. However, my choice of OS shouldn't dictate
that I must settle for second-best applications, hence the effort to port
pgsql and its various components.
I think I played by The Rules[TM] of freenix software with my posts to the
ports mailing list: well researched to the limits of my abilities, showing
what and where I thought the problem was, and asking specific questions.
Marc and Tom's replies make me sound like all I did was whine that "it
doesn't work". To be fair to the PostgreSQL developer team, Bruce Momjian
was very helpful in orienting me to the way the project has configured the
builds and the OS dependencies with Autoconf and Gmake. I posted first in
the PostgreSQL lists because I hoped the group would be more focused. I
got _no_ reply, not even hints (I think I got buried in the flurry of
64-bit issues). Maybe I should have been more pushy, but that's history
now. With both specific problems, a repost to the OpenBSD misc list
brought the answer from experienced OpenBSD developers.
I have a preliminary port of PostgreSQL that optionally builds pgaccess
and libpgsqlodbc.so. I'm now working on making sure the regression tests
perform correctly (at least on i386) and that the man pages get built and
installed correctly (the old OpenBSD port didn't make them). When it's
ready, I will submit the entire package to the OpenBSD ports maintainers.
The preliminary version is available from me directly.
Ciao
--Louis <louis@bertrandtech.on.ca>
Louis Bertrand http://www.bertrandtech.on.ca
Bertrand Technical Services, Bowmanville, ON, Canada
OpenBSD: Secure by default. http://www.openbsd.org/
On Mon, 2 Aug 1999, Tom Lane wrote:
> The Hermit Hacker <scrappy@hub.org> writes:
> > Basically, if you are non-Linux in this world nowadays, you have to learn
> > to be a little more pushy to get your point across :(
>
> Or, go and do it yourself. I think the real problem here is that the
> people who use OpenBSD *and* ODBC *and* Postgres probably form a pretty
> small group. Sitting back and waiting for someone else to fix problems
> seen only (?) in that combination may be a long wait. Roll up your
> sleeves and help make it better, instead.
>
> regards, tom lane
>
>
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
@ 1999-08-02 19:57 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 20:45 ` Re: [INTERFACES] Re: your mail Diana Eichert <deichert@wrench.com>
1 sibling, 1 reply; 25+ messages in thread
From: Tom Lane @ 1999-08-02 19:57 UTC (permalink / raw)
To: Louis Bertrand <louis@bertrandtech.on.ca>; +Cc: Diana Eichert <deichert@wrench.com>; The Hermit Hacker <scrappy@hub.org>; pgsql-interfaces
Louis Bertrand <louis@bertrandtech.on.ca> writes:
> Marc and Tom's replies make me sound like all I did was whine that "it
> doesn't work".
I certainly didn't mean to sound like I was casting aspersions on *you*.
It sounds like you've done what needed to be done --- excellent!
Thank you.
> ... When it's ready, I will submit the entire package to the OpenBSD
> ports maintainers.
Please also submit any necessary source diffs to the pgsql-patches
mailing list, so that they will get into future releases.
regards, tom lane
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 19:57 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-08-02 20:45 ` Diana Eichert <deichert@wrench.com>
0 siblings, 0 replies; 25+ messages in thread
From: Diana Eichert @ 1999-08-02 20:45 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Louis Bertrand <louis@bertrandtech.on.ca>; The Hermit Hacker <scrappy@hub.org>; pgsql-interfaces
heh, i've got a thick skin, if you were casting apersions towards me, so
be it. all i really care about is that PostgreSQL runs under OpenBSD,
i'd like to use it.
thanks everyone for PostgreSQL
thanks Louis for the effort he has put into getting all of PostgreSQL
running under OpenBSD.
just another whiny enduser,
diana
On Mon, 2 Aug 1999, Tom Lane wrote:
> I certainly didn't mean to sound like I was casting aspersions on *you*.
>
Diana Eichert
deichert@wrench.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
@ 1999-08-02 20:52 ` The Hermit Hacker <scrappy@hub.org>
1999-08-03 00:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
1 sibling, 1 reply; 25+ messages in thread
From: The Hermit Hacker @ 1999-08-02 20:52 UTC (permalink / raw)
To: Louis Bertrand <louis@bertrandtech.on.ca>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Diana Eichert <deichert@wrench.com>; pgsql-interfaces
On Mon, 2 Aug 1999, Louis Bertrand wrote:
> Hello all,
>
> I'm the guy trying to build the 6.5.1 port for OpenBSD. I agree there is a
> limited target audience for this port, but that audience won't get any
> bigger if nobody does anything about it. Like Diana, I chose my OS first
> and my database engine second. However, my choice of OS shouldn't dictate
> that I must settle for second-best applications, hence the effort to port
> pgsql and its various components.
>
> I think I played by The Rules[TM] of freenix software with my posts to the
> ports mailing list: well researched to the limits of my abilities, showing
> what and where I thought the problem was, and asking specific questions.
> Marc and Tom's replies make me sound like all I did was whine that "it
Marc who?? unless I black'd out the episode, this is the first I've read
about it...*raised eyebrow* And if I gave the impression that I thought
you were whining, I do apologize, as it was not my intention to do so...
> Maybe I should have been more pushy, but that's history
> now. With both specific problems, a repost to the OpenBSD misc list
> brought the answer from experienced OpenBSD developers.
Just curious, but what turned out to be the problem, and is it something
we can/should change in the source tree to prevent it in the future?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 20:52 ` Re: [INTERFACES] Re: your mail The Hermit Hacker <scrappy@hub.org>
@ 1999-08-03 00:36 ` Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-03 00:58 ` Re: [INTERFACES] Re: your mail The Hermit Hacker <scrappy@hub.org>
0 siblings, 1 reply; 25+ messages in thread
From: Louis Bertrand @ 1999-08-03 00:36 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Diana Eichert <deichert@wrench.com>; pgsql-interfaces
On Mon, 2 Aug 1999, The Hermit Hacker wrote:
> On Mon, 2 Aug 1999, Louis Bertrand wrote:
>
> > Hello all,
> >
> > I'm the guy trying to build the 6.5.1 port for OpenBSD. I agree there is a
> > limited target audience for this port, but that audience won't get any
> > bigger if nobody does anything about it. Like Diana, I chose my OS first
> > and my database engine second. However, my choice of OS shouldn't dictate
> > that I must settle for second-best applications, hence the effort to port
> > pgsql and its various components.
> >
> > I think I played by The Rules[TM] of freenix software with my posts to the
> > ports mailing list: well researched to the limits of my abilities, showing
> > what and where I thought the problem was, and asking specific questions.
> > Marc and Tom's replies make me sound like all I did was whine that "it
>
> Marc who?? unless I black'd out the episode, this is the first I've read
> about it...*raised eyebrow* And if I gave the impression that I thought
> you were whining, I do apologize, as it was not my intention to do so...
ooops, too wide a tar brush. Sorry.
>
> Just curious, but what turned out to be the problem, and is it something
> we can/should change in the source tree to prevent it in the future?
>
1) EGCS in OpenBSD no longer defines symbol i386, using the
namespace-friendly __i386__ instead. I suspect there will be a similar
problem with SPARC and maybe others. I had to add:
bsd.h:
#ifdef(__i386__)
#define i386
#endif
2) When building libpgsqlodbc.so, /usr/lib/libcompat.a on OpenBSD had a
problem with doubly defining symbol _v8_regerror(). I'm not even sure why
pgsql's build uses libcompat.a because it's not needed to resolve
anything. I patched src/configure.in to remove the
AC_CHECK_LIB(compat,main) macro. OpenBSD-current has been changed to
remove the doubly-defined symbol, but the port should still be able to
work with earlier released CD-ROM versions.
3) src/bin/pg_passwd/pg_passwd.c is patched to change the password length
from the hard-coded 14 with _PASSWORD_LEN of 128. It was like that in the
previous (6.3.2) port and FreeBSD has it also, so I just updated it.
Ciao
--Louis <louis@bertrandtech.on.ca>
Louis Bertrand http://www.bertrandtech.on.ca
Bertrand Technical Services, Bowmanville, ON, Canada
OpenBSD: Secure by default. http://www.openbsd.org/
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 20:52 ` Re: [INTERFACES] Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-03 00:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
@ 1999-08-03 00:58 ` The Hermit Hacker <scrappy@hub.org>
1999-08-03 01:22 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
0 siblings, 1 reply; 25+ messages in thread
From: The Hermit Hacker @ 1999-08-03 00:58 UTC (permalink / raw)
To: Louis Bertrand <louis@bertrandtech.on.ca>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Diana Eichert <deichert@wrench.com>; pgsql-interfaces
On Tue, 3 Aug 1999, Louis Bertrand wrote:
> > Just curious, but what turned out to be the problem, and is it something
> > we can/should change in the source tree to prevent it in the future?
> >
> 1) EGCS in OpenBSD no longer defines symbol i386, using the
> namespace-friendly __i386__ instead. I suspect there will be a similar
> problem with SPARC and maybe others. I had to add:
> bsd.h:
> #ifdef(__i386__)
> #define i386
> #endif
Okay, I know that Bruce did some patches for this, changing i386 ->
__i386__, so that v6.6 will have it, and v6.5.2 *might* ... I'm the one
working on back-patching that...
> 2) When building libpgsqlodbc.so, /usr/lib/libcompat.a on OpenBSD had a
> problem with doubly defining symbol _v8_regerror(). I'm not even sure why
> pgsql's build uses libcompat.a because it's not needed to resolve
> anything. I patched src/configure.in to remove the
> AC_CHECK_LIB(compat,main) macro. OpenBSD-current has been changed to
> remove the doubly-defined symbol, but the port should still be able to
> work with earlier released CD-ROM versions.
hrmmm...let me look at patching configure.in such that 'if openbsd' it
doesn't get added...I've never seen the problem with FreeBSD, so it must
be an 'OpenBSD' specific problem...
> 3) src/bin/pg_passwd/pg_passwd.c is patched to change the password length
> from the hard-coded 14 with _PASSWORD_LEN of 128. It was like that in the
> previous (6.3.2) port and FreeBSD has it also, so I just updated it.
Will look at this one too...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: [INTERFACES] Re: your mail
1999-08-02 17:47 ` Re: your mail Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Re: [INTERFACES] Re: your mail Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 20:52 ` Re: [INTERFACES] Re: your mail The Hermit Hacker <scrappy@hub.org>
1999-08-03 00:36 ` Re: [INTERFACES] Re: your mail Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-03 00:58 ` Re: [INTERFACES] Re: your mail The Hermit Hacker <scrappy@hub.org>
@ 1999-08-03 01:22 ` Louis Bertrand <louis@bertrandtech.on.ca>
0 siblings, 0 replies; 25+ messages in thread
From: Louis Bertrand @ 1999-08-03 01:22 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Diana Eichert <deichert@wrench.com>; pgsql-interfaces
On Mon, 2 Aug 1999, The Hermit Hacker wrote:
> Okay, I know that Bruce did some patches for this, changing i386 ->
> __i386__, so that v6.6 will have it, and v6.5.2 *might* ... I'm the one
> working on back-patching that...
>
OK, I'll look at it again when 6.5.2 or 6.6 gets released. I'll also see
what happens with other architectures.
> hrmmm...let me look at patching configure.in such that 'if openbsd' it
> doesn't get added...I've never seen the problem with FreeBSD, so it must
> be an 'OpenBSD' specific problem...
>
Yes, it was specific to OpenBSD. It's fixed in -current now. I'll keep the
patch in my 6.5.1 port and update it as needed.
Ciao
--Louis <louis@bertrandtech.on.ca>
Louis Bertrand http://www.bertrandtech.on.ca
Bertrand Technical Services, Bowmanville, ON, Canada
OpenBSD: Secure by default. http://www.openbsd.org/
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1999-08-02 18:50 ` Peter Mount <peter@retep.org.uk>
1999-08-02 19:29 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
3 siblings, 1 reply; 25+ messages in thread
From: Peter Mount @ 1999-08-02 18:50 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: pgsql-announce@postgresql.org
On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> out of 84 votes, while MySQL is in first with 33...
>
> Even if you aren't using Linux, take a minute and make your vote...we like
> to see PostgreSQL on top, no? :)
Well, I've just voted, and now were 1st with 64.8% (to mysql's 22.2). I
think your plea for votes worked :-)
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
1999-08-02 18:50 ` Re: your mail Peter Mount <peter@retep.org.uk>
@ 1999-08-02 19:29 ` The Hermit Hacker <scrappy@hub.org>
0 siblings, 0 replies; 25+ messages in thread
From: The Hermit Hacker @ 1999-08-02 19:29 UTC (permalink / raw)
To: Peter Mount <peter@retep.org.uk>; +Cc: pgsql-interfaces
Drop'ng now...the MySQL camp appears to have finally heard about it...we
are still just slightly above 60%...
On Mon, 2 Aug 1999, Peter Mount wrote:
> On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> >
> > LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> > http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> > out of 84 votes, while MySQL is in first with 33...
> >
> > Even if you aren't using Linux, take a minute and make your vote...we like
> > to see PostgreSQL on top, no? :)
>
> Well, I've just voted, and now were 1st with 64.8% (to mysql's 22.2). I
> think your plea for votes worked :-)
>
> --
> Peter T Mount peter@retep.org.uk
> Main Homepage: http://www.retep.org.uk
> PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> Java PDF Generator: http://www.retep.org.uk/pdf
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 1999-08-02 21:36 ` Brett W. McCoy <bmccoy@lan2wan.com>
1999-08-02 17:51 ` Re: your mail The Hermit Hacker <scrappy@hub.org>
3 siblings, 1 reply; 25+ messages in thread
From: Brett W. McCoy @ 1999-08-02 21:36 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: pgsql-general@postgreSQL.org; pgsql-announce@postgreSQL.org
On Mon, 2 Aug 1999, The Hermit Hacker wrote:
> LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> out of 84 votes, while MySQL is in first with 33...
>
> Even if you aren't using Linux, take a minute and make your vote...we like
> to see PostgreSQL on top, no? :)
It's shot way up now. We're up to 122 votes and in first place!
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Today is the tomorrow you worried about yesterday
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
1999-08-02 21:36 ` Re: your mail Brett W. McCoy <bmccoy@lan2wan.com>
@ 1999-08-02 17:51 ` The Hermit Hacker <scrappy@hub.org>
0 siblings, 0 replies; 25+ messages in thread
From: The Hermit Hacker @ 1999-08-02 17:51 UTC (permalink / raw)
To: Brett W. McCoy <bmccoy@lan2wan.com>; +Cc: pgsql-general@postgreSQL.org; pgsql-announce@postgreSQL.org
133 and climbing...65% of the votes so far :)
On Mon, 2 Aug 1999, Brett W. McCoy wrote:
> On Mon, 2 Aug 1999, The Hermit Hacker wrote:
>
> > LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at
> > http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21
> > out of 84 votes, while MySQL is in first with 33...
> >
> > Even if you aren't using Linux, take a minute and make your vote...we like
> > to see PostgreSQL on top, no? :)
>
> It's shot way up now. We're up to 122 votes and in first place!
>
> Brett W. McCoy
> http://www.lan2wan.com/~bmccoy
> -----------------------------------------------------------------------
> Today is the tomorrow you worried about yesterday
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: your mail
@ 2000-12-13 04:09 Bob Kline <bkline@rksystems.com>
2000-12-13 13:46 ` Re: Re: your mail Adam Lang <aalang@rutgersinsurance.com>
0 siblings, 1 reply; 25+ messages in thread
From: Bob Kline @ 2000-12-13 04:09 UTC (permalink / raw)
To: Aziz ABI <abi@mail.cbi.net.ma>; +Cc: pgsql-interfaces
On Sat, 9 Dec 2000, Aziz ABI wrote:
> Bonjour
>
> Vous pouvez m'aider à créer une connexion ODBC à partir par un petit
> module VB.
>
> Merci
>
Sure.
1. Set your pg_hba.conf to allow access from your Windows machine.
2. Install the ODBC driver for PostgreSQL on that machine.
3. Set up an ODBC DSN using that driver.
4. Here's some sample VB code to talk to the database using the DSN:
Dim rs As ADODB.Recordset
Dim cn As String
Dim rc As Variant
Dim r, c As Integer
Set rs = New ADODB.Recordset
cn = "DSN=pgtest;UID=moi;DATABASE=test"
rs.Open "SELECT * FROM t", cn, , , 1
Do While Not rs.EOF
rc = rs.GetRows
For r = 0 To UBound(rc, 2)
For c = 0 To UBound(rc, 1)
Debug.Print r & " " & c " " & rc(c, r)
Next c
Next r
Loop
Hope this help.
--
Bob Kline
mailto:bkline@rksystems.com
http://www.rksystems.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Re: your mail
2000-12-13 04:09 Re: your mail Bob Kline <bkline@rksystems.com>
@ 2000-12-13 13:46 ` Adam Lang <aalang@rutgersinsurance.com>
2000-12-13 15:32 ` Re: Re: your mail Bob Kline <bkline@rksystems.com>
0 siblings, 1 reply; 25+ messages in thread
From: Adam Lang @ 2000-12-13 13:46 UTC (permalink / raw)
To: ; +Cc: pgsql-interfaces
For curiosity's sake... why are you using getrows?
Much easier to do:
dim fd as ADODB.Recordset
dim strRow as string
do while not rs.EOF
strRow = ""
for each fd in rs.Fields
strRow = strRow & " " & fd.value
next
debug.Print strRow
rs.MoveNext
Loop
set fd = nothing
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Bob Kline" <bkline@rksystems.com>
To: "Aziz ABI" <abi@mail.cbi.net.ma>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, December 12, 2000 11:09 PM
Subject: [INTERFACES] Re: your mail
> On Sat, 9 Dec 2000, Aziz ABI wrote:
>
> > Bonjour
> >
> > Vous pouvez m'aider à créer une connexion ODBC à partir par un petit
> > module VB.
> >
> > Merci
> >
>
> Sure.
>
> 1. Set your pg_hba.conf to allow access from your Windows machine.
> 2. Install the ODBC driver for PostgreSQL on that machine.
> 3. Set up an ODBC DSN using that driver.
> 4. Here's some sample VB code to talk to the database using the DSN:
>
> Dim rs As ADODB.Recordset
> Dim cn As String
> Dim rc As Variant
> Dim r, c As Integer
> Set rs = New ADODB.Recordset
> cn = "DSN=pgtest;UID=moi;DATABASE=test"
> rs.Open "SELECT * FROM t", cn, , , 1
> Do While Not rs.EOF
> rc = rs.GetRows
> For r = 0 To UBound(rc, 2)
> For c = 0 To UBound(rc, 1)
> Debug.Print r & " " & c " " & rc(c, r)
> Next c
> Next r
> Loop
>
> Hope this help.
>
> --
> Bob Kline
> mailto:bkline@rksystems.com
> http://www.rksystems.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Re: your mail
2000-12-13 04:09 Re: your mail Bob Kline <bkline@rksystems.com>
2000-12-13 13:46 ` Re: Re: your mail Adam Lang <aalang@rutgersinsurance.com>
@ 2000-12-13 15:32 ` Bob Kline <bkline@rksystems.com>
0 siblings, 0 replies; 25+ messages in thread
From: Bob Kline @ 2000-12-13 15:32 UTC (permalink / raw)
To: Adam Lang <aalang@rutgersinsurance.com>; +Cc: pgsql-interfaces
On Wed, 13 Dec 2000, Adam Lang wrote:
> For curiosity's sake... why are you using getrows?
>
> Much easier to do:
>
> dim fd as ADODB.Recordset
> dim strRow as string
> do while not rs.EOF
> strRow = ""
> for each fd in rs.Fields
> strRow = strRow & " " & fd.value
> next
> debug.Print strRow
> rs.MoveNext
> Loop
> set fd = nothing
Sure, that works, too. All I was trying to illustrate was how he could
establish the connection, which is what he originally asked. Turns out
that's not what he meant, though. What he really wanted to know was how
to create the data source programmatically.
--
Bob Kline
mailto:bkline@rksystems.com
http://www.rksystems.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* RE: your mail
@ 2000-12-13 13:13 Bob Kline <bkline@rksystems.com>
0 siblings, 0 replies; 25+ messages in thread
From: Bob Kline @ 2000-12-13 13:13 UTC (permalink / raw)
To: Aziz ABI <abi@mail.cbi.net.ma>; +Cc: pgsql-interfaces
On Wed, 13 Dec 2000, Aziz ABI wrote:
> Merci pour votre exemple
>
> Mais ce que je veux c'est de créer une connexion ODBC à partie d'un
> programme VB sans passer par ODBC 32 du panneau de configuration.
>
> Merci
Ah, sounds as if you want to create the DSN, not the connection.
Try this:
Declare Function SQLConfigDataSource Lib "ODBCCP32" _
(ByVal pWind As Long, _
ByVal reqType As Long, _
ByVal driver As String, _
ByVal attrs As String) As Long
Private Sub Form_Load()
Dim rc As Long
' 1=ODBC_ADD_DSN
rc = SQLConfigDataSource(0, 1, "PostgreSQL", _
"DSN=NouvelleDS" & Chr(0) & _
"Servername=foo" & Chr(0) & _
"Username=bar" & Chr(0) & _
"Port=5432" & Chr(0) & _
"Protocol=6.4" & Chr(0) & _
"ReadOnly=0" & Chr(0) & _
"RowVersioning=0" & Chr(0) & _
Chr(0))
If rc = 0 Then
MsgBox "Can't create data source"
Else
MsgBox "Data source created successfully"
End If
End Sub
--
Bob Kline
mailto:bkline@rksystems.com
http://www.rksystems.com
^ permalink raw reply [nested|flat] 25+ messages in thread
end of thread, other threads:[~2000-12-13 15:32 UTC | newest]
Thread overview: 25+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-03-04 14:45 Re: your mail Andreea Gheorghe <andi@sri.ziua.ro>
1998-11-23 14:11 Re: your mail The Hermit Hacker <scrappy@hub.org>
1998-12-10 09:51 Re: your mail Marcio Macedo <marciom@conectiva.com.br>
1999-05-13 00:00 Re: your mail Brett W. McCoy <bmccoy@lan2wan.com>
1999-08-02 16:12 ` J. Michael Roberts <mirobert@cs.indiana.edu>
1999-08-02 16:40 ` The Hermit Hacker <scrappy@hub.org>
1999-08-09 09:43 ` Alex P. Rudnev <alex@Relcom.EU.net>
1999-08-02 17:47 ` Diana Eichert <deichert@wrench.com>
1999-08-02 17:56 ` The Hermit Hacker <scrappy@hub.org>
1999-08-02 18:28 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 19:36 ` Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 19:57 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-08-02 20:45 ` Diana Eichert <deichert@wrench.com>
1999-08-02 20:52 ` The Hermit Hacker <scrappy@hub.org>
1999-08-03 00:36 ` Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-03 00:58 ` The Hermit Hacker <scrappy@hub.org>
1999-08-03 01:22 ` Louis Bertrand <louis@bertrandtech.on.ca>
1999-08-02 18:50 ` Peter Mount <peter@retep.org.uk>
1999-08-02 19:29 ` The Hermit Hacker <scrappy@hub.org>
1999-08-02 21:36 ` Brett W. McCoy <bmccoy@lan2wan.com>
1999-08-02 17:51 ` The Hermit Hacker <scrappy@hub.org>
2000-12-13 04:09 Re: your mail Bob Kline <bkline@rksystems.com>
2000-12-13 13:46 ` Adam Lang <aalang@rutgersinsurance.com>
2000-12-13 15:32 ` Bob Kline <bkline@rksystems.com>
2000-12-13 13:13 RE: your mail Bob Kline <bkline@rksystems.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox