am 19.06.2006, um 5:26:54 -0700 mailte Mustafa Korkmaz folgendes:
> Hi,
>
> Iam using PostgreSQL 7.4.5 on a linux machine, and have the problem
> that an easy "SELECT field1, field2, field3 FROM a_table"-statement
Hey, read my answer on your question in the news, MID
<[EMAIL PROTECTED]> ;-)
A
Daniel wrote:
Hi All..
Is there a way to do auto database bacl up in "PostgreSQL".
Please Reply..
There are different ways, the most common is to do a pg_dump /
pg_dumpall once a night via cron.
http://www.postgresql.org/docs/8.1/static/backup.html
--
Postgresql & php tutorials
ht
hi, there. i'm trying to write a SQL statement which does the following
things.
1. checks if data already exists in the database
2. if not, insert data into database otherwise skip.
for example, i'd like to insert a student called 'Michael Jordan' whose
ID is 'JORDANMICHAEL' only if the id, 'JORD
sorry to nitpick, but I think that to get this query to do exactly
what you want you'll need to add ordering over EventTime on your sub-
selects to assure that you get the next event and not just some event
later event on the given day.
-ae
On Jun 20, 2006, at 11:12 AM, Gurjeet Singh wrot
>
> I read recently about the efforts underway to COPY from a view,
> however I was wondering what the current best-practices are for being
> able to copy out of a view and import that data into an actual table
> elsewhere. I am currently doing psql -c "SELECT ..." and the using a
> bit of perl
Hi all
I desperately needs OLEDB Provider for Postgres. Can any one help me?
Thanks and Regards
A.M.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
I was wondering if anyone happens to know whether there is an Aggregate
function available in Postgres that can do an OR on a column of the bit varying
type. For example I would like to do something as follows:
bitstring
*
1110
0100
SELECT bitwise_or(bitstring) FROM table;
Result
HelloI want to know how to print a database eschema with the information of tables, fields,keys,etc Thanks Giraldo
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
I don't want to revisit or be redundant... but is there a quick and
dirty and cross-platform system for developing user input forms for
Postgres? Ideally, I am interested in something such that you can give
it ("it" being something like a Python function) a table name,
resulting in a magically app
I have a completely idle postgresql system (all backends "idle", none
"in transaction"); every time I attempt to vacuum a particular table,
it hangs
after a while. Here is the output of vacuumdb:
INFO: vacuuming "public.ledgerdetail"
INFO: index "ledgerdetail_pkey" now contains 11574842 row vers
Hi Everybody,In my research project, I need a DBMS that supports XML storage and retrieval, and provides ECA rule support.Currently, I am using Oracle 10g. However, I am interested in using Open Sources DB.
I am looking for a document addressing the XML support in the current Postgresql release (8
> CREATE OR REPLACE FUNCTION alias(
>v_mask alias.mask%TYPE,
>) RETURNS INT8 AS
Sorry my mistake it should be:
CREATE TABLE alias (
alias_id BIGSERIAL PRIMARY KEY,
mask VARCHAR(20) NOT NULL DEFAULT '',
Hi
I have following table:
CREATE OR REPLACE FUNCTION alias(
v_mask alias.mask%TYPE,
) RETURNS INT8 AS
with index:
CREATE INDEX alias_mask_ind ON alias(mask);
and this table has about 1 million rows.
In DB procedure I execute:
LOOP
<.
Hi,
Iam using PostgreSQL 7.4.5 on a linux machine, and have the problem
that an easy "SELECT field1, field2, field3 FROM a_table"-statement
takes 10 minutes to give an answer. The table has 750.000 datarows. I
also made an VACUUM a_table before the statement, but it doesnt help at
all. The table h
Hello to all,
This is my first time posting to this forum and I am very
new to PostgreSQL. I am very excited about using it. I have set up
a database and just need a point in the right direction on
interfacing. I have an orders and messages database. One of
the providers I would li
Hi All..
Is there a way to do auto database bacl up in "PostgreSQL".
Please Reply..
Thanks,
Daniel
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Title: Message
Hello,
I'm curently in
version 7.3
I know, this is an
old version and It would be a good idea to migrate.
Before doing that, I
would like to make a dump of my base. That's why I must running this service at
any coast.
Thank's for your
help !! :)
2006-06-19 10:31:55 L
How do you retrieve a comment on a constraint? For example, consider
the following table and comment:
create table people (
person_id serialprimary key,
uid varchar(25) not null,
constraint uid_alphanumeric check (uid ~ '^[a-z0-9_]+$')
);
comment on constra
Hello everyone -
Array columns are, by default, 1-offset in their
subscripting. Since I usually am calling postgres
from a language with zero-offset, I would prefer
that postgres conform to that. The online
documentation hints that this may be configurable
but I haven't been able to find how th
Harold,
That's brilliant.
Sim
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Sim Zacks <[EMAIL PROTECTED]> writes:
I want my query resultset to be
Employee,EventDate(1),EventTime(1),EventType(1),EventTime(2),EventType(2)
Where Event(2) is the first event of the employee that took place
af
After a reboot today Postgresql 8.1 came back up and started
accepting connections over TCP but the unix socket file was missing.
This is on Debian Stable, and I can't imagine what might of removed
the file.
Running psql I get:
$ psql test
psql: could not connect to server: No such file
Hi Tim,
Thanks for the advice, it saves me continuing to dig in the help files
and my reference books any longer. I don't know how much help I could be
in adding features but I am glad to participate in any way I can in the
community. I will follow your link to the TODO pages.
Thanks again.
John Tregea wrote:
Greeting again,
I am writing records to postgreSQL from an IDE called revolution. At the
time I perform the INSERT command I need to retrieve the value of the
serial_id column from the newly created row.
Is it possible to have a specified column value returned after the
I
Sorry, I just realised this should have gone to the SQL list... (Bloody
Newbie's) :-[
John Tregea wrote:
Greeting again,
I am writing records to postgreSQL from an IDE called revolution. At
the time I perform the INSERT command I need to retrieve the value of
the serial_id column from the ne
Greeting again,
I am writing records to postgreSQL from an IDE called revolution. At the
time I perform the INSERT command I need to retrieve the value of the
serial_id column from the newly created row.
Is it possible to have a specified column value returned after the
INSERT (rather than t
On Wed, 21 Jun 2006, Relyea, Mike wrote:
> ExecutorState: 550339936 total in 123 blocks; 195003544 free (740135
> chunks); 355336392 used
> HashBatchContext: 293593176 total in 44 blocks; 3107384 free (80
> chunks); 290485792 used
> TIDBitmap: 2088960 total in 8 blocks; 924720 free (27 chunks);
On Wed, Jun 21, 2006 at 04:12:08PM +0200, Alban Hertroys wrote:
> Martijn van Oosterhout wrote:
> >ISTM that what would really work well is some kind of "Merge Sort" node
> >that would work by having multiple subnodes which are already sorted
> >and merging them into one sorted list.
>
> Would...
Another way is to use correlated-subqueries (refrencing outer
query's columns inside a subquery; hope this feature is supported):
select *
fromFileVersionHistory H1
where modificationDate = ( select max(modificationDate)
fromFileVersionHistory H2
Hrishikesh Deshmukh wrote:
Dear All,
I have a sql MS-SQL script, i would like to run the script in
postgresql. Is there a MS-SQL2PostgreSQL converter available or does one
has to go trouble shooting line by line changing data types etc one line
at a time??!!!
Something on this page might he
I assume the the task takes longer than 5 seconds to complete?
Are you running the same OS? Can pgsql distribute the load on both
Xeon processors? Is pgsql custom compiled for a specific architecture(Pentium III, for example)? How do you measure the response time? Arethere other apps involved?t.n.a
On 6/21/06, Hugo <[EMAIL PROTECTED]> wrote:
Hi, I am testing my application and DB (postgres 8.1.4 ) on a :
DELL-Power Edge 1800 with 2 Xeon 3.2ghz, 2 Gb RAM and 2 SCSI 149 Gb
each.
trouble is that the same application and DB(postgres 8.0.4) runs on a:
DELL pentium 3 with 526MB of RAM a
Hi, I am testing my application and DB (postgres 8.1.4 ) on a : DELL-Power Edge
1800 with 2 Xeon 3.2ghz, 2 Gb RAM and 2 SCSI 149 Gb each.trouble is that the same application and DB(postgres 8.0.4) runs on a: DELL pentium 3 with 526MB of RAM and an IDE 20 GB and comparing the performance
Dear All,I have a sql MS-SQL script, i would like to run the script in postgresql. Is there a MS-SQL2PostgreSQL converter available or does one has to go trouble shooting line by line changing data types etc one line at a time??!!!
Thanks,Hrishi
"Jasbinder Bali" <[EMAIL PROTECTED]> writes:
> I've disabled my SELinux and now postgres is being able to access the shared
> library i.e test.so file.
> Don't know if thats the right way to do it or not.
It's not. Almost certainly, SELinux is keying the rejection off the
fact that you have the .
I've disabled my SELinux and now postgres is being able to access the shared library i.e test.so file.Don't know if thats the right way to do it or not.PS: I'm using Fedora core 2 OSThanks,~Jas
On 6/21/06, Joe Conway <[EMAIL PROTECTED]> wrote:
Jasbinder Bali wrote:> Now the error is different. It c
well as of now my postgres is running on a trusted connection that well as of now my postgres is running on a trusted connection that i've specified in pg_hba.conf file.
ls -l /usr/include/pgsql/server/test.so shows the following
-rw-rw-rw- 1 root root 4620 Jun 21 12:00 /usr/include/pgsql/server/
Jasbinder Bali wrote:
Now the error is different. It cries something on the permissions.
ERROR: could not load library "/usr/include/pgsql/server/test.so":
/usr/include/pgsql/server/test.so: failed to map segment from shared
object: Permission denied
Can you comment on this?
What does
l
On 6/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> create or replace rule insert_fsv as on insert to frequency_service_view
> do instead
> (
> insert into frequency_operation
> select new.table_name, new.frequency, old.code where new.set =
On Jun 21, 2006, at 9:42 AM, Jasbinder Bali wrote:
Hi,
I raised this problem yesterday aswell. I'm badly stuck at this point.
The problem is as follows:
I have a C function that i want to use in my postgres function.
I adopt the following steps to do that.
--- compile the C file as follows
Yes, that helped. I was missing that leading '/'Now the error is different. It cries something on the permissions.ERROR: could not load library "/usr/include/pgsql/server/test.so": /usr/include/pgsql/server/test.so: failed to map segment from shared object: Permission denied
Can you comment on thi
Jasbinder Bali wrote:
CREATE FUNCTION command(integer) RETURNS integer
AS 'usr/include/pgsql/server/test_func', 'command'
LANGUAGE C STRICT;
when i try to run this function, always gives me the follwoing error:
ERROR: could not access file "usr/include/pgsql/server/test_func": No
Hi,I raised this problem yesterday aswell. I'm badly stuck at this point.The problem is as follows:I have a C function that i want to use in my postgres function.I adopt the following steps to do that.
--- compile the C file as follows gcc -shared -o test_func.so test_func.c test_func.c is
I've tried everything so that my .so file is recognized but in vein.Don't know whats going wrong.~JasOn 6/20/06, Tom Lane <
[EMAIL PROTECTED]> wrote:Bill Moran <
[EMAIL PROTECTED]> writes:> In response to "Jasbinder Bali" <[EMAIL PROTECTED]>:>> I get the follwing error>> ERROR: could not access fi
Martijn van Oosterhout wrote:
ISTM that what would really work well is some kind of "Merge Sort" node
that would work by having multiple subnodes which are already sorted
and merging them into one sorted list.
Would... So this isn't available yet?
The planner would use this whenever it saw a
On 6/20/06 8:17 PM, "Florian G. Pflug" <[EMAIL PROTECTED]> wrote:
> Maybe you could ask at some postgresql support companies how much effort it
> would
> be to add a "without check" flag to "alter table add constraint foreign key",
> and
> how much they'd charge for it...
Or if I get ambitious, d
On Mit, 2006-06-21 at 14:16 +0200, Martijn van Oosterhout wrote:
> On Wed, Jun 21, 2006 at 02:08:29PM +0200, simon wrote:
> > > The aggregate stuff should work. something like:
> > >
> > > SET kategorie = (SELECT comma_aggregate(kategorie_bezeichnung) FROM ...)
> > >
> > > should do the trick.
>
On 6/7/2006 4:34 PM, Bruce Momjian wrote:
Tom Lane wrote:
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> At the same time, it strikes me that at least the userlock stuff, and
> maybe dbmirror as well, are candidates for pgfoundry rather than
> contrib/
We'd already agreed to move dbmirror to pgf
>>>
> >>> Is anybody over at the dev team considering what an onerous burden
> >>> this is? Is anyone considering doing away with it?
Just my 2 cents:
more and more databases have to run 24 * 7 , so something has to be done.
The last 15 years we also used Informix and we never, never had to
Kenneth Downs wrote:
Richard Huxton wrote:
Kenneth Downs wrote:
AFAIK it has always been the case that you should expect to have to
dump out your databases and reload them for version upgrades.
Is anybody over at the dev team considering what an onerous burden
this is? Is anyone consideri
On Wed, Jun 21, 2006 at 08:10:20AM -0400, Kenneth Downs wrote:
> Regardless of whether a package is commercial or free, it strikes me as
> counter to the very soul of programming to build in a burden that
> increases with the user's use of the program, threatening even to tip
> the balance altog
On Wed, Jun 21, 2006 at 02:08:29PM +0200, simon wrote:
> > The aggregate stuff should work. something like:
> >
> > SET kategorie = (SELECT comma_aggregate(kategorie_bezeichnung) FROM ...)
> >
> > should do the trick.
> i just found
>
> CREATE FUNCTION comma_aggregate(text,text) RETURNS text AS
Richard Huxton wrote:
Kenneth Downs wrote:
AFAIK it has always been the case that you should expect to have to
dump out your databases and reload them for version upgrades.
Is anybody over at the dev team considering what an onerous burden
this is? Is anyone considering doing away with it?
On Mit, 2006-06-21 at 12:34 +0200, Martijn van Oosterhout wrote:
> On Wed, Jun 21, 2006 at 12:23:44PM +0200, simon wrote:
> > or in other words, i just would like to know how to rewrite
> >
> > SET kategorie = array_to_string ((SELECT ARRAY (SELECT
> > kategorie_bezeichnung
> >
> > so it works i
Alban Hertroys wrote:
Jim Nasby wrote:
Probably a better bet would be going to 8.1 and using constraint
elimination.
Maybe you mean constraint exclusion?
If so, is that going to help excluding partitions (basically the same
thing, it seems) from a query based on an ORDER BY and a LIMIT?
On Wed, Jun 21, 2006 at 12:23:44PM +0200, simon wrote:
> or in other words, i just would like to know how to rewrite
>
> SET kategorie = array_to_string ((SELECT ARRAY (SELECT
> kategorie_bezeichnung
>
> so it works in psql7.3 as well.
The aggregate stuff should work. something like:
SET kateg
On Mit, 2006-06-21 at 00:09 +0200, simon wrote:
> On Die, 2006-06-20 at 15:34 -0500, Bruno Wolff III wrote:
> > On Tue, Jun 20, 2006 at 12:06:24 +0200,
> > simon <[EMAIL PROTECTED]> wrote:
> > > hi all
> > >
> > > i'm using postgres 7.3
> > >
> > > my problem is i want to build a helper table:
On Wed, Jun 21, 2006 at 11:56:27AM +0200, Alban Hertroys wrote:
> Say we take the query I posted:
> "SELECT * FROM mm_posrel ORDER BY number DESC LIMIT 25;"
> and the knowledge that this table is inherited by two other tables, with
> number being unique across them (though PostgreSQL probabl
Of cause I had probed it already - with command:
SGML_CATALOG_FILES=/usr/local/share/sgml/docbook/4.2/docbook.cat
./configure --prefix=/usr/local/pgsql --enable-depend --enable-nls
--enable-integer-datetimes --with-openssl --with-pam
--enable-thread-safety --with-includes=/usr/local/include
--
Jim Nasby wrote:
On Jun 19, 2006, at 7:00 AM, Alban Hertroys wrote:
Now all we need to do is getting MMBase to do its queries like this :P
Probably a better bet would be going to 8.1 and using constraint
elimination.
I searched the documentation, google and wikipedia for "constraint
eli
Am Dienstag, 20. Juni 2006 09:29 schrieb Oleg Golovanov:
> I have changed configure command. Currently I issue command:
> SGML_CATALOG_FILES=/usr/local/share/xml/docbook/4.2/docbook.cat
Replace that by /usr/local/share/sgml/docbook/4.2/docbook.cat.
--
Peter Eisentraut
http://developer.postgresql
I have not been able to download the document for the last day and a
half... Can someone please forward a copoy to me if you have one???
Thanks,
Gurjeet.
On 6/20/06, Chris Smith <[EMAIL PROTECTED]> wrote:
Thanks for everyone's suggestions. I found the following, which at least
seems to meet my
Hi Tomi.
Thanks for your answer, I was not aware of such a tool.
The next question at this point is (of course): what is the problem if
I have blob? Should I recode them as well?
Regards
Marco
On 6/20/06, Tomi NA <[EMAIL PROTECTED]> wrote:
On 6/19/06, Marco Bizzarri <[EMAIL PROTECTED]> wrote:
unsubscribe
--
Jad madi
-
Blog: http://jadmadi.net/
-
Web standards Planet
http://W3planet.net/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Below are links for the patch and binary (image) files for argument
handling improvements in ppa. You can view the original concept @
http://jawed.name/pgsql_soc. It provides support for both JS and JS
deficient users.
I tried to keep it within the coding guidelines set forth.
I appreciate and l
64 matches
Mail list logo
