433 dbname=MYDB user=postgres
password=mypass');
"mypass" being whatever my password is; is still set in plain text?
Why don't I have to send the md5 version of the password to connect?
Thanks,
Vince.
---(end of broadcast)---
T
e printing myself? I want to
be able to know why it failed... ie password in this case.
Thanks,
Vince.
---(end of broadcast)---
TIP 6: explain analyze is your friend
nected
or the postgres server shuts down (neither of which is desirable.)
Vince
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
filehandle.
Thanks for the pointers.
Vince
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: 26 October 2007 13:22
To: Vince Negri
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] TRUNCATE - timing of the return of disk space -
caused by long-lived client
7.4631299) - radians(-97.4631299)) + sin(radians(37.7438640))
* sin(radians(37.743864000)));
acos(1) would give me 0.
Thoughts or workaround suggestions?
Thanks.
--Vince--
the \i, try this:
pg_dump -t table olddb > old.info
psql newdb < old.info
Vince.
--
==
Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Po
r a way to correlate zip, city,
> and/or geographic locations.
You mean this one:
http://ftp.census.gov/geo/www/gazetteer/places.html
It sure helped me too!
Note the web page says the data is from 1990, but there were continual
updates over the last decade. I hope to see 2
than the exit is status 25.
>
> Signal 25?? What is that on your machine? (see /usr/include/signal.h)
> On mine it's SIGTSTP, which doesn't make any sense --- for one thing,
> that doesn't cause a process exit, only suspension ...
That's o
On Tue, 24 Oct 2000, Robert Kernell wrote:
> Hi.
>
> 1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s
> book)?
http://www.postgresql.org/users-lounge
>
> 2.) Can someone point me to the Postgres FAQ?
http://www.postgr
web interface.
Vince.
>
> Rick
> Vince Vielhaber <[EMAIL PROTECTED]> wrote:
> > On Tue, 31 Oct 2000, Adam Lang wrote:
>
> > Scrappy from postgresql wants me to reply to subscription messages for each
> > of the lists I am subscribed to... do I need to, or shou
to rely on 6.5 manuals.
> >
> > I really don't feel like wasting paper and printing 7.0 manual and
> > dumping 6.5.
> >
> > Who put 6.5 manuals on top of 7.0 on that web page? Not everyone has
> > 72 inch monitor you know.
> >
>
> I thought I fi
On Tue, 12 Dec 2000, Bruce Momjian wrote:
> > > > Who put 6.5 manuals on top of 7.0 on that web page? Not everyone has
> > > > 72 inch monitor you know.
> > > >
> > >
> > > I thought I fixed that, but it seems to have moved again. Vince, is
DOCS list and
ask. Getting people to help with documentation for ANY project is like
pulling teeth. Finding people to criticize existing documentation is
quite easy.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL
documentation is more than adequate, but could always be improved. Hopefully
> I will learn enough at some point to be able to say that I'm ready to
> contribute... until then I'll be here feeding off the scraps of knowledge
> that are dribble
adequate to you may not be
to the person that wrote it, but they won't know that something's wrong if
you don't tell them *specifically* what it is. I guess in that respect
'put up or shut up' is correct, but not completely.
Vince.
--
===
rsion. If you look in the user's area you will find
the docs for the current version. If you look at www.postgresql.org's
(and mirrors) home page you will see that the third item down explains
how and where to find the appropriate documentation and even provides
links
gresql.org/mhonarc/pgsql-general/search.mpl and
it should work fine.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4
said he's being anal. Since I came up with the user's lounge
I'm the one that knows it's not a proper noun and therefore *should* be
lower case. I do however make it upper case at times for no apparent
reason -- my bad :)
Vince.
--
==
0116316-8891907
>
> I guess everyone isn't going to like my book. :-)
Did you read any of his other reviews? He doesn't strike me as a happy
person. Someone musta moved his cheese.
Vince.
--
==
Vince Vielh
t; version 7.1 (The Linux World Editors winner for Best Database in 2000).
WTFI "PostgreSQL Great Bridge version 7.1" ? Is GB putting out
their own releases now? Ned? Bruce?
Vince.
--
==
Vince Vielhaber -
On Mon, 26 Mar 2001, Christian Marschalek wrote:
> Hm... I can only find how to compile the libraries under visual c++
http://www.postgresql.org/related.html
Vince.
>
> regards
>
> > -Original Message-
> > From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
&g
, I put a link up for this. http://www.postgresql.org/ftpsite Looks
like I forgot to put up a link to it on a webpage.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
56K Nat
Great! You guys do it and I'll put it on the website.
Vince.
On Sun, 8 Apr 2001, Bruce Momjian wrote:
> Sounds great.
>
> I have collected some comments from people about PostgreSQL vs. other
> databases at:
>
> ftp://candle.pha.pa.us/pub/postgresql/comparison
It's back.
Vince.
On Sun, 8 Apr 2001, Justin Clift wrote:
> Hi all,
>
> Is it just my route to the main webserver, or is the website at
> www.postgresql.org down?
>
> Can access the mirrors, but can't touch anything at the main PostgreSQL
> website.
>
&
omeone wants to run the A4 docs through a PDF converter, send 'em to
> me and I'll post them too.
Tom, ps2pdf is on hub.
Vince.
--
======
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.
you looked at SQL-Ledger? THough I disagree with some of the
> table designs it is a pretty good accounting package. (Given I'm not an
> accountant.) Possible down side is it is web-server/browser based. Has
> support desi
good tools available.
>
> My problem is with mailing labels. Standard Avery sort. How do I do
> about formatting multiple pages for mass mailings?
>
> Any pointers?
I'd write a simple C app to read the data
On Sun, 13 May 2001, Louis-David Mitterrand wrote:
> * On Thu, May 03, 2001 at 07:45:23PM -0400, Vince Vielhaber wrote:
> > On Thu, 3 May 2001, Ludwig Meyerhoff wrote:
> >
> > > Hallo!
> > >
> > > Maybe this is a bit off-topic, as this problem is more a
At least that way you'll know what you have and if you
still have problems you'll be starting from a known good starting point.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.ne
> discovered many of the ftp mirrors aren't synched yet.
> Also many of the mirrors are refusing logins. I did find a responsive
> mirror in thailand, but the rpms all carry the "PGDG" tag.
>
> Can anyone shed som
On Thu, 24 May 2001, Abhimanyu_Bhola wrote:
> check these links out for the odbc driver,
>
> ftp://ftp.PostgreSQL.org/pub/odbc/
>
> http://www.openlinksw.com.
Of course there's always http://odbc.p
On Mon, 7 May 2001, Bruce Momjian wrote:
> I like the new mirrors web page at http://www.postgresql.org. Now I
> just need to learn about some of those flags.
The alt tags will tell you what country. Looking at the status bar
will tell you what host (if your browser supports that).
ards
> >
> >
> > ---(end of broadcast)---
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to [EMAIL PROTECTED] so that your
> > message can get through to the mailing list
On Wed, 20 Jun 2001, Norman J. Clarke wrote:
> You do an excellent job Vince. By and large the website is awesome, and I
> love some of the newest additions such as the interactive docs. But you
> should listen to his gripes and respond in a more polite way. If you think
> he is
On Wed, 20 Jun 2001, Adam Haberlach wrote:
> On Wed, Jun 20, 2001 at 04:38:58PM -0400, Vince Vielhaber wrote:
> > On Wed, 20 Jun 2001, Norman J. Clarke wrote:
> >
> > > You do an excellent job Vince. By and large the website is awesome, and I
> > > love some of
Agreed. I always thought of "Lounge Singer".
You mean you didn't hang around long enough to hear that guy singing
the mssql blues? He's pretty good!
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMA
nger-pointing.
>
> The $400/year has been worth it for me so I suspect there are PostgreSQL
> users that need such support too.
I didn't mean someone to blame, I meant someone to call.
Vince.
--
==
Vince Vielhaber -
one that may work on the mac. You
can find more info on either the PostgreSQL ODBC website:
http://odbc.postgresql.org
or the PostgreSQL odbc mailing list. You may even find someone who
knows what they're
with:
');\n
and when run it took a directory of about 480 files and neatly filed
them into a table.
Vince.
--
======
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
56K Nationwide
On Mon, 16 Jul 2001, stefan wrote:
> Hi:
>
> Are there JDBC drivers for PostGresSQL?
http://jdbc.postgresql.org
Vince.
--
======
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
BTW.) But no one is
> maintaining the bug database in the sense of marking stuff done.
>
> I hadn't realized that there was a publicly-visible database attached
> to the webform, actually. Perhaps we should not make the database
> visible, if we're not going to update it.
database needing transactions, ACID features, etc. But, I'm
> definitely not for a document which will incite PostgreSQL-vs-MySQL
> warfare and not try and get people to choost the appropriate product(s).
Don't worry, it
ay of site maintenance recently, so
> that page hasn't been updated in ages.
If you want we can merge jobs into the main site for now.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.
On Sun, 9 Sep 2001, Justin Clift wrote:
> Vince Vielhaber wrote:
> >
> > On Sat, 8 Sep 2001, Justin Clift wrote:
> >
> > > Hi Guys,
> > >
> > > It is definitely something interesting, and there are a fair few
> > > PostgreSQL jobs out the
On Mon, 10 Sep 2001, Justin Clift wrote:
> Sorry Vince,
>
> My mistake. I must have worded that badly.
>
> What I mean is that some Agencies find it difficult to believe that we
> would actually assist them in looking for candidates, especially
> directly to a targe
The website is currently undergoing a rewrite.
Vince.
On Wed, 12 Sep 2001, Ryan Mahoney wrote:
> Since Great Bridge is no longer, there is a need for a strong online
> presence for companies and individuals to learn about postgresql. This gap
> is a detriment to the project from a
m is PostgreSQL, Inc, and RedHat.
The projects website is, or is about to be available at
http://gborg.postgresql.org
So to answer your question about what the future is for PostgreSQL? Just
as bright as ever.
Vince.
>
> Tommy
>
> "reywob" <[EMAIL PR
a use the proper tool for the job or you're
only screwing yourself. The way you evaluate the tool is noone's
responsibility but your own. Make the proper decision and you keep your
customers; blow it and someone else gets your customers. Personally I
don't like those a
t; Linux penguin? :)
I was thinking maybe the BSD daemon grilling the Linux penguin. :)
Vince.
--
==
Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] flame-mail: /dev/null
# includeTEA
redirected to general
-
We are trying to use psql on RedHat 5.2 to access a database on another
Redhat 5.2 box runing Postgres (started as user postgres: postmaster
-D /var/lib/pgsql -B 256 -i -d 3 &.)
The backend start okay and we can access the data on the local
are any problems with them...
>
> Vince, can you please make links for the patches as well as the release
> itself?
Done.
Vince.
--
==
Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] flame-mail: /dev/null
text" or are there other options ?
Thanks,
Vince
Hello, I am in need of help with performance of case insensitive queries.
I have searched the general and hackers archives for references to this
problem and
have found the information on how to build a lower case index.
I have included output from 3 query plans that detail my performance
proble
give Customer 002 access to BillsCustomerID002
etc.
Would this solve your problem ?
Vince
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Peter
> Eisentraut
> Sent: Tuesday, December 14, 1999 5:02 PM
> To: [EMAIL PROTECTED]
her books or
>reference . give me the correct syntax :
>
> my table name is : cricktimes2
> and the field name to be sorted is : email
I'm CCing this one to the general mailing list.
Vince.
--
==
Vince Viel
xing over 90k URLs) and the
> server has been running flawlessly for the past ~14days now, and what is
> only because that was the last time we rebooted it ...
Ditto, except the uptime here (PostgreSQL running all the time taking
care of user's mailboxes, web server, etc.): 265 days
performance, it triggered a problem in PostgreSQL
> > that is unlikely in real world scenarios (creating and
> > dropping 20,000 tables first, blowing up a system catalog).
> > Then running the test queries with the blown up catalog.
&g
.2 which is available at:
http://www.postgresql.org
then follow the installation instructions carefully and you'll be up and
running in a very short time. On a decently fast machine it shouldn't
take but 30-60 minutes (longer if you're on a slow internet connection).
Vince.
--
site nor was
it said by anyone associated with Postgres. I'm thinking it was in either
an online magazine or something like that. It was many months ago, tho.
Almost a year, perhaps longer.
Vince.
--
==
Vince Vielha
//www.postgresql.org/docs/postgres/cvs28436.htm
> still has the old location :-( ... that needs to be updated.
> Hey Vince, isn't that stuff supposed to be rebuilt from sources
> nightly?
Tom Lockhart said he had to disable the auto build because i
;links" section or something.
Already did it. Look at Info Central | Interfaces
Vince.
> I went looking for the jdbc driver on the postgresql.org site today and
> spent several frustrating minutes looking for it but could not find it. All
> I wanted was the latest jar file
eryone... now I have one more thing...
>
> where are the docs that go along with the current version? I have browsed and
>rebrowsed the site and everything seems to stick right with the forthcoming version...
It's not yet ready for prime time, but you can find the docs here:
http://ww
arlier when it didn't work and now it's:
users-lounge/docs/v7.0/... I just can't wait to see what it'll become
in August! so the corrected link is:
http://www.postgresql.org/users-lounge/docs/v7.0/postgres/postgres.htm
Vince.
--
kslashes and stuff like that. I rolled my own for apps that I worked
on that needed one, lately I've been using PHP which has such a function
and a reversing function.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [E
On Tue, 18 Jul 2000, Thomas Lockhart wrote:
> > > Yup ;-). It's nice having the devel docs up there, but seems like they
> > > ought to be labeled or segregated or something.
>
> Vince, can we re-target the most-visible docs references to point at the
> 7.0 re
yet to make sure.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directoryhttp://
Can anyone speak up who had an opinion (or who has dirty hands ;) on
> this so Vince can get back to being right-side-up and oriented?
Not necessary unless it happens again. Then I'm gonna be looking for a
big stick! :)
Vince.
--
=
ersion of Postgre.
It'll help if you provide more info, like what version of PostgreSQL,
what OS and version, example queries, etc..
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4
it to reread all the directories shared libs reside in.
Vince.
--
======
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Onl
onding field type in PostgreSQL for a memo field in
> > )SQL Server/Access (varchar())?
>
> > 'text' type perhaps ?
>
> Uh ... what's wrong with varchar(n) ?
How big can our n be for varchar? B
70 matches
Mail list logo