Hello there!
http://news.zdnet.co.uk/software/0,39020381,39249666,00.htm
What do you think about this?
Nicolay
---(end of broadcast)---
TIP 6: explain analyze is your friend
Am Mittwoch, 1. Februar 2006 15:46 schrieb Noble, Robert:
> I get the following error from ecpg when it encounters a structure
> containing a bit field:
> ...
A quick guess would be that the parser simply doesn't know this syntax. I'll
have a look at it.
Michael
--
Michael Meskes
Email: Michael
On Friday 03 February 2006 13:02, Bruce Momjian wrote:
> Read the FAQ.
>
Thanks. Somehow it slipped my mind to go to PostgreSQL's FAQ :P
Regards,
Leonard Soetedjo
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Mott Leroy <[EMAIL PROTECTED]> writes:
> I turned on statement logging (and duration), issued a "pg_ctl reload"
> and got it working (logging to sys log and standard out). Now however,
> when i try to turn it off, it won't turn off, using the same procedure.
> I've now commented out all the line
Read the FAQ.
---
Leonard Soetedjo wrote:
> On Tuesday 31 January 2006 14:09, Jim C. Nasby wrote:
> > At present time, your best bet is to drop in on the IRC channel and ask
> > questions there. You'll normally get an immedi
On Thu, Feb 02, 2006 at 06:19:53PM -0500, Mott Leroy wrote:
> On Postgres 7.4.1
That's pretty old. If you can't upgrade to 8.0 or 8.1 then at least
consider staying up to date with bug fixes by using the latest
version in the 7.4 branch (currently 7.4.11).
> I've been experiencing some strangene
I presently use the following to export the database and as per my
earleir post hope to have an equivent to do the backup as per:
a) check for time since the last backup
b) if older than hrs
(i) perform a vacuum analyze
(ii) force a call to dbbackup
(iii) add a new record into fsysl
I would like each database to encapsulate its own backup procedure.
Each database contains a table (fsyslog) which has a record of each
backup taken:
At the application level I presently
a) check for time since the last backup
b) if older than hrs
(i) perform a vacuum analyze
(ii)
Michael Glaesemann wrote:
Hello, all!
Recently there was quite a bit of discussion regarding surrogate keys
and natural keys. I'm not interested in discussing the pros and cons of
surrogate keys. What I'd like to find out are the different methods
people actually use to uniquely identify c
Madison Kelly wrote:
Madison Kelly wrote:
Hi all,
I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).
I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am hop
Madison Kelly wrote:
Hi all,
I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).
I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am hoping to help fix the pr
Hi all,
I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).
I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am hoping to help fix the problem by being
able t
No, the name is .s.PGSQL.{port#}, and there is a lock file. Why do you
want to specify a different name?
---
[EMAIL PROTECTED] wrote:
> Is it possible to specify using PQsetdbLogin() or
> PQconnectdb()
> the name of unix do
You'll need to create a separate psql user.
See http://www.postgresql.org/docs/8.1/static/sql-createrole.html
Then get your php script to connect with that username/password.
Trans Porter wrote:
I want to setup a database that will be used by my php application. Right
now I installed postgres
On 2006-02-01, rlee0001 <[EMAIL PROTECTED]> wrote:
> Stephan,
>
> How do IN and NOT IN treat NULLs? Don't these functions search an array
> for a specified value returning true or false? I guess the intuitive
> thing for IN and NOT IN to do would be to return NULL if NULL appears
> anywhere in the
On Thu, 2 Feb 2006 [EMAIL PROTECTED] wrote:
> The problem was fixed by initializing the array before giving it a
> value. Not surprising Postges isnt as popular as it should be. I was by
> luck that I found this out - the manual says nothing about init arrays.
Well, I think that's in part becaus
On Wed, 1 Feb 2006, rlee0001 wrote:
> How do IN and NOT IN treat NULLs? Don't these functions search an array
> for a specified value returning true or false? I guess the intuitive
> thing for IN and NOT IN to do would be to return NULL if NULL appears
> anywhere in the array since those elements
On Tuesday 31 January 2006 14:09, Jim C. Nasby wrote:
> At present time, your best bet is to drop in on the IRC channel and ask
> questions there. You'll normally get an immediate reply, even if it's
> just a URL to look at.
As a beginner, I feel not knowing where to start and what to ask in IRC o
On Wed, Feb 01, 2006 at 12:56:30PM -0500, [EMAIL PROTECTED] wrote:
> From a C stored procedure, how can I tell Postgres to pass on to
> the Java client that there is No Data? A zero length byte array or
> a null value is not the same as No Data.
If you declare the function with "RETURNS bytea" the
Stephan Szabo wrote:
I think something like
CFLAGS="-D MAKE_EXPIRED_TUPLES_VISIBLE" ./configure
would be the way to get it.
Thanks,
I worked like a charm once I knew it was a CFLAG.
I did the dump as plain text insert statements, verified the deleted
records where there, then restored in
[EMAIL PROTECTED] wrote:
The problem was fixed by initializing the array before giving it a
value. Not surprising Postges isnt as popular as it should be. I was by
luck that I found this out - the manual says nothing about init arrays.
Instead of flippant comments like that, submit docs a patch
On Postgres 7.4.1
I've been experiencing some strangeness with the logging settings in
postgresql.conf.
I turned on statement logging (and duration), issued a "pg_ctl reload"
and got it working (logging to sys log and standard out). Now however,
when i try to turn it off, it won't turn off,
We have a Java client that is using JDBC to communicate with the Postgres database. We have a stored procedure, foo, that is written in C which returns a byte array (bytea) to the Java client. This function takes in a couple of integers and based upon their values can return a byte array or no da
Stephan,
How do IN and NOT IN treat NULLs? Don't these functions search an array
for a specified value returning true or false? I guess the intuitive
thing for IN and NOT IN to do would be to return NULL if NULL appears
anywhere in the array since those elements values are "unknown".
Personally I
Is it possible to specify using PQsetdbLogin() or
PQconnectdb()
the name of unix domain socket?
In documentation I read that I can specify path using host:
host
Name of the host to connect to. If this begins with
a slash ('/'), it
specifies Unix domain communication rather than TCP/IP
communic
Oracle keeps looking more and more appealing. $$$ vs actually being
able to get stuff done?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
The problem was fixed by initializing the array before giving it a
value. Not surprising Postges isnt as popular as it should be. I was by
luck that I found this out - the manual says nothing about init arrays.
DECLARE
id_var INTEGER[];
record_var RECORD;
BEGIN
id_var := '{}';
id_var[0] :=
I want to setup a database that will be used by my php application. Right
now I installed postgresql, I used an admin account to install it on a user
account. So I can only access the database (like psql dbname) when i'm
logged in as the user, if i try psql from admin it says fatal role "admin
I get the following error from ecpg when it encounters a structure
containing a bit field:
../../include/ecn_types.h:317: ERROR: syntax error at or near ":"
The source it is complaining about is:
176 typedef enum{
177 tifIOC = 0,
178 tifDay = 1,
179 tifGTX = 2,
On Feb 3, 2006, at 7:25 , Merlin Moncure wrote:
There is also the problem that a name can change. People change
names
by deed-poll, and also women can adopt a married name or keep
their old
one. All in all an ID is about the only answer.
I'll take the other side of this issue. The fact
On Thu, 2 Feb 2006, Tony Caduto wrote:
> Tom Lane wrote:
>
> >Tony Caduto <[EMAIL PROTECTED]> writes:
> >
> >
> >>I saw some where that if I recompiled my server with
> >>MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows?
> >>
> >>
> >
> >If you aren't a certified wizard you do NOT w
Hi,
I accidently deleted 2600 records. They are not super important but I
would like to get them back.
I copied the WAL file the deletes are in and I can see the text and
dates from the records, they are all there.
Is there a way to just extract the records without going through the
whole
> > I should perhaps be posting this under another subject, but I feel that
> > beneath the surface, Michael's problem and my own are strongly related.
> There is also the problem that a name can change. People change names
> by deed-poll, and also women can adopt a married name or keep their old
On Thursday 02 February 2006 21:09, Martijn van Oosterhout wrote:
>To the GP, your page is an interesting one and raises several
>interesting points. In particular the one about the "person" being the
>conclusion of the rest of the database. You essentially have a set of
>facts "A married B in C on
- Original Message -
From: "Leif B. Kristensen" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 02, 2006 4:07 AM
Subject: Re: [GENERAL] Primary keys for companies and people
[snip]
I'm very interested to hear what other use in their applications for
holding people and companies.
Tom Lane wrote:
Tony Caduto <[EMAIL PROTECTED]> writes:
I saw some where that if I recompiled my server with
MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows?
If you aren't a certified wizard you do NOT want to turn that on,
because it will very probably help you make t
Tony Caduto <[EMAIL PROTECTED]> writes:
> I saw some where that if I recompiled my server with
> MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows?
If you aren't a certified wizard you do NOT want to turn that on,
because it will very probably help you make things worse. My opinion
I saw some where that if I recompiled my server with
MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows?
I did a ./configure --enable-MAKE_EXPIRED_TUPLES_VISIBLE
It compiled ok but I dont see the deleted tuples
---(end of broadcast)---
On Thu, Feb 02, 2006 at 10:36:54AM +, David Goodenough wrote:
> > Still, I'm struggling with the basic concept of /identity/, eg. is the
> > William Smith born to John Smith and Jane Doe in 1733, the same William
> > Smith who marries Mary Jones in the same parish in 1758? You may never
> > rea
Russ Brown wrote:
> Yes, and that's fantastic because it's very clear and easy to find.
> However, it's for 8.1 only. I was looking for 8.1.2 specifically.
>
> I suppose what I'm saying is that for someone who isn't familiar with
> the layout of the site it's a bit difficult to find the release not
Michelle Konzack wrote:
> Is this like the Adabase Add-on of StarOffice 5.2 ?
I don't know what that is.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
> > What about PgAdmin III, I know, it is now perfect but I prefer it a
> > lot against similar commercial products.
>
> It is not availlable as a Debian-Package. ;-)
Yes, it is.
http://www.pgadmin.org/download/debian.php
//Magnus
---(end of broadcast)-
Toni Casueps wrote:
I have got some views (for example view B) that use another views (for
example view A) in the FROM clause.
If I want to change view A, and it doesn't allow me to (for example
adding a new column), another way would be dropping A and recreating it
with the new column, but i
I have got some views (for example view B) that use another views (for
example view A) in the FROM clause.
If I want to change view A, and it doesn't allow me to (for example adding a
new column), another way would be dropping A and recreating it with the new
column, but it doesn't allow me to
PgAdmin III is available on Debian. Its package name is pgadmin3. Try doing:
apt-cache show pgadmin3
On Wed February 1 2006 20:06, Michelle Konzack wrote:
> Am 2006-01-30 10:30:42, schrieb Cristian Prieto:
> > What about PgAdmin III, I know, it is now perfect but I prefer it a lot
> > against si
Am 2006-01-30 20:04:43, schrieb Peter Eisentraut:
> Michelle Konzack wrote:
> > Design a Database with OO2? code Functions?
>
> I'm not sure about what kind of function coding support you have in
> mind, but certainly you can design a database with it.
Is this like the Adabase Add-on of StarOffi
Am 2006-01-30 10:30:42, schrieb Cristian Prieto:
> What about PgAdmin III, I know, it is now perfect but I prefer it a lot
> against similar commercial products.
It is not availlable as a Debian-Package. ;-)
> Really, I have long time looking for a product with the same specs.
Me to. It would b
On Thu, 02 Feb 2006 16:15:43 +
Adam Witney <[EMAIL PROTECTED]> wrote:
> On 2/2/06 4:06 pm, "Russ Brown" <[EMAIL PROTECTED]> wrote:
>
> > Ah, there is it. Thanks! Just me not looking hard enough.
> >
> > However, I would argue that I shouldn't have to look so hard. I
> > instinctively went fo
On 2/2/06 4:06 pm, "Russ Brown" <[EMAIL PROTECTED]> wrote:
> Ah, there is it. Thanks! Just me not looking hard enough.
>
> However, I would argue that I shouldn't have to look so hard. I
> instinctively went for the 8.1.2 release link, and I think there should
> be a link to the release notes rig
On 2/2/06 3:56 pm, "Russ Brown" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm looking at www.postgrsql.org and wondering how to find the release
> notes for 8.1.2.
>
> I can see the link for the 8.1.2 release, but that just links to a
> directory of the release tarballs. Actually, all that would be n
Hi,
I'm looking at www.postgrsql.org and wondering how to find the release
notes for 8.1.2.
I can see the link for the 8.1.2 release, but that just links to a
directory of the release tarballs. Actually, all that would be needed
here would be a text file in that directory containing the release
n
On Thu, 2006-02-02 at 10:16 -0500, Sven Willenberger wrote:
> On Thu, 2006-02-02 at 08:58 -0600, Justin Pasher wrote:
> > > -Original Message-
> > > From: Sven Willenberger [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, February 01, 2006 2:13 PM
> > > To: Justin Pasher
> > > Cc: pgsql-ge
On Thu, 2006-02-02 at 08:58 -0600, Justin Pasher wrote:
> > -Original Message-
> > From: Sven Willenberger [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 01, 2006 2:13 PM
> > To: Justin Pasher
> > Cc: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] Best way to handle table
> -Original Message-
> From: Sven Willenberger [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 01, 2006 2:13 PM
> To: Justin Pasher
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Best way to handle table trigger on update
>
>
> On Tue, 2006-01-31 at 13:45 -0600, Justin
Richard Huxton wrote:
Sergey Karin wrote:
Are there any abilities to represent NULL values as string?
Null isn't a real value. Try not to think of it as a value.
That being said, and with due credit elsewhere (http://www.varlena.com/varlena/GeneralBits/84.php), what I do is
CREATE OR R
FERREIRA, William (VALTECH) wrote:
Hi,
i have a recursive function building a xml file, from differents
table. the xml is stored in memory and then flush on disk. the xml
text is used in each recursive calls and i would like to know if in
plpqsql parameters are passed by reference,
I don't be
I know understand. Thank you ;)
On 2/2/06, Richard Huxton wrote:
> Silas Justiniano wrote:
> > Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question:
> >
> > I have Books, Authors and Intermediate table. At intermediate I'm
> > currently using the following indexes:
> >
> > CR
Hi,
i have a recursive function building a xml file, from differents table.
the xml is stored in memory and then flush on disk.
the xml text is used in each recursive calls and i would like to know if in
plpqsql parameters are passed by reference, or if there is a key word for
passing parameter
Silas Justiniano wrote:
Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question:
I have Books, Authors and Intermediate table. At intermediate I'm
currently using the following indexes:
CREATE INDEX authorIndex ON Intermediate(author_id);
CREATE INDEX bookIndex ON Intermedia
Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question:
I have Books, Authors and Intermediate table. At intermediate I'm
currently using the following indexes:
CREATE INDEX authorIndex ON Intermediate(author_id);
CREATE INDEX bookIndex ON Intermediate(book_id);
I need a t
On Thursday 02 February 2006 09:07, Leif B. Kristensen wrote:
> On Thursday 02 February 2006 09:05, Michael Glaesemann wrote:
> >For people I'm more or less stumped. I can't think of a combination
> >of things that I know I'll be able to get from people that I'll want
> >to be able to add to the da
Sergey Karin wrote:
Hi, List!
I'm using PG8.1.
Are there any abilities to represent NULL values as string?
Null isn't a real value. Try not to think of it as a value.
http://archives.postgresql.org/pgsql-sql/2003-01/msg00222.php
num_value alias for $1;
string_value := \'input val
Sergey Karin schrieb:
Hi, List!
I'm using PG8.1.
Are there any abilities to represent NULL values as string?
I'm doing something like this:
create function func(int4) returns varchar as'
declare
num_value alias for $1;
string_value varchar;
begin
string_value := \'input value =
Hi, List!
I'm using PG8.1.
Are there any abilities to represent NULL values as string?
I'm doing something like this:
create function func(int4) returns varchar as'
declare
num_value alias for $1;
string_value varchar;
begin
string_value := \'input value = \' || num_value;
ret
Matthew Terenzio wrote:
I'm looking into methods to store XML docs for query and retrieval
across all the docs or subsets.
I've looked over a couple of options and may end up creating relations
with the data.
Are there any "Super" solutions that I might be overlooking.
Also, this article clai
On Thursday 02 February 2006 09:05, Michael Glaesemann wrote:
>For people I'm more or less stumped. I can't think of a combination
>of things that I know I'll be able to get from people that I'll want
>to be able to add to the database. Starting off we'll have at least
>7,000 individuals in the da
Hello, all!
Recently there was quite a bit of discussion regarding surrogate keys
and natural keys. I'm not interested in discussing the pros and cons
of surrogate keys. What I'd like to find out are the different
methods people actually use to uniquely identify companies and people
*besi
67 matches
Mail list logo
