|
+--+
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 16:05
To: Mayers, Philip J
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] MACADDR types NULL value (undocumented?)
"Mayers, Philip J" <[EMAIL PROTECTED]> writes:
> I
+--+
| Phil Mayers, Network Support |
| Centre for Computing Services|
| Imperial College |
+--+
-Original Message-
From: Mayers, Philip J [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 12:18
To: '[EMAIL PROT
ntre for Computing Services|
| Imperial College |
+--+
-Original Message-
From: Mayers, Philip J [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 11:22
To: '[EMAIL PROTECTED]'
Subject: [GENERAL] FW: Optimisation of IN condition
I'v
I've got some tables:
create table interface (
machineid text,
mac macaddr,
primary key(mac)
);
create table arptable (
router text,
interface int2,
mac macaddr,
ip inet
);
They're big, 10k rows in interface, maybe 35k in arptable. I want to do
this:
hdb=> explain select * from
What does:
EXPLAIN
SELECT
tblSIDEDrugLink.DrugID,
tblSIDEDrugLink.MedCondID,
tblMedCond.PatientName AS MedCondPatientName,
tblMedCond.ProfessionalName AS MedCondProfessionalName,
tblSIDEDrugLink.Frequency,
tblSIDEDrugLink.SeverityLevel
FROM
Hmm... very suspicious...
However, if you have root on that machine, try this:
su - root
su - postgres
cd /var/lib/pgsql/data
vi pg_hba.conf
add:
local databasename trust
Restart postgres, Switch back to your user, then try:
psql databasename postgres
Bingo, you're in as the DB admin. GRANT
All,
I want to do a LIKE on a column of type macaddr, looking (for example) for
all MAC addresses with the prefix "00:80", and so on. There's no ~~ operator
for macaddr though... I tried casting macaddr to text, but that's undefined
apparently (WTF?) - any ideas?
Regards,
Phil
+
15:37
To: Mayers, Philip J
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] RE: even more CIDR weirdness (was equality
operator on CIDR colum n as primary key)
IIRC, there were some problems with CIDR where it was considering
the low bits significant even though they might not have been s
#x27;t see any pattern to the addresses that work, and those that
don't. Help!
Regards,
Phil
+--+
| Phil Mayers, Network Support |
| Centre for Computing Services|
| Imperial College |
+----------+
-Original M
I'm having problems with the CIDR type. I have a table containing a column
of type CIDR, and that is the primary key. The equality operator for the
CIDR type appears to only work once per connection. The following SQL shows
a test case demonstrating the problems.
I'm running stock Redhat 6.2 on
10 matches
Mail list logo
