Thank you Tom Lane and Phillip Smith, you've answered my questions.
--Geoff
On Jun 15, 2006, at 22:46, Tom Lane wrote:
Geoffrey Knauth [EMAIL PROTECTED] writes:
Andrew Sullivan wrote:
Well, do you actually have an interface with that address?
I think I do, in that the machine's
I'm running Mac OS X 10.4.6 on PPC, if that makes a difference.
For now, listen_addresses = '*' works for me, but I was curious why I
couldn't use the more restrictive listen_addresses.
Geoffrey
--
Geoffrey S. Knauth | http://knauth.org/gsk
---(end of broadcast
I'm misunderstanding. I thought the purpose of listen_addresses was
to allowing incoming connections only from listed addresses.
Geoff
On Jun 15, 2006, at 10:40, Tom Lane wrote:
Geoffrey Knauth [EMAIL PROTECTED] writes:
I'm running PostgreSQL 8.1.3. In my postgresql.conf, the following
parameters.)
Geoffrey
--
Geoffrey S. Knauth | http://knauth.org/gsk
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
That did exactly what I wanted. Thank you! (I had tried \set
acct ... before, but it was your quoting that fixed my problem.)
Geoffrey
--
Geoffrey S. Knauth | http://knauth.org/gsk
On Sep 15, 2005, at 18:43, Michael Fuhr wrote:
What's your intention here? The above sets the variable tmp
where sqlcode contains your sql.
--
Until later, Geoffrey
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Michael Fuhr wrote:
On Sat, Apr 23, 2005 at 08:15:48AM -0400, Geoffrey wrote:
Or you can do the following:
psql database sqlcode
where sqlcode contains your sql.
That command redirects the standard input from the file named
sqlcode; the requirement says NOT to use an external file.
My bad, I
Richard Gintz wrote:
Pardon me ya'll, but can you tell me what a saisies is?
More than one saisy???
--
Until later, Geoffrey
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
Worik wrote:
Assuming it is unix The command
ps xau|grep post
You might want to change that to:
ps aux|grep postgres
As your suggestion will pick up extraneous data if one is running
postfix on the same box.
--
Until later, Geoffrey Registered Linux User #108567
. If it doesn't
have some value printed, how do you know what the value is? Although
your example would work (from a previous post), I don't see a real world
use for such an effort.
There are work arounds that are quite simple.
--
Until later, Geoffrey Registered Linux User #108567
would find this useful.
Don't take me wrong please. I'm by no means a db expert, but I can't
see a purpose for such a cast. Can you provide a reasonable example of
such usage?
Thanks.
--
Until later, Geoffrey Registered Linux User #108567
ATT Certified UNIX
Very simply, a boolean may have to values: true or false. It's also
possible that it's not been set to anything (NULL).
--
Until later, Geoffrey Registered Linux User #108567
Building secure systems in spite of Microsoft
---(end of broadcast
Eric Anderson Vianet SAO wrote:
How could I record the ´ \d table ´ command to a file?
echo '\d' | psql rnd outputfile
--
Until later, Geoffrey Registered Linux User #108567
Building secure systems in spite of Microsoft
---(end of broadcast
How does one check for an unset value in an integer field?
I've tried such things as:
select . where intnumber = ''
select .. where intnumber = ?
select . where intnumber = NULL
Thanks.
--
Until later, Geoffrey [EMAIL PROTECTED]
Building secure systems inspite of Microsoft
Wei Weng wrote:
Geoffrey wrote:
How does one check for an unset value in an integer field?
I've tried such things as:
select . where intnumber = ''
select .. where intnumber = ?
select . where intnumber = NULL
Thanks.
It is actually WHERE intnumber IS NULL. You don't use operator
15 matches
Mail list logo
