Is the EXECUTE command supported in v 7.0.3 or is that new in 7.1?
Wade Oberpriller
Hello,
I've noticed a bug if pg_ctl. If you do the following:
pg_ctl -w -D $PGSQL/data -o '-p 1' start;
The pg_ctl script will loop doing a 'psql -l' to connect to the postmaster
process on port 5432 (but postmaster is using 1 in this case). The
pg_ctl script should take the port number
Hello,
I am using PostgreSQL v7.0.2. I compiled myself with gcc/g++ v2.7.2.2 on
Solaris 2.5.1. In libpq++, I get compiler warnings complaining that
namespaces are mostly broken in this version of g++. When I attempt to run a
piece of client code that was linked with libpq++.so, I get a symbol re
Hello,
I have a script with the following code:
$(PGSQL)/bin/pg_ctl -D $(PGSQL)/data start ;\
$(PGSQL)/bin/createlang -L $(PGSQL)/lib plpgsql template1
Sometimes I get an error from createlang, and it appears that postmaster
has not completely been started and is not ready to ac
Hello,
I want to be able to do an initdb on a build machine and then copy this new
database to a production machine and run with it. One thing I have noticed is
that initdb needs an absolute path, so if I copy the database it needs to
reside in an identical location as where it was initialized.
You should be able to do the following:
CREATE TABLE table1 (
field1 INTEGER CHECK ((field1 >= 0) AND (field1 <= 10))
);
Wade Oberpriller
>
> Hi,
> how should I write a constraint that can keep an INT field with values
> between 0 and 10? Do I have to use two checks on the same field?
>
This requires you to change NAMEDATALEN in src/include/postgres_ext.h.
Note this requires a recompile, initdb, createdb, etc.
Also note that databases with different NAMEDATALEN's can't interoperate.
Wade
>
> Hello,
>
> Looking at the docs for pgsql I have only found stuff on altering a table
623
for <[EMAIL PROTECTED]>; Thu, 26 Oct 2000 15:49:38 -0400
Message-ID: <001901c03f85$79a17ac0$330a0a0a@6014cwpza006>
From: "Adam Lang" <[EMAIL PROTECTED]>
To: "Wade D. Oberpriller" <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject:
You must use initlocation to initialize the location and have the path to the
location in an environment variable before postmaster is started.
For example:
> setenv PGDATA2 /home/someuser/data
> initlocation 'PGDATA2'
> pg_ctl -D /home/pgsql/data start
> createdb mydb -D 'PGDATA2'
This will st
Hello all,
I posted this query a while ago, but I might have missed the response, so here
goes again.
Is there any good documentation on the PL/PGSQL language? Like the complete
grammar and syntax? I have read the user's and programmer's manuals and all
they include is a few examples (hardly eno
Hello all,
I was wondering if PostgreSQL protects itself when executing user-defined
functions? Or does it go under the assumption that all user-defined functions
will NOT crash (if they do you have a serious problem and need to fix the
function)?
We are building an app where we want 3rd partie
Hello,
Is it possible to restrict the number of entries in a table? I have attempted
to write a check like so:
CREATE TABLE mytable (
id integer NOT NULL,
CHECK (COUNT(id) <= 10)
);
This is not allowed, I get an error saying:
ERROR: Exec
Can the max size of the tuples be enlarged, currently they are 8128 bytes ( I
believe). Is there a macro or option that can be set to increase this?
I have a table with quite a few constraints (and the field names are large also), and
the tuple size is being exceeded, and the table can't be crea
That was it! Thanks alot.
Wade Oberpriller
StorageTek
[EMAIL PROTECTED]
>
> [EMAIL PROTECTED] (Wade D. Oberpriller) writes:
> > Once I attempt to install, I get errors that look like:
>
> > gmake[2]: Entering directory
>`/home/anubis22/oberpwd/postgresql-7.0.2/src/b
>
> [EMAIL PROTECTED] (Wade D. Oberpriller) writes:
> > Once I attempt to install, I get errors that look like:
>
> > gmake[2]: Entering directory
>`/home/anubis22/oberpwd/postgresql-7.0.2/src/backend/access'
> > gmake -C common postgres/usr/X11R6
>
>
15 matches
Mail list logo
