ing these problem using psql client,
please do the following.
Try these commands ( I suppose you can have root privileges ):
root# su - postgres
postgres# psql -l
this will show you all the database in your engine.
If you need to access on of these database:
psql
Regards
Gaetano Men
ect timestamp '2005-09-23 23:59:59.999'
>
> I get the following result (note the value of the seconds):
>
> 2005-09-23 23:59:60.00
It's the leap second.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: In
e tt<>NULL;
>
> 0 row(s) !!!
This is not a bug. If you want find all values with that
field null you have to do:
select tt from test where tt is null;
And I can assure you this is what the standard say.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
trying to connect 50 separate clients via Npgsql 0.7 beta3.
Inside the postgres config maxconnections = 100
(the config settings are a all default!)
Did you restart the server ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forg
the function by itself Explain
would always report the index being used, but when run in the context of
the function the indexes where not being used.
Is not solved because is a bad idea run the server with that parameter
disabled.
Regards
Gaetano Mendola
---(end of
Tom Lane wrote:
! maskl = (0xUL << (32 - (int)
bits))
! & 0xUL;
Is that "& 0xUL" required ?
---(end of broadcast)---
TIP 8: explain analyze i
separate files, for example you'll miss the FK creation delayed after the
data load.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
telly postgresql is not a "time to market" slave.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
o();
NOTICE: INTEGER
CONTEXT: PL/pgSQL function "sp_foo" line 4 at perform
NOTICE: INTEGER
CONTEXT: PL/pgSQL function "sp_foo" line 6 at perform
sp_foo
0
(1 row)
AS the OP can see even calling sp_bar with a null value then
the correct function is called.
shows me this message.
Violacion de segmento (violation of segment).
Good to know. May you provide an example?
Are you using your own C functions ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an
base is in recovery mode'
This is normal if you try to reconnect the DB immediately after the error above,
this because the engine perform a recovery after have close all connections.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if
#x27;t seem to think so!
This is a known issue, thank you for the report.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
nline when
you're done messing. I can not reproduce this problem on a RH8
(2.4.20.x) system
Do you mean that is not enough stop your java application in order to
retrieve the space with a vacuum ? Do you have some connection in status:
"Idle in transaction" ?
Regards
Gaetano Men
d and I never had a problem
with that.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
"quota" is not assigned yet
DETAIL: The tuple structure of a not-yet-assigned record is indeterminate.
and is clear to me why. Shall not this be inserted in the release note ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the plan
tart on a FATXX, and not trust on the failre of a cacls.exe
My 2 cents.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
ion of the same row, the result however is the same.
Are you reindexing your tables regulary ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmail
ve already some
backwards-incompatibilities so one more is mitigated by the other one.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
t; addition to the usual services applet.
Because a window user expect to have the applications running visible on
the traybar; and also is annoyng
start->control panel->administrative-tools->service->...
I know is possible to do the same with a CLI but we are speaking about
windows user
Robert Treat wrote:
On Thu, 2004-08-26 at 09:08, Gaetano Mendola wrote:
Robert Treat wrote:
On Thu, 2004-08-26 at 04:23, Gaetano Mendola wrote:
Tom Lane wrote:
Stephan Szabo <[EMAIL PROTECTED]> writes:
I believe it sees the one that was valid in the snapshot as of the
beginning of the fu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Treat wrote:
| On Thu, 2004-08-26 at 09:08, Gaetano Mendola wrote:
|
|>Robert Treat wrote:
|>
|>
|>>On Thu, 2004-08-26 at 04:23, Gaetano Mendola wrote:
|>>
|>>
|>>>Tom Lane wrote:
|>>>
|>
Robert Treat wrote:
On Thu, 2004-08-26 at 04:23, Gaetano Mendola wrote:
Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
>
>>I believe it sees the one that was valid in the snapshot as of the
>>beginning of the function.
>
>
> Actually, the problem is th
havior. Seems like 8.0 is exactly the right
> version to consider doing that in.
If my 2 cents are valid I agree with you, what I don't totally agree is why
consider this bug as a *feature* in previous 8.0 version.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
select in
that function doesn't see the same row if you perform that same select after
the function execution, and for sure doesn't see the same row that the update
statement touch.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
least with the TCP stacks I've worked with.
mmm You can bind a local address not an interface, may be I don't have
your experiences but I think that interfaces in Linux world are
eth0, eth1, ...
for sure I'm wrong :-)
Regards
Gaetano Mendola
---(end of broadc
Win32 works
only if the filesystem is journalized, NTFS for istance.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
';
IF NOT FOUND THEN
CREATE TEMP TABLE test ( a integer ) ON COMMIT DELETE ROWS;
END IF;
select a INTO my_value from test limit 1;
return 0;
END;
' LANGUAGE 'plpgsql'
VOLATILE;
regression=# select sp_test();
sp_test
-
0
(1 row)
regression=# s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruno Wolff III wrote:
| On Mon, Jul 12, 2004 at 14:47:34 +0200,
| Gaetano Mendola <[EMAIL PROTECTED]> wrote:
|
|>As someone says NULL = NULL is false
|
|
| As someone else pointed out, NULL = NULL is NULL which is not TRUE.
Yes, that it
says NULL = NULL is false
so that two rows are different. If you want enforce
only one null value for that column you have to write
you own trigger.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
o solve your problem setting the serial value equal to
max(id)+1 in that table.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
e each 10 minutes. I strongly suggest you to use
the autovacuum daemon.
Do not esitate to ask how use it.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
which couldn't connect) can finally connect to db.
Reproduced on 7.4 but not in 7.5devel
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
using the version 7.4.x ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
saint wrote:
(ver. 7.4) select netmask('192.168.1.5/24') return '255.255.255.0/24'
not '255.255.255.0' (example in docs)
(ver. 7.3) return '255.255.255.0'
Fixed on 7.4.1
Regards
Gaetano Mendola
---(end of broadcast)-
Other Contributors list is in alphabetic order, right ?
The family name of "Massimo Dal Zotto" is "Dal Zotto",
so must be inserted just after Robert Bruccoleri
( another italian family name BTW :-) ).
Regards
Gaetano Mendola
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
too and I solved not running anymore
each night a REINDEX on the table. I posted this problem in the
past ...
Do you scedule reindex on this table very often ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Neil Conway wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
I don't know how the check for the data integrity is implemented but if
is a trigger
It isn't -- trigger firing order is irrelevant to the original
question.
Well, it is. If the data integrity was done with a system
4) drop trigger: trigger_a
5) create trigger: trigger_a
( now trigger b is the oldest one)
test=# insert into test values ( 10 );
NOTICE: TRIGGER A
NOTICE: TRIGGER B
INSERT 3416836 1
why this ?
Regards
Gaetano Mendola
---(end of broadcast)
Bruce Momjian wrote:
This now works in current CVS and will be in 7.4 final:
Thank you.
regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatyp
s allocated share of FSM space
decreases due to roundoff error. Fix committed accordingly.
Less dangerous then this:
http://mathworld.wolfram.com/RoundoffError.html
:-O
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/rea
Hi all
I'm esperiencing problem with the autocomplete on
postgres 7.4beta5:
#select * from pg_l
and no suggestions out.
On postgres 7.3.4:
#select * from pg_l
pg_language pg_largeobject pg_listener pg_locks
am I wrong ?
regards
Gaetano Mendola
---(e
u sure that all indexes are needed and that a partial index could
not help ? What about the statistics on these indexes ? Are they really
used ?
Yup, they're all essential. :(
May I see yours tipical queries where these indexes are involved ?
Regards
Gaetano Mendola
d that a partial index could
not help ? What about the statistics on these indexes ? Are they really
used ?
Regards
Gaetano Mendola.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
2.5.4 or later and Bison 1.875 or later. Other yacc
programs can
sometimes be used, but doing so requires extra effort and is not
recommended. Other lex programs will definitely not work.
Regards
Gaetano Mendola
---(end of broadcast
36.46 sec.
INFO: Pages 217213: Changed 1362, Empty 0; Tup 10810476: Vac 348991, Keep 0, UnUsed
352822.
Total CPU 17.09s/13.98u sec elapsed 284.52 sec.
Do you regular reindex these tables ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP
"Tom Lane" <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] (Payman) writes:
> > Hey tom and your PowerBook ???
>
> I had it back for a day, and it went belly up again :-(
Look at this then
http://www.waveworks.net/mac.html
:-)
Regards
Gaetano Mendola
---
t;
> > Of course, none of this is going to happen until someone gets around to
> > creating infrastructure for flushing cached plans at need. Right at the
> > moment the answer is going to have to be "don't do that".
>
> Yep. I was j
teger + date is not necessary but is
better to have just to forget that not exist each time that someone wrote an
expression involving integer and date.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
I already post the fact that the file pgdb.py distribuited with
Postgres 7.3 is wrong but was not already fixed in 7.3.1
The class pgdbTypeCache is not working with the version 7.3.1
the method getdescr try to do the following select:
"SELECT typname, typprtlen, typlen FROM pg_type"
and th
known )
2) when postgres is launched the script do:
echo " [ OK ] "
or
echo " [ FAIL ] "
but should be more correctly:
echo_success
or
echo_failure
I attach both patch ( I added also the stop_immediate )
Regards
Gaetano Mendola
51 matches
Mail list logo
