[GENERAL] Changing column in a table

1998-06-02 Thread Christoph Lorenz
Hi, what is the _safest_ way to change the data type of a column in a table? (I want to change one column, which is a char into a char(2)). Thank you Christoph -- ** http://ourworld.compuserve.com/homepages/ChLorenz/ ** [EMAIL PROTECTED] ** ** No Spam ! ** No Adverts ! ** No Junk-Mails ! **

Again: [GENERAL] Extending SQL with a C function

1998-06-02 Thread Christoph Lorenz
Hi, I still haven't found it out, so here's my question again: > how can I write a SQL extention in C, which works with "unusual" data > types? > > I've managed to write a c function, which accepts int4 as input parameter > and has got int4 as output parameter. > > My problem now is, that I wa

[GENERAL] ODBC-drv for WinNT 4.0

1998-06-02 Thread Christian Steindl
does anybody know if there is a odbc-drv for win nt 4.0? is anybody developing it? are there other ways to access postgresql-server from a nt 4.0 workstation? best regards Christian Steindl student/TU WIEN

[GENERAL] Resetting connection ...

1998-06-02 Thread Przemyslaw Bak
Hi all, Tell me first if it is correct group for that kind of questions. If it is not tell me which group. So question: what does "resetting connection" mean while loading huge number of data into postgres. I have postgres 6.1 And second question: while migrating from 6.1 to 6.3.2 do I have to

[GENERAL] Loading PDF fiel held on Databases

1998-06-02 Thread Linden
Is it possible to store large image fiel's on a database then select them from a search . If possible, while they are stored on the postgres database can you instigate a search of the text held inside them. my thanks linden

Re: [GENERAL] Loading PDF fiel held on Databases

1998-06-02 Thread David Hartwig
Linden wrote: > Is it possible to store large image fiel's on a database then select > them from a search . > Yes, the database supports large objects. You may need to decide on your client side requirements to make a better judgment. For what its worth ODBC driver supports OLE objects. >

Re: [GENERAL] Re: [HACKERS] custom types and optimization

1998-06-02 Thread Richard Lynch
At 12:12 AM 6/1/98, Bruce Momjian wrote: >Users, we need to hear from you on this, and why you chose to use >PostgreSQL. We don't need people foaming at the mouth, but we do need >our users to give use good visibility and publicity. I'm using pgsql because that's what my ISP has, and I'm having

[GENERAL] Hey Bruce

1998-06-02 Thread Tom Good
> At 12:12 AM 6/1/98, Bruce Momjian wrote: > > Users, we need to hear from you on this, and why you chose to use > PostgreSQL. We don't need people foaming at the mouth, but we do need > our users to give use good visibility and publicity. Bruce, I'm looking to deploy PostgreSQL in a real envi

[GENERAL] Graphical database maintenence design tool

1998-06-02 Thread Peter Cordone
I am new to Postgres and somewhat new to Linux and Unix. I am trying to find a graphical tool that I can use to do my database table design, in XWindows or one that I can run in Microsoft Windows NT over my network. Can anyone suggest anything?

[GENERAL] ODBC driver

1998-06-02 Thread Peter Cordone
I downloaded and installed the ODBC driver for Postgres. I have a linux box on the network and the postgres server is running on it. I am trying to connect to the sample database mydb from a Windows NT ver 4.0 machine though ODBC with C++ Builders BDE. I get the following errors: Unknown user

[GENERAL] Parametrized Types

1998-06-02 Thread mmc
I wonder if I could make parametrized types: * complex numbers with a certain precision * cities or countries ... types --- strings would be stored in another table The problem is that the inpu/output functions accept only the value. I would like postgres to Communicate an optional value s

Re: [GENERAL] ODBC driver

1998-06-02 Thread Kevin Heflin
On Tue, 2 Jun 1998, Brett W. McCoy wrote: > Did you create a Postgres user with the 'createuser' tool (usually run by > the postgres superuser (but not root))? This allows designated users to > use postgresql databases, and in some cases, create and destroy and even > set database permissions fo

Re: [GENERAL] ODBC driver

1998-06-02 Thread Brett W. McCoy
On Tue, 2 Jun 1998, Kevin Heflin wrote: > > Did you create a Postgres user with the 'createuser' tool (usually run by > > the postgres superuser (but not root))? This allows designated users to > > use postgresql databases, and in some cases, create and destroy and even > > set database permissi