netmask
-
255.255.255.240
(1 row)
spidermon=# SELECT text ( netmask ( '192.168.1.1/28' ) );
text
255.255.255.240/32 - ??
(1 row)
--
Vadim I. Passynkov, Axxent Corp.
mailto:[EMAIL PROTECTED]
:= cn + test1 ( rec.child, $2 + 1 );"
SELECT test1 ( 1, 0 );
test1
---
6
Very strange problem;
On 7.0.3 both functions working right.
--
Vadim I. Passynkov, Axxent Corp.
mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
---(end of broadcast)---
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
--
Vadim I. Passynkov, Axxent Corp.
mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi All,
pg_dump -o mydb
CREATE TABLE pgdump_oid (dummy int4);
COPY pgdump_oid WITH OIDS FROM stdin;
199150660
\.
DROP TABLE pgdump_oid;
PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Segmentation fault(core dumped)
What it means, and how realy dump database.
--
Vadim I
Tom Lane wrote:
>
> "Vadim I. Passynkov" <[EMAIL PROTECTED]> writes:
> > But, next result is wrong.
>
> > spidermon=# SELECT aclcontains ( ( SELECT relacl FROM pg_class where
> > relname = 'objects_view' ), 'user pvi=w' );
> &g
for group.
How I can know permission for user/group before make real operations?
FreeBSD 4.2, postgresql 7.0.3.
Thanks
--
Vadim I. Passynkov, Axxent Corp.
mailto:[EMAIL PROTECTED]
row)
test=# select now() where '127.0.0.1'::text = host ( '127.0.0.1' ) ||
'';
now
2001-01-29 14:32:04-05
(1 row)
--
Vadim I. Passynkov, Axxent Corp.
mailto:[EMAIL PROTECTED]
row)
test=# select now() where '127.0.0.1'::text = host ( '127.0.0.1' ) ||
'';
now
2001-01-29 14:32:04-05
(1 row)
--
Vadim I. Passynkov, Axxent Corp.
mailto:[EMAIL PROTECTED]
oop (cost=0.00..21582.82 rows=701404 width=99)
-> Nested Loop (cost=0.00..30.74 rows=836 width=95)
-> Index Scan using interfaces_name_pkey on interfaces_name
(cost=0.00..2.02 rows=1 width=91)
-> Seq Scan on routers_snmp (cost=0.00..20.36 rows=836
width=4)
