Hello,
Is it possible to restrict the number of entries in a table? I have attempted
to write a check like so:
CREATE TABLE mytable (
id integer NOT NULL,
CHECK (COUNT(id) <= 10)
);
This is not allowed, I get an error saying:
ERROR: Exec
> I have several databases in one implementation. Do I have to
> dump/restore them all to get the pg_log file under control?
Yes.
Vadim
The performance of my client Java app using JDBC to access PGSL is very
finicky. Sometimes it's fast, and sometimes it's slow, depending on how
much memory I'm allocating in my program.
This appears to be an issue with the JVM I'm using on Linux.
Performance is very consistent using HotSpot JDK1
Does anyone know how to invoke an external shell script from a function when
it is called from a sql statement?
-- Artemis Chau, Intel Corp.
I was about to say that it may cause more harm than good, but...
If they do want to move the utilities to the /bin folder, then that may be a
good solution. pg_access, pg_createdb etc would be put there and merely
mapped to the usual location of the createdb utilities.
That would solve the issu
It would probably be easy to create a link, or a script called pg_XXX that
executes the command XXX. I'd rather have createdb instead of pg_createdb
just because it's easier to type. A script that creates the pg_ command
names could be written and made available at someone's web site for peopl
I have several databases in one implementation. Do I have to
dump/restore them all to get the pg_log file under control?
Thanks
John
"Mikheev, Vadim" wrote:
> > My "pg-log" file is getting huge. I tried to zero it out with
> > disastrous consequences. I can find no documentation on what it
> >
On Thu, Sep 28, 2000 at 11:00:20AM -0500, Daryl Chance wrote:
> > without knowing the hardware organization & availability of software,
> > it's seems strange that you're considering different database systems
> > for things that one is perfectly capable of performing. it's a bit of a
> > fallacy
> without knowing the hardware organization & availability of software,
> it's seems strange that you're considering different database systems
> for things that one is perfectly capable of performing. it's a bit of a
> fallacy that MySQL is better for read only database sites. on the low
> end
Daryl Chance wrote:
> > > I know MySQL is fast but just remember, it's just "A filesystem with an
> > SQL
> > > interface" -- that's ALL... :-)
> >
> > Cool, thats what I needed to know. as for MySQL, thats about all I really
> > need :P.
without knowing the hardware organization & availability
If memory serves me correctly, Virtuoso (OpenLinkSW) and AOLserver both claim
inter-database connections.
>= Original Message From "Mitch Vincent" <[EMAIL PROTECTED]> =
>> Hi,
>>
>> I'm pretty new to PgSQL (been lurking) and am wondering if
>> it's possible to talk with other DB's easily
Howdy!
I continually get the following error when I truncate a very large table in
my db:
NOTICE: trying to delete a reldesc that does not exist
Is this something that I should be concerned about?
Thanks for the help!
Darrin
oops...meant to send to list.
| Daryl Chance | I have made this letter longer then |
| Valuedata, LLC | usual because I lacked the time to |
| Memphis, TN| make it shorter. -- Blaise Pascal |
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> In the provided example SPI functions I couldn't determine a good way of
> testing for NULL on columns. Should I first try to return the Datum,
> test it for NULL, then run DatumGetFloat64() on it? Isn't there a
> simpler way?
Yes. No. The Da
> Hi,
>
> I'm pretty new to PgSQL (been lurking) and am wondering if
> it's possible to talk with other DB's easily? I'm using
> FreeBSD atm and the project I'm working on will be moving
> from dbase to postgres in the next release. It will also
> have a web based side to it that I plan on using
Hello,
In a SPI function I have this code snippet:
double startprice = *DatumGetFloat64(SPI_getbinval(
auction_tt->vals[i], auction_tt->tupdesc,
SPI_fnumber(auction_tt->tupdesc,
"startprice"), &isnull));
To
Hi,
I'm pretty new to PgSQL (been lurking) and am wondering if
it's possible to talk with other DB's easily? I'm using
FreeBSD atm and the project I'm working on will be moving
from dbase to postgres in the next release. It will also
have a web based side to it that I plan on using MySQL for
po
"Adam Lang" <[EMAIL PROTECTED]> writes:
> I'd assume a problem with changing all the commands now is that it may break
> a lot of people's scripts and programs.
Well, we've done it before ;-). If memory serves, the create/drop
scripts *were* named pg_xxx a few years back. I forget the reasons
t
I'd assume a problem with changing all the commands now is that it may break
a lot of people's scripts and programs.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Keith L. Musser" <[EMAIL PROTECTED]>
To: "PGSQL-General" <[EMAIL PROTECTED]>
Sent:
Well, I'm not even a new user, I'm maybe a future new user but interested
right now. With the exception of the help command, I don't see any need to
change commands names. But the help command would be very helpful.
- Original Message -
From: Keith L. Musser
To: PGSQL-General
Sent: Thurs
I know all of you are accustomed to the command
line interface for pgsql. (Of course, some of you created it!)
However, I'd be interested if anyone else feels the way I do
I would prefer to have a consistent set of names
for the commands. For example,
I propose the following:
Inst
On 28 Sep 2000, Gunnar R|nning wrote:
> Tim Kientzle <[EMAIL PROTECTED]> writes:
>
> > > I'm finding that ... my CPU spends about 60% of the time in JDBC, and about
> > > 40% of the time in the postmaster backend.
> > > (Each query takes 2 msec on my machine, RH Linux 6.2, 733 MHz Intel, w/
> >
On Thu, 28 Sep 2000, Gilles DAROLD wrote:
> Hi,
>
> After taking a look to many way from fast search into full text (flat
> field with regrep, UDMSearch,
> and other stuff like contrib FTI) i have developped my own indexer and
> fast search.
> It's still specific to my database but can be easily
Enrico Comini writes:
> Hi, how I have to change the next query ?
>
> da_kg=Numeric
> a_kg =Numeric
>
> cusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg < 3.5) and (a_kg >= 3.5));
> ERROR: Unable to identify an operator '<' for types 'numeric' and 'float8'
> You will have to retype th
Hi, how I have to
change the next query ?
da_kg=Numeric
a_kg
=Numeric
cusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg
< 3.5) and (a_kg >= 3.5));ERROR: Unable to identify an operator
'<' for types 'numeric' and
'float8' You will have to retype
this query using an explicit cast
Manfred Pock writes:
> I have compiled the sources under WinNT with cygnus tools.
> This has functioned perfect, then i start the ipc-deamon
> and the postmaster with -i option - It look like that all would
> be ok, but then i try to connect do the database by psql, pgaccess and
> over the jdbc -
Hi Steve,
first of all: which ODBC driver do you use? and which PostgreSQL Version?
I've been using Postgers 7.0 and 7.0.2 with postdrv.exe (SFX) for Driver
Version 6.5
>2) I notice in /usr/local/pgsql there is a file called "odbcinst.ini". Am
>I supposed to alter this file?
Normally you don'
Hi,
After taking a look to many way from fast search into full text (flat
field with regrep, UDMSearch,
and other stuff like contrib FTI) i have developped my own indexer and
fast search.
It's still specific to my database but can be easily ported to any other
database structure.
It also use sto
28 matches
Mail list logo
