[GENERAL] Changing column in a table
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 ! ** No unwanted Mails ! **
Again: [GENERAL] Extending SQL with a C function
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 want to use a char(10) as input parameter, since > the input for that function is a colum, which is a char(10) type. > How do I do this? > > (In the manuals, it is said, one should create an own data type in C - I've > already done this, called it "char10", but of course, I cannot use this > data type in SQL...) > Thank you very much Christoph -- ** http://ourworld.compuserve.com/homepages/ChLorenz/ ** [EMAIL PROTECTED] ** ** No Spam ! ** No Adverts ! ** No Junk-Mails ! ** No unwanted Mails ! **
[GENERAL] ODBC-drv for WinNT 4.0
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 ...
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 dump my database using tools from 6.3.2 or I can use tools from 6.1 ? thanx przemol
[GENERAL] Loading PDF fiel held on Databases
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
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. > If possible, while they are stored on the postgres database can you > instigate a search of the text held inside them. > It does sound a bit tricky, but you could create your own functions to accomplish this.
Re: [GENERAL] Re: [HACKERS] custom types and optimization
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 enough trouble getting a compatible php compiled (since my ISP won't let me compile) that I wouldn't even want to think about trying to get a backend *AND* frontend compiled. That said... The more you can do to make the installation/upgade process easier for a Unix sysadmin who probably isn't all that familiar with pgsql, the better. There are lots of ISPs out there that want to offer more bullet points to potential customers, and most of them are smart enough not to offer something they don't really know how to support. Perhaps a really low-valume mailing list specifically for ISP managers would be an inducement. And training in PostgreSQL for ISPs to ramp up would be a boon. In my limited experience, most ISPs are so overloaded trying to keep their hardware alive and staying up-to-date on the networking software they already support, that adding a new package is extremely tough. Anything pgsql developers can do to significantly lower that acquisition curve would be good. -- -- -- "TANSTAAFL" Rich [EMAIL PROTECTED]
[GENERAL] Hey Bruce
> 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 environment (well, if one considers Psychiatry a real environment ;-) The tentative go-live date is 01 OCT 1998. I am replacing UnixWare 2.1.2 and Progress 7.3A09 with Slackware 3.4, PostgreSQL 6.3.2 (or 6.4 ;-) and Perl 5.004. Why? $8k for 25 users/1 developer for PROGRESS. And they adamantly refuse to port to Linux. (And I've had enough of SCO...) But it's not just money. Progress (at least version 7) only supports 2 of the 3 SQL subsets (they have a proprietary interface that replaces DCL, oh, and you can't use the 4GL on tables created by SQL DDL.) And Progress only adheres to the 1989 ANSI std (ouch). I know alot of Progress users who hesitate to jump ship (despite no great love for Progress' prices and clumsy account adminstration) due to fondness for the 4GL. Edmund Mergl has solved that problem. DBI::DBD-Pg makes Perl into a virtual 4GL. (Bad pun intended.) And of course, Michael Meskes is creating a valuable tool in ecpg. libpq eludes me but perl is cake. And so I can have my great engine and a nice (and very portable) interface. BTW, I am an exhibitor at PC Expo at the Javitts Centre the week of 15 June - if you want any literature dispensed. Incidentally, I will be tabling with a partner organization: The National Cristina Foundation. We are both non-profits and are going to PC Expo to solicit donated hardware...so we have no problem with supporting another dot-org. Cheers, Tom === User Guide Dog Database Project === Project Coordinator: Peter J. Puckall <[EMAIL PROTECTED]> Programmers: C/Perl: Paul Anderson <[EMAIL PROTECTED]> SQL/Perl:Tom Good <[EMAIL PROTECTED]> HTML:Chris House <[EMAIL PROTECTED]> SQL/Perl:Phil R. Lawrence <[EMAIL PROTECTED]> Perl:Mike List <[EMAIL PROTECTED]> Progress 4GL:Robert March <[EMAIL PROTECTED]> === Powered by PostgreSQL 6.3.2 // DBI-0.91::DBD-PG-0.69 // Perl5 ===
[GENERAL] Graphical database maintenence design tool
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
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 name or password. Failed to authenticate client as Postgres user 'pcordone' using : be_recvauth: unrecognized message type: 65536 Alias: PostgreSQL Can anyone help me?
[GENERAL] Parametrized Types
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 stored in pg_types ... a new field. Is that easy; where to start ?? PS: I am working on a "system" to co-operate with Emacs-widget library to permit a comfortable editing of records. If interested mail me.
Re: [GENERAL] ODBC driver
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 for other users. Also, don't you have to set up Postgres to accept users from another machine.. I forget exactly where you do that. Kevin Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net
Re: [GENERAL] ODBC driver
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 permissions for other users. > > Also, don't you have to set up Postgres to accept users from another > machine.. I forget exactly where you do that. That'd be the pg_hba.conf file, and you can set up everything from IP based authentication to password authentication. Brett W. McCoy http://www.lan2wan.com/~bmccoy/ --- "The number of UNIX installations has grown to 10, with more expected." -- The UNIX Programmer's Manual, 2nd Edition, June, 1972
