ya'da man tom!
applied the patch, rebuilt, and postgres doesn't crash anymore. fixed
my syntax error, and all is working properly.
phew, my first experience with sql
thanks!
matt
On Thu, Dec 14, 2006 at 09:23:40PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > so maybe i'm using
You asked:
"I'd appreciate a clean yes/no; From a Java application, throught PG in
both directions, the same timestamp comes back that was handed to the
JDBC
driver so long as it's stored in a "timestamp without time zone"
attribute, nomatter neither where on earth the insert/update originates,
no
Richard Troy <[EMAIL PROTECTED]> writes:
> That said, nobody has yet assured me that when I give a timestamp I get it
> back unmolested.
Well, as far as the backend is concerned you do get it back unmolested
(up to the limits of float roundoff error, if you use float timestamps):
* unconditional
Richard Troy wrote:
> I'd appreciate a clean yes/no; From a Java application, throught PG in
> both directions, the same timestamp comes back that was handed to the JDBC
> driver so long as it's stored in a "timestamp without time zone"
> attribute, nomatter neither where on earth the insert/upda
> Richard Troy <[EMAIL PROTECTED]> writes:
> > See my post from a few minutes ago, but simply put, time/date is at least
> > as challenging as money or multibyte character. And, simply put, the
> > Postgres implementation of timezone is INSUFFICIENT.
>
> Really? We do all the things you have list
Richard Troy <[EMAIL PROTECTED]> writes:
> See my post from a few minutes ago, but simply put, time/date is at least
> as challenging as money or multibyte character. And, simply put, the
> Postgres implementation of timezone is INSUFFICIENT.
Really? We do all the things you have listed, and more
On Fri, Dec 15, 2006 at 12:10:24PM -0800, Richard Troy wrote:
> > I think your fundamental error is in using timestamp without time zone
> > in the database. Try with-time-zone if you want consistent results
> > across clients in different zones.
>
> I sure hope there's no issue with using timest
rised
queries to run, nor could I run multiple commands in one block (which I
need for speed to load big chunks of data).
So, I started hacking on the Provider, and ended up almost completely
rewriting it. I have placed a copy at:
http://people.freebsd.org/~reg/pgoledb-20061215.zip
Things that i
On Wed, 13 Dec 2006, Richard Huxton wrote:
> Randy Shelley wrote:
> > I get different result if I query it from my workstation(US/Easter
> > timezone) and from the server (GMT timezone).
>
> > A data type of timestamp without time zone should not do any
> > conversions. The java.sql.Timestamp doe
Richard Troy <[EMAIL PROTECTED]> writes:
> I'm not fully caught up with my Readings In Postgres, but this post caught
> my eye and raised a concern...
AFAIK, all the reasons you enumerate are good reasons to delegate the
problem to a timestamp WITH time zone column.
> First, you need at least min
Hi Tom, Randy, et al,
I'm not fully caught up with my Readings In Postgres, but this post caught
my eye and raised a concern...
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Randy Shelley" <[EMAIL PROTECTED]> writes:
> > The java.sql.Timestamp does not store any timezone info, just nano seconds
> > fro
In response to "Paul Khavkine" <[EMAIL PROTECTED]>:
>
> I have a bit of a peculiar situation.
>
> I have t move a PostgreSQL 7.3 installation from a freeBSD 4.8 to a FreeBSD
> 6.1.
> I have PG 7.3 installed in a single directory, have moved the directory from
> one server to another. After instal
Hi,
I am trying to move up in the world with my sql and need to do the following...
I have a subscribers table and I need to export to csv (semi-colon
separated) certain fields - that is fine, but I also need to export a
multi-select field from another table as one string (0 to n values
separated
On Fri, 2006-12-15 at 13:54 -0500, Paul Khavkine wrote:
> IpcSemaphoreCreate: semget(key=5433001, num=17, 03600) failed: No
> space left on device
>
> I have adjusted kernel settings for shared memory, but no go.
> We have a native PG 8.1 on same machine (different port) working just
> fine.
>
A
Hi Guys.
I have a bit of a peculiar situation.
I have t move a PostgreSQL 7.3 installation from a freeBSD 4.8 to a FreeBSD
6.1.
I have PG 7.3 installed in a single directory, have moved the directory from
one server to another. After instaling all the compat 4x and 5x libraries
everything seems
blackwater dev wrote:
How can I run a query based on a table name and get the column names
and data types returned?
Thanks!
Check out the columns view in the information_schema.
--
erik jones <[EMAIL PROTECTED]>
software development
emma(r)
---(end of broadcast)-
On Fri, 2006-12-15 at 12:26 -0500, blackwater dev wrote:
> How can I run a query based on a table name and get the column names
> and data types returned?
Usually your language API will give you what you need for that.
Sincerely,
Joshua D. Drake
>
> Thanks!
--
=== The PostgreSQL Compa
How can I run a query based on a table name and get the column names and
data types returned?
Thanks!
15 dec 2006 kl. 17:40 skrev Chris Browne:
[EMAIL PROTECTED] (Tom Lane) writes:
Henrik Zagerholm <[EMAIL PROTECTED]> writes:
Postgres has been designed as a server, and lots of
implementation details might not make sense in an embedded
context. you might be better served by SQLite, or some othe
[EMAIL PROTECTED] (Tom Lane) writes:
> Henrik Zagerholm <[EMAIL PROTECTED]> writes:
>>> Postgres has been designed as a server, and lots of
>>> implementation details might not make sense in an embedded
>>> context. you might be better served by SQLite, or some other
>>> such library.
>
>> ... It i
15 dec 2006 kl. 17:15 skrev Ragnar:
On fös, 2006-12-15 at 16:59 +0100, Henrik Zagerholm wrote:
I think I need to specify what I mean with embedded.
Its not that we try to embed it into an application.
It is just run from a flash disk and the datafiles are put on
standard raid attached disks.
On fös, 2006-12-15 at 16:59 +0100, Henrik Zagerholm wrote:
> I think I need to specify what I mean with embedded.
> Its not that we try to embed it into an application.
> It is just run from a flash disk and the datafiles are put on
> standard raid attached disks.
>
> Its an embedded device not
I think I need to specify what I mean with embedded.
Its not that we try to embed it into an application.
It is just run from a flash disk and the datafiles are put on
standard raid attached disks.
Its an embedded device not an embedded application. :)
Cheers,
Henrik
15 dec 2006 kl. 16:30 s
- Original Message From: "Thomas H.", etc.
Thank you all for your replies and suggestions. I apologize for not
replying earlier but the client is located several hours away and I have not
been back to the site until yesterday.
Here's an update of the situation (PostgreSQL 8.1.5 on Window
Henrik Zagerholm <[EMAIL PROTECTED]> writes:
>> Postgres has been designed as a server, and lots of
>> implementation details might not make sense in an embedded
>> context. you might be better served by SQLite, or some other
>> such library.
> ... It is also quite crash resistant with the WAL imp
Rafal Pietrak <[EMAIL PROTECTED]> writes:
> Looks like this thread have died away.
No, it moved to the appropriate mailing list:
http://archives.postgresql.org/pgsql-hackers/2006-12/msg00564.php
regards, tom lane
---(end of broadcast)--
Original Message -From: "RPK" <[EMAIL PROTECTED]>
I want to perform database backup (pgdump) from within VB.NET. Can it be
done?
I have an application developed using VB.NET that backs up the database
every 12 hours using a small batch file containing both a vacuum and pg_dump
backup script.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/15/06 07:50, Martijn van Oosterhout wrote:
> On Fri, Dec 15, 2006 at 07:44:16AM -0600, Ron Johnson wrote:
>>> The difference in performence will be determined by the cost of
>>> comparison. The cost of comparing strings is much higher than for
>>
On Fri, Dec 15, 2006 at 07:44:16AM -0600, Ron Johnson wrote:
> > The difference in performence will be determined by the cost of
> > comparison. The cost of comparing strings is much higher than for
> > integers, so it will be slower.
>
> And comparing INT8 is more expensive on a 32-bit system.
T
Thats true and we have.
With the amount of data we need to handle and the queries we need to
execute the postgresql database is way better suited for our needs.
SQLite do not have the functions we need anyways.
It is also quite crash resistant with the WAL implementation.
We still create the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/15/06 05:41, Martijn van Oosterhout wrote:
> On Fri, Dec 15, 2006 at 01:13:00PM +0200, Yonatan Ben-Nes wrote:
>> Hi all,
>>
>> I was wondering does the b-tree index performance change when it's
>> implemented on different data types fields? is it
Is there a way to see how free space is distributed across tables after
running vacuum (without looking through the verbose output)?
Thanks,
Greg
Automated Trading Desk, LLC (ATD) is the sole owner of Automated Trading
Desk Brokerage Services, LLC (ATDB) and Automated Trading Desk Financial
Ser
On fös, 2006-12-15 at 11:41 +0100, Henrik Zagerholm wrote:
> Hello list,
> I'm working on a project which tries to run postgre as a embedded
> database.
>
> I'm know looking at start up scripts and initdb scripts.
>
> What are the necessary files for running initdb and running postgres
> as a
On Fri, Dec 15, 2006 at 01:13:00PM +0200, Yonatan Ben-Nes wrote:
> Hi all,
>
> I was wondering does the b-tree index performance change when it's
> implemented on different data types fields? is it better to use one of them
> instead of the other for (=) comparisons?
> I'm especially interested be
Hi all,
I was wondering does the b-tree index performance change when it's
implemented on different data types fields? is it better to use one of them
instead of the other for (=) comparisons?
I'm especially interested between INT8 and TEXT data types.
Thanks a lot in advance,
Ben-Nes Yonatan
Hello list,
I'm working on a project which tries to run postgre as a embedded
database.
I'm know looking at start up scripts and initdb scripts.
What are the necessary files for running initdb and running postgres
as an embedded database?
All binary files and their deps are already fixed
On Fri, Dec 15, 2006 at 02:29:48PM +0530, Gurjeet Singh wrote:
> Is it session level !!??? I think it is query level; don't we discard the
> plan after each query? AFAIK, only the plpgsql and other pl/ sisters cache
> the plan for the queries inside their code-blocks. I am under the impression
> th
On Fri, Dec 15, 2006 at 03:54:01AM -0500, Brandon Aiken wrote:
> My understanding of VSS is that only one non-VSS aware app can access
> the data at any one time. All I meant was that if their NetBackup
> version was old that they probably cannot benefit from VSS since I doubt
> the Win32 PG port
On 12/14/06, Martijn van Oosterhout wrote:
On Thu, Dec 14, 2006 at 09:35:47AM -0800, Ben wrote:
> Interesting. Is that plan cached for the life of the session doing the
> inserts, the life of the trigger, or until the database is restarted?
Duration of a session, there is no support to cache a
My understanding of VSS is that only one non-VSS aware app can access
the data at any one time. All I meant was that if their NetBackup
version was old that they probably cannot benefit from VSS since I doubt
the Win32 PG port knows about it either.
Brandon Aiken
-Original Message-
From:
40 matches
Mail list logo
