> Here's your problem: user1 has the same userid as pgsql. this
> used to happen in 7.0, I think. Is that what you're running?
I'm sure it's what I used to be running. I am running this now:
postgresql-7.1.2_2
according to FreeBSD ports.
> As to fixing it - have you created a lot of db objects
how come you can not alter a table and add a primary key after the
table has been created?
(or at least i can't seem to)
mydb=> alter table actions add primary key (action);
ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented for that
constraint type.
any suggestions?
---
Here's the error message:
---
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
connection to server was lost
vacuumdb: vacuum failed
Does any one know what is causing this problem
At 10:43 PM 12/2/2001 , [EMAIL PROTECTED] wrote:
>Can anyone advise me on running postgres and php on a WinNT box with IIS?
I believe there are Windows versions of both PostgreSQL and PHP.
> I found cygwin, does it work and is that the only solution?
Cygwin =does= work. Quite well, too.
On 30 Nov 2001 10:52:26 -0800, Tony Reina <[EMAIL PROTECTED]> wrote:
> I seem to remember a psql option that dumped out the table schema. I
> can't seem to find it in the man for psql. Could someone point out the
> option to me?
>
In psql \? is your friend.
Probably what you want is \d tableNam
Hello.
Is there a way to configure postgres so that the connection doesn't check
the username as case sensitive. It's kind of anoying for window users.
Ligia
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appro
[EMAIL PROTECTED] (Jodi Kanter) writes:
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_00D1_01C17CBA.DEDC5EF0
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I am trying to connect to postgres via ODBC so that I can use
Hi!
I am running postgreSQL 7.1.3 on a HP-UX 10.20 box. I have a problem telling
postgres which time zone to use. I want to use WETDST, but no matter what I
do, postgres is off with 5 hours.
I have tried to set the time zone in the script that starts postgres
TZ=WETDST
export TZ
I also came ac
Well, a while ago I set up postgresql and have been using it for a small
database ever since. I'm now looking at local authentication and
permissions and a number of questions have come up. When I run select *
from pg_database, I get this:
datname | datdba | encoding | datistemplate |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello:
I have a PostgreSQL 7.1.3 system which is accessed from an Apache CGI
handler via ODBC (driven by libiodbc-3.0.5). It has worked very well, but
on two occasions queries just stop working.
The Apache error log shows:
Unknown error;
Unexp
On 3 Dec 2001, jason wrote:
> how come you can not alter a table and add a primary key after the
> table has been created?
Because it wasn't implemented for that constraint type ;) (I
think it'll work in at least some cases for 7.2)?
> any suggestions?
Check the archives for 7.1 and earlier wo
On Wed, 5 Dec 2001, Yanek Korff wrote:
> here's pg_user:
> usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
> passwd | valuntil
> +--+-+--+--+---+
> --+--
> pgsql | 72 | t | t
On Thu, Dec 06, 2001 at 01:32:56PM -0500, Yanek Korff wrote:
> > Here's your problem: user1 has the same userid as pgsql. this
> > used to happen in 7.0, I think. Is that what you're running?
> I'm sure it's what I used to be running. I am running this now:
> postgresql-7.1.2_2
> according to Fr
13 matches
Mail list logo
