Hi all,
Can anyone please tell me how to download the PostgreSQL-7.1 source code
through CVS, i use the following set of commands to get the source code
of postgreSQL.
1) cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot
login
This command will do an initial login to the PostgreSQL
Scott and Tom,
Thanks for your replies. Yes, the missing select keyword was simply a typo on
my part.
The code that I sent was simplified (I didn't include all the fields, most of
which are character varying). I've spent all day yesterday trying to make it
work. (I'm not sure if I
On Tue, 14 Aug 2007, [EMAIL PROTECTED] wrote:
Name, Surname , Job, Hobby, Pet, address
John, Smith, NULL, photo, NULL, NULL
John, Smith, student, NULL, cat, NULL
by using name and surname as selecting key, I want :
John, Smith, student, photo, cat, NULL
If you are sure there's no
preventivo immediato.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6916d=20070814
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tue, Aug 14, 2007 at 6:29 AM, in message
[EMAIL PROTECTED],
Kuriakose, Cinu Cheriyamoozhiyil [EMAIL PROTECTED] wrote:
Can anyone please tell me how to download the PostgreSQL-7.1 source code
through CVS, i use the following set of commands to get the source code
of postgreSQL.
Did you
I've found the problem - I didn't see a misplaced/extra quote_literal.
My bad!
Thanks for the help.
Gord
-Original Message-
From: Hyatt, Gordon
Sent: Tuesday, August 14, 2007 9:18 AM
To: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] plpgsql question/problem
Scott and Tom,
Thanks
Kuriakose, Cinu Cheriyamoozhiyil wrote:
Hi all,
Please do not start a new thread by replying to someone else's post. This is
called hijacking a thread and it has the effect of stopping the conversation
about the original poster's (OP's) point.
Start a new thread by sending a post that is
Tena Sakai wrote:
~/bin/pg_ctl -D ~/bin reload
It's quite unlikely that your data directory is ~/bin.
As I looked at the pid file, there were three lines. The
first line seemed like the pid of the server process. The
second line indicates where the database cluster resides.
In
On 8/14/07, Hyatt, Gordon [EMAIL PROTECTED] wrote:
Scott and Tom,
Thanks for your replies. Yes, the missing select keyword was simply a typo
on my part.
The code that I sent was simplified (I didn't include all the fields, most of
which are character varying). I've spent all day
Hi Jay
This is the pgADMIN query so you should ask it in that list /
you should try to restart the service in the service panel
Subject: [ADMIN] PgAgent..Date: Tue, 14 Aug 2007 16:44:28 +0530From: [EMAIL
PROTECTED]: pgsql-admin@postgresql.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Dear All
testing...am I being copied to the list
Medi
--- [EMAIL PROTECTED] wrote:
If you need to, you can append your own timestamp to the dump file if you
need it.
I rolled this functionality into a .bat file.
Hi could you please share how you automated the pg_dump in the command
line. It seems to always want the password, but I would
Actually I found the answerpg_ctl supports a -w switch which waits for
the start operation to complete.
Decibel...without -w, pg_ctl will return immediately before postmaster is
fully operational. If you don't believe me start the engine and try to
connect to it right away with pgsql(1)...
We need to change the maximum length of table/column name lengths, and it looks
as if changing NAMEDATALEN in src/include/postgres_ext.h and recompiling
postgres.
2 questions:
a) Do I need to dump the database and reload ? (my guess is yes but only a
guess ...)
b) any caveats or warnings
Gregory Williamson [EMAIL PROTECTED] writes:
a) Do I need to dump the database and reload ?
Yes. (Any reasonably modern backend will in fact refuse to start
if pg_control shows an incompatible nameDataLen.) This is not a
lot different from changing --enable-integer-datetimes, for instance.
15 matches
Mail list logo