to speak of, then
sorry for yapping up the wrong woody perennial plant.
Really just fishing for some insights here folks.
--
Until later, Geoffrey
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
.0.1-1PGDG.i686.rpm \
postgresql-8.0.1-1PGDG.i686.RPM \
postgresql-server-8.0.1-1PGDG.i686.rpm
Not that I expect that to resolve the issue, but grasping at some straws
here.
--
Until later, Geoffrey
---(end of broadcast)---
TIP 8: explain analyze is your friend
, I'd appreciate hearing anyone who might have
some insights...
--
Until later, Geoffrey
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Lonni J Friedman wrote:
On Thu, 17 Feb 2005 15:41:11 -0500, Geoffrey <[EMAIL PROTECTED]> wrote:
FYI, Seems there might be some confusion on the part of Red Hat.
Checking the 4.0 channel on the Red Hat Network for the version of
Postgresql that comes on 4.0 I see:
postgresql-7.4.7-2.R
t see any responses. Is there anyway to deal
with this issue. I know I've got code that takes a similar approach and
I'm now concerned that I'm going to trash my database.
Anyone?
--
Until later, Geoffrey
---(end of broadcast)
Michael Talbot-Wilson wrote:
How, really, do people pronounce PostgreSQL?
http://www.serioustechnology.com/postgres.ogg
Or for those of you who have an inferior operating system:
http://www.serioustechnology.com/postgres.wav
--
Until later, Geoffrey
Any society that would give up a little
at LEAST 7.4.12... :)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both.
http://tinyurl.com/zhnmc
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both. - Benjamin Franklin
---(end of broadcast)---
TIP 3: Have you checked our extensive
expected to backup your database, you should get rid of them.
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both. - Benjamin Franklin
---(end of broadcast)---
TIP
Ari Kahn wrote:
I think the issue is something like this though.
Send the output of your database listing to a pipe through 'cat -evt'
and see if you've got any unusual characters in the names of your databases:
echo '\l' | psql template1 |cat -evt
--
Until lat
Tom Lane wrote:
If you don't trust your DBA,
You should fire him/her...
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both. - Benjamin Franklin
---(end of broa
resql.org lists are the only ones that I've seem do that.
So what's the reasoning behind this choice?
Look, this really has become a religious issue. There are list that do
it both ways. Let's not waste anymore bandwidth on the list with it.
Learn to live with the way the list is
, don't try and make the database
handle it.
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both. - Benjamin Franklin
---(end of broadcast)---
TIP 5: don't
well. What we want to do is gracefully (as possible) shutdown
the application.
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both. - Benjamin Franklin
---(end of broa
(btw, if you want all vowels, don't forget 'y' :-P)
As I recall, that should be 'and sometimes y... I don't recall the sql
syntax for SOMETIMES :)
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security w
Dave Page wrote:
http://www.postgresql.org/community/
Okay, so I voted and I see Linux leads the pack 16 of 29. I return a
few moments later and Linux leads the pack 13 to 24. What gives??
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security
tion unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Searching google for 'invalid frontend message type 78' returns no hits,
which is a scary thing.
Any insights would be greatly appreciated.
--
Until later, Geoffre
Martijn van Oosterhout wrote:
On Tue, Jun 20, 2006 at 09:33:13AM -0400, Geoffrey wrote:
We have an unusual problem with some perl code that is processing data
via DBD facility. Basically, the code consists of various subroutines
that are identified in a hash. The primary script then
later, Geoffrey
Any society that would give up a little liberty to gain a little
security will deserve neither and lose both. - Benjamin Franklin
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
rldoc Pg' for Pg specific info
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)---
TIP 1: if posting/rea
database design.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)---
TIP 1: if posting/reading through Usenet,
ribe" in the subject, with an explanatory
message about the right way to unsubscribe. There's no reason the rest
of us should be bothered.
I would agree with that.
Problem is, half the time they don't spell it correctly..
--
Until later, Geoffrey
Those who would give u
Joshua D. Drake wrote:
Actually it is quite ridiculous that we expect someone to read the mail
headers.
But relatively reasonable to assume that one could unsubscribe if they
can figure out how to subscribe..
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
' (a tear for your 66 cuda...)
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
da.shtml
Note that this was a very long time ago :)
I hope it wasn't on 1966 ...
I am not going to ask how you got to 135MPH.
I don't think you'd have any problem doing 135mph in a '66 Cuda.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase
dn't
even ticket me... All white, red interior... man I loved that car. It
was the first car that *I* bought with *my* money and I *owned* it. No
bank :)
Note that this was a very long time ago :)
We are showing our age...
--
Until later, Geoffrey
Those who would give up essential Liberty
.txt
Any help will be greatly appreciated.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)---
TIP 5: don't
ressable, it's nothing, it's not set, it's not
there. I know it's not 100% accurate, but I think it helps folks
understand the concept.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
And this is why I live in pa, but make the trek in to the netherworld
known as new jersey. :D
On 1/16/08, Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to dvanatta <[EMAIL PROTECTED]>:
>
> >
> > What's up with 3 of the 7 being from Pennsylvania? What's the connection?
>
> Well, as every
Sounds reasonable, but what one manager answers today is subject to be
changed by another tomorrow.
On 1/16/08, Otto Hirr <[EMAIL PROTECTED]> wrote:
> > Russ Brown wrote:
> > > http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
> > >
> > > What does this mean for Sun's support of Postgres?
> >
to 64 bit hardware, where one machine is
running a 32 bit OS and the other is running a 64 bit OS?
Further:
Say 32 bit hardware and 64 bit hardware, where both are running a 32 bit OS?
Specifically speaking of RHEL.
Thanks.
--
Until later, Geoffrey
"I predict future happiness for Amer
On 10/13/2010 11:30 AM, zhong ming wu wrote:
On Wed, Oct 13, 2010 at 11:17 AM, Geoffrey Myers
mailto:li...@serioustechnology.com>> wrote:
> Excuse the ignorance, but I see the following in the docs:
>
> 'In any case the hardware architecture must be the same — shipping fr
, Geoffrey
Sent from my iPhone
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Patience is my friend. No transactions so no archiving. Waiting long enough
produced results. Sorry for the noise.
--
Later, Geoffrey
Sent from my iPhone
On Dec 27, 2010, at 3:18 PM, Geoffrey Myers wrote:
> Set up wal shipping on postgresql 8.3.9 and rhel 5.5. When I start the
> post
Is there a way to search for a character in the database by the
hexidecimal value of that character?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
, which is controlled by
"client_encoding".
CONTEXT: COPY cust, line 778
Is there any easy way to figure out which record caused this error?
Thanks.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the peo
x27; is your hexadecimal character value.
Be sure to read and understand everything you can find about encodings;
and make sure the hexadecimal value you are searching for is from the
same encoding.
Best wishes,
Harald
On Mon, Jan 24, 2011 at 16:00, Geoffrey Myers
mailto:li...@serioustechnolo
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as SQL_ASCII and we
are changing them to UTF8.
When testing this Friday, I received the
Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as
Adrian Klaver wrote:
On Monday 24 January 2011 8:06:38 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our
Adrian Klaver wrote:
On 01/24/2011 09:16 AM, Geoffrey Myers wrote:
We hope to identify the characters and fix them in the existing
database, then convert. It appears to be very limited, but it would help
if there was some way to identify these characters outside of simply
doing the reload of
I am trying to write a plsql routine that will delete a range of
characters based on their octal or hexadecimal values. Something like
the 'tr' shell command will do:
cat file| tr -d ['\177'-'\377']
Can't seem to figure this one out.
Pointers would be app
values to decimal values at
http://www.asciitable.com/
while (<>)
{
$_ =~ s/(.)/((ord($1) >= 0) && (ord($1) <= 8))
|| ((ord($1) >= 11) && (ord($1) <= 31))
|| ((ord($1) >= 127)) ?"": $1/egs;
print;
}
comments would be apprec
Vick Khera wrote:
On Tue, Feb 15, 2011 at 11:09 AM, Geoffrey Myers
wrote:
comments would be appreciated.
If all you're doing is filtering stdin to stdout and deleting a range
of characters, it seems that tr would be a faster tool:
cat foo.txt | tr -d '\000-\008\013-\037\177-\
get around the data integrity issue.
Is there a way to resolve this issue with the psql loading approach?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
hen a table is built
using pg_restore all the data is loaded into all tables BEFORE any
constraints are created. I believe that if you did a data-only dump from
pg_dump you would have the same integrity problems.
Yes.
A
--
Until later, Geoffrey
"I predict future happiness for Americ
xksXzk
=f9co
-END PGP SIGNATURE-----
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pg
2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1diwUACgkQvJuQZxSWSshcPgCdGuHIe4bINl/BmoKW89YmQscD
IdAAnA8bwbzmMKssCga9G0dpSh1GopzD
=khQx
-END PGP SIGNATURE-
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the lab
lock
psql:test.sql:17: ERROR: current transaction is aborted, commands
ignored until end of transaction block
ROLLBACK
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of
//biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1dpvQACgkQvJuQZxSWSsjvrgCgmiITSLnGyrBunVZTScc4HKvz
Y3IAn1sYG4/BdM6XJpBAVMz6lU1WfUVH
=XZcQ
-END PGP SIGNATURE-
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-genera
201102171551
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1diwUACgkQvJuQZxSWSshcPgCdGuHIe4bINl/BmoKW89YmQscD
IdAAnA8bwbzmMKssCga9G0dpSh1GopzD
=khQx
-END PGP SIGNATURE-
--
Geoffrey Myers
Myers Consulting Inc.
770.592
F6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1d360ACgkQvJuQZxSWSsidCQCfTnQxp5w6psa3C9NREX0ecZ+j
Ft0An2JKofuxVJNwxhVkh4NBTJU3Xcom
=fLDa
-END PGP SIGNATURE-
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wast
AREDAAYFAk1ehJEACgkQvJuQZxSWSsj/5gCgjsQa+nzZz26xQ7c70Bxl5Hs3
AuUAn1uD7MY2BtGR7usl45pC3Yv2pqVS
=mLCm
-END PGP SIGNATURE-
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking c
session_replication_role = replica;
I'm still getting the errors. If it doesn't belong at the beginning of
this process, I'm not exactly sure where it should go.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wastin
SIGNATURE-
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
N PGP SIGNATURE-
iEYEAREDAAYFAk1ew9MACgkQvJuQZxSWSshETwCg2oEEicHhokORuQRl3sxkLkpj
ghIAnRe02LCuyyRlyzvKZ67QCYUyfPzC
=H9Wb
-END PGP SIGNATURE-
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the peopl
3sxkLkpj
ghIAnRe02LCuyyRlyzvKZ67QCYUyfPzC
=H9Wb
-END PGP SIGNATURE-
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent
6714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1iy74ACgkQvJuQZxSWSsgWQACgrxKDvN/yCZD5GZJvlqFMyyIC
9mwAnjOMJ9QDRa3IoiBCvaS9mT5sMR6f
=JYCs
-END PGP SIGNATURE-
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of
friendly?'
What about some sort of wal log shipping replication?
WAL Log shipping won't help.
Thanks & Regards,
Vibhor Kumar
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
mp makes it
difficult to view that line.
Is there a way to view that data line without converting this dump to a
text dump?
All I'd like to do is know which column in the table caused the problem
so I could apply my fix to that particular column.
--
Until later, Geoffrey
"I predict f
Tom Lane wrote:
Geoffrey Myers writes:
So we are in the process of converting our databases from SQL_ASCII to
UTF8. If a particular row won't import because of the encoding issue we
get an error like:
pg_restore: [archiver (db)] Error from TOC entry 5317; 0 1266711 TABLE
DATA
: [archiver (db)] Error from TOC entry 5246; 0 4978675 TABLE
DATA cust postgres
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
for encoding "UTF8": 0xbd
As I see it, the perl code above should catch this '0xbd' character, but
somehow it is finding it's
characters
mentioned above, the process fails.
So, now the question is, is this effort even worth our effort?
What is the harm in leaving our databases SQL_ASCII encoded?
Thanks for any insights.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the
Vick Khera wrote:
On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
mailto:li...@serioustechnology.com>> wrote:
Here's our problem. We planned on moving databases a few at a time.
Problem is, there is a process that pushes data from one database to
another. If t
Jasen Betts wrote:
On 2011-04-22, Geoffrey Myers wrote:
Vick Khera wrote:
On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
mailto:li...@serioustechnology.com>> wrote:
Here's our problem. We planned on moving databases a few at a time.
Problem is, there is a process that
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each other. Trouble is, I have a
windows 7 64bit OS and the
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each other. Trouble is, I have a
windows 7 64bit OS and the
do? That is, replace the
same character in multiple records using regex_replace() ?
In reality, we are trying to change characters like the 1/2 character to
the three characters '1/2'.
Thanks for any assistance.
--
Until later, Geoffrey
"I predict future happiness for America
disk space.
Any clues would be appreciated.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list
Alban Hertroys wrote:
On 3 Jul 2011, at 12:00, Geoffrey Myers wrote:
We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16
gig of memory with the
Craig Ringer wrote:
On 3/07/2011 6:00 PM, Geoffrey Myers wrote:
out of memory for query result
How is this possible?
Resource limits?
Could this message be generated because of shared memory issues?
The odd thing is the error was generated by a user process, but there is
no reference
One other note, there is no error in the postgres log for this database.
I would have expected to find an error there.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking ca
Geoffrey Myers wrote:
We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16 gig
of memory with the following error:
out of memory for query result
Craig Ringer wrote:
On 3/07/2011 6:00 PM, Geoffrey Myers wrote:
out of memory for query result
How is this possible?
Resource limits?
Could this message be generated because of shared memory issues?
The odd thing is the error was generated by a user process, but there is
no reference to
Tom Lane wrote:
Geoffrey Myers writes:
Geoffrey Myers wrote:
out of memory for query result
One other note that is bothering me. There is no reference in the log
regarding the out of memory error. Should that not also show up in the
associated database log?
Not if it's a client
Am I correct in assuming that the 'running out of oids' issue was
resolved with a design change within Postgresql?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taki
Merlin Moncure wrote:
On Wed, Aug 3, 2011 at 2:41 PM, Geoffrey Myers
wrote:
Am I correct in assuming that the 'running out of oids' issue was resolved
with a design change within Postgresql?
not exactly -- for quite some time now the use of oids in user tables
has been discour
Is max connections in any table in the database I can access?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgs
Is the max connections value in a system table somewhere?
Thanks.
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Scott Marlowe wrote:
On Wed, Aug 10, 2011 at 12:47 PM, Geoffrey Myers
wrote:
Is max connections in any table in the database I can access?
No it's in the postgresql.conf file, which is in various places
depending on how pg was installed. for debian / ubuntu it's in
/etc/postgresq
Adrian Klaver wrote:
On Wednesday, August 10, 2011 11:47:25 am Geoffrey Myers wrote:
Is max connections in any table in the database I can access?
SELECT current_setting('max_connections');
current_setting
-
100
Thanks for all the responses folks. Obviousl
Greg Smith wrote:
On 08/10/2011 02:46 PM, Geoffrey Myers wrote:
Is the max connections value in a system table somewhere?
If you intend to do anything with the value you probably want one of
these forms:
SELECT CAST(current_setting('max_connections') AS integer);
SELECT CAST(
I'm trying the following:
ship_date between '04/30/2010' AND '04/30/2010' + 14
But this returns:
ERROR: invalid input syntax for integer: "04/30/2010"
Can I use between with dates?
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-
ostgres".
This user must also own the server process.
.
.
Why is it trying to change directory to /root??? Running as the
postgres user.
Any assistance would be appreciated.
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@pos
LinkedIn
Geoffrey Gowey requested to add you as a connection on LinkedIn:
--
Andrew,
I'd like to add you to my professional network on LinkedIn.
- Geoffrey Gowey
Accept invitation from Geoffrey Gowey
http://www.linkedin.
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
With PGS 7.4 :
INSERT INTO table (col1, col2) VALUES (val1) failed
Is it a known bug ?
Thx.
Geoffrey KRETZ
Four J's De
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
With PGS 7.4 :
INSERT INTO table (col1, col2) VA
Geoffrey KRETZ wrote:
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
With PGS 7.4 :
INSERT INTO t
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:49, Geoffrey KRETZ wrote:
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) V
Hi,
I was wondering when a PREPARE statement is check. (ie : is it normal
that the following statement doesn't return an error : PREPARE stmnt AS
"") ?
Geoffrey Kretz
Four J's Development Tools
---(end of broadcast)--
Tom Lane wrote:
Geoffrey KRETZ <[EMAIL PROTECTED]> writes:
I was wondering when a PREPARE statement is check. (ie : is it normal
that the following statement doesn't return an error : PREPARE stmnt AS
"") ?
Hm?
regression=# PREPARE stmnt AS &quo
CREATE TABLE test_table (
some_column integer,
another_column text
);
CREATE TYPE test_type as (
some_type test_table.some_column%TYPE
);
Gives me:
ERROR: syntax error at or near "%" at character 62
LINE 2: some_type test_table.some_column%TYPE
I also can't define rowtypes as return t
I recently installed 7.4.1 on two different machines (Linux/Intel and MacOSX)
and in both cases the commands in src/backend/command did not get installed.
Everything else is okay, as far as I can tell. I tried re-running make install
on both machines and still, nothing. I have had 7.3.x fully insta
ow whereas with informix
or db2 for exemple, it will return an error.
So is that normal ?
Geoffrey Kretz - Four J's Development Tools
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregi
bit2_vc200 =
'xx' WHERE dbit2_key=1
Geoffrey KRETZ - Four J's Development Tools
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Richard Huxton wrote:
Geoffrey KRETZ wrote:
Hello,
Is it a way to make the following UPDATE statement work with PGS 7.4
(UNIX) :
UPDATE dbit2 SET (dbit2_key,dbit2_c10,dbit2_vc200) =
(ABS(-1),NULL,'xx') WHERE dbit2_key=1
Or am I force to use the following syntax :
UPDATE dbit2 SET
Richard Huxton wrote:
Geoffrey KRETZ wrote:
I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a
launching the following request :
INSERT INTO temp_tab VALUES (1,2,3)
It will insert the values in the three first row whereas with
informix or db2 for exemple, it will return an
Hello,
For the purpose of QA testing, I need a 7.3.X version of postgreSQL for
unix (linux i686) but I can't find it on the postgre website.
Is it still possible to find such an old version of pgs available for
download ?
Thx in advance
Geoffrey Kretz - Four J's Develop
ld be:
ftp.postgresql.org/pub/postgresql/source/
You could also check the nearest mirror to you:
http://www.postgresql.org/mirrors-ftp.html
Regards,
Finally I get it ;) !
Thx for all
Geoffrey
---(end of broadcast)---
TIP 3: if posting/reading through U
(I've just reply to a
random message and change the subject and the recipient).
I apologize for any inconvenience it could have done.
So, if I want to post a new message I should not use "reply" but wrtie
an all new mail, is that right ?
Geoffrey
---
201 - 300 of 312 matches
Mail list logo
