do a
select setval('sequence',max(col)+1) from tablename
for each table
tm
Uwe C. Schroeder schrieb:
Hi,
just thought I ask before I start doing it myself: Has anyone ever written a
stored procedure (or any other means) of syncing the sequence to the max #
key in the corresponding tables?
On Jun 11, 2007, at 11:41 PM, Joe Barwell wrote:
OK, it installed fine, restarted fine, but postgres does not
appear in Activity
Monitor. I can't use Creat User in the Client tools (or any
other tool). It says:
Database connection failed:
could not connect to server: Connection refused
Is the
John DeSoi <[EMAIL PROTECTED]> wrote:
> I think the easiest approach to get you started is to
> download and install the startup item. Then reboot your
> computer. You won't need to know the postgres user
> password to start the server and it will be started
> automatically when your compute
Hi,
just thought I ask before I start doing it myself: Has anyone ever written a
stored procedure (or any other means) of syncing the sequence to the max #
key in the corresponding tables?
I'm running a simple script to update table contents between dev and
production system, however the scri
On Jun 11, 2007, at 9:00 PM, [EMAIL PROTECTED] wrote:
Thanks again! You're quite right, I didn't think to look in
/Library, but there it
is! However, when I try that command of yours, I get a
password query, but it
doesn't accept my password. How do I find out the correct
password for
super-user
John DeSoi <[EMAIL PROTECTED]> wrote:
>/sw is just for Fink, so I would expect nothing to go there
unless
you are using Fink.
Ah! Thanks, John.
>Which package did you download from sourceforge? I notice
there are
several variations and some might only have the client
tools. It
looks like you wan
On Jun 11, 2007, at 7:52 PM, [EMAIL PROTECTED] wrote:
The
installer seemed to run fine, but afterward I find that
there are no postgres
files in my /sw/ directory. It has installed files in
/Applications/ instead, but I
suspect they are just gui front-ends.
/sw is just for Fink, so I would e
Hello People,
My (belated) thanks to John DeSoi & Tom Lane for their
responses to my earlier
query.
I have uninstalled the old postgres 8.0 via FinkCommander,
and downloaded
the 8.2.4 binaries from the sourceforge website that John
suggested. The
installer seemed to run fine, but afterward I find
Hi all.
Sorry for my problem.
I am using pg on ~100 servers fro 5 y. without any problems,
but this time I make a big mistake.
A have a table tasks with about 2 records.
The table have ID as pk and some other fields.
I typed : update tasks set c1='sss';
instead update tasks setc1='sss' wher
Hello,
If anyone would like to beta test a binary of PGAdmin 1.6.3, for RHEL5-32,
please drop me a line. I'm in the process of setting up an online
repository for the RPM's but I can put them up in a day or so for people
to download.
Thanks,
-J
---(end of broadcas
It actually is:
pg_ctl --help
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/11/07, Abraham, Danny <[EMAIL PROTECTED]> wrote:
Hi,
I am building a Windows installation by copying all the .exe and .dll
files to a single \bin file.
I am, then, testing by running "pg_ctl –help" and
Hi,
I am building a Windows installation by copying all the .exe and .dll
files to a single \bin file.
I am, then, testing by running "pg_ctl -help" and nothing comes out.
The Path is set properly.
Thanks
Danny Abraham
BMC Software
CTM&D BU
972-52-4286-513
[EMAIL PROTECTED]
Hi all,
I was wondering if there are any applications out there that we can use
to monitor the PostgreSQL DB for performance and runaway
transactions/queries/users? Does pgAdmin III and/or phpPgAdmin III do
these for us?
Thank you,
Best Regards
Luqman B Mohd Ali
CONFIDENTIALITY
This e-mail m
13 matches
Mail list logo
