The following bug has been logged online:
Bug reference: 5717
Logged by: Richard Huxton
Email address: d...@archonet.com
PostgreSQL version: 9.0.1
Operating system: linux
Description:Domain as array of numeric/varchar does not respect
limits
Details:
Summary: you
Marcos FabrÃcio Corso wrote:
I would like to leave the list ...
Not really a question worth posting several lists. If you don't know how
to unsubscribe, try starting with the form linked from here.
http://www.postgresql.org/community/lists/
--
Richard Huxton
Archone
you can work-around the problem for the moment by accessing
a view that does the cast-to-text for the geometry columns.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
is is not a bug - see the manuals for details.
A set returning function is like a table so you need to call it as:
SELECT * FROM my_set_function();
For general help you might like to try the general/sql mailing lists
rather than the bug tracker.
--
Richard Huxton
Archonet Ltd
---
.
You might be able to do this with a trigger function (although I'm not
clear what you're trying to do).
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
See you there!
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: explain analyze is your friend
t user" command if you are
running XP Home.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ty up?
3. What does "psql -U root -h localhost sample" do for you?
4. Have you checked your pg_hba.conf file
It's almost certainly an issue with #4 - the pg_hba.conf file.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
anything?
I tried both way and this problem seems never happen.
Hmm - I'd have expected it to fail in one direction but not the other.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ake sure there aren't any known issues with the jdbc driver version
you have http://jdbc.postgresql.org/
2. Check if there is anything unusual about the problem machine
3. Try running the client on the problem machine and the database on
another, then the other way around. Does this change a
-system?
2. Installed from a package (which) or source?
3. What hangs - the client or the backend (or both)?
4. What do the logs show?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 4: Have you searched our list archives
in a file you've built yourself, then
clearly not.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
e lock though, which is why you see the error message.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: explain analyze is your friend
#x27;ll want to tell people what you've tried already.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
e of any list i was subscribed to please?
Can I ask what you had tried to unsubscribe from the lists you had
subscribed to? It might be the instructions need to be improved.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
the value is a
parameter.
When a change this value to "109922.11" the function works fine.
You'll need to give some more details - can you produce a small function
that reproduces the error so others can test it on their machines?
--
Richard Huxton
Archonet Ltd
--
922.11" the function works fine.
You'll need to give some more details - can you produce a small function
that reproduces the error so others can test it on their machines?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP
t the problem is in the
function itself where you may be executing a SELECT without putting its
results into a variable.
You would probably get more answers on the plpgsql-general list. This
mailing list is for bugs in the PostgreSQL server itself. See you there!
--
Richard Huxton
Archone
nload whatever RPMs you require and install as normal.
You might find it useful to subscribe to the pgsql-novice mailing list,
or check the website for details of a Spanish mailing list.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
T
he general or novice
mailing lists - this is unlikely to be a bug in PostgreSQL.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: explain analyze is your friend
foo (cost=0.00..3.01 rows=1 width=8) (actual
time=43.832..43.839 rows=1 loops=1)
Index Cond: (id = 1)
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Richard Huxton wrote:
mouse wrote:
The following bug has been logged online:
Bug reference: 1978
Logged by: mouse
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Gentoo Linux 2.6.11-r9
Description:connection sinks
Mouse has been in
he two machines. Can't say what from the
information you've given here. Check the logging and come over to
-general and I'm sure someone can get you connected.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: Have
x27;t recognise the type (I think)
The error is different in 8.0.x and 8.1.x but occurs in both.
--
Richard Huxton
Archonet Ltd
CREATE TABLE test_table (a int4, b text);
COPY test_table FROM stdin;
1 aaa
2 bbb
3 ccc
4 ddd
\.
CREATE OR REPLACE VIEW test_view AS SELECT a,b FROM test_table WH
t unsorted.txt
aa a
aaab
aa b
$ LC_COLLATE=C sort unsorted.txt
aa a
aa b
aaab
See "man locale" for details on how to find out what locales are setup
on your machine. See the documentation for details on how to set locale
on a database cluster.
HTH
--
Richard Hu
egistry keys by hand.
http://archives.postgresql.org/pgsql-odbc/2005-05/msg00018.php
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
)
Details:
We did have a error using TO_DATE() function with 09-10-2005 the result is
08-10-2005.
Works OK in 7.4 here. Does it work for other dates, and is that a
daylight-saving-time (or summer-time) change-over date in your locale?
--
Richard Huxton
Archonet Ltd
--
with pg_dump and pg_restore.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
when inserting these batches.
Put some inadmissible data in and check you get an error back.
2. Does the problem go away when you just use single statements within a
transaction rather than addBatch() - that would narrow down where the
problem is.
--
Richard H
/98/95/3.1 are supported for PostgreSQL. Windows
2000 and on should be fine though.
If you really need to run PG on Win98, perhaps take a look at the cygwin
project and see about installing via that route.
--
Richard Huxton
Archonet Ltd
---(end of
jdbc.postgresql.org/),
but they'll probably need a short example of how to reproduce it.
(and please forgive my bad english)
Your English is fine sir.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: explain analyze is your friend
ice status E_GC0135 -- A default server class has been
defined (by II_GCN_SVR_TYPE), but that server class is not known to the
Name Server..
Are you sure that's a PostgreSQL error, and not from something else
(e.g. Ingres?)
--
Richard Huxton
Archonet Ltd
---
want
floating-point or int8 instead of int4. PostgreSQL is flexible about its
types, but that does mean you need to be more precise in defining what
you mean sometimes.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Steve Peterson wrote:
Running COPY FROM on a Windows server; using a Windows-format fully
qualified path with backslashes results in the backslashes being interpreted
as escapes.
Did you escape the backslashes: C:\\Windows\\Path ?
--
Richard Huxton
Archonet Ltd
bug-list.
You have not described a bug in PostgreSQL, and there are more people
who can help on the general list anyway.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
they are empty strings. You haven't forbidden empty
strings.
You'll want constraint(s) to do something like:
ALTER TABLE tbarrio
ADD CONSTRAINT no_empty_codbarrio
CHECK (bar_codbarrio > '');
http://www.postgresql.org/docs/8.0/static/sql-altertab
you
increase logging options.
5. Whether there is a problem with only one query or many/all queries.
6. Whether you are happy your configuration settings for PostgreSQL are
good. How you know this.
See you on the general lists soon!
--
Richard Huxton
Archonet Ltd
--
leave
the other 2 empty (null), the DB accept and insert the record without any
problem.
Can you provide definitions of both tables and and example of an insert
that should fail.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 5
" FROM employee;
If you don't quote when you create, then the column is case-insensitive.
See the mailing-list archives for plenty of details.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ct to deal with here, but the
tools to check documentation for are: top/free/vmstat/iostat/netstat
Oh - and make sure your configuration settings are reasonable. Read
these two performance-tuning guides:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
http://www.powerpos
read all the Faq. But there is no reason to it.
Could you help?
Is it doing anything?
Do your logs show any activity?
If you do "strace -p " as root, you'll see what system calls the
backend is making.
--
Richard Huxton
Archonet Ltd
---(e
dbmirror/pgpool/slony/etc projects.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
se, you aren't storing an absolute time at all.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
controls sorting, not encoding. See the manuals/mailing list
archives for details and discussion.
I don't believe PG supports unicode (UTF-8) on Windows fully. Check the
manuals for details.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broa
lution
Name-lookup isn't working. It's strange that you can't resolve
"localhost", but you should look at your DNS setup.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: Have you checked our extensive
e I expect the same result of the first query.
In recent versions, you can disable the feature in your postgresql.conf
by setting "add_missing_from" to false. See the manuals - run-time
environment / compatibility.
--
Richard Huxton
Archonet Ltd
---
PostgresqlDAC?
http://microolap.com/products/connectivity/postgresdac/
As far as I can see, it looks like you have a problem in your
application code rather than with PostgreSQL itself. If that's the case,
then the pgsql-general list is probably a good starting point for your
questions.
--
Rich
ll failed
starting up.
Did the initdb work?
Was the error message the same?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
ral mailing list where there are lots of people who can help you.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
i tryed to use psql and the .net program on the same pc, or a lan-connected
pc.
If i change the type of the field originally SERIAL, the error vanish.
Is the problem with the table not being found or the type of the column?
--
Richard Huxton
Archonet Ltd
--
Olleg Samoylov wrote:
Richard Huxton wrote:
That's not a bug, it's a feature (as they say). I suppose you could
argue that a sequence only used by one table could inherit that
table's permissions by default, but I can see problems when people
reorder GRANT statements.
It's n
u create them
separately from a table, you can have many columns using
nextval('my_sequence') as their default.
I suppose you could argue that a sequence only used by one table could
inherit that table's permissions by default, but I can see problems when
people reorder GR
store the dumps
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing
e you wait for one minute - that should do it.
Alternatively, look at timeofday() instead.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
e not truncated because postgres was not running when the time
based rotation occurs.
You probably want to look at the "anacron" package - should be installed
by default. Designed for just this sort of thing.
You should find if you log to syslog it's already rotating those files.
probably win
my fight against a stubborn professor, that wants to stick to his big
fat oe 'cause it is the most conforming db.
What, with their use of nulls?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: Have you searche
resql.conf?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 8: explain analyze is your friend
t; if a dump is possible. Karel, can you look into it?
I got sig-11 here (although that was with an 8.0 beta I had lying
around) - does it with intervals but not with dates.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ex (see ch 11.6 of the manuals). I think there are examples in the
mailing-list archives.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 8: explain analyze is your friend
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: 21 February 2005 15:37
To: Tom Yeh
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #1487: Index problem
The above can be replicated by using pgAdmin III only
e better to post details to the performance or sql lists where
there are more people to help answer.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
need to do is issue SQL like:
ALTER USER "Hannes" ...
Personally, I keep all objects and users lower-case only, it makes my
life easier.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
t past that stage of parsing.
There are similar issues with regexp strings.
If you're using dollar-quoting in 8.0 the problem is gone.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
isleading you here. You want a comma not AND
above. The parser is reading that as:
UPDATE cfp SET testo=('test' AND cod_procedimento='82')
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: you can get off all li
he rule qualification and
the original query tree's qualification; and the original query tree
with the negated rule qualification added"
So, in your case you get two branches:
1. INSERT ... WHERE NOT EXISTS (...)
2. SELECT * FROM TEST WHERE EXISTS (...)
Is this making s
e you'd want to consider concurrency and locking
issues too.
Repost your question on the general/sql lists if you'd like some
discussion. It's probably worth checking the list archives too - plenty
in there about rule/trigger differences.
--
Richard Huxton
Arc
x27;...' is type unknown so it looks at x.id to see
what type it wants and casts for you.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail c
so you might want to read the FAQ, particularly section 4.8
http://www.postgresql.org/docs/faqs/FAQ.html
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 8: explain analyze is your friend
table only contains odd storage_ids,
while the log table only contains even ones.
This is as expected (though perhaps not what you want). Rules are
basically macros, so you can end up with nextval() etc. being evaluated
multiple times.
For logging inserts, you want a trigger.
HTH
http://www.postgresql.org/news/216.html
This is going to be a native Windows port and there is a standard
installer for it (link in the news article). This probably makes more
sense if you're just starting out.
Good Luck!
--
Richard Huxton
Archonet Ltd
---(end of
from
backend - Exception: java.net.SocketException: Connection reset
Ken, is there anything interesting in the postgresql logs?
Oh, and what platform is this on?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: if posting/reading throu
with (iirc) the dbexperts version. Restarting PG fixed it there
too.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere&
ommend you subscribe to the novice mailing list (details at
http://www.postgresql.org/lists.html) - lots of good help there.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ke a crash.
In 7.4 there is a postgresql.conf setting to control this behaviour
(add_missing_from). I'd turn it off, as I've always found it to cause
problems rather than solve them.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2
TAIL: Failed system call was shmget(key=1, size=1081344, 03600).
Have you read the FAQ?
http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN
You don't say whether you followed step 3a - starting the ipc daemon.
--
Richard Huxton
Archonet Ltd
---(end of broadcast
of my records and PC becomes very
> slow.
> Even if I restart postgresql , the memory does not return back.
Which would suggest perhaps that postgresql might not be the problem here. Can
you provide output from ps/top showing memory usage for the key processes
involved here?
--
Richar
file called /var/log/postgresql or /var/log/pgsql
(or similar). That log file should contain lines indicating the details
of the problem.
You should have a pg_hba.conf file, probably in /var/lib/pgsql/... or
/etc. What does this contain?
--
Richard Huxton
Archonet Ltd
: Missing or erroneous pg_hba.conf file, see postmaster log
for details
Some more details needed:
1. What does the log show?
2. Where is your pg_hba.conf file?
3. Does it contain any errors?
--
Richard Huxton
Archonet Ltd
---(end of broadcast
om the default.
I tried to get a stack trace; unfortunately the stack is corrupted but this
much (truncated) looks for real:
...
#8 0x40ecb020 in ?? () from /lib/libnss_wins.so.2
...
#35 0x4028efce in __errno_location () from /lib/libc.so.6
For the record, my Fedora setup is slightly behind the release version
of core-2.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
ure you provide the error message when
you post to the mailing list.
PS - We have lots of mailing lists, for PHP, Java etc. too and searchable
archives.
Best of luck with your problem. If I can be of any more help, you can find me
on the pgsql-general or pgsql-sql mailing lists.
--
Ri
ry for each row in quips_transactions (which is what you
want). You probably need a trigger on the transactions table that issues
separate queries for each row inserted.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
controlled via the pg_hba.conf file. Check the settings
there, and let us know if you still think there is a problem.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Don't forget it could be a problem with server A lookup up
server B or vice versa.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ortant values are on the second line - 99MB used, 875MB free.
If you still think there is a problem, can you show the output of "top" when
your system's memory usage increases. Tip: press "M" (not "m") to sort the
output by memory usage.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
r on this.
You can add a foreign key with something like (example from manual):
ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address)
REFERENCES addresses(address) MATCH FULL;
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TI
orary tables.
HTH
PS - If you think the documentation needs clarifying, suggestions on wording
are always appreciated, preferably on pgsql-docs mailing list.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: the planner will ignore
wait for a patch that prevents invalid SQL from executing valid sub
> transactions.
I'm saying it _could_ be considered a feature rather than a bug, but the
people who will know more than me will be hanging out on the jdbc list.
It's entirely possible that someone there will go "
ur system. This is
standard security practice.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
_field = 0" should be used.
But until it's evaluated ''<>'' it doesn't know it is false. When building the
CASE expression, it's trying to map types to each elements and notes that ''
is not an int. Only after this stage will it actually try
t distribution of Linux you are using.
4. You don't give any error message details
5. You don't say what point in the installation guide you have reached.
If you can address these points, ask again on the general list and we'll soon
have you up and ru
the source for the jdbc driver near the line mentioned and
see if you can see anything suspicious. Can't help you there since my java
skills don't extend much past "hello world".
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
of load you're testing it with.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wednesday 08 October 2003 20:56, Peter Eisentraut wrote:
> Richard Huxton writes:
> > CREATE OR REPLACE FUNCTION zzz_test () RETURNS text AS '
> > SELECT ''hello world''
> > -- SELECT ''goodbye world''
> >
> >
ext;
"
It took forever to find a simple reproducible example, but the rules seem to
be:
1. You must have quoting at the end of both adjacent lines
2. Both lines must be within a single SQL statement.
3. You must use the -- comment, not /* ... */
Originally spotted with a formulation like:
On Friday 03 October 2003 16:20, Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > On dump/restore the search_path is set to reports, pg_catalog so of
> > course you get a "no relation a" error
>
> This is an SQL function right?
It was indeed
hat search_path settings were at the time the function was originally
designed.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
B
(1 row)
richardh=# select version();
version
-
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
Not sure whether this is because of the change 7.3.1->7.3.2 or cygwin vs
linux. Don&
.
As for PG silently discarding inserts, your best bet might be to write a short
Perl script to reproduce the problem. Without that, people are likely to be
sceptical - if PG tended to do this sort of thing, none of us would use it.
--
Richard Huxton
Archonet Ltd
7.1 and consider myself experienced with postgres
>
> Schemas are the best thing since slice breads but
> the baker decided to poison the bread. Nice!
Let me know if this reply helps
--
Richard Huxton
---(end of broadcast)---
TIP 8: explain analyze is your friend
99 matches
Mail list logo
