"Gregory S. Youngblood" <[EMAIL PROTECTED]> writes:
> I got the data loaded that I need to work with, and am having a
> problem with one specific query. It keeps dumping out with
> ExecEvalExpr: unknown expressiong type 704.
And the query is?
The only known cause of that at the moment is if you
"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> I'm still a bit confused about how to declare the type of the transition state.
> I have a structure that will hold the current state:
> struct state {
> int elem_count; //how many numbers have been assigned so far
> int *elem_are
Patrick COLLIN <[EMAIL PROTECTED]> writes:
> I first tried a global update on each column, but I have not enough
> memory and swap to do that.
> FOR nouvEnreg IN SELECT * FROM mfnf00 LOOP
>nouvCoupal := 2 * nouvEnreg.coupal;
>UPDATE mfnf00 SET coupal = nouvCoupal
> WHERE cbase = nouv
"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> So do I just copy it manually from src/include/ ?
>>
>> add -I/usr/local/pgsql/include and -L/usr/local/pgsql/lib
To do backend code development, you need to either add a -I pointing at
the source include tree, or do make install-all-hea
On Tue, 19 Jun 2001, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Sure, you create a (static) global variable and reallocate memory for it
> > in each call and free it by the finalizer function.
>
> A static would be a bad idea (consider a query with multiple instances
> of
Does anyone know what the option "Use declare fetch" on the windows ODBC driver mean?
Is there anything in particular to be fine-tuned in ODBC when transfering large data
sets?
TIA,
thalis
---(end of broadcast)---
TIP 6: Have you searched our lis
> THESE ARE NOT WHINING GRIPES. They are pefectly valid points about
> how the current website design is flawed. Your responses were pretty
> much "Make your own bookmark", "it doesn't work", and "you aren't
> working hard enough to find things." This attitude is unacceptable.
I thought tha
On Wed, 20 Jun 2001, Adam Haberlach wrote:
> On Wed, Jun 20, 2001 at 04:38:58PM -0400, Vince Vielhaber wrote:
> > On Wed, 20 Jun 2001, Norman J. Clarke wrote:
> >
> > > You do an excellent job Vince. By and large the website is awesome, and I
> > > love some of the newest additions such as the in
> > Will PostgreSQL take advantage of more than 1 CPU? If so, are there
any
> > benchmarks showing how it scales with multiple CPUs?
We run PG on a quad xeon, and it works wonderfully. From PG's design
of forking off a new backend for each connection, it is inherantly
scalable, as each backen
On 14 Jun 2001, denis wrote:
> I use a linux/mandrake 7.2 on PIII 350
> when doing
> 1 - create an initialisation file
> i=0;
> loadfile="/usr/local/pgsql/param/loadfile"
> rm -fr $loadfile ;
> #creating a file with 1500 records
> while [ $i -lt 1500 ] ; do
> i=`expr $i +
Give the fullname of the file. Make sure the file is on the server machine and not
your local machine (in case you are forwarding pgaccess to another X terminal)
cheers,
thalis
On 16 Jun 2001, Chakravarthy K Sannedhi wrote:
> Hi,
>
> When I am trying to import a file in my home directory int
On Wed, 20 Jun 2001, Gregory Youngblood wrote:
> I have an ID column which is a bigint, and I have another ID column which was
> created using SERIAL, so it is an integer.
>
> Is it possible to use SERIAL to get a int8 datatype instead int (int4)?
Not as far as I know, but there is talk to act
>From a previous thread, I remember being said that it is mostly an OS issue. So if
>you make your OS kernel aware of your multiple CPUs, Pg will be just fine.
cheers,
thalis
On Thu, 14 Jun 2001, Rich Bowman wrote:
> Will PostgreSQL take advantage of more than 1 CPU? If so, are there any
> be
Do you have the postmaster configured to listen on the port as opposed
to only the local socket? (Either the -i command line option or
an option in the postgres.conf should do it I believe)
On Sat, 16 Jun 2001, Sam Wun wrote:
> Hi,
>
> When I finished running ./010.pgsql.sh start, then tried
On Wed, 20 Jun 2001, Norman J. Clarke wrote:
> You do an excellent job Vince. By and large the website is awesome, and I
> love some of the newest additions such as the interactive docs. But you
> should listen to his gripes and respond in a more polite way. If you think
> he is wrong, then expla
> It looks like Red Hat has announced an open source database called Red
Hat
> Database:
>
> (via slashdot:)
>
http://dailynews.yahoo.com/h/cn/20010619/tc/red_hat_to_play_in_oracle_s_ar
ena_1.html
>
> Why is this not PostgreSQL? Why can't the Red Hat folks sell support to
> PostgreSQL, rather than
Also the comment that RHDB would be better for small businesses than
large ones makes me think that it's not exactly high-performance or
full-featured. : )
steve
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://w
17 matches
Mail list logo
