Hi All,
I recently had a need to have conditional update rules on a view. This
didn't work too well:
CREATE RULE insert_one AS
ON INSERT TO one WHERE NEW.id IS NULL
DO INSTEAD (
INSERT INTO _simple (id, guid, state, name, description)
VALUES (NEXTVAL('seq_kinetic'), NEW.guid, NEW.state, NEW.n
On Apr 21, 2005, at 11:16 PM, Tom Lane wrote:
The only real solution I know of is to sleep for a little before
trying to issue the DROP DATABASE. Certainly, adding more database
traffic as you suggest isn't going to improve matters.
I think just sleeping is all I'm doing. The extra database traffi
David Wheeler <[EMAIL PROTECTED]> writes:
> 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 acce
"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 postgr
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 us
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
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
you
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
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: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...cas
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 Type
-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
|
|
| Po
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
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"
>
> 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,
-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 (
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 RECO
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
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
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:
>
> SELE
>
> 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 t
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', timeofday()::t
>
> 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, 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)::ti
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 s
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 th
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
http://groups-beta.google.com/group
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 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:
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:
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,
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] L
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
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 t
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)
> >
> >
> >
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
> ---+
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
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
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
> ---+---+-
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 ti
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 | 26601
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: +31(0)5
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
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 m
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
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
http://groups-beta.google.com/group/comp.os.linux.misc/msg/b299a71fd540c2b8?
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
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
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
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,
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 en
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 wa
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 1
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. Ho
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 TIMESTAM
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.
--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
logi
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 users
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 re
\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
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
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 mes
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
current
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.: N
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
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 t
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()
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
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 f
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 s
[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 real
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 i
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 Files\PostgreSQL\8.0\da
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 th
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
query
[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
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 nearly
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_
78 matches
Mail list logo