On Thu, May 11, 2006 at 09:52:41 -0600,
Mark Gibson [EMAIL PROTECTED] wrote:
Is there a disadvantage to having the primary key for a table be a text
type vs. an integer type? Performance? Any difference between having a
varchar or char as a primary key?
You probably want to use 'text'
On Thu, May 11, 2006 at 10:43:50 -0600,
Mark Gibson [EMAIL PROTECTED] wrote:
I've got a followup - The primary key for the table in question consists
of 2 varchar fields: picture 'state' and 'city' where city is guaranteed
to be unique within a state, and (state, city) form a unique key.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 12 May 2006 04:33
To: Bart Butell
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Your in Luck Bart,
Check out PG Lightning Admin, it was developed
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 12 May 2006 02:09To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
The longer you use it, the longer it takes to connect to databases each
time you start up. It
On Thu, May 11, 2006 at 18:41:25 -0500,
Jim C. Nasby [EMAIL PROTECTED] wrote:
On Thu, May 11, 2006 at 07:20:27PM -0400, Bruce Momjian wrote:
My damn powerbook drive recently failed with very little warning, other
than I did notice that disk activity seemed to be getting a bit slower.
IIRC
Using interger as opposed to a character as a primary key has an advantage
when it comes to querying data in the table, it is faster searching with an
interger as compared to characters date types
+-+
| Martin W. Kuria (Mr.) [EMAIL PROTECTED]
On Fri, May 12, 2006 at 08:25:26AM +0930, Luke Vanderfluit wrote:
Does this mean libpq is part of the perl install?
Since libpq is under /usr/local/pgsql/lib/ doesn't that mean that it's
part of the postgresql install? Isn't then the postgres install 32 bit
and should be 64 bit?
libpq is
Dave Page wrote:
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Kenneth
Downs
Sent: 12 May 2006 02:09
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
The longer you use it, the longer it takes to
Dave Page wrote:
On my linux box, it
also has the dubious honor of being the only program I have ever seen
that can lock X hard, with killing the X server being the only rescue
(if you call that a rescue). It can connect over networks, but on mine
it always seems to hang after
Kenneth Downs schrieb:
Dave Page wrote:
On my linux box, it also has the dubious honor of being the only
program I have ever seen that can lock X hard, with killing the X
server being the only rescue (if you call that a rescue). It can
connect over networks, but on mine it
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 12 May 2006 13:06To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
Dave Page wrote:
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Thank you Tom. I will look at reindexing the database
---(end of broadcast)---
TIP 6: explain analyze is your friend
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tino
Wildenhain
Sent: 12 May 2006 13:19
To: Kenneth Downs
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Yes, that seems a gtk issue. You mark, then klick accidentaly
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market. I would guess that
more regular people (NON FOSS developers) access Postgresql from a win32
Kenneth Downs wrote:
Dave Page wrote:
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of
*Kenneth Downs
*Sent:* 12 May 2006 02:09
*To:* pgsql-general@postgresql.org
*Subject:*
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 12 May 2006 13:40
To: Kenneth Downs; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Part of the problem is that pgAdmin III seems to preload
object
Tony Caduto wrote:
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market.
I guess it depends on your definition of trivial. Linux represents
On Thu, May 11, 2006 at 12:30:13PM +0200, Tino Wildenhain wrote:
- create a greeting ;-)
(who has birthday?, ...)
I was not aware so many people working at the psql console
regulary :-)
Na klar ! :-)
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9
Hi, I have a linux box (Fedora 3) running the latest version of
PostgreSQL and PostGIS. I am trying connect to the database through a
windows computer but can't seem to make the connection work. I've
configured the pb_hba.config file in the usr directory to as host
all all
I'm working the Cisco ASC for wireless authentication and I'm having
problems getting the ODBC results in a format the ASC server
understands. I created a function that returns basic information for a
given user. The ACS server issues the following command :
select
Hi,
I got the following error on doing a vacuumdb :
NOTICE: RelationBuildDesc: can't open obo_switching_sql: No such file or
directory ERROR: _mdfd_getrelnfd: cannot open relation obo_switching_sql: No
such file or directory
I can do a \d on the table, but can't select (same error as above). I
Hi,
I've just installed postgresql onto my system but unable to successfully add
new users and databases. I would receive a error message:
createuser: could not connect to database template1: FATAL user root
does not exist
createdb: could not connect to database template1:
Hi,
In order to unify many distant Postgres databases, we
decided to use WAL archiving. The idea is to concatenate a distant WAL archive at
the beginning of a local WAL archive before launching PITR restore.
Does anyone know how to concatenate WAL contents, i.e.
decode and encode WAL
Hi all,
I'm in the planning stages of replacing a MySQL DB using ISAM tables
with PostgreSQL 8.1.x on Suse 10.0. I think that sentence right there
will tell you why!
Anyway, one of the columns in one of the tables is a big chunk of XML
(500 to 500KB). I'm not normally a fan of that kind of
Hello,
Has anyone thought of integrating shp2pgsql and pgsql2shp into
pgAdmin? This would be an extremely helpful addition. I'm really
happy that I've found pgsql and postgis, but getting geometry data in
and out of pgsql is still a major hassle for me.
Thanks,
nelson
Hi,
I have written a couple of trigger functions in C that utilise the SPI
interface. They are both row level triggers, one a before trigger and
one an after trigger.
If the triggers are called with an update statement that only affects
one row then both are excecuted correctly and without
On 10 May 2006 07:46:01 -0700, mmaclennan [EMAIL PROTECTED] wrote:
Hi, I have a linux box (Fedora 3) running the latest version of
PostgreSQL and PostGIS. I am trying connect to the database through a
windows computer but can't seem to make the connection work. I've
configured the pb_hba.config
On 5/11/06, APSC, Patrick Chee Seng Onn [EMAIL PROTECTED] wrote:
Hi,
I've just installed postgresql onto my system but unable to successfully add
new users and databases. I would receive a error message:
createuser: could not connect to database template1: FATAL user root
does not
On Thu, May 11, 2006 at 10:35:12AM +0800, APSC, Patrick Chee Seng Onn wrote:
Hi,
I've just installed postgresql onto my system but unable to successfully
add new users and databases. I would receive a error message:
createuser: could not connect to database template1: FATAL user
On Thu, May 11, 2006 at 10:28:37AM +0100, Chris Coleman wrote:
Hi,
I have written a couple of trigger functions in C that utilise the SPI
interface. They are both row level triggers, one a before trigger and
one an after trigger.
If the triggers are called with an update statement that
On Thu, May 11, 2006 at 11:15:16PM -0400, Perez wrote:
TOASTing is automatic? I don't have to code anything for it? Plain
vanilla SQL99 will work with it? I have terrible memories of Oracle's
LONG RAW columns
TOAST is automatic, yes. It's also transparent (ie there's no
functionality
Hi,
I was trying to create an updateable view. Suddenly I got foreign key
violations when using nextval('myseq').
As I understand, the rewriter does something similar to a simple text
replacement (I guess copying the plan tree nodes?) so that nextval gets
evaluated again for every rule that
On Fri, May 12, 2006 at 03:51:18PM +0200, Markus Schiltknecht wrote:
Hi,
I was trying to create an updateable view. Suddenly I got foreign key
violations when using nextval('myseq').
As I understand, the rewriter does something similar to a simple text
replacement (I guess copying the
On Fri, 2006-05-12 at 15:57 +0200, Martijn van Oosterhout wrote:
It's a known problem. It's also one of the reasons why triggers are
recommended over rules. And it's not desirable behaviour.
Well, triggers cannot be used to create writeable views, can they?
There have been discussions about
mmaclennan [EMAIL PROTECTED] writes:
Hi, I have a linux box (Fedora 3) running the latest version of
PostgreSQL and PostGIS. I am trying connect to the database through a
windows computer but can't seem to make the connection work. I've
configured the pb_hba.config file in the usr directory to
Martijn van Oosterhout kleptog@svana.org writes:
I beleive you can set it to EXTERNAL, which it will always toast.
I don't think that will help; if the overall row size is below the
threshold, the code is not going to pick it apart to see if anything
is saying toast me anyway!. And it shouldn't
Kenneth Downs wrote:
I guess it depends on your definition of trivial. Linux represents
100% of the desktops at Secure Data Software. Therefore lightning
will be deployed in the trivial percentage of zero.
---(end of broadcast)---
TIP 2:
Dave Page wrote:
Part of the problem is that pgAdmin III seems to preload
object properties instead of pulling them in as you need them.
I have noticed many times in pgAdmin III that when a function
is edited and saved by someone else on a different
workstation I can't see those changes until
Well, triggers cannot be used to create writeable views, can they?
The documentation says that triggers can be used on views but only for Inserts;
not updates or
deletes.
http://www.postgresql.org/docs/8.1/interactive/rules-triggers.html
Regards,
Richard
---(end of
-Original Message-
From: Erik Jones [mailto:[EMAIL PROTECTED]
Sent: 12 May 2006 15:09
To: Dave Page
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Why not have it be an option as to how it loads table info?
It's a fairly fundamental part of the design
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
Sent: 12 May 2006 15:46
To: Erik Jones
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
I work in a professional environment in a country (the UK)
where the cost
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Rhys
Peace Love | Live Long Prosper
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Two options I have run across.
pl/sh
http://developer.postgresql.org/~petere/pgplsh/
ShellSQL
http://www.edlsystems.com/shellsql/
On Friday 12 May 2006 07:54 am, Rhys Stewart wrote:
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Rhys
Peace
On Friday 12 May 2006 10:54 am, Rhys Stewart [EMAIL PROTECTED] thus
communicated:
-- hi all,
-- are there any function in pl/pgsql to call a shell script? or like is
-- there a pl/bash?
--
You can use Perl in untrusted mode as a backend function and accomplish
something like that.
Kenneth Downs wrote:
Tony Caduto wrote:
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market.
I guess it depends on your definition of
On Fri, May 12, 2006 at 09:54:23AM -0500, Rhys Stewart wrote:
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
PL/sh might be what you're after; you could also use PL/Perl, etc.
http://pgfoundry.org/projects/plsh/
What does the shell script do? Having
My damn powerbook drive recently failed with very little warning
It seems to me that S.M.A.R.T. reporting is a crock of shit. I've had ATA
drives report everything OK while clearly in the final throes of death, just
minutes before total failure.
--
Scott Ribe
[EMAIL PROTECTED]
On Fri, 2006-05-12 at 09:39, Tony Caduto wrote:
Kenneth Downs wrote:
I guess it depends on your definition of trivial. Linux represents
100% of the desktops at Secure Data Software. Therefore lightning
will be deployed in the trivial percentage of zero.
And, seriously,
are we still living at a time when connection speed should be
considered a deciding design factor? Yes, some people still
work off of slow connections, but the vast majority of us who
work in a professional environment most definitely do not.
I work in a professional
Rhys Stewart wrote:
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Actually scary enough, there is pl/bash. Google is your friend. You can
also use:
plpython, plperl, plphp, pljava etc...
Joshua D. Drake
Rhys
Peace Love | Live Long
Dave Page wrote:
I work in a professional environment in a country (the UK) where the
cost of a 2Mb leased line could buy you a new laptop every month (a
significant amount of money for a small company), and yes, I regularly
use servers on the other side of the world where the round trip time
Scott Ribe [EMAIL PROTECTED] writes:
My damn powerbook drive recently failed with very little warning
It seems to me that S.M.A.R.T. reporting is a crock of shit. I've had ATA
drives report everything OK while clearly in the final throes of death, just
minutes before total failure.
FWIW, I
Dave Page wrote:
query-per-click interface unusable.
And I forgot to mention the remote users working from home via VPN over
a domestic ADSL line with only 256Kb/s upstream at 50:1 contention.
Regards, Dave
---(end of broadcast)---
TIP 4:
-Original Message-
From: Tony Caduto [mailto:[EMAIL PROTECTED]
Sent: 12 May 2006 16:51
To: Dave Page; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Dave Page wrote:
I work in a professional environment in a country (the UK)
where the
cost of a 2Mb
On Fri, May 12, 2006 at 04:22:00PM +0200, Markus Schiltknecht wrote:
There have been discussions about the problems
Do you have some pointers here? I did not find relevant discussions in
the archives (of gmane.org)
Hmm, maybe not so much discussions as comments from developers when the
Nth
In this case, I'd be willing to bet that there are easily as many linux
desktops accessing PostgreSQL servers as there are Windows desktops, and
that the Mac comes in a distant third to either of them.
[snip]
I agree with everything you had to say Scott, but just FYI I think the
Mac,
Joshua D. Drake wrote:
Well even more then that. The market that Tony is going after he
*thinks* runs Windows, it doesn't.
The majority of people out there that run PostgreSQL are running *nix.
Yes, the majority of downloads we have received over the past two
years is Windows. However that
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 12 May 2006 17:08
To: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
It would be interesting to see what the numbers really are,
maybe
Tony Caduto wrote:
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market. I would guess that
more regular people (NON FOSS developers) access
Dave Page wrote:
I've used Enterprise Manager since before I started with pgAdmin II and
I still curse it to this day.
it's all what you are used to I guess :-)
I don't like enterprise manager either, but most of the hardcore MS DBAs
use the Query Analyzer program
which is separate from
On Fri, May 12, 2006 at 11:07:32AM -0500, Tony Caduto wrote:
It would be interesting to see what the numbers really are, maybe
someone should put up a survey and put a link to it from the main
Postgresql site.
I doubt you could lend any credence to the results, but there is a
poll system on
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 12 May 2006 17:08
To: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
It would be interesting to see what the numbers really are,
-Original Message-
From: Tony Caduto [mailto:[EMAIL PROTECTED]
Sent: 12 May 2006 17:14
To: Dave Page; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Dave Page wrote:
I've used Enterprise Manager since before I started with pgAdmin II
and I still curse it
Tony Caduto wrote:
Dave Page wrote:
I work in a professional environment in a country (the UK) where the
cost of a 2Mb leased line could buy you a new laptop every month (a
significant amount of money for a small company), and yes, I regularly
use servers on the other side of the world where
A survey would be interesting. But I'm sure it would still point out
that Windows is king as far as percentage goes. Linux and Mac would
possibly be neck and neck, but I'm not sure about that. I'm just
guessing. I know lots of Ruby on Rails developers use Macs, but I
don't know how many of
Tino Wildenhain wrote:
Tony Caduto wrote:
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market. I would guess that
more regular
That's not exactly true :-)
The market I am going after are those that run windows on the desktop
and access Postgresql running on any server platform.
I would still argue that the vast majority of people access their
Postgresql servers from a Windows Desktop, not a Unix one.
O.k., lets
I am regularly dealing with customers, and specifically developers that
are running Linux+PostgreSQL on the server... but their desktop of
choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
PostgreSQL runs a Powerbook ;)
I found it interesting because I
Dave Page wrote:
Interesting - you've been complaining about the way the 'Enterprise
Manager' part compares to pgAdmin up until now, not the Query Analyser.
Out of interest, what is wrong with our Query Tool? We may well have
resolved many of the issues - for example, 1.6 will have:
I don't
Not a sales pitch
And it may have been offered earlier in this string
But I have enjoyed the extra bells and whistles offered
This application is not Open Source.
I have been using it in windows to manage and manipulate a PostgreSQL
server running in Linux with limited of success.
The
On Thu, 2006-11-05 at 11:09 -0700, Joshua D. Drake wrote:
select relname from pg_class where oid = 17736;
relname
-
bbs_auth_access
(1 row)
phpbb_mainlandpc= \q
To access this user's table, I can be logged on as anyone, and that is
expected in SQL
I have been using it in windows to manage and manipulate a PostgreSQL
server running in Linux with limited of success.
The application is EMS PostgreSQL Manager currently $135 directly from
their site
http://www.pgsqlmanager.com/
Just to complete the list of commercial products.
This
It would be great if by default postgres used NOTIFY after any schema
changes. Then, listening UIs could be aware of changes behind the scenes
without polling or manual refreshing.
-M
---(end of broadcast)---
TIP 5: don't forget to increase your
On Fri, 2006-05-12 at 11:39, Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers that
are running Linux+PostgreSQL on the server... but their desktop of
choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
Joshua D. Drake wrote:
I am not trying to be antagonistic here, but honestly curious as to
how you are coming to your conclusions. I have been using PostgreSQL
since before it was PostgreSQL and except for Internet Explorer/Web
access I can tell you that most do not use Windows to manage
Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers
that are running Linux+PostgreSQL on the server... but their desktop
of choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
PostgreSQL runs a Powerbook ;)
hate to
Thanks Joshua,
According to the man page:
-s
--schema-only
Dump only the schema (data definitions), no data.
I need data too.
What are the command line options to get a user's schema, and a user's data?
You are confusing The Schema with Schemas. It is a common
I am getting my conclusions from the fact that Desktop Linux is just
not popular yet, there are few if any commercial apps being written for it.
Uhh... because they are not needed :)
I run my entire business one Linux. My business is no different then any
other small business. I need:
A
On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
See following-
-n schema
--schema=schema
Dump the contents of schema only. If this option is not specified, all
non-system schemas in the target database will be dumped.
Note: In this mode, pg_dump makes no attempt to dump any other
On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
See following-
-n schema
--schema=schema
Dump the contents of schema only. If this option is not specified, all
non-system schemas in the target database will be dumped.
Tony Caduto wrote:
Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers
that are running Linux+PostgreSQL on the server... but their desktop
of choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
PostgreSQL runs a
A.M. wrote:
It would be great if by default postgres used NOTIFY after any schema
changes. Then, listening UIs could be aware of changes behind the scenes
without polling or manual refreshing.
That sounds like a huge misuse of resources.
Sincerely,
Joshua D. Drake
-M
Uhmmm your market *IS* developers ;)... You don't actually think my
mom needs your product do you?
Joshua D. Drake
Sorry, I meant Postgresql developers :-) I figured you would have
figured that out since you where talking about Tom :-)
--
Tony Caduto
AM Software Design
This option shows up in 7.4.
On Friday 12 May 2006 10:16 am, Blair Lowe wrote:
On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
See following-
-n schema
--schema=schema
Dump the contents of schema only. If this option is not
user# pg_dump -n schema_name tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
Oh... if you are running 7.3 your pretty much hosed... You need to
upgrade to 7.4 at a minimum.
Sincerely,
Joshua D. Drake
TTYL,
Blair.
On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
user# pg_dump -n schema_name tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
Oh... if you are running 7.3 your pretty much hosed... You need to
upgrade
Blair Lowe wrote:
On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
user# pg_dump -n schema_name tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
Oh... if you are running 7.3 your pretty much hosed... You need to
Scott Marlowe wrote:
On Fri, 2006-05-12 at 11:39, Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers that
are running Linux+PostgreSQL on the server... but their desktop of
choice is MacOSX.
And to follow up on this, I just saw that Tom Lane,
On Fri, May 12, 2006 at 12:00:26PM -0500, Tony Caduto wrote:
Joshua D. Drake wrote:
I am not trying to be antagonistic here, but honestly curious as to
how you are coming to your conclusions. I have been using
PostgreSQL since before it was PostgreSQL and except for Internet
Explorer/Web
From: Tony Caduto
Kenneth Downs wrote:
I guess it depends on your definition of trivial. Linux represents
100% of the desktops at Secure Data Software. Therefore lightning
will be deployed in the trivial percentage of zero.
---(end of
On Fri, 2006-12-05 at 10:57 -0700, Joshua D. Drake wrote:
Blair Lowe wrote:
On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
user# pg_dump -n schema_name tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
So pg_dump does not work well in 7.3.4, and I have to pg_dump or the
global equivalent to upgrade to 7.4. A bit of a catch 22 in there.
No, because you will use the 7.4 dump to dump and restore to 7.4 from
the 7.3.
For full disclosure I run a consulting company for PostgreSQL but there
Bruce Momjian wrote:
I actually use a laptop running XP. I got it for the Win32 port, and
because I use putty/ssh, Mozilla, and Gaim 99% of the time, it doesn't
matter what OS I use. I could install a unix on it, but there seems to
be no need because all my unix work is done on my server via
Z-z-z-z-z-z-z-z-z-z-z-z-z-z-z-z-z
Those Windows developer tools must be working really well since you have the time
to litter my inbox with all these trivial arguments. :-)
BTW who was the EXPERT that slammed java performance?
No clue, but java sucks on the desktop :)
Best regards,
-Original Message-
From: Tony Caduto [mailto:[EMAIL PROTECTED]
Sent: 12 May 2006 17:17
To: Dave Page
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
I'm sure I can arrange an official survey on
http://www.postgresql.org/community/
/D
Jim Wilson wrote:
Those Windows developer tools must be working really well
How right you are Jim, far superior and more productive than anything
available on
Linux at this time, though the netbeans IDE comes close, to bad Java is
slow for
almost all desktop applications.
One example is
Tom Lane wrote:
David Link [EMAIL PROTECTED] writes:
Does anyone know how I can test ident?
I'd try sniffing the IP traffic to and from it with a packet sniffer
and/or tracing the daemon's system calls with strace. Manually invoking
the daemon isn't going to prove a lot, you want to
David Link [EMAIL PROTECTED] writes:
Thanks for your suggestion. I'm new to the concept of packet sniffing
and tracing. Can you suggest where I should go or what I should read to
better understand this?
man strace ... strace is probably easier to use for this purpose than
a packet sniffer,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 12 May 2006 20:41
To: Jim Wilson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Jim Wilson wrote:
Those Windows developer tools must be working
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 12 May 2006 20:41
To: Jim Wilson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Jim Wilson wrote:
Those Windows developer tools must
1 - 100 of 120 matches
Mail list logo