понедельник, 13 февраля 2006 г.
|
| This doesn't help. How many databases am I using when... Guest 18:24:39 |
| | This doesn't help. How many databases am I using when searching on google? |
| | Add comment |
четверг, 19 января 2006 г.
|
| Dear Markus,I am dealing with a similar problem. I have a... Guest 23:25:19 |
| | Dear Markus,I am dealing with a similar problem. I have a PostgresSQL 8.0 with a PostGIS version 0.9 ("0.9 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"). Both versions run under Windows. I want to migrate {censored} to a PostgreSQL 8.1 with PostGIS version 1.0("1.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1") but it seems almost impossible for me.
I don't understand your instructions
"- create new database. ". Ok, it is simple.
"- install postgis into database, including spatial_ref_sys.sql.". Ok.
"- install the schema dump via postgis_restore.pl". How can I do this?. I made a pg_dump -Fc of the old data base with the old psql. What do you mean:"only the schema"?. Under windows additionally, I found an error associated with user password in the Perl script so it can not access to psql. Literally, it does not allow me to type the right password at the third step. The script create the database and also install pgsql language but then fail!.
"- install the geometry_columns dump (and manually drop the obsolete
columns afterwards)." How can I install only the geometry ?
"- install all other dumps via psql. " What all other dumps?
Please, can you help me? Thanks in advance an best regards.
Mario |
| | Add comment |
понедельник, 16 января 2006 г.
|
Problem encounter for checking data from database before continues with command.  dav tan 04:55:17 |
| | hi all, just wonder anyone can help to solve my problem here. I'm a new user here trying to use my CGI and DBI script to allow my system to check on the detail before allowing the user to login to the page... I can connect the my CGI to the web, and getting information from DBI, but when i add both code together, error occur. So hope if anyone can help me to solve the problem. Thank you
below is my code...
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
use CGI qw standard);
use DBD::Pg;
$name = ("name");
$password = ("password");
my ($sth_p, $dbh_p, @info);
print "contents-type: text/html\n\n";
if(($name)&&($password ))
{
&Validate;
}
else{
print "Error, please Enter a Login.";
}
Sub Validate{
if($name= ~m/['\$\\"';&...+%<>*|? #{}~!]/||
$password= ~m/['\$\\"';&...+%<>*|?#{}~!]/)
{ &Error;
}
else{
&Login;
}
}sub Login
{
#Driver #Database #Host #username #password
my $dbh_p=DBI->connect("DBI g amian:h152.226.140.234", "dbname=dbcumedia","mediacorp","")
my $sth_p= $dbh_p->prepare("SELECT * FROM login");
$sth_p->execute();
while(my @ login=$sth_p->fetchrow_array())
{push (@info,$Login[1]);
push (@info,$Login[2]);
}
$sth_p->finish();
if($info[0] eq "$name" && $info[1] eq "$password")
{
print "Login success.\n";
}
else{
print "Login Failed.\n";}
}
Sub Error{
print "You entered an illegal character.\n";
}
<html>
<head>
<title>Login</title>
</head>
<FORM action="http://152.226.140.234/~dabscheduler/cgi-bin/test1.pl" method="GET">
<DIV><div style="position: absolute; top:-1px; left:0px;"><IMG align=baseline border=0 hspace=0 src="file:/home/dabscheduler/Desktop/new5.jpg"></DIV>
<br>
<br><br><br><br><br><br>
<div style="position: absolute; top:100px; left:600px;">
<div align="center"><h2><strong><u>Login</u></strong></h2></div>
<br>
<br><br>
<form method="post" action="http://h152.226.140.234/dabscheduler/public_html/cgi-bin/" method="GET">
<div align="center"><sup> <font color="#ffffff">User ID</sup>
<BR><INPUT class="form_join_text" type="text" name="name" value="name" size="20" maxlength="20">
</TD>
</tr><br><tr>
<TD class="join_form_right" width="130"><font color="#ffffff"><sup>Password</sup></TD>
<BR><INPUT class="form_join_text" type="password" maxLength="16" value name="password" size="16"></TD>
</tr><br><br><INPUT type="submit" checked>
<INPUT type="reset" checked name="cancel"></div>
</form>
</Html> |
| | Add comment |
понедельник, 19 декабря 2005 г.
|
| I have a homework porblem: there is a trapozoid and you... Guest 02:50:19 |
| | I have a homework porblem: there is a trapozoid and you have to fine x...the top left corner is 109 degrees bottom left is 71 degrees bottom right is 68 degrees and top right is x...what does x =? |
| | Add comment |
среда, 9 ноября 2005 г.
|
| i think tht every 1 should get it Guest 04:13:01 |
| | i think tht every 1 should get it |
| | Add comment |
среда, 26 октября 2005 г.
|
| how do you enter data in to a computer? Guest 22:46:32 |
| | how do you enter data in to a computer? |
| | Add comment |
вторник, 13 сентября 2005 г.
|
| I need a script to try out for a play in school! You are my... Guest 23:42:54 |
| | I need a script to try out for a play in school! You are my only hope to making it!! Everything else is all bull! |
| | Add comment |
четверг, 1 сентября 2005 г.
|
| what is a field type Guest 18:07:52 |
| | what is a field type |
| | Add comment |
воскресенье, 14 августа 2005 г.
|
| Vacuuming on database archita 14:48:57 |
| | If I do a vacuum on database or tabel periodically without enabling stat_starts_collector, does it affect the performance of the database. |
| | Add comment |
вторник, 9 августа 2005 г.
|
| if my program just can insert number when loop.How to fix... Guest 13:22:31 |
| | if my program just can insert number when loop.How to fix the problem when a user insert a letter to my program????? |
| | Add comment |
|
| If you are looking for SQLServer2000 then sp_help command... Guest 12:25:50 |
| | If you are looking for SQLServer2000 then sp_help command will describe the table.
Ex: sp_help tablename
KrishnaMohan |
| | Add comment |
вторник, 19 июля 2005 г.
|
| I have the same problem. Any answer to it. Thanks. -Kelvin Guest 23:12:12 |
| | I have the same problem. Any answer to it. Thanks. -Kelvin |
| | Add comment |
четверг, 14 июля 2005 г.
|
| I am a prinsipiante but gustaria to know to me that type of... Guest 19:54:46 |
| | I am a prinsipiante but gustaria to know to me that type of Windows I need for you install Postgre 7,3,4 or that she programs he is necesari to install it. Thank you very much by his antencion. |
| | Add comment |
понедельник, 27 июня 2005 г.
|
| Moving the database to another drive Guest 18:32:51 |
| | I am using a Windows 2003 server and I'm trying to figure out how to move the entire database from the C drive to the D drive. Does anyone know how I can do this without error? |
| | Add comment |
воскресенье, 19 июня 2005 г.
четверг, 21 апреля 2005 г.
|
| Hi Michael, I am facing the same problem. Did you get any... Guest 19:41:57 |
| | Hi Michael, I am facing the same problem. Did you get any answer or solution to this problem? |
| |  1 answer | Add comment |
|
