Are there any books out there that are fairly current, but go into the
more advanced aspects of Postgresql, such as internals and advanced
programming? I'd rather avoid the whole intro to SQL with a few extra
chapters on Postgresql if I could help it.
Thanks,
John
Robert Wille writes:
I have tried to do the same on my production server, and when I do the
initdb, it says that LC_COLLATE is C, but it does not sort the same as
the test server. Namely, on the test server 'z' '~' and on the
production server 'z' '~'.
You probably still have
John Wells [EMAIL PROTECTED] writes:
Are there any books out there that are fairly current, but go into the
more advanced aspects of Postgresql, such as internals and advanced
programming? I'd rather avoid the whole intro to SQL with a few extra
chapters on Postgresql if I could help it.
I'm
Tom,
I'd love to, but I can't read at a terminal for longer than an hour or so.
I really prefer the dead tree version.
Does anyone provide printed copies of the documentation for a fee? I know
some companies do this for other apps...
Thanks,
John
Tom Lane said:
John Wells [EMAIL PROTECTED]
John Wells wrote:
Tom,
I'd love to, but I can't read at a terminal for longer than an hour or so.
I really prefer the dead tree version.
You can get the tarball of HTMLs out of a build and view it in lynx or something
like that if you prefer. They are very simple HTMLs.
I agree that when eyes
On Fri, Oct 03, 2003 at 10:08:43 -0400,
John Wells [EMAIL PROTECTED] wrote:
Tom,
I'd love to, but I can't read at a terminal for longer than an hour or so.
I really prefer the dead tree version.
Does anyone provide printed copies of the documentation for a fee? I know
some companies
SD == Shridhar Daithankar [EMAIL PROTECTED] writes:
SD You can try creating index/triggers first and load the data. At the
SD end it will take a while before you get a usable database with either
SD approach but see what works faster for you.
The triggers and FK's don't do much at the time they
Vivek Khera wrote:
SD footprint. I dropped the table and recreated it. Also created index
SD before loading data. The loading was slow with this approach but it
SD finished in 3 hours. And I had an updated index as well. Just had to
SD run vacuum over it.
I cannot believe that this was faster than
Shridhar Daithankar [EMAIL PROTECTED] writes:
Peter Childs wrote:
Postgresql do have update logs in form of WAL.
No it does not. WAL is Down-Date Logs not update logs. WAL will
enable you to rewind to the beginning of all currently running
transactions after a crash. Ie roll-back not
Marcelo Soares [EMAIL PROTECTED] writes:
To me, this looks not like a bug, because the tuple is not at A phisically.
A lot of people call it a bug because it makes it impossible for them to
use inheritance the way they want to.
Like I said, this is not a problem for me, but I want to know if
Hi,
this might be actually offtopic, but its always time to fight some FUD :-)
Microsoft will be doing away with the OLEDB to ODBC bridge in the near
future.
Funny enough if I use __Microsoft__ SQL Query Analyzer which directly
connects to SQL Server and somehow shut the SQL Server down
Anyone on the list have experience with this? I (potentially) could be
hired today to help in an effort to convert from Progress to Postgresql,
and I'm looking for any resources/insights/urls/books/etc that might aid
towards this end.
Anything you can forward will be greatly appreciated (and
After applying the patches supplied so far and also trying the lastest
stable tar.gz for tsearch2 ( downloaded 24th of september)
I am still experiencing the same issue as previously described:
I try to do a
SELECT to_tsvector( 'default', 'some text' )
The backend crashes.
SELECT
--- Fabrizio Mazzoni [EMAIL PROTECTED] wrote:
Hello .. i did the migration and my advice is that
you forget about the automatic translation tools...
I have used the migration wizard that comes as a
plugin for PgAdminII, and was very happy with the
result. Yes, you can do everything by hand,
Yes, the mod_auth_pgsql series for Apache 2 is broken as you
describe. It does not release the connection, but the change
is intentional. Looking at the Changelog I see:
- now we reuse database connection, 2x speedup !!
Perhaps this is a good thing with different MPMs, but the
Sorry about the repost here guys... I sent this from my other email
(non-subscribed), but sent an email to the list admin before reposting to
get him/her to cancel it. Apparently some miscommunication there. :)
---(end of broadcast)---
TIP 7:
[I also posted this to comp.databases but since I'm actually using
PostgreSQL I would be content with a pgsql specific answer, so I
also posted this to comp.databases.postgresql.novice because I'm
a novice and it looked like a good group, but then I realized that
this might not be a novice
Hello
I have a problem, I want to migrate the data of a postgres' database to a
mysql's database, this because i need to move to a windows.
I tried making a postgres' backup using pg_dump, but this file doesn't have
the insert in Transac-sql.
Any help is welcome
txs in advance!!
On Thursday 02 Oct 2003 09:13 in
[EMAIL PROTECTED], Chris
([EMAIL PROTECTED]) wrote:
Suppose you want to use an RDBMS to store messages for a threaded
message forum like usenet and then display the messages. A toy table
definition (that I've tried to make standards compliant) might look
like:
I am running a SELECT to get all tuples within a given date range. This
query is much slwoer than i expected - am i missing something?
I have a table 'meta' with a column 'in_date' of type timestamp(0), i
am trying to select all
records within a given date range. I have an index on 'in_date'
I need to find out which tables, and columns in that table, reference a
given table.
I would like to use the information_schema views, but am stuck at 7.3.X
right now.
Here is what I came up with so far
SELECT pcl.relname AS thistable,
pcl1.relname AS referencesthistable
FROM
On Fri, 3 Oct 2003, Bruno BAGUETTE wrote:
I'm getting many errors when I do the make on the patched files. Is
there other people that have compiled successfully the patched
mod_auth_pgsql 2.0.1 ?
I've attached to this email the error log. Do you have the same errors
than me or do I have
Hmm,
it's weird. Could you provide us with backtrace ?
Oleg
On Tue, 30 Sep 2003 [EMAIL PROTECTED] wrote:
After applying the patches supplied so far and also trying the lastest
stable tar.gz for tsearch2 ( downloaded 24th of september)
I am still experiencing the same issue as
Oops! [EMAIL PROTECTED] (Dennis Gearon) was seen spray-painting on a wall:
Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
It's the components that matter moreso than the sticker on the front
of the box.
Presently, I have a Dell 6600
[EMAIL PROTECTED] (John Wells) writes:
To that end, I've also started studying up on Postgresql. It seems to
have all the necessary features for a transaction heavy DB. The recent
release is 7.3. Of course, the proof will be in the pudding. We
average 2.5 million transactions per day or
Hi, I'm in the process of converting an Oracle database into
postgresql. One thing I've noticed is that postgresql functions keep
the entire function body in a string, e.g.:
CREATE OR REPLACE FUNCTION f_do_something(varchar, numeric, varchar)
RETURNS varchar AS
'
...
'
LANGUAGE 'plpgsql'
I also have troubles with pg_dump. I have a database called 'shipping' and
it has many tables(I populated them via a script). To dump the database I
did these steps:
su greg and then pg_dump /tmp/greg.dmp. A file greg.dmp gets created but
it has nothing in it(0 bytes). Could you advise what was
Bruno Wolff III [EMAIL PROTECTED] writes:
On Fri, Oct 03, 2003 at 10:08:43 -0400,
John Wells [EMAIL PROTECTED] wrote:
Does anyone provide printed copies of the documentation for a fee? I know
some companies do this for other apps...
You should be able to print the documentation on a
Robert Wille [EMAIL PROTECTED] writes:
You probably still have LC_ALL set to something else. LC_ALL overrides
LC_COLLATE and friends, which in turn override LANG.
Nope. Any other ideas?
Please use pg_controldata to verify the LC_ settings on both databases.
I suspect they are not really both
Christopher Browne wrote:
Oops! [EMAIL PROTECTED] (Dennis Gearon) was seen spray-painting on a wall:
Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
It's the components that matter moreso than the sticker on the front
of the box.
Presently, I
Hi all.
I am using Visual FoxPro via ODBC to update records on a 7.3.4
PostgreSql server and it appears that it always uses delete/insert
instead of updating the current record. Can this be changed to update
the existing record instead?
--
Eugene Vital
Any technology indistinguishable from
On Tuesday 30 September 2003 09:15 pm, Greg wrote:
I also have troubles with pg_dump. I have a database called 'shipping' and
it has many tables(I populated them via a script). To dump the database I
did these steps:
su greg and then pg_dump /tmp/greg.dmp. A file greg.dmp gets created but
On Fri, Oct 03, 2003 at 11:27:11 -0400,
Gene Vital [EMAIL PROTECTED] wrote:
Hi all.
I am using Visual FoxPro via ODBC to update records on a 7.3.4
PostgreSql server and it appears that it always uses delete/insert
instead of updating the current record. Can this be changed to update
On Fri, 3 Oct 2003, Kathy Zhu wrote:
Hi,
I notices a weird thing here.
version 7.2.1
on Solaris
table test, has a field state.
There are 4 state values, 1, 2, 3, 4.
select count(*) from test group by state;
took 11500 msec
but
select count(*) from test where state = 1;
select
Tom Lane writes:
Building the HTML version is pretty simple, but it does look like
making a nice printed version is tedious ... which, no doubt, is
why no one does it for beta releases.
For printable versions, the size and complexity of the PostgreSQL
documentation breaks every tool known to
On Fri, 3 Oct 2003, Vivek Khera wrote:
sm == scott marlowe scott.marlowe writes:
sm also, turning off fsync during the load helps a lot. Be sure to turn it
sm back on when you're done of course.
Only if you don't have a battery-backed cache on your RAID. If you
do, it won't likely
Native Win32 is slated for 7.5.
Sincerely,
Joshua Drake
Relaxin wrote:
Does this have native Win32 support?
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - [EMAIL PROTECTED] -
On Fri, 3 Oct 2003, Alvaro Herrera wrote:
On Fri, Oct 03, 2003 at 01:06:26PM -0600, scott.marlowe wrote:
also, turning off fsync during the load helps a lot. Be sure to turn it
back on when you're done of course.
I'm not sure I understand why this is so. If I turn fsync off, it means
sm == scott marlowe scott.marlowe writes:
sm also, turning off fsync during the load helps a lot. Be sure to turn it
sm back on when you're done of course.
Only if you don't have a battery-backed cache on your RAID. If you
do, it won't likely make a big difference. For me it was about 2
On Fri, 3 Oct 2003, Relaxin wrote:
Does this have native Win32 support?
As has been mentioned *several* times already, v7.4 will *not* have Win32
support in it.
Marc G. Fournier [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Well folks, we are now coming into the home
scott.marlowe [EMAIL PROTECTED] writes:
Yes, you are. Basically, with fsync on, things have to happen in order.
I.e.
write to WAL what you're gonna do. WAIT for confirmation on write
write the tuples out. wait for confirmation
checkpoint the WAL. wait for confirmation
Not really. With
Hi,
I notices a weird thing here.
version 7.2.1
on Solaris
table test, has a field state.
There are 4 state values, 1, 2, 3, 4.
select count(*) from test group by state;
took 11500 msec
but
select count(*) from test where state = 1;
select count(*) from test where state = 2;
select count(*)
On Fri, 3 Oct 2003, Kathy Zhu wrote:
Hi,
I notices a weird thing here.
version 7.2.1
on Solaris
table test, has a field state.
There are 4 state values, 1, 2, 3, 4.
select count(*) from test group by state;
took 11500 msec
but
select count(*) from test where state = 1;
I did a vacuum and got the same result.
I think the problem lies in there is swapping going for groupby when there is a
large number of rows in the table, 5000 in this case.
I guess I have to use group by with caution.
thanks for the all the replies though,
kathy
Date: Fri, 03 Oct 2003
On Fri, 3 Oct 2003, scott.marlowe wrote:
On Fri, 3 Oct 2003, Tom Lane wrote:
It'd be interesting to think about whether a write-caching IDE drive
could safely be used for data storage, if WAL is elsewhere.
Well, I just so happen to have a machine with two drives in it. I'll get
back
Well folks, we are now coming into the home stretch of another long
development cycle, and its time for more vigorous and extensive testing
...
Last night, we bundled up Beta4, which is the first one that we've
officially announced publicly, with the other 3 having been only
announced on
Hi
the problem is to avoid users from viewing functions code (in general db
structures) when connecting to db by means of pgpadmin client.
My db contains several tables and functions and I need to make users viewing
only a restricted
number of tables. It works for tables, as it's possible to
47 matches
Mail list logo
