Friday, 9 May 2008
|
| Postgres Stored Procedure Call Function Return Type OID Caching Problem Feng Chen 06:24:18 |
| | Hello,
I'm wondering if anyone has experienced the same problem and is it fixed
in the new Postgres release (We use Posgtgres 8.1.2, psqlodbc.so 7.2.5
(moving to 8.2.200), unixODBC 2.2.11 (moving to 2.2.12), running on
Linux OS.):
We have a recurring problem that the return type (a customer defined
type) was changed somehow, which resulted in a failure: lookup for that
type failed when trying to call that function.
Specifically, we have a file defining the following type and function.
It is loaded at the start of the Postgres start time and the function
then is called many times.
drop type type_foo cascade;
CREATE TYPE type_foo AS
(
......
......
);
CREATE OR REPLACE FUNCTION sp_foo(int4, int4 , text, text , text , text,
text , text)
RETURNS SETOF type_foo AS
$BODY$
DECLARE
temp_row type_foo ; /** the type of data to be returned **/
insert_statement text; /** placeholder for populating the page **/
BEGIN
/** create a temp table to put everything in **/
EXECUTE 'CREATE TEMP TABLE temp_foo_page
(
......
......
) ';
/** build the insert statement to load initial values from
cxcsession **/
insert_statement = 'INSERT INTO temp_foo_page SELECT * from bar
where ( date( "timestamp" ) = date( ''' || DATE_TO_USE || ''' )) ' ;
......
......
/** execute the select **/
EXECUTE insert_statement;
/** return the result set **/
FOR temp_row IN EXECUTE 'SELECT * FROM temp_foo_page order by "'
|| SORT_COLUMN || '" desc '
LOOP
RETURN NEXT temp_row ;
END LOOP;
/** drop the table we no longer need **/
EXECUTE 'drop table temp_foo_page ';
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION sp_foo(int4, int4 , text, text , text , text, text ,
text) OWNER TO postgres;
The problem after a period of time (10 days or so not consistent),
function sp_foo referenced an oid for an old return type that no longer
existed. We had to explicitly drop the function sp_foo reload from the
SQL source file to correct the problem.
I knew that there was a bug of Postgres with sp functions caching the
temp table ids, and there is a temp table used in this function, but the
problem is with the type id changing underneath:
Here is the results of system tables query. The oid 25266 no longer
exists and the current type oid is somehow changed to 34487???
# select prorettype, proname from pg_proc where proname like 'sp_%';
prorettype | proname
16450 | sp_session
25226 | sp_foo
25 | sp_resolve
......
(12 rows)
spotlite=# select * from pg_type where typname = 'type_foo';
typname | typnamespace | typowner | typlen | typbyval |
typtype |
t
ypisdefined | typdelim | typrelid | typelem | typinput | typoutput |
typreceiv
e | typsend | typanalyze | typalign | typstorage | typnotnull |
typbasetype
| typtypmod | typndims | typdefaultbin | typdefault
---------------------+--------------+----------+--------+----------+----
-----+-
-
------------+----------+----------+---------+-----------+------------+--
-------
-
---+-------------+------------+----------+------------+------------+----
-------
-
-+-----------+----------+---------------+------------
type_foo | 2200 | 10 | -1 | f | c |
t
| , | 34487 | 0 | record_in | record_out |
record_re
cv | record_send | - | d | x | f |
0
| -1 | 0 | |
(1 row)
Any help would be greatly appreciated!
FC
|
| Options |  8 answers | Add comment |
Monday, 5 May 2008
|
| Multilingual Support Nandha Kumar 09:32:22 |
| | hi,
Does PostgreSQL support Multilingual data?
Is it possible to have rows in different languages like japanese etc?
nandha kumar & prasad
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
|
| Options | 2 answer | Add comment |
Wednesday, 16 April 2008
|
| Hack credit card ( New Fraud ) !! John K 14:49:48 |
| | How To Hack Or Steal Credit Card Information
HOW TO GAIN VALID CREDIT CARD NUMBERS
In August, 1999, Scientific American ( http://www.sciam.com/ ) has published an article entitled “How to stealmillions in chump change” which was about online credit card theft. The original article can still be found online at:
http://www.efc.ca/pages/media/scientific-american.01aug99.html
No sooner had the article been published than hackers from around the world undisclosed complete hacking procedures used to obtain credit card numbers on various websites. One of the most famous one was: http://www.creditcardhack.com/ In May, 2000, at the request of VISA ( www.visa.com ) and MasterCard ( www.mastercard.com ), information on the complete hacking procedures was forced to be TAKEN OFF, so that credit card companies would not lose potential customers due to the insecurity of internet marketing.
However, today credit card fraud is still very much at large around the world and the hacking procedures that were used a few years ago STILL WORK PERFECTLY TODAY.
Since the hacking info has been forced to be taken off the net for years, credit card companies take for granted that no one today knows the procedures anymore. But THEY’RE WRONG! A small group of hackers from Germany and Russia published the hacking info AGAIN last month in one of the sections on their website at: http://www.snz.cc/04.code.htm I havealways been a true believer of the idea that resources on the net should be shared by EVERYONE absolutely free of charge, and though my German still leaves much to be desired, I tried my best to translate the procedures into English and I hope you guys will understand it. The site was written in German in a very technical way and it’s MORE THAN HARD for not-too-experienced hacker to understand it. However, I’ve simplified it and put it into simple English. Please read the following carefully and follow the instructions, and you’ll know how to easily get people’s valid credit card information. All computer companies make mista
kes.
As we know, Microsoft made such a HUGE mistake in its design of Windows XP. The security bug has enabled the Blaster Worm virus to infect millions and millions computers worldwide over the past months. Another company, Yahoo Inc.( www.yahoo.com ) also has a huge security bug in its server. We can get people’s credit card information JUST FROM THIS BUG. Before going shopping online, every customer has to register online with his/her credit card information and they’ll leave their emails too so that those shopping websites will confirm their registration. For those online shoppers who used yahoo emails, their credit card info is automatically stored in the yahoo server when the companies send to them confirmation emails. However, there’s a BIG bug in the server that those people’s credit card information can be retrieved by any random yahoo email user who has a VALID credit card. To simplify this, here is how it works: Send an Email to confuse a yahoo email, and it takes 3 mins
to
create a yahoo email account) with complete information of people’s credit card information stored in the server in the last 72 hours. This is how you’ll get people’s VALID credit card information. Now you have to do exactly the same as follows: Send an Email to mailto:creditcard_access@yahoo.com
With the subject:
accntopp-cc-E52488 (To confuse the server )
In the email body, write: boundary="0- 86226711-106343” (This is line 1)
Content-Type: text/plain; (This is line 3)
charset=us-ascii (This is line 4, to make the return email readable)
credit card number (This is line 7, has to be LOWER CASE letters) 000000000000000 (This is line 8, put a zero under each character, number, letter, hyphen, etc)
name on credit card (This is line 11, has to be LOWER CASE letters) 0000000000000000 (This is line 12, put a zero under each character, number, letter, hyphen, etc) cid/cvv2 number then pin (This is line 15, has to be LOWER CASE letters) 0000000000000 (This is line 16, put a zero under each character, number, letter, hyphen, etc)
address,city (This is line 19, has to be LOWER CASE letters)0000000000 (This is line 20, put a zero under each character, number, letter, hyphen, etc)
state,country,p.o. box (This is line 23, has to be LOWER CASE letters) 00000000000000000 (This is line 24, put a zero under each character, number, letter, hyphen, etc)
phone number ( put a zero under each character, number, letter, hyphen, etc)
type of card (This is line 27, has to be LOWER CASE letters) 000000000
( This is line 28, put a zero under each character, number, letter, hyphen, etc)
expiration date (This is line 31, has to be LOWER CASE letters) 0000000 (This is line 32, put a zero under each character, number, letter, hyphen, etc)
252ads< m > (This is line 35
Return-Path: < Your Email Here > (This is line 36, type in your email between < >)
You have to make sure you do EXACTLY as what is said above and the credit card info above the 0000’s are absolutely CORRECT/VALID, otherwise you will NOT get any reply and therefore you won’t get anybody’s credit card information. Here’s a sample email .
(CAUTION ) ! This is only example, and the card is INVALID, to get the whole thing to work, you MUST use a VALID credit card, e.g. YOUR OWN VALID CC)
Send to:
creditcard_access@yahoo.com
Subject:
accntopp-cc-E52488
Email body:
boundary="0-86226711-106343” Content-Type: text/plain;
charset=us-ascii
4013993145565451
0000000000000000
jesse d banks
00000000000
523 5632
0000000
2537 stillwell rd.,des moines
00000000000000000000000
la,usa,50567
0000000000
645-867-9950
00000000000
visa
0000
03/2006
0000000
252ads< m >8> Return-Path: <
aol_shafiq@yahoo.co.uk > This may take a few minutes
but it REALLY WORKS!!! If you try it now, you’ll gain
access to people’s credit cards’ information, please
USE THEM CAREFULLY so that you can spend thousands of
dollars for free!! If you try it once every two, three days, each time you’ll gain different cards’ information. I’ve got information about 11 cards over the last 5 days!
 HACKERS FOREVER!!!!
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort. |
| Options | 2 answer | Add comment |
Tuesday, 6 November 2007
|
| updating Angelo Rigo 21:33:48 |
| | Hi
I am working on an update php script, i have a list of the records and at
the bottom of the script i do write the id number
on the id field i want to change and the others fields values, i have to
write it, i want to select with a radio button and to get the fields at
the bottom receiving the values of that line i do select how can i do that?
Below is my script:
//part one: list and update form.
<?php
$db = pg_connect("dbname=db user=user");
$query = "SELECT * FROM thetable";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
$numrows = pg_numrows($result);
$row=0;
printf ("<table border=1>
");
printf ("<tr bgcolor='#66CCFF'><td><b>ID</b></td><td><b>Cidade</b></td><td><b>Estado</b></td><td><b>Local</b></td><td><b>Dia</b></td><td><b>Mês</b></td><td><b>Horário</b></td><td><b>Evento</b></td></tr>");
do
{
$myrow = pg_fetch_array ($result,$row);
printf ("<tr bgcolor='$bgcolor'><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>
",$myrow[id],$myrow[cidade], $myrow[estado], $myrow[localidade],$myrow[dia],
$myrow[mes], $myrow[horario],$myrow[evento]);
$row++;
}
while ($row < $numrows);
printf ("</table><br>
");
pg_close($db);
?>
<form action="atual.php" method="post">
<TABLE>
<TR><TD>ID to modificar :</TD>
<TD><input type="text" name="id" size="4" length="4" value="id"></TD>
</TR>
<TR><TD>Cidade : </TD>
<TD><input type="text" name="cidade" size="80" length="80" value=""></TD>
</TR>
<TR><TD>Estado :</TD>
<TD><input type="text" name="estado" size="80" length="80" value=""></TD>
</TR>
<TR>
<TD>Local :</TD>
<TD><input type="text" name="local" size="80" length="80" value=""></TD>
</TR>
<TR>
<TD>Dia : </TD>
<TD><input type="text" name="data" size="80" length="80" value=""></TD>
</TR>
<TR>
<TD>Mês :</TD>
<TD><input type="text" name="data" size="80" length="80" value=""></TD>
</TR>
<TR>
<TD>Horário :</TD>
<TD><input type="text" name="horario" size="80" length="80" value=""></TD>
</TR>
<TR>
<TD>Evento :</TD>
<TD><input type="text" name="evento" size="80" length="80" value=""></TD>
</TR>
<TR>
<TD><input type="submit" name="submit" value="Atualizar"></TD>
<TD><input type="reset" name="reset" value="Limpar"></TD>
</TR>
</TABLE>
// atual .php
<?php
$db = pg_connect("dbname=db user=puser");
$query = "UPDATE thetable SET $id='$id', cidade='$cidade', estado='$estado',
localidade='$localidade', dia='$dia', mes='$mes', horario='$horario', evento='$evento'
WHERE id='$id'";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
printf ("these values were updated: %s %s %s %s %s %s %s %s", $id, $cidade,
$estado, $localidade, $dia, $mes, $horario, $evento);
pg_close($db);
?>
________________________________________
A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
|
| Options | 2 answer | Add comment |
Saturday, 27 October 2007
|
| build error Darko Prenosil 00:35:30 |
| | Yesterdays snapshot fails to build on my NT:
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declaratio
ns -I../../src/port -I../../src/include -I./src/include/port/win32 -DEXEC_BA
CKEND "-I../../src/include/port/win32" -c -o path.o path.c
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declaratio
ns -I../../src/port -I../../src/include -I./src/include/port/win32 -DEXEC_BA
CKEND "-I../../src/include/port/win32" -c -o pipe.o pipe.c
pipe.c: In function `pgpipe':
pipe.c:32: warning: implicit declaration of function `ereport'
pipe.c:32: `LOG' undeclared (first use in this function)
pipe.c:32: (Each undeclared identifier is reported only once
pipe.c:32: for each function it appears in.)
pipe.c:32: warning: implicit declaration of function `errmsg_internal'
make[2]: *** [pipe.o] Error 1
make[2]: Leaving directory `/d/postgresql-snapshot/src/port'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/d/postgresql-snapshot/src'
make: *** [all] Error 2
Putting
#include "utils/elog.h"
in the beginning of the pipe.c solves the problem
However I did the build because I was trying to compile tsearch2, and it
fails too:
dict_ispell.o(.text+0x31b):dict_ispell.c: undefined reference to
`pg_strcasecmp'
dict_ispell.o(.text+0x420):dict_ispell.c: undefined reference to
`pg_strcasecmp'
dict_ispell.o(.text+0x500):dict_ispell.c: undefined reference to
`pg_strcasecmp'
wparser_def.o(.text+0xc83):wparser_def.c: undefined reference to
`pg_strcasecmp'
wparser_def.o(.text+0xcd9):wparser_def.c: undefined reference to
`pg_strcasecmp'
wparser_def.o(.text+0xd02):wparser_def.c: more undefined references to
`pg_strcasecmp' follow
ispell/SUBSYS.o(.text+0xbd2):spell.c: undefined reference to
`pg_strncasecmp'
ispell/SUBSYS.o(.text+0xbfc):spell.c: undefined reference to
`pg_strncasecmp'
ispell/SUBSYS.o(.text+0xc15):spell.c: undefined reference to
`pg_strncasecmp'
ispell/SUBSYS.o(.text+0xc2e):spell.c: undefined reference to
`pg_strncasecmp'
c:\mingw\bin\dllwrap.exe: c:\mingw\bin\gcc exited with status 1
make: *** [libtsearch2.a] Error 1
Too late tonight to dig more...
Regards !
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
| Options | 6 answers | Add comment |
Monday, 24 September 2007
|
| Problem with the use of Array and Loop Benjamin RICHARD 23:43:45 |
| | Hi,
I would like to read each value of an array.
To do this i create the following function which return me a parse error
near '[' (in the Raise notice line)
What mistake did i do ?
And maybe there is a better way to do this in Postgre
CREATE FUNCTION array_int(_int4) RETURNS int4 AS 'DECLARE
start_char INTEGER DEFAULT 4;
len_char INTEGER;
array_count INTEGER;
val_tmp VARCHAR;
tmp INTEGER;
BEGIN
SELECT INTO val_tmp array_dims( $1 ) ; --get the length of the array =>
[x:y]
SELECT INTO len_char ( position('']'' in val_tmp) - start_char ) ; --get the
length of y
SELECT INTO array_count substring(val_tmp from start_char for len_char)
; --get the value of y
FOR tmp IN 1..(array_count) LOOP
RAISE NOTICE ''current value = %'' , $1[tmp] ;
END LOOP;
RETURN array_count ;
END;
-------------------------------------------------------------------
Try :
select array_int('{5,3,6,9,7,5,10,5,87,45,12,65,98,21,65,21}') ;
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
| Options | 2 answer | Add comment |
Friday, 7 September 2007
|
| I have implement set/get stored procedure parameter by name Skaljac Bojan 21:43:24 |
| |
Hi!
My name is Bojan Skaljac.
I use PostgreSQL JDBC driver in my project.
I did not find set/get by name for stored procedure parameters so I
make one.
Only modification is in file AbstractJdbc3Statement.java so i sending
you that file. I found that file in CVS repository.
I hope that you find this useful and perhaps include this code in next
driver release.
Question on mailto:skaljac@gmail.com.
P.S. Please excuse me for my English (I am Serbian).
Best regards,
Skaljac mailto:skaljac@gmail.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
| Options | Add comment |
Thursday, 23 August 2007
|
| html forms Mattia Boccia 02:30:17 |
| | I have installed a Postgres server and built up a test
database
now i would like to connect an HTML form with it to
insert data.
wich is the best way to do it?
i would like to use java for it but i need some usage
example.
does anyone now where i could find them?
regards
Matt
__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
|
| Options | 16 answers | Add comment |
Tuesday, 24 July 2007
|
| Perl DBI Cheryl Thompson 19:46:15 |
| | I'm sorry if this is the wrong forum... if someone knows of a better forum
(alt.users.trying.to.run.postgres.and.perl.with.apache.on.windows doesn't
exist , please let me know.
Thanks to the many helpful people in this group I located the DBD::Pg files
on CPAN.
However, following the instructions for PgSimple (this is all being done on
the Cygwin side), I get an error that has stumped the one person in the
office who uses Perl. (He came up with the supremely helpful: "You're
missing the Perl module for postgresql." To which my reply is, "This IS the
Perl module for PostGresQL").
Has anyone set up this configuration? Can you tell me what I'm doing wrong
here??? (Besides trying to ignore the first error in hopes it would go
through steps 2 and 3 anyway).
I can read this and say, "Ok, it can't find Perl", but I don't know how to
tell it "hey, Perl is over here---> /Perl".
I have currently on this box:
Apache 2.0.3
Cygwin
Postgresql (runs through Cygwin)
Active Perl 5.8
[Should I have installed a different Perl through Cygwin as a LINUX build,
not through windows as Active Perl?? Would Apache and everything ELSE then
have to run through Cygwin? I can see that being an issue; on the other hand
it seems kind of a silly way to do this. Access through Windows can see
Postgresql; why can't Perl?]
Thanks,
Cheryl "I Hope To Stop Posting To This List Real Soon Now" Thompson
---------------------Cut N
Paste---------------------------------------------
cthompso@MyBox /Pg-Simple-1.0
$ ls
COPYRIGHT LICENSE Makefile README test.pl
Changes MANIFEST Makefile.PL Simple.pm
cthompso@MyBox /Pg-Simple-1.0
$ perl Makefile.pl
Warning: prerequisite Pg failed to load: Can't locate Pg.pm in @INC (@INC
conta
ns: /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1
/usr/lib/perl5/site_
erl/5.6.1/cygwin-multi /usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl
) at (eval 4) line 3.
Writing Makefile for Pg::Simple
cthompso@MyBox /Pg-Simple-1.0
$ make
cp Simple.pm blib/lib/Pg/Simple.pm
Manifying blib/man3/Pg.Simple.3
cthompso@MyBox /Pg-Simple-1.0
$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.6.1/c
gwin-multi -I/usr/lib/perl5/5.6.1 test.pl
1..1
Can't locate Pg.pm in @INC (@INC contains: blib/arch blib/lib
/usr/lib/perl5/5.
.1/cygwin-multi /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1
/usr/lib
perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/cy
win-multi /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl .) at
blib/li
/Pg/Simple.pm line 67.
BEGIN failed--compilation aborted at blib/lib/Pg/Simple.pm line 67.
Compilation failed in require at test.pl line 10.
BEGIN failed--compilation aborted at test.pl line 10.
make: *** [test_dynamic] Error 2
cthompso@MyBox /Pg-Simple-1.0
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
| Options | 10 answers | Add comment |
Tuesday, 19 June 2007
|
| iplike.so access denied help!! Faqeer ALI 06:28:44 |
| |
i have installed pgsql8.* on fc3 .. it has installed
well and test was successful.
while installing opennms i run the installer
#./installer -disU.. this lead to ca certain error regarding iplike.so
permission denied.
error message
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: could
not access file
"/root/Desktop/downloadable/opennms-1.2.9-1/source/dist/lib/iplike.so":
Permission denied
at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:298)
at org.opennms.install.Installer.updateIplike(Installer.java:1691)
at org.opennms.install.Installer.install(Installer.java:265)
at org.opennms.install.Installer.main(Installer.java:2450)
plz help me out
ALi
_________________________________________________________________
View Athlete s Collections with Live Search
http://sportmaps.live.com/index.html?source=hmemailtaglinenov06&FORM=MGAC01
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
| Options | 2 answer | Add comment |
Monday, 18 June 2007
|
| CachedRowSet insertion problem with serial PK Rcolmegna@Tiscali.It 12:16:32 |
| | hi,
I'm tring postgresql-8.1-407.jdbc3.jar (with PG 7.4.3 srv) and
CachedRowSet (Sun implementation).
I have a small test table: it has two fields:
1) id SERIAL NOT NULL PRIMARY KEY
2) info VARCHAR(100)
I try this java code:
CachedRowSet rs;
...
rs.setCommand("select id,info from a WHERE id<?");
rs.setInt(1, 10);
...
rs.moveToInsertRow();
rs.setString(2, "zzzz2");
rs.insertRow();
but I obtain this error:
"SQLException: Failed on insert row" (generated from the insertRow()
line).
I sniffed the network-connection betweend DB-srv and JDBC-client, and
I noted that
the INSERT instruction isn't fired against the DB. If I ask if
"isAutoIncrement(<id_idx>)"
I obtain a true reply.
Any idea?
TIA
Roberto Colmegna
La gara più entusiasmante dell'anno!
Gioca e corri alla velocità della luce sui 18 circuiti di Intel Speed Contest 2006!
I più bravi vincono Notebook Sony VAIO, iPod da 60 GB e altro ancora...
Sfida gli amici!
http://intelspeedcontest2006.tiscali.it/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
|
| Options | 2 answer | Add comment |
Tuesday, 5 June 2007
|
| Question Regarding Locks Terry Lee Tucker 18:49:53 |
| | Greetings:
I am working on converting a transportation application from a Progress
database to PostgreSQL. This application will be hammered by about 75 users
at any given time. Also, depending on the operation, there are many record
updates that occur at the trigger level. I would like to be able to provide
feedback to the user when they select a row for update (using SELECT FOR
UPDATE). At present, if the row is being accessed (with SELECT FOR UPDATE) by
another user, the application just sits there waiting. I spent some time
looking at pg_locks hoping to be able to gain information from that table so
as to programically return something to the user. The stuff I read didn't
look promising. The only thing I've been able to come up with is having my
own "lock" table and inserting a row into it containing the table name, the
pid, the oid of the row, the user id, and a time stamp. Of course, I'm
searching lock table entries before selecting for update and reporting a lock
situation to the user if I find anything. I'm just wondering if I can use
some system table or combination of tables to provide the feed back I need.
Does anyone have any ideas about how to accomplish this? I searched the FAQ
and didn't find anything.
PostgreSQL 7.3.6-RH on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-39)
Thanks...
--
Quote: 32
"The world we have created is a product of our thinking. It cannot be
changed without changing our thinking."
--Albert Einstein
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry@esc1.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
| Options | 8 answers | Add comment |
Friday, 1 June 2007
|
| Internal function call from C-language function Zoltan Boszormenyi 10:56:52 |
| | Hi,
I need to call date_part() from a C function.
How to do that?
Thanks in advance,
Zolt n B sz rm nyi
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
| Options | 9 answers | Add comment |
Thursday, 10 May 2007
|
| error codes in postgresql Sandhya 18:38:34 |
| |
Hi,
I want to know ,if there is any way to return error codes/numbers as a return value from the postgresql functions.
For ex:
If i am using my connection function say,
DbConnect(dname,uname,.........)
{
//here i use postgres connection function
pg_conn *conn;
conninfo="dbname=example(dname) user=postgres(uname)";
conn=PQConnectdb(conninfo)
//After connecting i need to create a table..and if the table exists
PQerrormessage(conn) will return error message...
But what i need is ..
Is there any other way of returning error number to my main program.
Can you please tell me how to handle these errors in my application.
I referred posgresql site..I didn't get any clear idea of it.
Any help please......
Thank you...
Regards,
Sandhya R
|
| Options | 5 answers | Add comment |
Wednesday, 2 May 2007
|
| CSS file Nurlan Mukhanov 22:42:45 |
| | Hello!
My name is Nurlan Mukhanov.
3 years ago I have made CSS file for PostgreSQL docs
reading. Can anybody include it in mainstream?
======================CUT START=====================
BODY { font-family : Tahoma; font-size : 8pt; color :
#000033; background: #FFFFFF; }
A:LINK { color : #333366; }
A:HOVER { color : #3333CC;text-decoration :
underline;}
A:VISITED {color : #3366CC;}
HR {size: 1;color: #3366CC;width: 90%;text-align :
center;}
TABLE {font-family: Tahoma;font-size: 8pt;}
h1 {font-family: Tahoma;color: #336600;font-size:
18pt;}
h3 {font-family: Tahoma;color: #339966;font-size:
14pt;border : thin none;}
h2 {font-family: Tahoma;color: #006666;font-size:
16pt;font-weight: bold;}
.ABBREV {color:#993399; font-weight: bold;}
.ABSTRACT {color: #666699; letter-spacing: 3;
margin-left: 18; font-family: Times New
Roman;font-size: 12pt; font-style : italic;}
.ACRONYM {color:#0066CC; font-weight: bold;}
.APPENDIX {}
.APPLICATION {color: #006666; font-family: Courier
New; font-weight: bold; font-size: 9pt}
.ATTRIBUTION {font-family: Arial; color: #003300;
font-size: 8pt; font-weight: bold;}
.AUTHOR {color: #336600; font-weight: bold;}
.BIBLIODIV {text-align: center;}
.BIBLIOENTRY {}
.BIBLIOENTRYBLOCK {}
.BIBLIOGRAPHY {}
.BLOCKQUOTE {}
.BOOK {}
h3.BRIDGEHEAD {color: #5757AC}
.CALLOUTLIST {}
table.CALSTABLE {font-family: Tahoma; font-size: 8pt;
color: #333333; border: #4A4A4A 1px; border-collapse:
collapse; border-style: solid; text-indent : 3px;}
table.CAUTION {background: #FFFFF; align: center;
font-family: Tahoma; font-size: 8pt; color: #FF0000;
border: #FF0000 1px solid; border-color: #FF0000 1px
solid; border-collapse: collapse; border-style: solid;
text-indent : 3px;}
.CHAPTER {}
.CITEREFENTRY {}
.CITETITLE {color: #7777DD; font-family: Times New
Roman;font-size: 12pt; font-style: italic;
font-weight: bold;}
.CLASSNAME {color: #6666FF; font-family: Courier;
font-size: 10pt; font-weight: bold;}
.COMMAND {color: #0033CC;}
.COMPUTEROUTPUT {font-family: Courier New;font-size:
8pt;color: #000066; font-weight: bold;}
.CONFDATES {color: #747474}
.CONFTITLE {color: #669966}
h1.COPYRIGHT {text-align: center;}
h3.CORPAUTHOR {text-align: center;}
.DATABASE {color: #003366; font-weight: bold;}
.EMAIL {color: #996699}
.EMPHASIS {font-weight: bold; font-family: Times New
Roman;font-size: 10pt; font-style: italic; color:
#336699}
.ENVAR {font-family: Arial;font-weight:
bold;font-size: 8pt;color:#990099;}
.ERRORNAME {color:#CC3300;font-weight: bold;}
.EXAMPLE {}
.FIGURE {}
.FILENAME {font-family: Courier;font-size:
10pt;color:#8C4600;font-weight: bold;}
.FIRSTTERM {font-family: Times New Roman;font-size:
10pt; font-style: italic; color: #CC6600;}
.FOOTNOTES {color: #CC0000;}
.FOREIGNPHRASE {font-family: Times New
Roman;font-size: 10pt; font-style: italic; color:
#009148; font-weight: bold;}
.FORMALPARA {}
.FUNCTION {color: #CC3399;font-family: Times New
Roman;font-size: 9pt; font-weight: bold;}
.GUIBUTTON {color: #666633; font-weight: bold;}
.GUILABEL {color: #5E5E00; font-weight: bold;}
.GUIMENU {color: #CC9900; font-weight: bold;}
.GUIMENUITEM {color: #00AA80; font-weight: bold;}
.IMPORTANT {background-color: #FFF2F2}
h2.INDEXDIV {color: #6600FF; font-family: Times New
Roman;font-size: 17pt; font-weight: bold; font-style:
italic;}
.INFORMALEXAMPLE {}
.INFORMALFIGURE {}
.INFORMALTABLE {}
.KEYCAP {color: #FF0066;}
.LEGALNOTICE {border-color: gray 2px solid;}
.LINEANNOTATION {color: #666666; font-family: Times
New Roman;font-size: 10pt; font-weight: bold;}
.LITERAL {font-family: Courier;font-size: 10pt;color:
#6600CC;}
.LITERALLAYOUT {color: #575739;}
.LOT {}
.MEDIAOBJECT {}
.MSG {}
.MSGENTRY {}
.MSGEXPLAN {color: #FF6666;}
.NAVFOOTER {}
.NAVHEADER {}
.NOTE {}
.OPTION {color: #0066FF; font-weight: bold;}
.OPTIONAL {font-family: Times New Roman;font-size:
9pt;font-style: italic; color: #0099CC;}
.PARA {}
.PARAMETER {color: #888844;}
.PART {text-align: left;}
.PARTINTRO {}
.PREFACE {}
.PROCEDURE {}
.PRODUCTNAME {font-weight: bold;}
.PROGRAMLISTING {font-family: Fixedsys; color:
#AF5F5F}
.PROMPT {color: #666699;font-family: Courier
New;font-weight: bold;}
.QUOTE {color: #666699; font-weight: bold;}
.REFENTRY {}
.REFENTRYTITLE {font-weight: bold;}
.REFERENCE {}
.REFNAMEDIV {}
.REFSECT1 {}
.REFSECT2 {}
.REFSECT3 {}
.REFSYNOPSISDIV {}
.REPLACEABLE {font-family: Times New Roman;font-size:
12pt; color: #669999}
.RETURNVALUE {color: #006666;}
.SCREEN {font-family: Fixedsys;color: #000000;}
.SECT1 {}
.SECT2 {}
.SECT3 {}
.SECT4 {}
.SET {}
.SETINDEX {}
.SGMLTAG {color: #009933; Times New Roman;font-size:
10pt; font-weight: bold;}
.STRUCTFIELD {color: #CC0099; Times New
Roman;font-size: 9pt; font-style: italic;}
.STRUCTNAME {color: #0066FF; font-weight:
bold;font-size: 10pt;}
.SUBSTEPS {color: #669900;}
.SYMBOL {color: #339933; font-weight: bold; font-size:
10pt;}
.SYNOPSIS {font-family: Courier;font-size: 10pt;color:
#74744E;}
.SYSTEMITEM {font-weight: bold; color: #FF5959;}
.TABLE {}
.TIP {}
.TITLE {text-align: center;}
.TITLEPAGE {text-align: center;}
.TOC {text-align: left;}
.TOKEN {color: #FF9900; font-weight: bold;}
.TYPE {color: #009900;font-family: Tahoma;font-size :
8pt;font-weight: bold;}
.USERINPUT {font-family: Courier New;font-size:
8pt;color: #666666;}
.VARIABLELIST {}
.VARNAME {color: #009900; font-weight:
bold;font-family: Tahoma;font-size : 8pt;}
=======================CUT END======================
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
|
| Options | 3 answer | Add comment |
Tuesday, 10 April 2007
|
| Performance issue Pascal Van Puymbroeck 17:05:57 |
| | Hi folks,
I would like to solve a strange behaviour I encountered using Postgresql
8.0.1 on windows. Connecting to the database is OK, but when running a
query to the database, its terribly slow. The fact is that I need the
database to be running on the same machine, my application is. So I
connect to either localhost, 127.0.0.1 or 192.168.0.1. Strangly enough
I placed my application on my portable and connected from there to my pc
and now the queries are amazingly fast.
Is this something I can fix by some special setting or is it inevitably,
that connecting locally is punished by a performance slowdown ?
Thanks
Pascal Van Puymbroeck
ZENON productions bvba
---------------------------(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
|
| Options | 43 answer | Add comment |
Saturday, 24 March 2007
|
| Syntax Error Marcel Boscher 03:28:33 |
| | Hey there,
ERROR: function round(double precision, integer, integer) does not exist
Any suggestions
Purpose is to generate a 4 digit errorcode 1st letter alpha - rest numeric
my source code:
DECLARE
chars nchar(26);
charpos INTEGER;
character nchar(4);
nentries INTEGER;
key INTEGER;
BEGIN
chars := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
charpos := Round((random() * (length(chars)-1)), 0, 0);
character := SubString(chars, charpos, 1) ;
nentries := 1;
WHILE (nentries > 0) LOOP
key := trunc(random() * 10000);
SELECT eCode = character + key
SELECT
INTO nentries
count(*)
FROM se_errorcode
WHERE se_errorcode.entry = eCode;
END LOOP;
INSERT
INTO se_errorcode (entry)
VALUES (eCode);
RETURN(eCode);
END;
Thx in advance
Marcel
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
|
| Options | 18 answers | Add comment |
Saturday, 17 March 2007
|
| Slony-I on Windows Ezequias Rodrigues da Rocha 00:05:44 |
| | Hi list,
It is possible to put slony to run on windows ?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda È melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
|
| Options | 3 answer | Add comment |
Monday, 5 March 2007
|
| Corrupted DB - Help Mark Liberman 10:13:26 |
| | Running postgres 8.1.2 on gentoo linux 2.6.14
Server crashed (not sure if due to pg operation). Upon rebooting server and trying to start postgres, get the following log entries:
<4983:2006-07-27 18:04:24 PDT>LOG: database system was interrupted at 2006-07-27 17:58:51 PDT
<4983:2006-07-27 18:04:24 PDT>LOG: checkpoint record is at 2A4/2A23F328
<4983:2006-07-27 18:04:24 PDT>LOG: redo record is at 2A4/2A23F328; undo record is at 0/0; shutdown FALSE
<4983:2006-07-27 18:04:24 PDT>LOG: next transaction ID: 70649528; next OID: 345957
<4983:2006-07-27 18:04:24 PDT>LOG: next MultiXactId: 1742; next MultiXactOffset: 3498
<4983:2006-07-27 18:04:24 PDT>LOG: database system was not properly shut down; automatic recovery in progress
<4983:2006-07-27 18:04:24 PDT>LOG: redo starts at 2A4/2A23F36C
<4983:2006-07-27 18:04:24 PDT>WARNING: could not truncate relation 1663/128873/129263 to 398 blocks: Success
<4984:2006-07-27 18:04:24 PDT>LOG: connection received: host=[local]
<4984:2006-07-27 18:04:24 PDT>FATAL: the database system is starting up
<4981:2006-07-27 18:04:24 PDT>DEBUG: forked new backend, pid=4984 socket=7
<4981:2006-07-27 18:04:24 PDT>DEBUG: server process (PID 4984) exited with exit code 0
<4985:2006-07-27 18:04:25 PDT>LOG: connection received: host=[local]
<4985:2006-07-27 18:04:25 PDT>FATAL: the database system is starting up
<4981:2006-07-27 18:04:25 PDT>DEBUG: forked new backend, pid=4985 socket=7
<4981:2006-07-27 18:04:25 PDT>DEBUG: server process (PID 4985) exited with exit code 0
<4983:2006-07-27 18:04:26 PDT>PANIC: could not open relation 1663/128873/129201: No such file or directory
<4981:2006-07-27 18:04:26 PDT>LOG: startup process (PID 4983) was terminated by signal 6
<4981:2006-07-27 18:04:26 PDT>LOG: aborting startup due to startup process failure
<4982:2006-07-27 18:04:26 PDT>LOG: logger shutting down
The last commmand that I did right before the crash was a vacuum full on a very small table. After it completed, I exited psql, tried a non-pg command and it hung up. Here are the last log entries before the crash:
<1054:2006-07-27 18:00:18 PDT>LOG: statement: vacuum full verbose port_etr_state_offline;
<1054:2006-07-27 18:00:18 PDT>INFO: vacuuming "public.port_etr_state_offline"
<1054:2006-07-27 18:00:18 PDT>INFO: "port_etr_state_offline": found 0 removable, 213 nonremovable row versions in 16 pages
<1054:2006-07-27 18:00:18 PDT>DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 45 to 45 bytes long.
There were 2445 unused item pointers.
Total free space (including removable row versions) is 109896 bytes.
12 pages are or will become empty, including 0 at the end of the table.
16 pages containing 109896 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
<1054:2006-07-27 18:00:18 PDT>INFO: "port_etr_state_offline": moved 213 row versions, truncated 16 to 2 pages
<1054:2006-07-27 18:00:18 PDT>DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
<1054:2006-07-27 18:00:18 PDT>LOG: duration: 16.078 ms
Any way to salvage this db?
Thanks,
Mark
|
| Options | 2 answer | Add comment |
Sunday, 28 January 2007
|
| Change draft gmake control Bruce Momjian 00:38:30 |
| | I had to change the draft flag for SGML from 'gmake draft html' to
'gmake DRAFT=Y html'. Internally the code used to recurse with DRAFT=Y,
but I found there is no way to exit the makefile after the recursion
returned, so I had to use this new syntax. Though more cumbersome, it
is more logical because DRAFT is really a modifier, not a rule itself.
For example, 'gmake html draft' would never have worked. Patch attached
and applied.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
| Options | 8 answers | Add comment |
|
| DROP FUNCTION failure: cache lookup failed for relation X Michael Fuhr 00:38:30 |
| | I've found a situation that causes DROP FUNCTION to fail (tested
in 8.1.6, 8.2.1, and 8.3devel):
CREATE TABLE foo (id integer);
CREATE FUNCTION foofunc() RETURNS trigger AS $$
BEGIN
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
Then in concurrent sessions:
A: BEGIN;
A: CREATE TRIGGER footrig BEFORE INSERT ON foo
FOR EACH ROW EXECUTE PROCEDURE foofunc();
B: DROP TABLE foo; -- blocks pending A's commit
A: COMMIT; -- B's DROP TABLE completes
A: SELECT tgrelid FROM pg_trigger WHERE tgname = 'footrig';
tgrelid
---------
66153
(1 row)
A: DROP FUNCTION foofunc();
ERROR: cache lookup failed for relation 66153
Apparently the row in pg_trigger that A committed wasn't deleted
by B's DROP TABLE, presumably because B didn't have visibility to
to the trigger when its DROP TABLE statement began. This case is
admittedly contrived but I did stumble across it in a test environment.
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
| Options | 2 answer | Add comment |
|
| initdb failure John Wilcher 00:38:30 |
| | Hi!
I received the following error after attempting to initialize the database
within Cygwin.
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in /user/local/pgsql/data/ba
initdb: failed
initdb: removing data directory "/user/local/pgsql/data"
Any help is appreciated. Here is my configuration dump:
$ cygcheck -s
Cygwin Configuration Diagnostics
Current System Time: Fri Aug 06 10:48:18 2004
Windows XP Home Edition Ver 5.1 Build 2600
Path: C:\cygwin\usr\local\bin
C:\cygwin\bin
C:\cygwin\bin
C:\cygwin\usr\X11R6\bin
c:\WINDOWS\system32
c:\WINDOWS
c:\WINDOWS\System32\Wbem
c:\Program Files\PuTTY
c:\java\apache-ant-1.6.1\bin
c:\java\j2sdk1.4.2_04
.\
Output from C:\cygwin\bin\id.exe (nontsec)
UID: 1006(John) GID: 513(None)
513(None)
Output from C:\cygwin\bin\id.exe (ntsec)
UID: 1006(John) GID: 513(None)
0(root) 513(None)
544(Administrators) 545(Users)
SysDir: C:\WINDOWS\System32
WinDir: C:\WINDOWS
HOME = `C:\cygwin\home\John'
MAKE_MODE = `unix'
PWD = `/home/John'
USER = `John'
Use `-r' to scan registry
c: hd NTFS 28576Mb 28% CP CS UN PA FC
d: hd FAT 62Mb 67% CP UN FLASH DISK
e: cd N/A N/A
C:\cygwin / system binmode
C:\cygwin/bin /usr/bin system binmode
C:\cygwin/lib /usr/lib system binmode
. /cygdrive system binmode,cygdrive
Found: C:\cygwin\bin\awk.exe
Found: C:\cygwin\bin\bash.exe
Found: C:\cygwin\bin\cat.exe
Found: C:\cygwin\bin\cp.exe
Not Found: cpp (good!)
Found: C:\cygwin\bin\find.exe
Not Found: gcc
Not Found: gdb
Found: C:\cygwin\bin\grep.exe
Not Found: ld
Found: C:\cygwin\bin\ls.exe
Not Found: make
Found: C:\cygwin\bin\mv.exe
Found: C:\cygwin\bin\rm.exe
Found: C:\cygwin\bin\sed.exe
Found: C:\cygwin\bin\sh.exe
Found: C:\cygwin\bin\tar.exe
61k 2003/08/09 C:\cygwin\bin\cygbz2-1.dll
7k 2003/10/19 C:\cygwin\bin\cygcrypt-0.dll
841k 2004/03/17 C:\cygwin\bin\cygcrypto-0.9.7.dll
45k 2001/04/25 C:\cygwin\bin\cygform5.dll
35k 2002/01/09 C:\cygwin\bin\cygform6.dll
48k 2003/08/09 C:\cygwin\bin\cygform7.dll
28k 2003/07/20 C:\cygwin\bin\cyggdbm-3.dll
30k 2003/08/11 C:\cygwin\bin\cyggdbm-4.dll
19k 2003/03/22 C:\cygwin\bin\cyggdbm.dll
15k 2003/07/20 C:\cygwin\bin\cyggdbm_compat-3.dll
15k 2003/08/11 C:\cygwin\bin\cyggdbm_compat-4.dll
107k 2004/07/06 C:\cygwin\bin\cyggettextlib-0-14-1.dll
17k 2004/07/06 C:\cygwin\bin\cyggettextpo-0.dll
190k 2004/07/06 C:\cygwin\bin\cyggettextsrc-0-14-1.dll
17k 2001/06/28 C:\cygwin\bin\cyghistory4.dll
29k 2003/08/10 C:\cygwin\bin\cyghistory5.dll
991k 2004/07/06 C:\cygwin\bin\cygiconv-2.dll
22k 2001/12/13 C:\cygwin\bin\cygintl-1.dll
37k 2003/08/10 C:\cygwin\bin\cygintl-2.dll
54k 2004/07/06 C:\cygwin\bin\cygintl-3.dll
26k 2001/04/25 C:\cygwin\bin\cygmenu5.dll
20k 2002/01/09 C:\cygwin\bin\cygmenu6.dll
29k 2003/08/09 C:\cygwin\bin\cygmenu7.dll
156k 2001/04/25 C:\cygwin\bin\cygncurses++5.dll
175k 2002/01/09 C:\cygwin\bin\cygncurses++6.dll
226k 2001/04/25 C:\cygwin\bin\cygncurses5.dll
202k 2002/01/09 C:\cygwin\bin\cygncurses6.dll
224k 2003/08/09 C:\cygwin\bin\cygncurses7.dll
15k 2001/04/25 C:\cygwin\bin\cygpanel5.dll
12k 2002/01/09 C:\cygwin\bin\cygpanel6.dll
19k 2003/08/09 C:\cygwin\bin\cygpanel7.dll
62k 2003/12/11 C:\cygwin\bin\cygpcre-0.dll
63k 2003/04/11 C:\cygwin\bin\cygpcre.dll
9k 2003/12/11 C:\cygwin\bin\cygpcreposix-0.dll
61k 2003/04/11 C:\cygwin\bin\cygpcreposix.dll
108k 2001/06/28 C:\cygwin\bin\cygreadline4.dll
148k 2003/08/10 C:\cygwin\bin\cygreadline5.dll
171k 2004/03/17 C:\cygwin\bin\cygssl-0.9.7.dll
61k 2003/12/04 C:\cygwin\bin\cygz.dll
1126k 2004/05/26 C:\cygwin\bin\cygwin1.dll
Cygwin DLL version info:
DLL version: 1.5.10
DLL epoch: 19
DLL bad signal mask: 19005
DLL old termios: 5
DLL malloc env: 28
API major: 0
API minor: 116
Shared data: 4
DLL identifier: cygwin1
Mount registry: 2
Cygnus registry name: Cygnus Solutions
Cygwin registry name: Cygwin
Program options name: Program Options
Cygwin mount registry name: mounts v2
Cygdrive flags: cygdrive flags
Cygdrive prefix: cygdrive prefix
Cygdrive default prefix:
Build date: Tue May 25 22:07:00 EDT 2004
CVS tag: cr-0x5e6
Shared id: cygwin1S4
Cygwin Package Information
Package Version
_update-info-dir 00227-1
ash 20040127-1
base-files 2.6-1
base-passwd 1.1-1
bash 2.05b-16
bzip2 1.0.2-5
crypt 1.1-1
cygrunsrv 1.0-1
cygwin 1.5.10-3
diffutils 2.8.7-1
editrights 1.01-1
fileutils 4.1-2
findutils 4.1.7-4
gawk 3.1.4-3
gdbm 1.8.3-7
grep 2.5-1
groff 1.18.1-2
gzip 1.3.5-1
less 381-1
libbz2_1 1.0.2-5
libgdbm 1.8.0-5
libgdbm-devel 1.8.3-7
libgdbm3 1.8.3-3
libgdbm4 1.8.3-7
libgettextpo0 0.14.1-1
libiconv2 1.9.2-1
libintl1 0.10.40-1
libintl2 0.12.1-3
libintl3 0.14.1-1
libncurses5 5.2-1
libncurses6 5.2-8
libncurses7 5.3-4
libpcre 4.1-1
libpcre0 4.5-1
libreadline4 4.1-2
libreadline5 4.3-5
login 1.9-7
man 1.5k-3
mktemp 1.5-3
ncurses 5.3-4
openssl 0.9.7d-1
postgresql 7.4.3-1
readline 4.3-5
sed 4.0.9-2
sh-utils 2.0.15-4
tar 1.13.25-5
termcap 20021106-2
terminfo 5.3_20030726-1
texinfo 4.2-4
textutils 2.0.21-1
which 1.5-2
zlib 1.2.1-1
Use -h to see help about each section
Thanks!
John Wilcher
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
| Options | 5 answers | Add comment |
|
| [pgsql-patches] Ctid chain following enhancement Pavan Deolasee 00:17:11 |
| |
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
| Options | 3 answer | Add comment |
|
| [pgsql-patches] minor regression test refactor Neil Conway 00:10:18 |
| | I noticed that the "bigcheck" and "bigtest" targets of
src/test/regress/GNUMakefile don't have the right dependencies:
$ make -C src/test/regress clean bigcheck
[...]
make: ./pg_regress: Command not found
make: *** [bigcheck] Error 127
Attached is a patch that fixes this, by making "bigcheck" and "bigtest"
depend on the "all" target. Along the way, I removed some old Makefile
targets that were just aliases for existing targets, and refactored the
code for setting up the tablespace directory to avoid repeating it five
times.
Barring any objections, I'll apply this tomorrow.
-Neil
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
| Options | 1 answer | Add comment |
|
| Re: crash on 8.2 and cvshead - failed to add item to the Stefan Kaltenbrunner 00:03:02 |
| | Gregory Stark wrote: "Joe Conway" <mail@joeconway.com> writes: psql:/home/jconway/pgsql/das_data_load_failure2.sql:419: PANIC: failed to add item to the left sibling for "pk_status_log_2007_01_4_10" Was this preceded by a WARNING? Was the server running with a log_min_messages low enough to log WARNINGs? I probably can't help find the bug but I can see that would be helpful as there are three branches of the code that can result in this and two of them log warnings before returning the invalid offset which causes the panic.
FWIW I can reproduce the crash on 8.2 and I don't get a WARNING either ...
Stefan
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
| Options | 14 answers | Add comment |
|
