Hello all again,
Thank you for all of your replies,
We are creating a jdbc backup solution that does NOT require the pgdump
program.
We have managed to get it going pretty fast, and the output size at the
moment is rellativelly smaller, but anyway. Most of the key information you
can get from t
> -Original Message-
> From: A.M. [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2006 15:05
> To: Dave Page
> Subject: Re: [GENERAL] GUI Interface
>
>
> > I'm unable to reproduce this problem with pgAdmin SVN-trunk
> built with
> > wxGTK 2.6.3 on Slackware-current with KDE.
> >
> > Can an
hi friends,
Why the 'oid' column reference doesn't work with postgresql 9.x?
romeo midhun wrote:
hi friends,
Why the 'oid' column reference doesn't work with postgresql 9.x?
Hiya, time traveller. You ended up in the wrong year; PostgreSQL 9
doesn't exist yet.
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: ww
am 16.05.2006, um 11:18:09 +0200 mailte Alban Hertroys folgendes:
> romeo midhun wrote:
> > hi friends,
> >Why the 'oid' column reference doesn't work with postgresql 9.x?
>
> Hiya, time traveller. You ended up in the wrong year; PostgreSQL 9 doesn't
> exist yet.
;-)
Btw.: if you need the oid,
What i done is i use the last backup file and restore it on new $PGData
Directory, now it
ok. just curious how this thing can happen? maybe i asking a stupid
question since i using
quite old Postgresql Version but hoping this problem won't come back
again.
Thanks for your help to clear some d
I am using postgresql 8.1.0 on an Xserver running MacOS 10.3.9. I am
getting the following in the log every minute for the past couple of days.
The database is otherwise running normally, as far as I can tell:
2006-05-16 07:26:01 EDT FATAL: could not read statistics message:
Resource temporari
[leaving the original text, as it is reply to an older posting]
On Fri, 2006-03-31 at 21:26, Jim Nasby wrote:
> On Mar 29, 2006, at 3:25 AM, Csaba Nagy wrote:
>
> >> Could somebody explain me, or point me to a resource where I can find
> >> out what is the recommended practice when a live db need
Hi Jim,
I must have had a corrupt index as vacuum analyze verbose came back
with an error and crapped out the postgres instance. Once I re-
indexed the problem went away. This issue hasn't returned since re-
indexing.
Thanks,
brendan duddridge | CTO | 403-520-5793 x24 | [EMAIL PROTECTED]
Tom Lane wrote:
Nis Jorgensen <[EMAIL PROTECTED]> writes:
Try removing the DISTINCT ON from your view - that should make things
clearer to you. When t.approved is true, the row is joined to all rows
of the datum table satisfying the criteria. The sort order you specify
does not guarantee a uniq
Hello
Today, one user complained that one of the tickets in our system had
disappeared some places but could be accessed other places. I thought
this was weird and startet debugging.
I have found out the sql statement with 'problems'. Can anybody explain
me why A) returns 12 rows and B) returns 1
"Forums @ Existanze" <[EMAIL PROTECTED]> writes:
> We are creating a jdbc backup solution that does NOT require the pgdump
> program.
In heaven's name, WHY?
Do you have any idea how much future pain you are setting yourself up
for? pg_dump changes with every PG release to deal with new features
Does pg_dump run in Macintosh?
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 16 May 2006 17:22
> To: Forums @ Existanze
> Cc: pgsql-general@postgresql.org
> Subject: Re: FW: [GENERAL] Getting information about sequences
>
> "Forums @ Existanze" <[EMAIL PROTE
pg_dump runs on any platform postgres does.
On Tue, May 16, 2006 at 05:31:44PM +0300, Forums @ Existanze wrote:
> Does pg_dump run in Macintosh?
>
>
>
> > -Original Message-
> > From: Tom Lane [mailto:[EMAIL PROTECTED]
> > Sent: 16 May 2006 17:22
> > To: Forums @ Existanze
> > Cc: pgs
Here is the thing, the user doesn't have Postgres installed on his/her
computer. So how am I going to distribute pg_dump, from my understandin you
have to compile postgres on a Mac in order to get the pgdump executable. And
is this for every version of Mac?
> -Original Message-
> From: M
"Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
> I have found out the sql statement with 'problems'. Can anybody explain
> me why A) returns 12 rows and B) returns 13 rows?. The only different is
> the "open OR new" / "new OR open" part. Should not they return the samme
> result?
That is
Forums @ Existanze wrote:
Does pg_dump run in Macintosh?
Wait you are going to "creating a jdbc backup solution" that does
NOT require the pgdump program, and you don't know if pg_dump runs on
Macintosh?
PostgreSQL operates on every major OS platform. I strongly suggest you
read the
Do you mean every version of OS X? I will not run on OS 9, afaik.
It can be compiled against any version of OS X, again as far as I know.
Gavin
On May 16, 2006, at 7:51 AM, Forums @ Existanze wrote:
Here is the thing, the user doesn't have Postgres installed on his/her
computer. So how am
On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
> "Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
> > I have found out the sql statement with 'problems'. Can anybody explain
> > me why A) returns 12 rows and B) returns 13 rows?. The only different is
> > the "open OR new" / "new OR open"
Rafael Martinez <[EMAIL PROTECTED]> writes:
> On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
>> I suspect this may be a question of a corrupt index, in which case
>> REINDEXing the index being used would fix it.
> This is what I thought when I found out the problem. So before I sent my
> fir
On Tue, 2006-05-16 at 12:32 -0400, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
> >> I suspect this may be a question of a corrupt index, in which case
> >> REINDEXing the index being used would fix it.
>
> > This is what I
Rafael Martinez <[EMAIL PROTECTED]> writes:
> On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
>> So much for that theory. If you copy the table (create table foo as
>> select * from tickets) and build a similar index on the copy, does the
>> behavior persist in the copy?
> The new table behave
Given a user defined type foo...
I've created several casts to/from foo and built-in types.
I had adopted a naming convention of:
baz foo_to_baz(foo);
foo foo_from_baz(baz);
But:
...it is recommended that you continue to follow this old
convention of naming cast implementation functions
Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
I'm writing a set of casts to/from various user defined
types. As is unexpected, there are cases where one
data type doesn't neatly map to another (for certain
values). In these cases I emit an INVALID_PARAMETER_VALUE
or OUT_OF_RANGE error -- d
On Tue, May 16, 2006 at 10:29:27AM -0700, Don Y wrote:
> Given a user defined type foo...
> I've created several casts to/from foo and built-in types.
> I had adopted a naming convention of:
> baz foo_to_baz(foo);
> foo foo_from_baz(baz);
>
> But:
> I don't see how I can do this in my decla
Csaba Nagy wrote:
[leaving the original text, as it is reply to an older posting]
On Fri, 2006-03-31 at 21:26, Jim Nasby wrote:
On Mar 29, 2006, at 3:25 AM, Csaba Nagy wrote:
Could somebody explain me, or point me to a resource where I can find
out what i
Martijn van Oosterhout wrote:
On Tue, May 16, 2006 at 10:29:27AM -0700, Don Y wrote:
Given a user defined type foo...
I've created several casts to/from foo and built-in types.
I had adopted a naming convention of:
baz foo_to_baz(foo);
foo foo_from_baz(baz);
But:
I don't see how I can
On Tue, 2006-05-16 at 13:01 -0400, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
> >> So much for that theory. If you copy the table (create table foo as
> >> select * from tickets) and build a similar index on the copy, does t
On Tue, May 16, 2006 at 10:53:10AM -0700, Don Y wrote:
> But what *binds* my C declaration to the corresponding SQL
> "CREATE CAST"?
>
> E.g.,
>
> CREATE FUNCTION foo_from_baz(baz)
> RETURNS foo
> AS '...'
> LANGUAGE 'C' IMMUTABLE STRICT;
Your create functions would look like:
CREATE FUNCTION f
I'm trying to partition my table on the first octet of an ip4 column
and can't seem to get the planner to do the constraint_exclusion. The
following SQL (copied by hand):
CREATE TABLE a (ip ip4);
CREATE TABLE a_1 ( CHECK (ip <<= '1.0.0.0/8' ) INHERITS(a);
CREATE TABLE a_2 ( CHECK (ip <<= '2.0.0.0
On Mon, May 15, 2006 at 10:14:05PM -0500, Russ Brown wrote:
> On Mon, 2006-05-15 at 17:12 -0500, Jim C. Nasby wrote:
> > On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> > > Sometime ago I saw a project with the purpose of creating Oracle views
> > > over
> > > the PostgreS
Forgot important part ... running on RHEL 4 Update 3 x86_64 using the
8.1.3 PG distributed in the RH Web Application Beta.
SELECT version()
PostgreSQL 8.1.3 on x86_64-redhat-linux-gnu, compiled by GCC
x86_64-redhat-linux-gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
-Mike
Hello folks,
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
We are inviting any early adopters who may wish to experiment to
download and install the code. You may contact me off-list with any
support or oth
On 5/16/06, Sean Davis <[EMAIL PROTECTED]> wrote:
I am using postgresql 8.1.0 on an Xserver running MacOS 10.3.9. I am
getting the following in the log every minute for the past couple of days.
The database is otherwise running normally, as far as I can tell:
2006-05-16 07:26:01 EDT FATAL: c
On 5/16/06 3:08 PM, "Tony Wasson" <[EMAIL PROTECTED]> wrote:
> On 5/16/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> I am using postgresql 8.1.0 on an Xserver running MacOS 10.3.9. I am
>> getting the following in the log every minute for the past couple of days.
>> The database is otherwise ru
Kenneth Downs wrote:
Hello folks,
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
We are inviting any early adopters who may wish to experiment to
download and install the code. You may contact me off-list wi
Joshua D. Drake wrote:
Kenneth Downs wrote:
Hello folks,
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
We are inviting any early adopters who may wish to experiment to
download and install the code. You
I participate regularly on three mailing lists, including
pgsql-general. I use thunderbird for mail.
pgsql-general has the peculiar property, when I hit reply, of replying
not to the list, but the individual who emailed to the list.
Is this me, or is this the list?
begin:vcard
fn:Kenneth D
On Tue, May 16, 2006 at 04:02:36PM -0400, Kenneth Downs wrote:
> Joshua D. Drake wrote:
>
> >Kenneth Downs wrote:
> >
> >>Hello folks,
> >>
> >>My company has developed an application development framework that
> >>targets PostgreSQL as its back-end, with PHP in the web layer.
> >>
> >>We are inv
Kenneth Downs wrote:
> I participate regularly on three mailing lists, including
> pgsql-general. I use thunderbird for mail.
>
> pgsql-general has the peculiar property, when I hit reply, of replying
> not to the list, but the individual who emailed to the list.
>
> Is this me, or is this the
On Tue, 2006-05-16 at 15:04, Kenneth Downs wrote:
> I participate regularly on three mailing lists, including
> pgsql-general. I use thunderbird for mail.
>
> pgsql-general has the peculiar property, when I hit reply, of replying
> not to the list, but the individual who emailed to the list.
>
Silly little question, but is there something to input/output hex
escaped data into a bytea, ala
CREATE TABLE a (lob BYTEA);
INSERT into a (lob) VALUES ('\x01\x02\x00\x03\x04');
INSERT into a (lob) VALUES ('\x01\x00\x02\x00\x03\x04');
It seems to work (doesn't error), but when selecting the data
On Tue, May 16, 2006 at 11:24:38AM +0200, A. Kretschmer wrote:
> am 16.05.2006, um 11:18:09 +0200 mailte Alban Hertroys folgendes:
> > romeo midhun wrote:
> > > hi friends,
> > >Why the 'oid' column reference doesn't work with postgresql 9.x?
> >
> > Hiya, time traveller. You ended up in the wron
On Tue, May 16, 2006 at 03:41:07PM -0400, Sean Davis wrote:
> I had cranked things up a bit from the standard install.
>
> shared_buffers = 15000 # min 16 or max_connections*2, 8KB
> each
> #temp_buffers = 1000# min 100, 8KB each
> #max_prepared_transactions =
Hi,
I have several user defined types with particular restraints
upon the data they represent. If I have crafted my foo_in()
function to ensure that these constraints are always satisfied
*before* allowing a datum into the database AND I have designed
my casts to be similarly vigilant, is there
Sounds great! But why GPL? Are you looking to sell licenses?
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for a closed source
application if it is GPL.
That may be your intent (which I actually don't have a busin
On 5/16/06, Sean Davis <[EMAIL PROTECTED]> wrote:
I had cranked things up a bit from the standard install.
shared_buffers = 15000 # min 16 or max_connections*2, 8KB
each
#temp_buffers = 1000# min 100, 8KB each
#max_prepared_transactions = 50 # can be
On Tue, May 16, 2006 at 04:04:28PM -0400, Kenneth Downs wrote:
> I participate regularly on three mailing lists, including
> pgsql-general. I use thunderbird for mail.
>
> pgsql-general has the peculiar property, when I hit reply, of replying
> not to the list, but the individual who emailed to
Don Y <[EMAIL PROTECTED]> writes:
> I.e., if I have a bunch of functions defined as taking an
> argument of type "foo", is there any way the user can pass
> a value to these functions WITHOUT it going through my
> gatekeepers (foo_in(), foo_from_baz(), etc.)?
No, not if foo is a separate type. Po
"Michael Artz" <[EMAIL PROTECTED]> writes:
> Silly little question, but is there something to input/output hex
> escaped data into a bytea, ala
PQescapeBytea, perhaps? The way you are doing it has multiple problems.
regards, tom lane
---(end of br
"Tony Wasson" <[EMAIL PROTECTED]> writes:
> When I saw the same error as you, the stats collector process was
> missing.
The collector, or the buffer process? The reported message would be
emitted by the buffer process, after which it would immediately exit.
(The collector would go away too once
"Michael Artz" <[EMAIL PROTECTED]> writes:
> I'm trying to partition my table on the first octet of an ip4 column
> and can't seem to get the planner to do the constraint_exclusion. The
> following SQL (copied by hand):
> CREATE TABLE a (ip ip4);
> CREATE TABLE a_1 ( CHECK (ip <<= '1.0.0.0/8' ) I
Jim C. Nasby wrote:
On Tue, May 16, 2006 at 03:41:07PM -0400, Sean Davis wrote:
I had cranked things up a bit from the standard install.
shared_buffers = 15000 # min 16 or max_connections*2, 8KB
each
#temp_buffers = 1000# min 100, 8KB each
#max_prepared_t
On 5/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Tony Wasson" <[EMAIL PROTECTED]> writes:
> When I saw the same error as you, the stats collector process was
> missing.
The collector, or the buffer process? The reported message would be
emitted by the buffer process, after which it would immedi
Tony Wasson wrote:
On 5/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Tony Wasson" <[EMAIL PROTECTED]> writes:
> When I saw the same error as you, the stats collector process was
> missing.
The collector, or the buffer process? The reported message would be
emitted by the buffer process, after
Eh, I'll just convert it all to octal, I just thought that I could get away without any middleman.What ig going on behind the scenes? Does it first get converted to text and then on to bytea? Would an explicit cast get around this (perhaps with associated UDF)?
-MikeOn 5/16/06, Tom Lane <[EMAIL P
Joshua D. Drake wrote:
Sounds great! But why GPL? Are you looking to sell licenses?
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for a closed source
application if it is GPL.
That may be your intent (which I
Scott Marlowe wrote:
On Tue, 2006-05-16 at 15:04, Kenneth Downs wrote:
I participate regularly on three mailing lists, including
pgsql-general. I use thunderbird for mail.
pgsql-general has the peculiar property, when I hit reply, of replying
not to the list, but the individual
"Michael Artz" <[EMAIL PROTECTED]> writes:
> What ig going on behind the scenes? Does it first get converted to text and
> then on to bytea?
No, the \nnn escape is built into the lexer's syntax for a string
literal (see backend/parser/scan.l), and only after that does the string
get fed to bytea'
Hi,
Is it possible to have one of my user defined data types
reviewed/critiqued to see if there are things that I am
not doing properly? Or, other things that I should be
including? Or, should I just contribute it and hope
for the best? (if so, how do I do that?)
Thanks!
--don
--
Kenneth Downs <[EMAIL PROTECTED]> writes:
> If it turns out that nobody can release a closed source app, I will
> definitely reconsider and look again at LGPL, but I am not convinced you
> cannot do so.
> If you seek to provide a closed source app that is built upon Andromeda,
> you are require
Tom Lane wrote:
> "Michael Artz" <[EMAIL PROTECTED]> writes:
> > What ig going on behind the scenes? Does it first get converted to text and
> > then on to bytea?
>
> No, the \nnn escape is built into the lexer's syntax for a string
> literal (see backend/parser/scan.l), and only after that does
Bruce Momjian writes:
> Tom Lane wrote:
>> No, the \nnn escape is built into the lexer's syntax for a string
>> literal (see backend/parser/scan.l),
> Should we rethink this for SQL standard strings?
We already have: \ isn't an escape anymore when
standard_conforming_strings is true.
Kenneth Downs wrote:
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for a closed source
application if it is GPL.
That may be your intent (which I actually don't have a business
problem with), I was just curious as t
> Also most DBAs are not hard core OSS programmers and anyone coming
> from a commercial system is more than likely used to running the
> admin tools on windows.
We have a whole department of DBAs, *none* of whom have Microsoft on
their desktops.
Further, the Big, Important Systems that we admini
On Tue, May 16, 2006 at 08:12:05PM -0700, Don Y wrote:
> Hi,
>
> Is it possible to have one of my user defined data types
> reviewed/critiqued to see if there are things that I am
> not doing properly? Or, other things that I should be
> including? Or, should I just contribute it and hope
> for
Good morning all,
I am running SUSE 10 (64bit) and need to download an rpm or other suitable
binary for this platform.
At the download site there only seem to be binaries for Redhat and Fedora.
There also only seems to be a 64bit binary for Fedora Core 4 and none for Core
5.
Can anyone advis
Kenneth Downs wrote:
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
Is this product somehow related to AndroMDA (which is usually pronounced
'Andromeda')?
http://www.andromda.org/
Greetings,
Anastasios
---
68 matches
Mail list logo
