Tom,
what do you think about the folowing: I updated the server field of my DSN
to point to the postgres runniong under cygwin on the localhost. The error
does not appear at all.
--
1 06:29:42 SQL Prepare: PostgreSQL - { call "addincominginvoice"
(?,?,?,?,?,?
Odd, I've never noticed that before ... will look into it though, I must
have something in the wrong place in the .resource file ...
On Wed, 2 Jul 2003, Alvaro Herrera wrote:
> Guys,
>
> Is anyone else annoyed by the fact that the "thread view" for the lists
> in archives.postgresql.org is incom
Guys,
Is anyone else annoyed by the fact that the "thread view" for the lists
in archives.postgresql.org is incomplete? I mean, there _is_ a link to
the "next page" of the thread view, but it taks you to the "date view"
instead...
--
Alvaro Herrera ()
"No reniegues de lo que alguna vez creíste"
On Wed, 2 Jul 2003, Joseph Shraibman wrote:
> You can CREATE INDEX on multiple columns, and you can CREATE INDEX on
> a functions, but can you create an index on multiple columns and
> functions? For example if I want to create an index on
> lower(textfield), intfield
In 7.3 or earlier you'd hav
You can CREATE INDEX on multiple columns, and you can CREATE INDEX on a functions, but can
you create an index on multiple columns and functions? For example if I want to create an
index on lower(textfield), intfield
---(end of broadcast)---
TIP 1
On Wed, Jul 02, 2003 at 01:23:52PM -0400, Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Is recode a feature that's normally enabled?
>
> > ./configure '--enable-recode' '--enable-integer-datetimes' '--enable-debug'
> > '--with-perl' '--with-pam' '--with-openssl' '--with-gnu-ld'
>
On Wed, Jul 02, 2003 at 01:52:46PM -0400, Tom Lane wrote:
> Kurt Roeckx <[EMAIL PROTECTED]> writes:
> > I'll probably rewrite that code to use rangeSockAddr /
> > SockAddr_cidr_mask instead of having it's own cidr code.
>
> Given that it's been under death sentence for awhile, I'm not sure it's
>
Congrats and Welcome to the East Coast from the New Yorker who dwells in Philly.
Quoting Jan Wieck <[EMAIL PROTECTED]>:
> Dear PostgreSQL community,
>
> it is with great pleasure that I would like to let you all know that I
> recently joined Afilias, a domain name registry services company that
As many of you already know, pgAdmin is a widely used Open Source GUI
Management tool for PostgreSQL, similar to DB2's Control Center or SQL
Server's Enterprise Manager.
We are currently working on the next generation pgAdmin III, with the
aim of releasing it at approximately the same time as Pos
When running a "VACUUM VERBOSE" query using PQsendQuery, PQconsumeInput,
and PQisBusy, all the "INFO:" output from the "VACUUM VERBOSE" command
is printed on the terminal, and is not available through the PGresult
structure. The resultset shows now rows, etc. but I would have expected
to be ab
I have a number of very common queries that the
optimizer plans a very inefficient plan for. I am using postgres 7.2.3. I vacuum
hourly. I'm wondering what I can do to make the queries faster.
Here are the relevant tables:
create table image( imageid
integer not null, /* The imag
Ahem... the postgresql version on the server is 7.2.1-2woody2.
Sam.
On Wed, 2 Jul 2003, scott.marlowe wrote:
> What he meant was what VERSION of postgresql is the server using. :-)
>
> On Wed, 2 Jul 2003, S.Peppe wrote:
>
> > Thanks for your reply, Tom. The server I'm connecting to is only ab
Kurt Roeckx <[EMAIL PROTECTED]> writes:
> I'll probably rewrite that code to use rangeSockAddr /
> SockAddr_cidr_mask instead of having it's own cidr code.
Given that it's been under death sentence for awhile, I'm not sure it's
worth putting that much work into ... the feature is superseded by
CLI
On Wed, 2 Jul 2003, Robert wrote:
> Tried ALTER TABLE (yes, this is 7.3) but \d says
>
> nbcz=# \d seasons
> Table "public.seasons"
> Column | Type |
> Modifiers
> --+-+-
> id | intege
Lincoln Yeoh wrote:
> At 01:51 AM 7/2/2003 -0400, Mike Mascari wrote:
>
>> > Maksim Likharev wrote:
>> >>I do not know how that will work for PG, but in Microsoft SQL Server
>> >>you can do following
>> >>BEGIN TRANSACTION
>> >>UPDATE [val] = [val]
>> >> WHERE
>> >>INSERT ...
>> >>COMMI
Greg Stark <[EMAIL PROTECTED]> writes:
> Is recode a feature that's normally enabled?
> ./configure '--enable-recode' '--enable-integer-datetimes' '--enable-debug'
> '--with-perl' '--with-pam' '--with-openssl' '--with-gnu-ld' '--with-maxbackends=64'
> '--with-pgport=5432' 'CFLAGS=-O0 -g -pg -DLI
Tom Lane wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
> > On Wed, 2 Jul 2003, Tom Lane wrote:
> >> You might find it useful to read the slides from my talk at last
> >> year's O'Reilly conference about this and related concurrency
> >> problems:
> >> http://conferences.oreillynet.com/cs/os200
Thank you Tom,
I'll check it out. But I must say that I have many other functions using
numeric fields and working well.
This error has been rising up since I converted my fields from double
precision to numeric.
May be the problem is in my ODBC settings but I'm sceptic a bit about this.
I had set
=?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes:
> alumil=# \df addincominginvoice
> List of functions
> Result data type | Schema |Name|
> Argument data types
> --+++---
Sorry for posting many times!
-- Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---(end of broadcast)---
TIP 9: the p
Hi Tom,
querying my functions results this:
alumil=# \df addincominginvoice
List of functions
Result data type | Schema |Name|
Argument data types
--+++---
=?iso-8859-1?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes:
> ERROR: Function addincominginvoice(integer, integer, "unknown", "unknown",
> "unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown",
> double precision) does not exist
> Unable to identify a function that satisfies the
On Wed, 2003-07-02 at 13:32, Alejandro Javier Pomeraniec wrote:
> Hello !!
>
> Can i configure a table or an entire database to use LATIN1 ascii encoding?
createdb -E LATIN1 my_db_name
Cheers
Tony Grant
---(end of broadcast)---
TIP 7: don't for
Rich Cullingford <[EMAIL PROTECTED]> writes:
> LD_LIBRARY_PATH; su -l antura -c "createlang plpgsql template1"
> ERROR: stat failed on file '$libdir/plpgsql': No such file or directory
> createlang: language installation failed
IIRC, the directory meant by "$libdir" is determined at configure tim
Ross Johnson <[EMAIL PROTECTED]> writes:
> Can I be confident that if there is no entry in pg_class, that there
> is actually no large object for that oid reference?
In 7.0, yes. Later versions keep large objects in pg_largeobject rather
than in individual tables. I don't recall the details of p
Thomas Bamesberger <[EMAIL PROTECTED]> writes:
> My PostgreSQL Database has been up and running exactly for one year, but
> last week after rebooting the error message "fixrdesc: no pg_class entry
> for pg_class" appeared on the screen. So is there any way to solve this
> problem or to recover the
Tom Lane wrote:
Yes. Last year I asked Vince to put those slides up somewhere on the
postgresql.org website, but he never got around to it (I think he got
stuck wondering where they should go). Bruce has materials for several
different talks he's given that should be there somewhere, too.
Perhaps
> Hi,
> I've a problem with some of my stored procs. My config is: RH7.1, Postgres
> 7.3.2
>
> I had converted a few fields of a few tables from one type to another and
> after this I made all the necessary changes on the functions and recreated
> all my types and functions.
> It seemd to be all ri
Hi,
I've a problem with some of my stored procs. My config is: RH7.1, Postgres
7.3.2
I had converted a few fields of a few tables from one type to another and
after this I made all the necessary changes on the functions and recreated
all my types and functions.
It seemd to be all right, but the ne
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> Well that's odd, since 7.2 has a pg_user table. hrm...
Well, it's a view actually, and the backend would continue to run just
fine if someone were to drop or rename the view. psql has some built-in
queries that expect it to be there though.
Hello !!
Can i configure a table or an entire database to use LATIN1 ascii encoding?
Instead of using to_ascii(field,'LATIN1') every time?
Thank you !
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
Well that's odd, since 7.2 has a pg_user table. hrm...
On Wed, 2 Jul 2003, S.Peppe wrote:
> Ahem... the postgresql version on the server is 7.2.1-2woody2.
>
> Sam.
>
> On Wed, 2 Jul 2003, scott.marlowe wrote:
>
> > What he meant was what VERSION of postgresql is the server using. :-)
> >
>
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> On Wed, 2 Jul 2003, Tom Lane wrote:
>> You might find it useful to read the slides from my talk at last
>> year's O'Reilly conference about this and related concurrency
>> problems:
>> http://conferences.oreillynet.com/cs/os2002/view/e_sess/2681
> I'd li
hi,
fairly new to postgres admin stuff..
i have a production machine that is running postgresql 7.1.3
also, there's a test machine which already had 7.0.3, and which i newly
installed 7.3.3
so, i dumped all the databases from the production db and reloaded on the
test,
there was a few proble
At 01:51 AM 7/2/2003 -0400, Mike Mascari wrote:
> Maksim Likharev wrote:
>>I do not know how that will work for PG, but in Microsoft SQL Server
>>you can do following
>>BEGIN TRANSACTION
>>UPDATE [val] = [val]
>> WHERE
>>INSERT ...
>>COMMIT TRANSACTION
>>
>>so basically by updating specif
What he meant was what VERSION of postgresql is the server using. :-)
On Wed, 2 Jul 2003, S.Peppe wrote:
> Thanks for your reply, Tom. The server I'm connecting to is only about 3
> months old - that shouldn't be the problem then, as far as I can
> tell. Thanks again.
>
> Regards,
>
> Sam.
>
>
36 matches
Mail list logo
