Chris (and others), thank you for the good explanation! =)
I will try to use database as you recommend, thank you again for the
advices!
Regards,
/Alexandre.
On Apr 20, 2005, at 17:39, Chris Browne wrote:
I think you're missing two points:
1. With careful design, the ISAM wrapper can _avoid_
A. Cropi wrote:
my objectives: (1) allow users to make query through the web (i guess
i will do this via PHP interacting with the postgresql)
my questions are: (1) is it reasonable to put the bookcontent into the
CONTENT column? (2) the content of the book can be very long (some of
them have
[EMAIL PROTECTED] schrieb:
When I did the windows install (NOT as a windows service) but as a
task to be manually started and stopped, it did not creat a DATA
directory, nor did it create a postgresql.conf file.
I even used windows explorer search to confirm that no such file
exists. I did the
I have a question about syntax and feasibility.
I do the following:
CREATE FUNCTION xyz(int, int) RETURNS RECORD AS '...'
CREATE TABLE abc(a int, b int);
Now I want to call my xyz function once for each row in abc and I want
my RECORD to be (x int, y int, z timestamptz). How do I write that
I'm trying to add some clarity to the rules I have on my tables. When a rule
is broken, I want to give a more informative message, so that the client
side can deal with it in a nicer manner. Right now I'm creating plpgsql
functions, and raising an exception in there with the customized text.
Is
On 21 Apr 2005 at 0:50, [EMAIL PROTECTED] wrote:
I just did a windows install of postgresql. I cannot find or edit the
postgresql.conf. This is a new Dell machine running XP Professional
I'm running it on my Dell laptop with XP Professional, and it's in
C:\Program
Hi!
I have a huge problem here. On a busy server (a web system, mainly java
servlets/jsp running on tomcat) running postgresql-8.0.2, all of a sudden,
one of the postgres processes gets into the state idle in transation
(revealed by `ps axU pgsql').
We use transaction very sparesly, so this is
[I've got a private reply from Scott, which I won't quote here, which
can be fairly (I hope) summarized as search the pgsql-performance
list. Well, I've done it, and I feel it's due to bring the issue
back in public. So if I seems I'm replying to myself, it's not,
I'm replying to Scott. I've
On Apr 21, 2005, at 12:50 AM, [EMAIL PROTECTED] wrote:
I just did a windows install of postgresql. I cannot find or edit the
postgresql.conf. This is a new Dell machine running XP Professional
OS.
I chose not to install as a windows service, but as a job which I can
start and stop.
Where
Thanks for your help!
Just want to share the solution I got to solve my problem. I wanted to
be eable to search a string (say X) (non case sensitive) without having
meta-character involved. The X string come directy from the web so any
[%]* may cause error in regular expression (because they
On 4/21/05, Marco Colombo [EMAIL PROTECTED] wrote:
Generally XFS and JFS are considered superior to ext2/3.
Do you mind posting a reference? I'm really interested in the comparison
but everytime I asked for a pointer, I got no valid resource, so far.
Well, my point being the ones I find
Try SELECT timeofday()::TIMESTAMP;
Regards,
Ben
Christopher J. Bottaro [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do this?
timeofday() returns a
Hello sir
actually i am working with Qt using postgresql i have to get connection
{(database(trainee),user(trainee))}
from the network (database remote accessing) so i have configured
postgresql.conf and pg_hba.conf upto some extents
the fields that i have configured r as follows even then
I have no idea if this is the correct list to use.
How do you obtain a list of the functions and their argument lists that have
been created on a Postgres database?
I have tried searching various lists and archives plus the documentation.
All I want to find is a list of:-
Function name
David Gagnon wrote:
Maybe there is a simple way to to this but I want find string X in
different column. The search must not be case sensitive.
So that searching aBc in abcDef return true. I don't want
META-CHaracter. Or at least I don't want meta-character to cause
errors (i.e.: No
Hi,
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the _actual_ time. How do I do this?
timeofday() returns a string, how do I convert that into a TIMESTAMP?
Is it possible to create a column with DEFAULT value evaluated to the actual
I haven't had any joy trying to install the Redhat RPMs on mandrake 10.1.
It might be me but I did take some time trying. I also tried using the
SRPMs and building my own but that didn't work either.
Since then I've compiled my version and it works great. The only thing I
needed to do was
Hi,
I had some issues
with previous versions of Postgresql using temporary tables in
functions.
The main issue was
that the both indexes pg_attribute_relid_attnam_index and
pg_attribute_relid_attnum_index were always growing and I had to restart
postgresql in single mode and run a REINDEX
\df
\df functionname
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rob Stone
Sent: Thursday, April 21, 2005 9:48 AM
To: 'pgsql-general@postgresql.org'
Subject: [GENERAL] List of Functions
I have no idea if this is the correct list
One thing I can think of is some kind of inadvertent SQL injection.
Somebody put
; begin;
into a string that got sent to the server unescaped?
The only other thing I can think of is if there was a hole in the
logic in one of your explicitly started transactions that allowed the
handle to be
Hi
We are likely to build a desktop application in
VB.Net and we are in a hunt to go for a database.We
need a free version basically if it dosnt meets our
demand then we can go for the developer versions.
For our application it may run as client server
application may be of 10 concurrent
--On torsdag, april 21, 2005 13.43.27 + Ian Harding
[EMAIL PROTECTED] wrote:
One thing I can think of is some kind of inadvertent SQL injection.
Somebody put
; begin;
into a string that got sent to the server unescaped?
The only other thing I can think of is if there was a hole in the
logic
I need to have an identity column in a view.
I was using bigserial columns in tables and Postgre created nextval function
expression automatically.
Now I have tried with nextval function in the view, but with no success
How can I put a bigserial column in a view ?
Thanks.
John DeSoi wrote:
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do this?
timeofday() returns a string, how do I convert that into a TIMESTAMP?
On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
John DeSoi wrote:
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do
syed magthum wrote:
Hi
We are likely to build a desktop application in
VB.Net and we are in a hunt to go for a database.We
need a free version basically if it dosnt meets our
demand then we can go for the developer versions.
For our application it may run as client server
application may be of
On Apr 21, 2005, at 1:22 AM, amit kumar awasthi wrote:
# Using sockets credentials for improved security. Not available
everywhere,
# but works on Linux, *BSD (and probably some others)
local all all ident sameuser
#local all all 127.0.0.1 sameuser
only this
The native win32 version of Postgres will work for you without issues and be
superior to the other choices you mentioned.
The MSDE runtime version of MS SQL server is crippled and only accepts a few
conncurrent connections.
Mysql is fast, but lacks things you will probably need such as triggers,
All,
Is there a way to determine cardinality (size) of an
index? In general how to you query the 'attributes'
(for lack of a better word) of an index.
thanks,
Bill
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Zlatko Matic wrote:
I need to have an identity column in a view.
I was using bigserial columns in tables and Postgre created nextval
function expression automatically.
Now I have tried with nextval function in the view, but with no success
How can I put a bigserial column in a view ?
What do
Christopher J. Bottaro wrote:
Alvaro Herrera wrote:
On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
John DeSoi wrote:
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it
References:
http://archives.postgresql.org/pgsql-performance/2005-01/msg00131.php
http://archives.postgresql.org/pgsql-performance/2004-05/msg00130.php
http://archives.postgresql.org/pgsql-performance/2003-08/msg00191.php
Well, my front-end is MS Access, and Access sees views as tables.
When I have forms with subforms there is a problem with linking them if
table has no primary key. As Access thinks that a view is a table, I need a
primary key in the view.
Also, Access doesn't like text field of ODBC-linked table
On Thu, 2005-04-21 at 08:42, syed magthum wrote:
Hi
We are likely to build a desktop application in
VB.Net and we are in a hunt to go for a database.We
need a free version basically if it dosnt meets our
demand then we can go for the developer versions.
For our application it may run
On Thu, 2005-04-21 at 09:52, Christopher J. Bottaro wrote:
Alvaro Herrera wrote:
On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
John DeSoi wrote:
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks
Thomas Hallgren wrote:
Why use timeofday() at all? Why not now(). It will return a timestamptz
without casts.
For the same reason that the OP couldn't use CURRENT_TIMESTAMP. It
returns the timestamp of the start of the transaction.
--
Alban Hertroys
MAG Productions
T: +31(0)53 4346874
F:
Hi people, is there a swtich or something to instruct a between statement
hat it must perform a most specific match ?
These are the details, i have these table
name| start| end
---+---+-
general | 266 | 266
specific |
On Thu, 2005-04-21 at 10:21, Thomas Hallgren wrote:
Christopher J. Bottaro wrote:
Alvaro Herrera wrote:
Ahh, thanks for the tip. I guess I'll just stick with
timeofday()::timestamp...its more concise anyways...
Why use timeofday() at all? Why not now(). It will return a timestamptz
On Thu, 2005-04-21 at 10:51, [EMAIL PROTECTED] wrote:
Hi people, is there a swtich or something to instruct a between statement
hat it must perform a most specific match ?
These are the details, i have these table
name| start| end
Scott Marlowe wrote:
I think you missed the first part of the conversation...
I sure did. Sorry...
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi,
i like to use postgresql for managing my postfix mailserver via lookup tables.
for each mailbox domain i have a system account to have quotas per domain. (i
know there are other solutions like postfix-vda and so on)
When i add a domain to the mailsystem i have to add a user account for this
On Thu, Apr 21, 2005 at 09:51:16AM -0600, [EMAIL PROTECTED] wrote:
Hi people, is there a swtich or something to instruct a between statement
hat it must perform a most specific match ?
These are the details, i have these table
name| start| end
On Thu, 2005-04-21 at 10:51, [EMAIL PROTECTED] wrote:
These are the details, i have these table
name| start| end
---+---+-
general | 266 | 266
specific | 2660124 | 2660124
(2 rows)
unsing the query:
I am writing a tsearch2 trigger function in plperl. I would like to
run a query similar to this:
setweight(to_tsvector(col1),'b') || setweight(to_tsvector(col2),'a')
and insert the result into the tsvector column. I know I can call
spi_exec_query('select ...') and insert the result, but is this
I was under the impression that using timezone('UTC', now())::timestamptz
would give me the current UTC time, with timezone offset. Instead I am
getting the UTC time, but with an offset of -07(my local time). How do I get
UTC time, with the 0 offset that it should be?
Thanks,
Steve
On Thu, 21 Apr 2005, Dinesh Pandey wrote:
\df
\df functionname
also, \df function*
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rob Stone
Sent: Thursday, April 21, 2005 9:48 AM
To: 'pgsql-general@postgresql.org'
Subject: [GENERAL]
I'm trying to track
down a hang in a slony "lock set" command, which creates triggers on a set of
tables. I assume that it's getting blocked by a lock on a table somewhere, and
I'd like to print out all the "create trigger" statements in the postgres
log.
I have
log_min_messages = DEBUG5,
Hi List,
I had a database with a 8 Mb pg_dump file with 1.7 Gb in PG_DATA.
I dropped the database and tried to recreate the db with this
step:
psql template1 data.sql
All tables and all data was restored and to help accessing the db
I tried to vacuum analyze it, yielding this error message:
On Wed, 20 Apr 2005, Tom Lane wrote:
On Tue, Apr 19, 2005 at 05:39:42PM -0700, Dennis Sacks wrote:
I am Seeing twelve of these messages every five to ten seconds in the
Postgresql serverlog when my java application is running:
2005-04-19 16:43:03 LOG: 0: statement: rollback;
Hi All,
I have some tests that create a database, run a bunch of tests against
it, and then drop it. But I was running into an issue where I'd get
this error even after I disconnected from the test database:
ERROR: source database foo is being accessed by other users
And no, no other users
On Thu, 21 Apr 2005, Scott Marlowe wrote:
References:
http://archives.postgresql.org/pgsql-performance/2005-01/msg00131.php
http://archives.postgresql.org/pgsql-performance/2004-05/msg00130.php
http://archives.postgresql.org/pgsql-performance/2003-08/msg00191.php
These attempts were run at 4/21/2005 13:15:00 -07.
UTC: 4/21/2005 20:15:00
SELECT timeofday()::timestamp
04/21/2005 13:15:00
SELECT timezone('UTC', now())
04/21/2005 20:15:00 PM
SELECT timezone('UTC', timeofday()::timestamp)::timestamp without time zone
04/21/2005 06:15:00 - What the heck is
Whoa, hold on. My original post was this:
QUOTE:
Generally XFS and JFS are considered superior to ext2/3.
ext3, in my experience, isn't much slower than ext2. Plus the decreased
time required to bring up a server after a power outage is worth
something too.
Having used ext3 quite a bit, I'd
On Thu, 2005-04-21 at 15:35, Steve - DND wrote:
These attempts were run at 4/21/2005 13:15:00 -07.
UTC: 4/21/2005 20:15:00
SELECT timeofday()::timestamp
04/21/2005 13:15:00
SELECT timezone('UTC', now())
04/21/2005 20:15:00 PM
SELECT timezone('UTC', timeofday()::timestamp)::timestamp
What version of PostgreSQL are you running? I seem to remember a few
versions ago the offset having the wrong sign.
I'm running 8.0.2 Win32.
Steve
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, Apr 21, 2005 at 01:35:16PM -0700, Steve - DND wrote:
These attempts were run at 4/21/2005 13:15:00 -07.
UTC: 4/21/2005 20:15:00
SELECT timeofday()::timestamp
04/21/2005 13:15:00
SELECT timezone('UTC', now())
04/21/2005 20:15:00 PM
SELECT timezone('UTC',
Perhaps this is what you want:
SELECT timezone('UTC', timeofday()::timestamptz);
That did it. Strangely, I thought I had tried that already, but I must not
have. My next question would be if I did:
SELECT timezone('UTC', timeofday()::timestamptz):timestamptz;
Why do I get the
On Thu, Apr 21, 2005 at 04:11:57PM -0700, Steve - DND wrote:
Perhaps this is what you want:
SELECT timezone('UTC', timeofday()::timestamptz);
That did it. Strangely, I thought I had tried that already, but I must not
have. My next question would be if I did:
SELECT
Steve - DND wrote:
What version of PostgreSQL are you running? I seem to remember a few
versions ago the offset having the wrong sign.
I'm running 8.0.2 Win32.
BSD Unix looks strange too:
test= select current_timestamp;
timestamptz
How do I install the headers and libraries for extending
postgreSql? They are not installed by the windows installer (see the following
post: http://archives.postgresql.org/pgsql-hackers-win32/2005-03/msg00169.php ).
Regards,
Mark Miller
I just discovered that my previous post concerning this had the same
subject line as a discussion that took place in January. I'm not asking
the same question though, so here I go again with my question about
syntax and feasibility.
I do the following:
CREATE FUNCTION xyz(int, int) RETURNS
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I would like to write a trigger that will do complex calculations on a
row, so the idea is to slipt the work throught several functions, and as
the row has 23 fields, it's not an option to pass them one by one, so I
tried to pass the record itself
Again looking at the documentation, we see that timestamp with
time zone AT TIME ZONE zone means Convert UTC to local time in
given time zone and has a return type of timestamp without time
zone. So if we run the above command without the final cast
around 16:25 PDT / 23:25 UTC, we get
Ok, I've been using postgres for a-while now, and am curious how you
guys handle this. What is the best way to make modifications to
tables that have lots of dependent objects, like views? Do you just
do the obvious drop...cascade and manually re-create your views? Do
you keep your create view
On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
carlos=# insert into test (c1) values( 'test');
ERROR: NEW used in query that is not in a rule
CONTEXT: PL/pgSQL function tftest line 2 at perform
PostgreSQL 8.0 and later have improved support for composite types.
Here's the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Fuhr wrote:
| On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
|
|carlos=# insert into test (c1) values( 'test');
|ERROR: NEW used in query that is not in a rule
|CONTEXT: PL/pgSQL function tftest line 2 at perform
|
|
|
On Thu, Apr 21, 2005 at 05:56:41PM -0700, Steve - DND wrote:
Okay, I understand what you're saying now, but then is a time without a
timezone implicitly assumed to be UTC? Is there a way to explicitly make the
timezone on the stamp be UTC, if the prior is not the case?
See Date/Time Types in
On Thu, Apr 21, 2005 at 09:24:49PM -0500, John Browne wrote:
Ok, I've been using postgres for a-while now, and am curious how you
guys handle this. What is the best way to make modifications to
tables that have lots of dependent objects, like views? Do you just
do the obvious drop...cascade
I finally got my windows install of postgresql to work (as a
service). It would not work when I did the other install (not as a windows
service).
Now, I am working through some tutorial examples.
My question is, what command can I issue to list all the tables in a
database?
I found the
On Thu, Apr 21, 2005 at 09:03:43AM -0400, David Gagnon wrote:
Just want to share the solution I got to solve my problem. I wanted to
be eable to search a string (say X) (non case sensitive) without having
meta-character involved. The X string come directy from the web so any
[%]* may
On Thu, Apr 21, 2005 at 11:33:07PM -0400, [EMAIL PROTECTED] wrote:
My question is, what command can I issue to list all the tables in a
database?
If you're using psql then you can use the \dt command, although that
will show only the tables in your search path (which is probably what
Thanks for the help with /dt... Mike, your post helped me to discover psql
command window, I had been trying out the pgAdmin ...
I found an interesting article regarding MSAccess as a front end to
Postgresql, so I downloaded the psqlodbc installer. I will be getting up
the nerve to run the
How to install Postgres 8.0.1
that supports 64-bit integer/date-time.
#
./configure --prefix=/usr/local/pgsql --with-tclconfig=/usr/local/lib
--with-tcl
checking build
system type... sparc-sun-solaris2.8
checking host system
type... sparc-sun-solaris2.8
checking which
template to
David Parker [EMAIL PROTECTED] writes:
I'm trying to track down a hang in a slony lock set command, which
creates triggers on a set of tables. I assume that it's getting blocked
by a lock on a table somewhere, and I'd like to print out all the
create trigger statements in the postgres log.
I
74 matches
Mail list logo