Normunds wrote:
> Hi all,
>
> how can I write function which takes text from one field, replaces
> some characters and puts it in other field? I have array with old and
> new values.
>
> For example:
> old array = {'r', 'Z', 'o'}
> new array = {'s', 'm', 't'}
> old field value = 'Zorro'
> new fiel
OK, I downloaded the source and followed the directions from here
(http://www.postgresql.org/docs/admin/installation.htm) and when I run the
command: /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data
>logfile 2>&1 &
I get the error:
[1] 28156
bash: logfile: Permission denied
I try to c
Not directly (by methods), but you can use them as you would elsewhere.
Issue the relevent sql to declare the cursors, and fetch the results using
Statement.
Peter
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
Post
Isn't this the
localall trust
host all 127.0.0.1 255.255.255.255 trust
lines in the default pg_hba.conf file that comes with the distribution?
-emile
On Wed, 30 Aug 2000, Eric Webber wrote:
> users dont seem to need pa
users dont seem to need password in postgres 7 on red hat linux
6.2, compiled from source.
I do an:
alter user nsadmin with password 'whatever';
And then when I do an:
psql -u -d mydb
username: nsadmin password: NOTwhatever
IT STILL LETS ME IN
This should not be so shou
Yes, I have same problem. This functionality is "almost" standard,
and
found on other RDBMS. How do new features get added to the todo list's.
Where can I view the current todo list?
Fredrick
Matthew Kennedy wrote:
> I have a ton of data in a text delimited file from an old legacy system.
>
Take a look at the sql COPY command (\h COPY) it will do it as you want
!
[EMAIL PROTECTED] wrote:
>
> How should I go about importing the contents of an Excel spreadsheet
> into a Postgres database table?
>
> I was considering a comma separated file, but am not sure how to
> import this into
stil looking for some much needed help on how to
use large objects. I've been able to sucessfuly create one, but thats about as
far as I have gotten, but I do need to be able to read, and rite to an
object.
Mike SearsWeb Developerhttp://www.vianet.ca
What do you need an example of? I can send you some C++ code that uses ODBC
to connect to PostgreSQL, if that's what you need.
- Original Message -
From: "Miguel Omar Carvajal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 2:45 PM
Subject: [GENERAL] C++ Examp
"Mayers, Philip J" <[EMAIL PROTECTED]> writes:
> I'm having problems with the CIDR type. I have a table containing a column
> of type CIDR, and that is the primary key. The equality operator for the
> CIDR type appears to only work once per connection.
I'm not quite sure why you are seeing the ch
Hmm. Hopefully that will sort the problem out.
I am fairly sure it's index-related - if a CIDR-type column is either a
PRIMARY KEY or explicitly set to UNIQUE, i.e. any indices on the column, the
equality operator fails. No index = works fine.
Does that tally with the problem you mentioned?
Reg
How should I go about importing the contents of an Excel spreadsheet into a Postgres database table?
I was considering a comma separated file, but am not sure how to import this into the database.
Are there any other suggestions?
Thanks Andrew
"Adam Lang" <[EMAIL PROTECTED]> writes:
> But wouldn't the dependencies be there whether I compile from scratch or use
> an RPM?
But if you compile from source, it will use whatever libc you have
installed.
regards, tom lane
On Thu, Aug 31, 2000 at 12:22:36AM +1000, Andrew Snow wrote:
>
> > I believe I can work around this problem using cursors (although I
> > don't know how well DBD::Pg copes with cursors). However, that
> > doesn't seem right -- cursors should be needed to fetch a large query
> > without having it
IIRC, there were some problems with CIDR where it was considering
the low bits significant even though they might not have been set
(in the case of 192.169/16 for example) which was causing fairly
odd behavior.
I believe they've routed out these problems in current sources
so it should be fixed
Hello,
a short question:
Is it possible to write jobs with PostgreSQl which run in background
like with oracle ?
cu
Martin
--
Martin Neimeier
Ingenieur-Buero Neimeier
Schwarzach / Germany
mailto:[EMAIL PROTECTED] / http://www.ibn.de (under heavy reconstruction)
Tel:+49(6262)912344 / Fax:+49(
Does the JDBC driver support the user of cursors in postgresql 7.0.2?
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
> I believe I can work around this problem using cursors (although I
> don't know how well DBD::Pg copes with cursors). However, that
> doesn't seem right -- cursors should be needed to fetch a large query
> without having it all in memory at once...
Actually, I think thats why cursors were inv
But wouldn't the dependencies be there whether I compile from scratch or use
an RPM?
What the main issue that stumped was the libc.6.so dependency. According to
epm -a -q, it is installed.
I guess I can blow out 6.5 and download the 7.0 source and reinstall a
compiled version.
Adam Lang
System
At 09:20 30/08/00 -0300, Campbell, Scott wrote:
>Hey,
>
>Is there a function within postgres that lets you search for both upper and
>lower case at the same time?
>I know of the upper() and lower() functions but if a word has both upper and
>lower case in it it won't be returned by a query.
>Or am
Hey,
Is there a function within postgres that lets you search for both upper and
lower case at the same time?
I know of the upper() and lower() functions but if a word has both upper and
lower case in it it won't be returned by a query.
Or am I limited to forcing my data to have one case only?
T
Hiya,
I am running a very large SELECT - it selects every row from a ~10 000
000 row table. I'm running this in Perl using DBD:Pg, with the general
sequence:
$sth = $dbh->prepare("SELECT $fields FROM $from") || return 0;
$fh = new FileHandle(">$file") || die "Can't open $file : $!";
$sth->execut
-BEGIN PGP SIGNED MESSAGE-
If OpenSSL compiled with `rsaref' need additional libraries: -lRSAglue -lrsaref
- --
Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200 RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35 87 1F 3F EF FD 6D 84 B3--|
-BEGIN
Be aware of one thing: having a seperate table for each product type makes
it extremely difficult to scale your application. In your plan, everytime
you add a new product type you have to create a new table. Which means if
you have any sort of general "search all product types for this
attribute"
Ok, now I'm getting truly confused. It works with some networks, but not
with others:
test=> select * from test;
network | netcol
+
192.168/16 | 192/8
192/8 | 192/4
155.198/16 |
155.198.1/24 |
156.198/16 |
156.198.1/24 |
193.63.75.
I'm having problems with the CIDR type. I have a table containing a column
of type CIDR, and that is the primary key. The equality operator for the
CIDR type appears to only work once per connection. The following SQL shows
a test case demonstrating the problems.
I'm running stock Redhat 6.2 on
> -Original Message-
> From: Tom Lane
>
> > Now, I'm not sure if this is related, but while trying to
> do vacuumdb
> > , I got...
>
> > NOTICE: FlushRelationBuffers(all_flows, 500237): block 171439 is
> > referenced (private 0, global 1)
> > FATAL 1: VACUUM (vc_repair_frag): Flush
Hello everyone,
I am using PostgreSQL already for quiet a while and now I want to extend my
knowledge and make better use of PostgreSQL itself.
Here is a selection of the issues I try to solve:
- If I delete a record, I want to delete all its references. -- Is it right
that I have to use a f
28 matches
Mail list logo
