[GENERAL] serial type

1999-09-27 Thread Greg Beams
I'm trying to create a table as such: create table comment (rec_id serial, locale varchar(50), ...) It creates correctly, telling me that it will create an implicit sequence for the serial column, and an implicit index for the table. But, when I try to insert a record into the database (withou

Re: [GENERAL] Solaris 7 x86 error

1999-09-27 Thread myers
On Tue, 28 Sep 1999, Bruce Momjian wrote: > See Solaris FAQ on web site. That is newer. Doesn't help -- at least, assuming you meant item 1.3 in that FAQ. I've varied the shared memory settings from four megabytes to over 200. I still get the same error. I wonder if something changed for

Re: [GENERAL] Solaris 7 x86 error

1999-09-27 Thread Bruce Momjian
See Solaris FAQ on web site. That is newer. > > > Folks: > > I get the following errors when trying to start up Postgres ('postmaster > -S') on a Solaris 7 x86 machine: > > IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120, > permission=700 > IpcMemoryIdGet: shmget fa

[GENERAL] Solaris 7 x86 error

1999-09-27 Thread myers
Folks: I get the following errors when trying to start up Postgres ('postmaster -S') on a Solaris 7 x86 machine: IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120, permission=700 IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010, size=120, permission=

Re: [GENERAL] ERROR: nodeRead: Bad type 0

1999-09-27 Thread Bruce Momjian
There is a TODO item: * Views with spaces in view name fail when referenced > > I have a similar problem, i think it worked with previous postrgesql versions (6.4.x) > when i typed: > > > > [marn@mi marn]$ createdb pr > [marn@mi marn]$ psql pr > Welcome to the

Re: [GENERAL] \d command

1999-09-27 Thread Rodney McDuff
HI Mark > I want to be able to build up information about the different tables held > in a database for a small diagnostic tool that I'm writing. > > I need to see the name of each column in the table, the column data type > and size, and if nulls are allowed - essentially what is produced by the

Re: [GENERAL] ERROR: nodeRead: Bad type 0

1999-09-27 Thread Marcin Inkielman
I have a similar problem, i think it worked with previous postrgesql versions (6.4.x) when i typed: [marn@mi marn]$ createdb pr [marn@mi marn]$ psql pr Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL [P

[GENERAL] Finding info on database users

1999-09-27 Thread Jason Farnsworth
Hello.. I'm fairly new to Postgres but have it mostly figured out. I'm just having a hard time finding any documentation that covers how to manage database users and set their permissions? ANybody have a URL or anything to point me to? Thanks.. Jason Farnsworth Northstar Digital

Re: [GENERAL] libpq on win32 & postgresql on linux

1999-09-27 Thread Keith G. Murphy
Otavio Exel wrote: > > hello list, > > note: postgres-newbie here! Me, too, pretty much. > > I have: > - a linux box with postgresql 6.3.2 installed; > - a win95 box with postgresql-win32-client-6.4.2 (from > ftp://ftp.postgresql.org) installed; > > the win32 client can't connect due to a

Re: [GENERAL] psql 6.3.2 for win32

1999-09-27 Thread Otavio Exel
Peter Mount wrote: > > PS: About 6 months ago (may be longer, I can't remember) for the TASS > project I compiled a standalone psql.exe (aka a Win32 version of the > psql client). Several people found it useful, and they only needed the > exe and the dll. sorry for branching the thread but I'm af

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Ted Nolan SRI Augusta GA
In message <[EMAIL PROTECTED]>you write: >> Bruce, >> >> As I am not going to be able to help on the coding I won't try to >> comment on it's dificulty. >> >> But I will ask what realistic expectations are for the current NT port >> using cgywin. My current concern is that the installation is ve

Re: [GENERAL] backend crashing with INTERSECT / ORDER BY

1999-09-27 Thread Bruce Momjian
> > So I tried INTERSECT with ORDER BY and it crashes on 6.5 and 6.5.1: > > [csmaster@kamet release0]$ psql cs1 > Welcome to the POSTGRESQL interactive sql monitor: > Please read the file COPYRIGHT for copyright terms of POSTGRESQL > [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Peter Mount
On Mon, 27 Sep 1999, David Warnock wrote: > Bruce, > > As I am not going to be able to help on the coding I won't try to > comment on it's dificulty. > > But I will ask what realistic expectations are for the current NT port > using cgywin. My current concern is that the installation is very >

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Bruce Momjian
> Bruce, > > As I am not going to be able to help on the coding I won't try to > comment on it's dificulty. > > But I will ask what realistic expectations are for the current NT port > using cgywin. My current concern is that the installation is very > complex and the useability is poor due to t

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread David Warnock
Bruce, As I am not going to be able to help on the coding I won't try to comment on it's dificulty. But I will ask what realistic expectations are for the current NT port using cgywin. My current concern is that the installation is very complex and the useability is poor due to the need to enter

[GENERAL] Re: [PORTS] ipc-daemon runs wild on NT?

1999-09-27 Thread Ted Nolan SRI Augusta GA
In message <[EMAIL PROTECTED]>you write: >Hello folks, > >I'm running 6.5.1 on NT. I think I've applied all the patches to the >ipc-daaemon, but after a while it starts hogging the CPU, even when no >queries of any sort are being made (although there is a postmaster present). >Reducing the priori

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Ted Nolan SRI Augusta GA
In message <[EMAIL PROTECTED]>yo u write: >Hello, > >My company is pretty impressed with postgre on unix, but we also need a >native port for nt (it is not an option to have our customers install cygwin >on their production systems.) Ideally we would like to see the backend >running as a native s

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Bruce Momjian
> Yeah, > > That is pretty much the short of it. My greatest concern undertaking an > effort like this is the resultant #ifdef/#else/#endif mess that I will need > to make of the code. We do a lot of cross-platform development here and > ultimately the code begins to look very ugly to anything

Re: [GENERAL] ERROR: nodeRead: Bad type 0

1999-09-27 Thread amy cheng
the problem is that I can not even dump! also, our system admin just upgrade the OS (linux5.x -> 6.x). thanks amy >From: Aaron Holtz <[EMAIL PROTECTED]> >To: amy cheng <[EMAIL PROTECTED]> >Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0 >Date: Mon, 27 Sep 1999 12:55:00 -0400 (EDT) > >Been the

RE: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread David Heinecke
Yeah, That is pretty much the short of it. My greatest concern undertaking an effort like this is the resultant #ifdef/#else/#endif mess that I will need to make of the code. We do a lot of cross-platform development here and ultimately the code begins to look very ugly to anything except a pre

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Bruce Momjian
> David, > > We could definately use this as we have very similar problems. We would > love to be able to support Win 9x as well. > > If you decide to do this then I will provide from our company least some > time by one or two people to test and help in non coding ways (we have > no c skills).

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread Bruce Momjian
> Hello, > > My company is pretty impressed with postgre on unix, but we also need a > native port for nt (it is not an option to have our customers install cygwin > on their production systems.) Ideally we would like to see the backend > running as a native service under nt. We have the resour

Re: [GENERAL] Anyone doing a native NT port?

1999-09-27 Thread David Warnock
David, We could definately use this as we have very similar problems. We would love to be able to support Win 9x as well. If you decide to do this then I will provide from our company least some time by one or two people to test and help in non coding ways (we have no c skills). Regards Dave

Re: [GENERAL] netmask

1999-09-27 Thread Bruce Momjian
As I mentioned I already applied it. > Hello! > > I think this is a bug. But it's said not to report any bugs unless you're > sure that it's a bug, so I'm asking heer is this a bug? > > template1=> select netmask('10.0.0.1/0'); > netmask > --- > 255.255.255.255 > (1 row) >