Yeesh. What the ding-dong is this?
JohnGage:EFNWebsite johngage$ od -a CopySql.sql
000? ? ? s e l e c t sp * sp f r o m
020 sp m e s h _ d e s c r i p t o r
040s ; nl nl
What are the ?'s. Mon Dieu, what is goin
Oh, I should add. Everything, the database, vim, is UTF-8.
On Apr 22, 2010, at 3:34 AM, Scott Mead wrote:
run:
od -a CopySql.sql
Look at the beginning, that'll show you character by character
what's in there (should reveal anything hidden).
--
Sent via pgsql-general mailing lis
On Thu, Apr 22, 2010 at 1:47 AM, Craig Ringer
wrote:
> On 22/04/2010 1:05 AM, Watson, Nathaniel wrote:
>>
>> I have downloaded the one click installer on Vista.
>
> From where? What version?
>
>> I right click on
>> the executable and select run as administrator, and an empty dialog box
>> appears
On 22/04/10 08:24, John Gage wrote:
Yeesh. What the ding-dong is this?
JohnGage:EFNWebsite johngage$ od -a CopySql.sql
000 ? ? ? s e l e c t sp * sp f r o m
020 sp m e s h _ d e s c r i p t o r
040 s ; nl nl
What are the ?'s. Mon Dieu, what is going on?
http://en.wikipedia.org/wi
http://en.wikipedia.org/wiki/Byte_order_mark
Tends to get added if you go through a Windows system. Useless for
utf-8 afaik. Confuse the hell out of you because various tools parse
and hide them then you pipe the file to a script and everything
falls over.
Bunch of scripts available here
John R Pierce wrote:
Ognjen Blagojevic wrote:
Is there a way to run Postgres in embedded mode? More precisely, to
run it without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
on unix, as you imply, it can
Thanks Anreas but I think that's not a issue. The issue is something to do
with "$1". I don't know how to get rid of it.
techdb=# INSERT INTO log_table(id) SELECT 5 EXCEPT SELECT id FROM log_table
WHERE id = 5;
INSERT 0 1
techdb=# select * from log_table;
id | txid | txtime
+-
Ognjen,
> Is there a way to run Postgres in embedded mode? More precisely, to run it
>>> without using TCP/IP port, and without installing as a service?
>>> I am aware of Unix-domain sockets, but is there something similar for
>>> Windows?
>>>
>>
>> on unix, as you imply, it can be run with unix
I got it resolved. I just need to put below statement into single quote
instead of double quote. :)
my $query ='INSERT INTO log_table(id) SELECT $1 EXCEPT SELECT id FROM
log_table WHERE id = $1;';
Thanks,
Jignesh
On Thu, Apr 22, 2010 at 2:02 PM, Jignesh Shah wrote:
> Thanks Anreas but I think t
Well, well, well. Guess who the culprit is...
I edited the file both in Vim and in pgAdmin3 (1.10.2, Mar 9 2010, rev
8217), and the BOM shows up after saving the file with pgAdmin3.
I don't know if pgAdmin3 wants to keep this feature...
Thank everyone again for the excellent help.
John
O
On 2010-04-22, John Gage wrote:
> Well, well, well. Guess who the culprit is...
>
> I edited the file both in Vim and in pgAdmin3 (1.10.2, Mar 9
> 2010, rev
> 8217), and the BOM shows up after saving the file with pgAdmin3.
>
> I don't know if pgAdmin3 wants to keep this feature...
>
> Thank
Hello,
I've written the following function:
CREATE OR REPLACE FUNCTION indifferent_cast(literal_value text,
type_specification anyelement) RETURNS anyelement AS
$function_body$
-- This function is used when writing migrating scripts and the like.
-- It attempts to cast to the datatype specified b
Hello
you can use pg_typeof(some) function
Regards
Pavel Stehule
2010/4/22 Peter Geoghegan :
> Hello,
>
> I've written the following function:
>
> CREATE OR REPLACE FUNCTION indifferent_cast(literal_value text,
> type_specification anyelement) RETURNS anyelement AS
> $function_body$
> -- This fu
This may be germane:
Filename: trunk/pgadmin3/src/ui/pgadmin3.lng
Revision 2954 - (view) (download) - [select for diffs]
Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by andreas
File length: 1301 byte(s)
Diff to previous 2840
adding UTF-8 BOM
I do not think that it is a feature.
Hi,
I have written following trigger and trying to improve the performance by
using prepared query everytime. I have used spi_prepare to prepare the query
and $_SHARED global hash to persist the prepared plan but it doesn't seem to
work. Though $query will be same always in following trigger, it p
On Thu, Apr 22, 2010 at 10:41 AM, John Gage wrote:
> This may be germane:
>
> Filename: trunk/pgadmin3/src/ui/pgadmin3.lng
> Revision 2954 - (view) (download) - [select for diffs]
> Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by andreas
> File length: 1301 byte(s)
> Diff to previ
I think I should clarify my original "problem" and what I see as the
difficulty in general.
I saved a UTF-8 file with the pgAdmin Query tool, which added the BOM
to the beginning of the file during the save.
I then attempted to run the file using psql with the \i meta command.
I got a synt
> Hello
>
> you can use pg_typeof(some) function
>
> Regards
> Pavel Stehule
That's great Pavel, thanks a lot.
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Apr 22, 2010 at 12:02, John Gage wrote:
> I think I should clarify my original "problem" and what I see as the
> difficulty in general.
>
> I saved a UTF-8 file with the pgAdmin Query tool, which added the BOM to the
> beginning of the file during the save.
>
> I then attempted to run the
Additionally, if the Vim option "bomb" is set to "nobomb" it will
strip the BOM. This solves my "problem" by permitting editing files
in both Vim and pgAdmin3 Query tool and then being able to run the
files in psql.
:set nobomb [in Vim]
On Apr 22, 2010, at 12:12 PM, Magnus Hagander wro
> The thing that takes the longest is planning queries. I made THAT problem
> just
> go away for the most part by using cached queries (only works within the same
> database connection, but thats no problem for me).
What do you mean by "cached queries"? Prepared statements?
--
Sent via
Hi all -
I would request, If any one has document on how to read and
interpret the postgres execution plan, can you please share it?
Regards
John R Pierce wrote:
Ognjen Blagojevic wrote:
Is there a way to run Postgres in embedded mode? More precisely, to
run it without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
on unix, as you imply, it can
Hi,
Having very difficult decision to make, data drive ran out of space,
startup recovery says:
- LOG: 58P01: could not open file
"pg_xlog/000100A50016" (log file 165, segment 22): No such
file or directory
-
last one is: 000100A50015
what is m
Thanks to all that replied my question !
I'll implement the Thomas Kellerer's.
Glus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I have written following trigger and trying to improve the performance by
> using prepared query everytime. I have used spi_prepare to prepare the query
> and $_SHARED global hash to persist the prepared plan but it doesn't seem to
> work. Tho
On Apr 22, 2010, at 5:43 AM, akp geek wrote:
> Hi all -
>
> I would request, If any one has document on how to read and interpret
> the postgres execution plan, can you please share it?
http://wiki.postgresql.org/wiki/Using_EXPLAIN
--
Sent via pgsql-general mailing list (pgsql-general@
On Thu, Apr 22, 2010 at 7:43 AM, akp geek wrote:
> Hi all -
> I would request, If any one has document on how to read and
> interpret the postgres execution plan, can you please share it?
http://wiki.postgresql.org/wiki/Introduction_to_VACUUM%2C_ANALYZE%2C_EXPLAIN%2C_and_COUNT
http://wiki
On Apr 21, 2010, at 1:41 PM, Brian Peschel wrote:
> I have a replication problem I am hoping someone has come across before and
> can provide a few ideas.
>
> I am looking at a configuration of on 'writable' node and anywhere from 10 to
> 300 'read-only' nodes. Almost all of these nodes will b
On Thu, Apr 22, 2010 at 6:43 AM, akp geek wrote:
> Hi all -
> I would request, If any one has document on how to read and
> interpret the postgres execution plan, can you please share it?
> Regards
start here:
http://explain.depesz.com/
--
Sent via pgsql-general mailing list (pgsql-gen
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I am looking at a configuration of on 'writable' node and anywhere from
> 10 to 300 'read-only' nodes. Almost all of these nodes will be across a
> WAN from the writable node (some over slow VPN links too). I am looking
> for a way to rep
You could also disable "Read and write Unicode UTF-8 files" in
Options->Preferences.
It will not write a BOM but you will not have UTF-8 either.
On Thu, Apr 22, 2010 at 07:29, John Gage wrote:
> Additionally, if the Vim option "bomb" is set to "nobomb" it will strip the
> BOM. This solves my "
Massa, Harald Armin wrote:
on unix, as you imply, it can be run with unix domain sockets,
but not on Windows as they simply don't have this interface.
and, it can be started as an application rather than as a
system service, but it still runs as a separate proc
Does any SQL standard allows for a multicolumn primary key where in one
record there is a null in on of the primary key columns?
regards
Szymon Guz
Hi,
I hope someone can help me. When running psql from the command line with
the PGHOST environment variable or the -h command line host set, it
throws a segmentation fault.
$ psql -U morgan -d cid -h localhost
Segmentation fault
$ export PGHOST=rhyme.ncl.ac.uk
$ psql -U morgan -d cid
Segmentati
Primary keys are defined as 'unique not null' even if they are
composite. So I believe postgres would not let you do that:
5.3.4. Primary Keys
Technically, a primary key constraint is simply a combination of a
unique constraint and a not-null constraint.
A primary key indicates that a c
Morgan Taschuk writes:
> I hope someone can help me. When running psql from the command line with
> the PGHOST environment variable or the -h command line host set, it
> throws a segmentation fault.
> $ psql -U morgan -d cid -h localhost
> Segmentation fault
Huh. Can you get a stack trace from
2010/4/22 Devrim GÜNDÜZ
> Can we please get a
>
> rpm -qa|grep postgresql
>
> first?
>
Here is it :
r...@server1 [~]#
r...@server1 [~]# rpm -qa|grep postgresql
postgresql-8.1.18-2.el5_4.1
postgresql-devel-8.1.18-2.el5_4.1
postgresql-libs-8.1.18-2.el5_4.1
postgresql-libs-8.1.18-2.el5_4.1
postg
Hi,
I hope someone can help me. When running psql from the command line with
the PGHOST environment variable or the -h command line host set, it
throws a segmentation fault.
$ psql -U morgan -d cid -h localhost
Segmentation fault
$ export PGHOST=rhyme.ncl.ac.uk
$ psql -U morgan -d cid
Segment
Andy, 21.04.2010 01:44:
No I haven't. I'm using MySQL right now. But I want to learn more
about Postgresql's Hot Standby and see if it offers a better
replication solution.
Can anyone share their experience about Postgresql replication
performance impact? Thanks.
You might be interested in thi
On 04/22/2010 10:12 AM, Ben Chobot wrote:
On Apr 21, 2010, at 1:41 PM, Brian Peschel wrote:
I have a replication problem I am hoping someone has come across before and can
provide a few ideas.
I am looking at a configuration of on 'writable' node and anywhere from 10 to
300 'read-only'
Hi, stack traces and other paraphernalia below:
$ psql -U morgan -d cid -h localhost
Segmentation fault
Huh. Can you get a stack trace from that?
$ gdb psql
...
Reading symbols from /usr/lib/postgresql/8.4/bin/psql...(no debugging
symbols found)...done.
(gdb) run -U morgan -d cid -h local
sunpeng escribió:
> how to debug the codes in the PostgresMain() from the begining of this
> function to the "for (;;)" loop that handles the connection?
> if i use eclipse cdt to attach the postgres process forked by postmaster,
> this part of codes from the begining of this PostgresMain() to the
On 22/04/10 20:06, Morgan Taschuk wrote:
Program received signal SIGSEGV, Segmentation fault.
0xb7bbb4eb in X509_VERIFY_PARAM_inherit () from
/lib/i686/cmov/libcrypto.so.0.9.8
(gdb) bt
#0 0xb7bbb4eb in X509_VERIFY_PARAM_inherit () from
/lib/i686/cmov/libcrypto.so.0.9.8
#1 0xb7f9b61a in ssl_verify
I recently started seeing the following in the logs:
ERROR: could not read block 46 of relation
pg_tblspc/16385/8578554/11521501: Input/output error
CONTEXT: automatic vacuum of table "foo.pg_toast.pg_toast_8578780"
This is a Slony-I 1.2.21 slave, which runs 8.4.3 on RHEL 5.5.
This toast rela
On Apr 21, 2010, at 9:38 PM, Glen Parker wrote:
Not if qty_requested_available needs to be <= qty_available...
indeed, i'm an idiot this week.
thanks a ton. this really helped me out!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
What is the best approach for PostgreSQL when creating indexes? E.g I have two
fields in a table that I want indexed, is it best to create one index
combining the two fields or creating one for each field? If I create one for
each field, will the search when using both fields be slower that a
com
Bjørn T Johansen wrote:
What is the best approach for PostgreSQL when creating indexes? E.g I have two
fields in a table that I want indexed, is it best to create one index
combining the two fields or creating one for each field? If I create one for
each field, will the search when using both f
Hi
I don't understand what the following error means.
I am trying to add a foreign key to table image, that holds column device_id.
This is to be controlled by column devices_id in table devices.
ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES
addresses (address
Richard Huxton writes:
> I'd guess the root cause is here though. You seem to be picking up some
> libraries from psqlODBC rather than your main package. I'm betting it's
> got some incompatible changes. Uninstall psqlodbc for a minute and see
> if that solves your problem.
Yeah, the fact that
2010/4/23 Bob Pawley
> Hi
>
> I don't understand what the following error means.
>
> I am trying to add a foreign key to table image, that holds column
> device_id. This is to be controlled by column devices_id in table devices.
>
> ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (add
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes:
> I recently started seeing the following in the logs:
> ERROR: could not read block 46 of relation
> pg_tblspc/16385/8578554/11521501: Input/output error
> CONTEXT: automatic vacuum of table "foo.pg_toast.pg_toast_8578780"
> Is this *definitely* a di
MadTh writes:
> creating conversions ... FATAL: could not load library
> "/usr/pgsql-9.0/lib/utf8_and_johab.so":
> /usr/pgsql-9.0/lib/utf8_and_johab.so: failed to map segment from shared
> object: Cannot allocate memory
> STATEMENT: CREATE OR REPLACE FUNCTION johab_to_utf8 (INTEGER, INTEGER,
> C
Devrim GÜNDÜZ wrote:
>
> I recently started seeing the following in the logs:
>
> ERROR: could not read block 46 of relation
> pg_tblspc/16385/8578554/11521501: Input/output error
> CONTEXT: automatic vacuum of table "foo.pg_toast.pg_toast_8578780"
>
> This is a Slony-I 1.2.21 slave, which run
concatenated indexes deliver faster results as concatenated indexes do not
require the resultsets to be merged
provided the more selective column of the concatenated index is first and least
selective column of the concatenated index is last
http://webglobalnet.net/support/index.php?topic=864.0
On 23/04/2010 2:06 AM, Tom Lane wrote:
On Red Hat
systems the thing to do is install the postgresql-debuginfo RPM
that matches your postgresql RPMs, but I'm not sure exactly how
Ubuntu packages that information.
Though it turns out to be unnecessary for this person's question, for
future refe
Hi,
I've two questions.
(1) I updated logging_collector = true in postgresql.conf because I want to
rotate the logs. I'd also like to set the log_min_message to 'debug5' so that
I can better debug the code for now and will change it back to a lower level
when it's in production. I'm looking at
On 23/04/2010 1:42 AM, Said Ramirez wrote:
Primary keys are defined as 'unique not null' even if they are
composite. So I believe postgres would not let you do that
You can, however, add a UNIQUE constraint on the column set as a whole.
PostgreSQL does *not* enforce non-null in this case, so s
Wang, Mary Y wrote:
(1) I updated logging_collector = true in postgresql.conf because I want to
rotate the logs. I'd also like to set the log_min_message to 'debug5' so that
I can better debug the code for now and will change it back to a lower level
when it's in production. I'm looking at t
On Thu, 2010-04-22 at 18:47 -0400, Tom Lane wrote:
> > Is this *definitely* a disk error, or could it be related to
> PostgreSQL
> > itself?
>
> "Input/output error" is pretty much always indicative of a hardware
> problem. If it's always associated with attempts to access a specific
> disk block
60 matches
Mail list logo
