On Thu, Jul 26, 2001 at 05:02:30AM -, Dr. Evil wrote:
> file that PG uses would be fantastic. Some of us are storing some
> valuable data in these things, and basically none of the free OSes
> support file system encryption in a way that doesn't suck. I know
> everyone will say, "do it at th
They are both the same, as far as I know. I usually make my table
definition file like this:
DROP SEQUENCE mytable_number_seq;
DROP TABLE mytable;
CREATE TABLE mytable (
number SERIAL
);
---(end of broadcast)---
TIP 1: subscribe and unsub
When creating an incremental and unique id, what are the benefits of using:
CREATE TABLE tablename (colname SERIAL);
instead of :
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename
(colname integer DEFAULT nextval('tablename_colname_seq');
CREATE UNIQUE INDEX tablename_colname_ke
I'm writing an application that requires cryptographicly-sound random
decimal digits in PG. One way to do this is with a plain old hash
like SHA1. The problem is that this produces a 20 byte string, when
what I want is a digit from 0 to 9. One thing I could do is take this
20 byte string, and
Call phpinfo() and see if you have postgres support compiled into
php. This would cause your error.
Good Luck!
-r
At 04:13 PM 7/26/01 +1200, Mike C wrote:
Hello,
Err message within a
browser(http://its-macman.otago.ac.nz/~mike/index.php) =
Fatal error: Call to
undefined function: pg_connec
Title: php error
Hello,
Err message within a
browser(http://its-macman.otago.ac.nz/~mike/index.php) =
Fatal
error: Call to undefined function: pg_connect() in
/Users/mike/Sites/index.php on line 2
Actual code in php file =
$connection = pg_connect("host=its-macman.otago.ac.nz
dbname=ontheweb
