On Mon, Feb 12, 2001 at 10:22:30AM -0500, Tom Lane wrote:
> DaVinci <[EMAIL PROTECTED]> writes:
> > On Mon, Feb 12, 2001 at 01:08:01PM -, Michael Ansley wrote:
> >> Typically, the insert for a person, and for all the associated addresses
> >> would be done in the same transaction so that if th
I run as user "spry" on psql, I created the database as "spry" but when I
run vacuum, all the system tables get skipped because "spry" is not the
owner. Is there a way to fully vacuum my db and the system tables as a user
other than "postgres"?
Is is very important that the system tables are "vac
If you can run the program psql via php's exec command or something then the
stdout might be available to you. Might work.
If php is in safe mode this can be a challenge.
Matt Friedman
Spry New Media
- Original Message -
From: "Dan Wilson" <[EMAIL PROTECTED]>
To: "pgsql general" <[EMA
Is there any way to trap the NOTICE output (specifically in PHP)? I would
like to impliment an EXPLAIN feature in phpPgAdmin and have been
unsuccessful in finding a way to do this because all the information
returned by EXPLAIN is in a NOTICE.
Any ideas?
-Dan
it depends on what kind of concurrent connections u will be getting..
For admin interfaces the kind of settingu mentioned might be OK but in
case it is a heavily loaded site then u need to think..
Anand
On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote:
>I'm in the process of imp
Hi tom
The table description is as follows
arttoday=> \d exhibit_distributions
Table "exhibit_distributions"
Attribute | Type | Modifier
--+---+-
On Mon, 12 Feb 2001, Bruce Momjian wrote:
> > As a suggestion regarding the docs ... as a newbie, I went straight to
> > the"user's lounge" and didn't check out the "developer's corner" because
> > I figured those docs would be pretty hard-core technical. But in
> > reality, many of the developer
James Patterson <[EMAIL PROTECTED]> writes:
> I am having a great deal of difficulting installing postgresql 7.03 on
> Darwin 1.2.
> Can anyone give me a few pointers?
Sure: forget 7.0.3, give 7.1beta4 (or current snapshot) a try instead.
There's no port for Darwin in 7.0.*.
"K. Ari Krupnikov" <[EMAIL PROTECTED]> writes:
> Many queries can be formulated as either a self-join or a subquery on
> the same table.
> Is there any difference in performance, or does the analyzer treat them
> the same?
You're a lot better off with a self-join, at present.
On Sat, Feb 10, 2001 at 11:16:45AM -0500, wrote:
> If i have a dbf database, how can I import it into PostgreSQL?
>
> Thanks
>
I have a program that does this. I've set up a project at SourceForge
for it, but I'm still fighting with them over CVS access etc. If you're
interested, I can email
On Tue, Feb 13, 2001 at 11:55:18AM +1300, Christopher Sawtell wrote:
> It is supported by a very competent team of developers who are not only
> determined to stay at the front of open source database race, but also
> quite patently give the impression that they actually _care_ about their
>
I'm in the process of implementing connection pooling
and the setup I'm using (http://www.javaexchange.com -
really slick!) has settings for min # connections and
max # connection. Any suggestions on where I should
set these values? min=2, max=6? My site will be
outside the firewall, open to the
On Sat, 10 Feb 2001 02:39, you wrote:
> Please could someone explain what are the major differences between
> PostgreSQL,
Pro:-
It's free in all senses of the word. ( BSD Licence )
Thus no new licence required if you migrate to more powerful hardware.
It works well enough to run a set of Ledgers
James Patterson writes:
> I am having a great deal of difficulting installing postgresql 7.03 on
> Darwin 1.2.
7.0.3 [sic] doesn't work on Darwin. Try a 7.1 beta.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
heya
there are a couple of good example on how to do this in the perl
cookbook
the trim function in chapter one might help
the source code from the book is avail at ora.com
Here's a code snippet that shows the problem:
+--+
boolean bNeuroPsych = objResults.getBoolean("NeuroPsych");
short sNeuroPsych = objResults.getShort("NeuroPsych");
System.out.println("Neurologic/Psychiatric: "+bNeuroPsych);
System.out.println("Neurologic/Psychiatric: "+sNeuroPsych);
+--+
The "
Found the problem:
In org/postgresql/jdbc2/ResultSet.java
The following line determines true/false:
return ((c == 't') || (c == 'T'));
Changing this to:
return ((c == 't') || (c == 'T') || (c == '1'));
Fixes the problem. This could probably be improved to:
return ((c == 't') || (c == 'T')
Alexander Jerusalem <[EMAIL PROTECTED]> writes:
> I'm running into problems while trying to install 7.1 beta 4 (on
> RedHat Linux 7 with bug fixes applied)
> I've downloaded the rpms but when I do an rpm -iv
> postgres-7.1beta4-1.i386.rpm it complains about an unresolved
> dependency on libreadli
Peter Eisentraut wrote:
> Alexander Jerusalem writes:
> > I'm running into problems while trying to install 7.1 beta 4 (on RedHat
> > Linux 7 with bug fixes applied)
> > I've downloaded the rpms but when I do an rpm -iv
> > postgres-7.1beta4-1.i386.rpm it complains about an unresolved dependency o
Mitch Vincent writes:
> if I try to cast minority to varchar (or anything else for that matter) I
> get
>
> ERROR: Cannot cast type 'bool' to 'varchar'
Try: CASE WHEN minority THEN 'value of true' ELSE 'value if false' END
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-
hhs=# INSERT INTO applicants_test (SELECT app_id ,old_id ,emp_id ,inv_id
,createdate ,updatedon ,todelete ,appstatus ,apptype ,infosent ,empinitials
,firstname ,lastname ,salutation ,fontype1 ,fonnumber1 ,fonext1 ,fontype2
,fonnumber2 ,fonext2 ,fontype3 ,fonnumber3 ,fonext3 ,address1 ,address2
,ci
Is it possible to accomplish any SQL statement manipulating the System
tables?
I was wondering about the possibility to substitute the unrecognized SQL
statements (ALTER TABLE table COLUMN , for instance) through some
queries to the system tables.
Nelio
--
Nelio Alves Pereira Filho
IFX Networ
Kyle <[EMAIL PROTECTED]> writes:
> Is it possible to make a compiled C function take an array as an
> argument?
Sure, although disassembling the array is not quite trivial (a Postgres
array is not the same as a C array). In the 7.1 code, there is a
deconstruct_array() function in src/backend/uti
Is it possible to make a compiled C function take an array as an
argument? Right now I've got a function that takes 32 arguments, all
declared as separate variables (int arg1, int arg2, ...) and it would
be a lot more natural for the function to be called with an array (int
*array, int num_elemen
Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> Besides dumping and COPY'ing the data into the second server, is there
> another form of easy one-way replication available? My schema has just
Have you looked at PG's replication? It's included in 7.1, and you
can get it from (I think) www.postgr
Anand Raman <[EMAIL PROTECTED]> writes:
> The second query is not priniting out site_section column.
Odd. What is the exact definition of table exhibit_distributions?
Does it have any indices? What plan is printed by EXPLAIN for the
problem query?
regards, tom lane
On 12 Feb 2001, at 10:10, Tom Lane wrote:
> > ERROR: Cannot insert a duplicate key into unique index
> > pg_type_typname_index
> > The query causing it it's an innocent query that duplicates a table
> > in a temporary one, i.e.
> > "select * into forum_clone from forums"
>
> I think you're pro
On Mon, Feb 12, 2001 at 12:56:04PM +0700, Jarungwit J. wrote:
> Now I can start ipc-daemon as NT Service by using invoker methood. But
> when I start postmaster with invoker method, it shows error:
>Error 0203: The sytem could not find the environment option that was
>entered.
> Note that
DaVinci <[EMAIL PROTECTED]> writes:
> On Mon, Feb 12, 2001 at 01:08:01PM -, Michael Ansley wrote:
>> Typically, the insert for a person, and for all the associated addresses
>> would be done in the same transaction so that if the insert for one of the
>> addresses failed, then the whole lot wo
Title: RE: [GENERAL] transaction safety
There should be no locks on the table for insert. The sequence number is retained by the session, not locked on the database. What this means is that somebody else may start their insert after you, and then you roll back, leaving a gap in the sequences
[EMAIL PROTECTED] writes:
> I've a postgresql 7.0.2 used as a backend for a website. Randomly,
> and not very frequently, an error pops up saying that the following
> problem has happened:
> ERROR: Cannot insert a duplicate key into unique index
> pg_type_typname_index
> The query causing it it
On Mon, Feb 12, 2001 at 01:08:01PM -, Michael Ansley wrote:
> The number returned by the sequence for the serial ID is retained within the
> session, and so it can be returned by calling currval, e.g.:
...[a detailed example]...
> Typically, the insert for a person, and for all the associa
Title: RE: [GENERAL] transaction safety
Hi,
The number returned by the sequence for the serial ID is retained within the session, and so it can be returned by calling currval, e.g.:
CREATE TABLE person (
id serial primary key,
name varchar not null,
dob timestamp no
On Mon, Feb 12, 2001 at 11:08:55AM +, Oliver Elphick wrote:
> DaVinci wrote:
> > Hi all.
> >
> > I want to create a new tuple of main info and detail tuples (in
> > different tables) that are joined by a key field. Key field is created by
> > generator automatically and I need that n
DaVinci wrote:
> Hi all.
>
> I want to create a new tuple of main info and detail tuples (in
> different tables) that are joined by a key field. Key field is created by
> generator automatically and I need that number in order to assign to detail
> tuples. How can I to get that number
Hi all.
I want to create a new tuple of main info and detail tuples (in
different tables) that are joined by a key field. Key field is created by
generator automatically and I need that number in order to assign to detail
tuples. How can I to get that number in a safe way?.
Thanks for idea
Hi all...
I've a postgresql 7.0.2 used as a backend for a website. Randomly,
and not very frequently, an error pops up saying that the following
problem has happened:
ERROR: Cannot insert a duplicate key into unique index
pg_type_typname_index
The query causing it it's an innocent query that
37 matches
Mail list logo
