On Thu, Apr 05, 2001 at 04:31:57PM +0200, Laurent MARTIN wrote:
> Hi!
>
> I'm now using PostgreSQL for a few months now and I need to use arrays
> in some tables of my database. I've read some documentation about using
> arrays with PostgreSQL, but I still don't how I can perform a 'COPY
> FROM'
"Wade Burlingame" <[EMAIL PROTECTED]> writes:
> ...and is there any way I can get rid of this requirement? I'm just getting
> into PGSQL and I find the quotes very distracting.
They're not required, unless you want to treat the table and column
names in a case-sensitive manner (which is not gen
On Mon, 2 Apr 2001, Wade Burlingame wrote:
> ...and is there any way I can get rid of this requirement? I'm just getting
> into PGSQL and I find the quotes very distracting.
The quotes are only *needed* around tables/columns/etc if they contain
characters not in the alphanumeric set, or if it c
Armin Preis wrote:
>
> I'd like to connect to a Postgresql Database(Ver. 6.5) on my localhost
> with JDBC, but it doesnt work.
Thanks, the problem is already solved.
Armin
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Simplest way I know of is to write a C function which fires off a
shell script which in turn executes psql with appropriate parameters.
The C function can pass it individual variables, or the entire SQL
string.
The reason for the shell script is that way the database, port, etc.
are easy to chang
On Wed, 4 Apr 2001, Marcin Wasilewski wrote:
> hello everybody,
>
> Maybe someone could help me with ODBC setup with POSTGRESQL
>
> thanks,
> Marcin
FAQ at www.scw.org/pgaccess
--
Joel Burton <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington
---
Hi all. I have a problem understanding/using PostgreSQL as a multiuser
database.
I have a simple table with a number of different IDs (int8) used for
different activities.
It should be possible for any number of simultaneous users to receive a
unique ID for a particular activity and then update th
Am Donnerstag, 5. April 2001 16:23 schrieb Tom Lane:
> "Oliver Elphick" <[EMAIL PROTECTED]> writes:
> >> However, if \dt hangs, the problem is probably in a system index;
> >> pg_class has two indexes: pg_class_oid_index and
> >> pg_class_relname_index.
> >
> > I can do a select * on pg_class, bu
I wrote the following test function:
CREATE FUNCTION tester(text)
RETURNS text
AS 'DECLARE
str text;
BEGIN
str := upper($1);
RETURN str;
END;'
LANGUAGE'plpgsql'
This runs OK. However, when I go to use it as follows:
SELECT tester('sometext');
I get the error:
NOTICE: plpgsql: ERROR d
I am using PostgreSQL 7.0.3 and have the following schema:
CREATE TABLE "products" (
"id" SERIAL NOT NULL PRIMARY KEY,
"name" text NOT NULL,
"description" text NOT NULL,
"brand" text NOT NULL,
"url" text,
"weight" float4 NOT NULL,
"stock" in
"Oliver Elphick" wrote:
>Debian packages of 7.1RC3 have been uploaded to the Debian experimental
>distribution and are also available at http://www.debian.org/~elphick/postgr
>esql
>
>These packages are built for sid (Debian unstable); I am currently
>trying to build a set for pota
I have to deploy an application using Postgres odbc to about 200 computers.
I'm using the latest psqlodbc.dll (version 7.01.003). All my clients have
Windows 98, my question is simple, could I trust that the ODBC drivers that
came with the original Windows 98 installation will work ok with the
psq
Hi,
I heard we can use Postresql without transaction mode. I read the comilation
options (configure) and the postmaster option (postmaster -h), but I didn't
find anything
I want to do that for accounting so I need speed but not transaction mode.
Thanks in advance
Livio
...and is there any way I can get rid of this requirement? I'm just getting
into PGSQL and I find the quotes very distracting.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq
Hi,
I get such error while trying to dumpall db on PostgreSQL 7.0.3
[postgres@trinity pgsql]$ pg_dumpall -p -d | gzip >
/admins/PGBACK/baza-last-all.sql.gz
getInherits(): SELECT failed. Explanation from backend: 'ERROR:
Attribute 'inhrel' not found
'.
pg_dump failed on trinity_admins_db
Is there a PostgreSQL equivalent for the MySQL program mysqladmin? My
system load jumped and using top I saw that it was due to postmaster. With
mysqladmin I can show the mysql processlist and see the list of connections
and who is doing what. I've looked through the indexes for all the
docume
Hi,
I'm trying to build postgresql but it's giving me problems. I get these
messages for all Makefiles when I run ./configure:
creating Makefile.global
sed: command garbled: s%@CC_VERSION@%Version: CSE C Compiler CAA 139
1065/11 R14A
this is repeated for all files. Of course it means that the Ma
Marek Pêtlicki <[EMAIL PROTECTED]> writes:
> Hi!
>
> I've got a question: has anybody noticed in your production
> tables, that updates on existing rows take longer than inserts
> into those same tables?
Standard first question: are you vacuuming?
-Doug
---(end of broa
If you want an install version of PostGres
look @
http://208.160.255.143/
or http://208.160.255.143/pgsql/pgsql.exe
Tonio
Steve Jorgensen wrote:
>
> I'm working with a group of people who need to use PostgreSQL on
> Windows, but are not yet knowledgeable hackers. I am also in this
> categor
I'm trying to install PG on my new OpenBSD machine. I installed the
latest version of GNU readline in the usual place (defaults to
/usr/local/...) and then I did ./configure in the src/ directory of
PG7.03. This should have detected readline properly, but when I tried
psql, I couldn't use the h
Hi!
I'm now using PostgreSQL for a few months now and I need to use arrays
in some tables of my database. I've read some documentation about using
arrays with PostgreSQL, but I still don't how I can perform a 'COPY
FROM' to insert large number of records : of course inserted records
should contai
I have a web server running FreeBSD 3.4. I installed postgres 7.0.3 and
tried to run not too large database (200k records, 20MB in size) accessed
via PHP. I keep getting this i my logfile:
syslogd: /var/run/utmp: Too many open files in system
I have filelimit set to 5000, so I think it should be
hello everybody,
Maybe someone could help me with ODBC setup with POSTGRESQL
thanks,
Marcin
.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL
Hi!
I've got a question: has anybody noticed in your production
tables, that updates on existing rows take longer than inserts
into those same tables?
I work on an Internet auction system. We have 'items' put to
auction with 'autorestore' option. When such an auction is ended
without solution (I
On Fri, 6 Apr 2001, Stephan Richter wrote:
> Hello everyone,
>
> did anyone notice that PostGres stops its services from time to time in
> SuSE. I do not have the problem with RedHat, my install there is running
> for several month smooth now, but the SuSE install gives me problems every
> second
One thing that confused me when I started seriously looking at PostgreSQL
was the features it had relative to other competitors. We have so many
powerful features that are often underused by new users:
* procedural languages
* triggers
* rules
* views
* custom aggregate functions
* .
On Fri, Apr 06, 2001 at 12:47:17PM -0700, Scott Gritton wrote:
> I've been reading through the lists but have not been able to find any
> information about how to take a Filemaker Pro database and convert it into a
> Postgresql database.
> Does anyone have any information on how to do this type of
On Sat, Apr 07, 2001 at 01:46:48PM -0400, Doug McNaught wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
>
> > Doug McNaught writes:
> >
> > > Doing this would almost certainly result in a corrupted database once
> > > you ran up against the limit.
> >
> > I think you can give PostgreSQL a
On Fri, 6 Apr 2001, Scott Gritton wrote:
> I've been reading through the lists but have not been able to find any
> information about how to take a Filemaker Pro database and convert it into a
> Postgresql database.
> Does anyone have any information on how to do this type of conversion?
> Thanks
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Doug McNaught writes:
>
> > Doing this would almost certainly result in a corrupted database once
> > you ran up against the limit.
>
> I think you can give PostgreSQL a little more credit than that. ;-)
I'm very glad to hear it. A lot of applic
Justin Clift writes:
> It doesn't seem to have been mentioned that the preferable way to
> compile PostgreSQL on Solaris is to unset your LD_LIBRARY_PATH and set
> an LD_RUN_PATH instead.
>
> That is right isn't it?
Not really. You don't need to set either of these variables. In the
problem th
Doug McNaught writes:
> "Richard Huxton" <[EMAIL PROTECTED]> writes:
>
> > AFAIK you can only do this at the OS level. Certainly cpu/memory usage can
> > be restricted on pretty much all unix-like systems - you'll need to see the
> > documentation for your specific platform to find how.
> >
> > L
Martín,
The problem was solved by explicitly defining LD_LIBRARY_PATH in the command
line i.e.
su - postgres -c "export
LD_LIBRARY_PATH=/usr/lib/:/usr/local/lib:/usr/local/pgsql/lib ;
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start"
Best Regards,
Ahmed
-Original Message-
From: "Doug McNaught" <[EMAIL PROTECTED]>
> "Richard Huxton" <[EMAIL PROTECTED]> writes:
>
> > Limiting disk usage, you *should* be able to change the group of the
various
> > database files and limit group file usage. I can't say I've tested this
> > though.
>
> Doing this would almost certainly
Hi,
It doesn't seem to have been mentioned that the preferable way to
compile PostgreSQL on Solaris is to unset your LD_LIBRARY_PATH and set
an LD_RUN_PATH instead.
That is right isn't it?
Regards and best wishes,
Justin Clift
Ahmed Moustafa wrote:
>
> Hi Tom,
>
> I did the test by hand and
35 matches
Mail list logo
