 |
| Recent blog posts: | |
 |
| They have birthday today: | |
 |
| Forums: | | |
 |
| Discuss: | |
 |
| Recent forum topics: | |
 |
| Recent forum comments: | |
 |
| Модератор: | |
 |
Tuesday, 22 July 2008
|
| Recordset problem Jean-Baptiste ESTIVAL 21:38:53 |
| | Hello, I can't use recordset.addnew in VB6 with postgreodbc the current connection is OK, the recordset is opened as dynamic, like the exemple given on the odbc site. So, if anyone have a solution, Regards, JiB
|
| | 14 answers | Add comment |
Tuesday, 1 July 2008
|
| Is there an ODBC driver available for Windows 2003 64-bit Regina Obe 09:31:32 |
| | I'm moivng over SQL Server 2000 32-bit databases over to SQL Server 2005 64-bit and ran into a small problem. In the old setup, I had a linked server configuration to a Postgresql server which used the 32-bit driver. In the new setup, the SQL Server 2005 64-bit can't see the 32-bit drivers (unless I run in 32-bit mode) and I don't think its possible for it to since its runing in 64-bit SQL Server. So I'm guessing I need to get a 64-bit PostGreSQL ODBC driver, somehow get the pgsql .NET driver to be seen as an option, or possibly the 32-bit. Thanks, Regina
----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
|
| | 1 answer | Add comment |
Saturday, 21 June 2008
|
| phpPgAdmin on Debian Sarge John Hedge 08:34:11 |
| | Hi,
Can someone point me at a 'howto' install phpPgAdmin from the point where I've apt-get install phpPgAdmin and dependencies (Apache etc.), please?
All I get for http://192.168.3.22/phpPgAdmin/index.php is:
Not Found
The requested URL /phpPgAdmin/index.php was not found on this server. ------------------------------ Apache/2.0.55 (Debian) Server at 192.168.3.22 Port 80 TIA
John
|
| | 1 answer | Add comment |
Tuesday, 17 June 2008
|
| error codes in postgresql Sandhya 19:32:12 |
| |
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
|
| | 7 answers | Add comment |
Saturday, 24 May 2008
|
| Really stupid question(?) Bear Giles 12:05:58 |
| | I've been giving a lot of thought to some of the questions raised by my SSL patch, and have both a conclusion and a really stupid question.
First, the conclusion is that what I'm working on is "secure sessions." As I mentioned before, that's not just encryption (e.g., SSH tunnels), but the combination of confidentiality (encryption), message integrity and endpoint authentication. This is what people think you mean when you say an application "supports" Kerberos or SSL, and it's what's required for really sensitive information.
(E.g., nobody cares that the data was encrypted if the confidential information supporting a search warrant went to the bad guys instead of directly to the central police database. The snitch is still dead, and the evidence destroyed.)
The latest SSL patches will be out by this weekend, and I hope to add GSS-API (which includes Kerberos 5) soon afterwards. Both will publish their endpoint authentication information (X509 structure and strings containing subject and issuer distinguished names, string containing Kerberos principal name), and the HBA code can then use this information for PostgreSQL authentication.
...
The really stupid question refers to some of the hardcoded fallback values in this code. The reason for having hardcoded values is to prevent "downgrade" attacks - you don't want to casually override the DBA, but you also don't want to make it easy for a knowledgeable attacker to fatally compromise the system in a way that your average DBA couldn't catch.
But the problem is that knowledgeable security administrators can replace the common hardcoded values with their own. How do you allow this to be easily done?
One possibility that occured to me was that dynamic libraries would handle this nicely. There's even some support for dynamic libraries in the user-defined functions, so this wouldn't be a totally unprecedented idea.
But this would be a new way of using dynamic libraries. Is this something everyone is comfortable with, or is it problematic for some reason? Or is this premature - maybe the first release should just use hardcoded values with a note to contact individuals if there's an interest in a dynamic library approach?
Bear
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
|
| | 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
|
| | 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
|
| | 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
|
| | 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
|
| | 2 answer | 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)
|
| | 16 answers | 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
|
| | 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
|
| | 8 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
|
| | 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
|
| | 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)
|
| | 18 answers | 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
|
| | 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
|
| | 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
|
| | 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
|
| | 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
|
| | 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
|
| | 1 answer | Add comment |
|
|