| General PostgreSQL Topics (view all ...) | Last Post | Replies |
|
| convert character varying to int | 09 Sep 2008 16:44 GMT | - |
I'm using postgres sql 8.1x
anyone can help convert a character varying to int?
I have a table with :
attribute | character varying(20)
|
| Closing a database | 18 Sep 2007 14:34 GMT | 1 |
Been away from PostgreSQL for a while and probably needs retraining in
the basics.
How do I close a database? Can't even find it in the Manual
Case:
|
| If criteria is Null then show all. | 09 Mar 2007 16:23 GMT | 3 |
I have an .asp page that passes four variables to another .asp page by using
an HTML form. A SQL query then runs against an Access database using those
four variables. The variables are: "cnty", "rte", "bgn", and "nd".
My current SQL statement is as follows:
|
| Trigger is preventing deletion of rows? | 07 Nov 2006 23:04 GMT | 1 |
Newbie to postgresql. I download and complied 8.15 on RH 9. I wrote a
trigger that records the actions of customer table into a customer
history table. INSERT and UPDATE work fine but it's prevents any
deletions in the customer table. It records a deletion in the customer
|
| money Data Type and pgadmin frustrations | 04 Nov 2006 21:33 GMT | 2 |
1. I'm trying to use the money data type in a table. Just playing around
with this stuff. I have a table with two fields defined, a varchar field
for an identifier, and a single money field. Using pgadmin, I am unable
to enter any reasonable value in the money field. pgadmin will ...
|
| Postgresql Vs. Mysql -- Need advice | 26 Sep 2006 11:55 GMT | 1 |
Hi Database Gurus,
Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are about to begin development for a data intensive web based application and are faced with the choice of database software. We (at least ...
|
| libpqdll.lib | 21 Aug 2006 16:45 GMT | 2 |
I used MinGW + MSys to compile PostgreSQL 8.1.4 using the sequence:
./configure --no-zlib
make
make install
|
| CREATEUSER question | 16 Jun 2006 08:27 GMT | 4 |
Is it possible to call CREATEUSER in VB.Net code so that a user password is
added and there is no prompts
Thanks in advance
|
| Synchronization across multiple applications... | 20 Apr 2006 00:42 GMT | 2 |
I have a problem I am trying to solve. I have a rather large
application that uses Postgresql. For performance reasons I
would like to run it on multiple machines. I ran into a problem
that I am trying to solve and the easiest solution seems to
|
| Executing interactive application from C function | 09 Apr 2006 23:47 GMT | 1 |
I'm working in Windows with PostgreSQL, and I have created a simple C
function in a DLL, which contains only the line:
system("C:/windows/notepad.exe")
I have successfully created a function in my db, and linked it to the
|
| Postmaster Problem | 02 Apr 2006 01:31 GMT | 2 |
I am normally the admin for our PostgreSQL servers, but someone else tried
to kill a runaway query while I was out sick. Unfortunately, he tried
killing the runaway query by killing the postmaster. Now we are dealing
with a persistent problem that just won't go away.
|
| Logging architecture | 28 Feb 2006 18:05 GMT | 1 |
Can anyone point me towards some docs/papers/etc of the transaction logging
system of PostgreSQL?
Thanks,
-Jim
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage