On reflection, I think what is needed is a handbook that features cut
and paste code to do the things with Postgres that people do today
with MySQL.
Such a handbook, featured as the first section of the documentation,
would take readers through the steps necessary to set up an online
I only said this to criticize it. And I agree completely with Thomas.
John
On Aug 6, 2010, at 2:09 PM, Thomas Kellerer wrote:
John Gage wrote on 06.08.2010 04:41:
But most people, including myself, don't even want to know the
documentation exists (for anything). We just want to plunge
it quits, but it is the only place to begin.
John
On Aug 6, 2010, at 3:13 PM, Torsten Zühlsdorff wrote:
John Gage schrieb:
On reflection, I think what is needed is a handbook that features
cut and paste code to do the things with Postgres that people do
today with MySQL.
Everyone of my
I would also enquire whether one thinks that the examples should be
removed from the Postgres documentation for fear that they may be cut
and pasted into an application?
John
On Aug 6, 2010, at 3:13 PM, Torsten Zühlsdorff wrote:
John Gage schrieb:
On reflection, I think what is needed
In my fondest moments, I consider myself a nerd, and when I do I think
I am completely cool.
On Aug 6, 2010, at 9:38 PM, zach cruise wrote:
john, you're running up against a culture here, and trying to answer
the question: how to make a nerd cool? answer: it can't be done.
--
Sent via
Postgres has a very gentle learning curve. By which I mean that it
takes an extremely long time, perhaps a lifetime, to fully appreciate
it. On the other hand, it is definitely worth it. Each new discovery
is worth the effort and the wait.
But most people, including myself, don't even
Shopping carts, company blogs, etc. Popular pieces of software.
As common denominators go, that's pretty low.
Perhaps what is needed is a dumbed down version of Postgres.
My hobby horse. MySQL supports regular expressions... In a [rhymes
with rat's ass]. It supports a kind of tinker toy
The easiest way to look at this is to give the simple dictionary a
document with to_tsvector() and see if stopwords pop out.
In my experience they do. In my experience, the simple dictionary
just breaks the document down into the space etc. separated words in
the document. It doesn't
By default it has no Init options, so it doesn't check for stopwords.
In the first place, this functionality is a rip-snorting home run on
Postgres. I congratulate Oleg who I believe is one of the authors.
In the second, I too had not read (carefully) the documentation and am
very
John Gage, 25.06.2010 11:50:
I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector.
Getting really off-topic now: but MySQL does support Regex
http://dev.mysql.com/doc/refman/5.1/en/regexp.html
I have done an extensive comparison
Is there an equivalent of svn/git etc. for the data in a database's
tables?
Can I set something up so that I can see what was in the table two
days/months etc. ago?
I realize that in the case of rapidly changing hundred million row
tables this presents an impossible problem.
The best
There are features, are there not, that Postgres has that MySQL does
not have?
I refer in particular to things like tsvector.
Am I mistaken in this?
John
On Jun 25, 2010, at 3:46 AM, Rob Wultsch wrote:
unless there was a specific reason to migrate
--
Sent via pgsql-general mailing
Forgive me for being somewhat stupid, but is MyISAM a text search
engine? The Wikipedia article doesn't make it sound like one.
Could you be more specific as to how, for example, MySQL implements
regular expressions or the tsvector funcitionality?
John
On Jun 25, 2010, at 10:33 AM, Rob
In the words of Dwight Eisenhower, I couldn't fail to disagree with
you less. That said...
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please
Disabused.
On Jun 25, 2010, at 11:59 AM, Thomas Kellerer wrote:
Getting really off-topic now: but MySQL does support Regex
http://dev.mysql.com/doc/refman/5.1/en/regexp.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Have you talked to A2 about this? They are very good about installing
things.
John
On Jun 14, 2010, at 3:20 PM, Merlin Moncure wrote:
On Sun, Jun 13, 2010 at 4:37 PM, Andre Lopes
lopes80an...@gmail.com wrote:
Hi,
I have an account in A2Hosting.com, and I'm developing some
functions
I ran the IP on http://whatismyipaddress.com/blacklist-check and it is
not blacklisted.
On Jun 15, 2010, at 6:53 AM, M. Bashir Al-Noimi wrote:
Now I wondering does postgresql forbids my country or not?, is it
open source or something else?
--
Sent via pgsql-general mailing list
A one file html version would be a godsend.
On Jun 12, 2010, at 3:20 AM, Bruce Momjian wrote:
Robert Gravsjö wrote:
I am for #1, not so much for #2, mainly on the grounds of size.
But
given #1 it would be possible for packagers to make their own
choices
about whether to include
:
Peter Eisentraut pete...@gmx.net writes:
On lör, 2010-06-12 at 11:18 +0200, John Gage wrote:
A one file html version would be a godsend.
I've committed a build target for that now. Use 'make
postgres.html' in
doc/src/sgml/.
Huh, is that actually worth anything? How many browsers will open
UFB! This was definitely worth the visit from the Nebula.
Thanks very, very much.
Sensational.
Thanks again,
John Gage
On Jun 12, 2010, at 6:01 PM, Bruce Momjian wrote:
http://momjian.us/expire/
The new rule name is postgres.txt. The file size are:
7,789,730
Like all visitors from the Crab Nebula (except our leaders who are
genetically separate) I qualify as a novice when it comes to
Postgres. What is more, the people (humans, that is) who need the
documentation the most are those who, well, need the documentation the
most.
Hence, if this
of the world.
I do suggest that a plain text file of the entire documentation be
made part of the documentation armamentarium.
Respectfully,
John Gage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Thank you all for your suggestions. Thank you very much.
John
1) I suppose the next thing you'll be suggesting is that, because
Postgres is a database, the documentation should be stored as some
form of searchable table within the database itself?
runs and hides/
--Well, that is
1) On a list that howls with complaints when posts are in html, it is
surprising that there is resistance to the idea of documentation in
plain text.
2) Posters are correctly referred to the documentation as frequently
as possible. In fact, very frequently. The frequency might decrease
I was aware that there are, in fact, many applications such as census
data or cell phone calls that would easily surpass this number.
However these applications exist in very large companies/organizations
that can throw essentially unlimited resources at the problem. One
thinks of the
-05-26 09:00:00';
fetches 1,350 rows at 25ms.
I also have a summary table that is maintained by triggers, which is a
bit of denormalization, but speeds up common reporting queries.
On 22:29 Wed 26 May , John Gage wrote:
Please forgive this intrusion, and please ignore it, but how many
Please forgive this intrusion, and please ignore it, but how many
applications out there have 110,000,000 row tables? I recently
multiplied 85,000 by 1,400 and said now way Jose.
Thanks,
John Gage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
, John Gage jsmg...@numericable.fr wrote:
Is this the latest on this subject?
Debian has it it a precompiled binary package.
Blastwave is/was a solaris thing AFAICT
And I guessing you want it for apple.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
will use.
Now go to http://www.giuseppetanzilli.it/mod_auth_pgsql2/ and download
the source. I put it in /Documents/mod_auth_pgsql2/mod_auth_pgsql-2.0.3
[snip]
Thanks,
John Gage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Yes it would. In fact, I have often wondered why this doesn't exist.
How can I do it?
John
On May 12, 2010, at 12:14 PM, Peter Eisentraut wrote:
On lör, 2010-05-08 at 11:06 +0200, John Gage wrote:
Is the documentation available anywhere as a single page text file?
This would
, Geoffrey wrote:
Bruce Momjian wrote:
Bruce Momjian wrote:
John Gage wrote:
Is the documentation available anywhere as a single page text
file? This would be enormously helpful for searching using
regular expressions in Vim, for example, or excerpting pieces
for future reference.
Uh
in approximately 20% of the
messages on the list, is extraordinary. Plain text, ultimately, gives
the greatest access to it IMHO.
Thanks for the reply,
John
Bruce Momjian wrote:
John Gage wrote:
Or maybe convert the PDF file to text.
--
Sent via pgsql-general mailing list (pgsql
If I delete from table, which table contains a serial type field,
and then insert new rows into the table excluding the [serial] column
from the list of columns in the INSERT statement, the numbers in the
serial column resume where they left off prior to the delete from
table: 639, 640,
Thanks very, very much. I got as far as 8.1.4 and did not find 9.15.
May I suggest that the documentation have an index entry under
serial for 9.15, which is a major heading whereas 8.1.4 is a minor
heading and has its own index entry?
This is said from the perspective of awe for the
Is the documentation available anywhere as a single page text file?
This would be enormously helpful for searching using regular
expressions in Vim, for example, or excerpting pieces for future
reference.
John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
I issue the following command to the shell:
echo '\o file.txt \\ select * from table_name limit 10 \o ' | psql --
host 'localhost' --port 5432 --username 'johngage' 'database_name'
I expect the results to be redirected to file.txt because that is the
meta-command immediately preceeding the
Thanks very much for elucidating this. \g is going to help me in this
situation more than the ;
John
On May 2, 2010, at 4:25 PM, Tom Lane wrote:
David W Noon dwn...@ntlworld.com writes:
On Sun, 2 May 2010 14:13:52 +0200, John Gage wrote abour [GENERAL]
I issue the following command
You can avoid stemming by using 'simple' instead of 'english' as the
language of the words in to_tsvector (which is a little more awkward
than the cast).
There are no stop words for the simple dictionary. It will just
convert to lower case, and index every unique word.
SELECT
Do you know of any guides to ritual suicide?
On Apr 27, 2010, at 3:02 AM, Scott Mead wrote:
Your path has 'PostgresPlus'
Locate shows 'PostgreSQL'
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
not work on the system.
John
On Apr 26, 2010, at 9:36 AM, Jorge Arevalo wrote:
On Sun, Apr 25, 2010 at 11:08 AM, John Gage jsmg...@numericable.fr
wrote:
If I open a bash terminal and type createlang -l, I get:
JohnGage:~ johngage$ createlang -l
-bash: createlang: command not found
JohnGage
). The reality is postgres and me.
John
P.S. Which is not to say that there are not false syntheses in life.
Guns and butter leaps to mind.
On Apr 26, 2010, at 10:58 AM, Dave Page wrote:
On Mon, Apr 26, 2010 at 8:55 AM, John Gage jsmg...@numericable.fr
wrote:
A very key difficulty
AM, John Gage jsmg...@numericable.fr
wrote:
If I open a bash terminal and type createlang -l, I get:
JohnGage:~ johngage$ createlang -l
-bash: createlang: command not found
JohnGage:~ johngage$ psql
-bash: psql: command not found
as one can see, the same thing happens with psql.
The way
After carefully examining what was out there, decided again to go with
hub.org.
Thanks again
John
On Apr 24, 2010, at 5:55 PM, Steve Atkins wrote:
If an ISP is offering virtual private servers (where you get full
access to your own virtual machine) then installing postgresql and
perl
If I open a bash terminal and type createlang -l, I get:
JohnGage:~ johngage$ createlang -l
-bash: createlang: command not found
JohnGage:~ johngage$ psql
-bash: psql: command not found
as one can see, the same thing happens with psql.
The way I have been using psql is by pulling down the
asked for a password that is not any password that exists. For
example, it is not the password that postgres uses to get to the
databases.
I am now going to see if I can find the mystery password for postgres.
On Apr 25, 2010, at 11:08 AM, John Gage wrote:
If I open a bash terminal
Question withdrawn.
Answered via documentation.
On Apr 25, 2010, at 11:08 AM, John Gage wrote:
If I open a bash terminal and type createlang -l, I get:
JohnGage:~ johngage$ createlang -l
-bash: createlang: command not found
JohnGage:~ johngage$ psql
-bash: psql: command not found
as one
.
John Gage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thank you for your reply and the reference. Excellent.
On Apr 24, 2010, at 5:55 PM, Steve Atkins wrote:
On Apr 24, 2010, at 8:40 AM, John Gage wrote:
I know this is perhaps an inappropriate question (and to some
extent I am repeating myself), but I now need to get my website up
is going on?
This is a file that runs perfectly well in pgAdmin and that I edit in
Vim.
Sorry to be so ignorant and thanks,
John Gage
On Apr 22, 2010, at 3:34 AM, Scott Mead wrote:
Do you have some funky hidden characters at the beginning of the file?
run:
od -a CopySql.sql
--
Sent
Oh, I should add. Everything, the database, vim, is UTF-8.
On Apr 22, 2010, at 3:34 AM, Scott Mead wrote:
run:
od -a CopySql.sql
Look at the beginning, that'll show you character by character
what's in there (should reveal anything hidden).
--
Sent via pgsql-general mailing
automatically put it at the beginning of the file, because I saved it
as UTF-8.
At least it isn't some evil virus. Have to do Mr. WorkAround now.
Thank you very much for your help Scott and Richard,
John Gage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Well, well, well. Guess who the culprit is...
I edited the file both in Vim and in pgAdmin3 (1.10.2, Mar 9 2010, rev
8217), and the BOM shows up after saving the file with pgAdmin3.
I don't know if pgAdmin3 wants to keep this feature...
Thank everyone again for the excellent help.
John
This may be germane:
Filename: trunk/pgadmin3/src/ui/pgadmin3.lng
Revision 2954 - (view) (download) - [select for diffs]
Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by andreas
File length: 1301 byte(s)
Diff to previous 2840
adding UTF-8 BOM
I do not think that it is a feature.
Page wrote:
On Thu, Apr 22, 2010 at 10:41 AM, John Gage jsmg...@numericable.fr
wrote:
This may be germane:
Filename: trunk/pgadmin3/src/ui/pgadmin3.lng
Revision 2954 - (view) (download) - [select for diffs]
Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by
andreas
File length
Additionally, if the Vim option bomb is set to nobomb it will
strip the BOM. This solves my problem by permitting editing files
in both Vim and pgAdmin3 Query tool and then being able to run the
files in psql.
:set nobomb [in Vim]
On Apr 22, 2010, at 12:12 PM, Magnus Hagander wrote:
mesh_descriptors;
when run from a file using \i
What am I doing wrong?
Thanks,
John Gage
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The 8.4.2 documentation says:
The default user name is your Unix user name, as is the default
database name.
Not so much. My one-click installer creates a user 'postgres' who
becomes the default user name...as well as the owner of the data file.
Is postgres arguing with itself here? Or
AM, John R Pierce wrote:
John Gage wrote:
The 8.4.2 documentation says:
The default user name is your Unix user name, as is the default
database name.
when you as a user connect to the database server the commands like
psql, pg_dump, etc all use your unix username as the default
to Postgres.
John
On Apr 2, 2010, at 8:29 AM, John R Pierce wrote:
John Gage wrote:
The 8.4.2 documentation says:
The default user name is your Unix user name, as is the default
database name.
when you as a user connect to the database server the commands like
psql, pg_dump, etc all use your
If I do cat /etc/passwd, I get the following, which does not include
'postgres'. Yet id knows about 'postgres'. And 'postgres' owns the
data.
nobody:*:-2:-2:Unprivileged User:/var/empty:/usr/bin/false
root:*:0:0:System Administrator:/var/root:/bin/sh
daemon:*:1:1:System
of the data folder.
Again, anytime a user is free to use any account as the service
account and not use 'postgres'.
On 4/2/10 12:37 PM, John Gage wrote:
Then I don't understand why the installer doesn't do the same thing.
Or, in the alternative, why it doesn't ask you what you want
On Apr 2, 2010, at 10:28 AM, Craig Ringer wrote:
b) Run as your user. What if you remove the user later - crunch,
your database just broke. If Pg was attacked successfully, the
attacker wouldn't get root ... but they would get the ability to
access and delete all your files.
Arguably
I'm not quite as brain-dead as this statement makes me sound. I use
posgres' back-up system to back up the databases. I don't copy the
files.
On Apr 2, 2010, at 12:15 PM, John Gage wrote:
And the only reason I know that 'postgres' owns my data (or did) is
that I wanted to back up
:
--install_plpgsql install_plpgsql Install pl/pgsql in template1
database?
Default: 1
On 4/2/10 1:14 PM, John Gage wrote:
There is a CLI option where? Forgive my ignorance, please. Does
it appear in the one-click installer?
John
On Apr 2, 2010, at 9:19 AM
Thanks very, very much for this. I am truly grateful.
On Apr 2, 2010, at 2:44 PM, Sachin Srivastava wrote:
Yes you need to re-install.. (uninstall and install again).
You can point the new installation to the old data directory if you
want..
On 4/2/10 4:25 PM, John Gage wrote:
I am
This is of interest to me, because something similar happens on the
Mac (with the one-click installer).
The data directory is placed in a file that user 'postgres' has
permission on. Of course, this is a new user, created by postgres,
but what it ends up meaning is that I run all my
I will bet a bucket of day-old squid that this is a user rights problem.
On Apr 2, 2010, at 6:43 AM, Craig Ringer wrote:
I log in as an Administrator-enabled user, but have UAC turned on.
This means that in fact I'm using non-admin rights unless/until I
accept a UAC prompt.
--
Sent via
I just wondered if I could access the same 8.4.2 server from the
Windows partition (XP via Bootcamp) as I do from the Mac partition
on my Mac?
Thanks,
John
P.S. In other words, do I have to duplicate everything on the two
machines?
--
Sent via pgsql-general mailing list
a method of
dual booting Windows and Mac OS. Meaning, that either one or the
other
would be running at any given point of time.
The impression I was under was that both OSes were active and you just
flipped between the two with a sort of super alt-tab command.
In the case of Bootcamp, only
virus susceptibilities of
the two systems, it is probably better to run a separate server and
data file(s) on each machine.
John
On Mar 30, 2010, at 11:46 PM, Scott Marlowe wrote:
On Tue, Mar 30, 2010 at 1:57 PM, John Gage jsmg...@numericable.fr
wrote:
I just wondered if I could access
This response came in as I was mea culpa-ing.
Everything here is correct to the best of my knowledge.
And I am very glad to be warned not to go between the two OS's.
Thank you,
John
Personally, what I'd do would be create a virtual machine image with
something like VMWare - something that
I ran a query out of pgAdmin, and (as I expected) it took a long
time. In fact, I did not let it finish. I stopped it after a little
over an hour.
I'm using 8.4.2 on a Mac with a 2.4GHz processor and 2GB of RAM.
My question is: is there a way to tell how close the query is to being
I will report back on this and attempt to give the particulars. It
will take 24 hours due to other time commitments.
Thank you very much for explaining :) this to me.
When I used only the first 10,000 rows of the 100+ thousand rows in
the original table (of two tables) I was working with,
As a kind of [very?] dumb question, is this where SQLite has been
used? I am just curious.
On Mar 26, 2010, at 3:14 PM, Ozz Nixon wrote:
On 3/26/10 10:06 AM, Alan McKay wrote:
On Thu, Mar 25, 2010 at 4:15 PM, Scott Marlowescott.marl...@gmail.com
wrote:
These questions always get the
Thanks very, very much for this reply. It is extremely useful.
So far, I have not run into anything remotely resembling a performance
barrier in Postgres. I'm still looking :-)
On Mar 26, 2010, at 4:43 PM, Ozz Nixon wrote:
On 3/26/10 11:12 AM, John Gage wrote:
As a kind of [very
Does anybody want to share their opinion as to the best beginner ISP
that supports Postgres?
I want to use PHP against a Postgres database. Hostpoint in
Switzerland gives you 10gig's for 9.9CHF (less than 7euros) per month
as a starter package...with MySQL, which I definitely do not want.
I had forgotten about hub.org. That's where I'm headed. Sorry for
the interruption.
John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I would just like to thank Albe and Jasen for their responses. What an
extraordinary environment Postgres is! Human and computing.
On Tue, Mar 9, 2010 at 1:32 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
John Gage wrote:
I would like to use the following query:
SELECT english || '\n
I would like to use the following query:
SELECT english || '\n' || english || '\x2028' || french AS output FROM
vocab_words_translated;
where \x2028 is the hexadecimal code for a soft carriage return.
However, this does not work.
Can anyone help with this problem?
Thanking you,
John
Is there an SQL code generator for ArgoUML for Postgres? I have not been
able to find it, which does not mean it is not there.
Thanking you,
John
This is a series of commands I issued to psql:
1) EFN=# \o aatest01.txt \i ./TestQuery01.txt
2) EFN=# \i ./TestQuery01.txt
3) EFN=# \p
4) select * from vocabulary_sources
;
5) EFN=# \g
6) EFN=# \p
7) select * from vocabulary_sources
;
8) EFN=# \echo yes man
9) yes man
I have numbered the lines
I realize that this is a feature and not a bug, but what I ran into
confronting the same issue was the fact that the servers listen on
different ports and when I uninstalled the older version, the newer
version was listening on a non-standard port. This caused some
confusion for awhile.
I am under the impression that MySQL does not have anything resembling
Postgres' support for regular expressions. Though some might think
that regular expressions are a sort of poor man's SQL, in any
application which manages large amounts of text they are crucial.
Postgres definitely
This is a two-part question:
1) I have a source_text that I want to divide into smaller subunits
that will be contained in rows in a column in a new table. Is it
absolutely certain that the initial order of the rows in the resultant
table after this operation:
CREATE TABLE new_table AS
are in the 2AM time
zone. Thank you again,
John
On Feb 24, 2010, at 8:06 AM, Tom Lane wrote:
John Gage jsmg...@numericable.fr writes:
This is a two-part question:
1) I have a source_text that I want to divide into smaller subunits
that will be contained in rows in a column in a new table
I have had the same/similar problem on a Mac. Postgres creates a user
postgres and the only way that user can see files is for them to
exist outside of any other particular user's home directory. I placed
the files in the root directory!? I would like, I think, to give
postgres
86 matches
Mail list logo
