On Thu, Jul 21, 2005 at 07:10:03PM +1000, Ezequiel Tolnay wrote:
> Thanks a lot, I've read the TODO and have now an idea of what is the
> current trend or plans for future releases.
>
> Regarding my own needs, I'd be happy to "scratch my own itch", but
> perhaps I should find some consensus befo
On Wed, Jul 20, 2005 at 09:47:53AM +0200, Axel Orth wrote:
> Hey List,
> due to the PostGIS extension PostgreSQL is THE free DBS for geospatial data.
> I know of its capabilities to handle vector data and like to know if
> PostgreSQL can also be used to administer geospatial raster data.
>
> I wo
Timezones are implemented using timezones files which contain info
about daylight savings since forever. When/if the change happens a new
set of timezone files should be released. Copy over the one for your
area and you're fine.
Postgresql may use it's own system, I think it depends on the version
La forma facil y rapido crea , un link a ese directorio y muevelo a otro
directorio
*---*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
They can also be set to drop with ON COMMIT DROP, this way they
disappear after the tranaction is commited.
I use them in this way on my web server to sort file listings, and it
works well since each apache DSO connection gets one connection to the
database.
Tony
http://www.amsoftwaredesign
On Jul 22, 2005, at 1:55 PM, Zlatko Matic wrote:
Hello.
I have some tables that are updated by several users in the same time
and are used in queries for reports. Those tables have rows that are
actualy copied from original tables that are not to be altered. There
is a procedure that insert
Hello.
I have some tables that are updated by several users in the same time and
are used in queries for reports. Those tables have rows that are actualy
copied from original tables that are not to be altered. There is a
procedure that inserts rows for every user when connects, along with his
With the U.S. Government poised to tinker with Daylight Saving Time, I
have a couple questions.
0) Does PG rely on system-level TZ info or will specific updates to PG
be required? I'm interested in *nix but the Windows folks are
probably interested, too.
1) However a change is implemented, wh
On Jul 20, 2005, at 3:37 AM, Jamie Deppeler wrote:
Hi, i have just installed 10.4 on one of our machines and cannot
get past this error during make
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Wendif-labels -fno-strict-aliasing -dynamiclib -install_name /usr/
loca
On Fri, 2005-07-22 at 09:56, Alex Stapleton wrote:
> On 21 Jul 2005, at 17:02, Scott Marlowe wrote:
> >
> > My feeling is that you may be going about this the wrong way. Most
> > likely the issue so far has been I/O contention. Have you tested your
> > application using a fast, battery backed ca
hi folks
the query:
SELECT P.ACT_INCORPORADA, P.FECHA_INICIO,
P.OBSERVACIONES1
FROM PASEST AS P
WHERE
P.FECHA_INICIO between '1999-08-22
00:00:00.00'::timestamp AND '1999-12-22
23:59:00.00'::timestamp
ORDER BY P.ACT_INCORPORADA
make table scan , t
Another question on the same matter:
Do I need XP SP2 for pgSQL 8.0.3 to work correctly? I
have all the security patches, but not SP2.
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Hi,
I am with problems to function postgreSQL 8.0.3 in windows XP with the Ipv6
protocol. I try to have access the bank in the following way:
psql
-h ::1 -d db_teste -u postgres
but
it gives an error: could not translate ::1: Unknown host.
already
I configured the archive pg_hba.conf so
# [EMAIL PROTECTED] / 2005-07-22 12:41:25 +1000:
> Tom Lane wrote:
> >Bruno Wolff III <[EMAIL PROTECTED]> writes:
> >>What happens if there is more than one existing function with that name
> >>already. Do all of the old functions get deleted?
> >
> >What happens if there are existing references to
On 21 Jul 2005, at 17:02, Scott Marlowe wrote:
On Thu, 2005-07-21 at 02:43, vinita bansal wrote:
Hi,
My application is database intensive. I am using 4 processes since
I have 4
processeors on my box. There are times when all the 4 processes
write to the
database at the same time and time
On Fri, Jul 22, 2005 at 12:41:25PM +1000, Ezequiel Tolnay wrote:
> Tom Lane wrote:
> >Bruno Wolff III <[EMAIL PROTECTED]> writes:
> >>What happens if there is more than one existing function with that name
> >>already. Do all of the old functions get deleted?
> >
> >What happens if there are existi
Kilian Hagemann <[EMAIL PROTECTED]> writes:
>> - what version are you running?
> 7.4.8, not sure if I'm ready for 8 yet.
Pre-8.0 tends to underestimate the correlation of a multicolumn index.
(8.0 may too, but not as much.)
> Also, note that set_id is strictly increasing (hence correlation of 1)
Tom Lane wrote:
Bruno Wolff III <[EMAIL PROTECTED]> writes:
What happens if there is more than one existing function with that name
already. Do all of the old functions get deleted?
What happens if there are existing references to the function using the
old parameter list?
The current approac
Martijn van Oosterhout wrote:
On Thu, Jul 21, 2005 at 07:10:03PM +1000, Ezequiel Tolnay wrote:
* Make temporary schemes visible (and accessible) only to its current
owner/user, and create a tool to clear currently unused temporary
schemes (for instance during backups, or when duplicating a data
Benjamin Smith wrote:
Now, I want to get a result like:
classroom | students | seats
101A 0 25
101B22 30
102A11 0
... etc.
Something somewhat akin to
select classroom.title,
count(students.id) AS students,
count(seats.id) AS seats
from classrooms, students, seats
wh
On Fri, Jul 22, 2005 at 10:46:39AM +0200, Kilian Hagemann wrote:
> > - did you run "VACUUM ANALYZE speed" lately?
>
> Yes, just before I ran all of the queries in my last email.
Did you run VACUUM ANALYZE or just ANALYZE? Could we see the output
of VACUUM ANALYZE VERBOSE speed?
> Hence I mentio
John Wells wrote:
Guys,
I have a number of jpegs and tiffs that are stored in a bytea field in a
PostgreSQL database by a Java program using Hibernate.
I need to copy these out to a flat file via pgsql for viewing, etc. I've
tried
psql -c 'select binarydata_field from my_image_table where id
Well, after hours to debug this issue, I found the problem.
There is a misspelled word, thanks and sorry for waste your time.
Alejandro
2005/7/21, Alejandro D. Burne <[EMAIL PROTECTED]>:
> Thanks Michael for your reply, I've attached the db structure and some
> data to add, this is the command th
# [EMAIL PROTECTED] / 2005-07-22 06:50:58 -0600:
> On Fri, Jul 22, 2005 at 02:20:31PM +0200, Roman Neuhauser wrote:
> >
> > select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet)
> >
> > ERROR: invalid input syntax for type inet: ""
> >
> > what is it trying to tell me?
>
>
Guys,
I have a number of jpegs and tiffs that are stored in a bytea field in a
PostgreSQL database by a Java program using Hibernate.
I need to copy these out to a flat file via pgsql for viewing, etc. I've
tried
psql -c 'select binarydata_field from my_image_table where id=1' mydb >
flatfile
On Fri, Jul 22, 2005 at 02:20:31PM +0200, Roman Neuhauser wrote:
>
> select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet)
>
> ERROR: invalid input syntax for type inet: ""
>
> what is it trying to tell me?
NULLIF returns the first argument if the arguments aren't equal,
s
select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet)
ERROR: invalid input syntax for type inet: ""
what is it trying to tell me?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. htt
# [EMAIL PROTECTED] / 2005-07-22 13:04:27 +0200:
>
>
> > # [EMAIL PROTECTED] / 2005-07-22 09:10:01 +0200:
> > > > # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> > > > > I use some updateable views to handle my data (which are
> > > > > amazingly slow), which gives me ultimate flexibility to
> # [EMAIL PROTECTED] / 2005-07-22 09:10:01 +0200:
> > > # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> > > > I use some updateable views to handle my data (which
> are amazingly
> > > > slow), which gives me ultimate flexibility to handle my data.
> > > >
> > > > there are some insert ru
# [EMAIL PROTECTED] / 2005-07-22 09:10:01 +0200:
> > # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> > > I use some updateable views to handle my data (which are amazingly
> > > slow), which gives me ultimate flexibility to handle my data.
> > >
> > > there are some insert rules which use curr
WA Pennant & Flag Displays - Darren wrote:
Thanks for your advice:
Do you get different messages with SSL disabled?
Yes - "Error connecting to the server: server closed the connection
unexpectedly. This probably means the server terminated abnormally before
or while processing the request."
G
Thanks for your advice:
Do you get different messages with SSL disabled?
Yes - "Error connecting to the server: server closed the connection
unexpectedly. This probably means the server terminated abnormally before
or while processing the request."
Can you connect with psql locally?
No
Can you co
Richard Sydney-Smith schrieb:
> An associate is using Postgresql 8 on a windows xp system. The
> installation has been operating for several months and he has recently
> tried installing some software and postgresql has begun refusing
> connection " could not receive server response to SSL negotiat
Ets ROLLAND wrote:
Hello !
I made the port of an Access 2002 Database to PostgreSQL 8, it seems to work.
I still use MS-Access 2002 for the application, using ODBC with linked tables.
For all the data created BEFORE the transfert to PostgreSQL, all works fine.
For the records created SINCE this
Hi there,
Thanks for your and Martijn's comments, I obviously forgot to put in some
vital detail:
> - You never want to set enable_seq off in production database.
That's what I thought...
> - did you run "VACUUM ANALYZE speed" lately?
Yes, just before I ran all of the queries in my last email
Hello !
I made the port of an Access 2002 Database to
PostgreSQL 8, it seems to work.
I still use MS-Access 2002 for the application,
using ODBC with linked tables.
For all the data created BEFORE the transfert to
PostgreSQL, all works fine.
For the records created SINCE this transfert, i
Richard Sydney-Smith wrote:
An associate is using Postgresql 8 on a windows xp system. The
installation has been operating for several months and he has recently
tried installing some software and postgresql has begun refusing
connection " could not receive server response to SSL negotiation pa
> # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
> > I use some updateable views to handle my data (which are amazingly
> > slow), which gives me ultimate flexibility to handle my data.
> >
> > there are some insert rules which use currval() to get the last
> > sequence id for my data which I h
38 matches
Mail list logo