Is it going to make things faster if I:
delete from s;
reindex table s;
Why do you think this step would help you any? There's no index on p
to begin with. You'd just be reindexing the auto-generated unique
index on s (due to it being a PK).
delete from p;
And no, this would most
Hello,
I'm sorry about that email you received earlier about hi5... it was a mess
(I've sent it to my whole gmail contact list :-s).
Please forget about it.
All apologize.
andy petrella
On Fri, 22 Aug 2008 08:48:30 +0200
Alban Hertroys [EMAIL PROTECTED] wrote:
Is it going to make things faster if I:
delete from s;
reindex table s;
Why do you think this step would help you any? There's no index on
p to begin with. You'd just be reindexing the auto-generated
unique
I was trying to drop a serial.
Dropped the default for a column.
Now it seems I can't drop the sequence since I incurred in:
http://archives.postgresql.org/pgsql-bugs/2005-11/msg00304.php
Is there a way I can still delete the sequence without using a
backup?
--
Ivan Sergio Borgonovo
Hi,
Does anyone know of a script/tool that allows one to export all users
with all privileges? I realise I could construct a query to do it but
google turned up nothing and if someone else has done the good work...
Cheers
Anton
--
echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
Hi all,
I have a problem with foreign keys and data-only (no schema) backup. I
have a simple table node (pseudo-SQL):
node
(
integer node_idNOT NULLPRIMARY KEY;
integer parent_node_id NULL;
)
It contains the following two entries:
node(1, NULL) the rood
Some time ago i found one simple sql over large table eat whole ram+swap and
almost killed server (postgresql 8.3.3 on 4gb freebsd server):
After some exploring i found what happens:
Query was over simple table:
profiles=# \d+ counter_vis
Table counter_vis
Column| Type |
Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL we have
some difficulties. One of them is use of Like and Similar to operators. We
often use LIKE to search a string from front-end without case sensetivity.
As postgreSQL's LIKE is case sensitive, we tried ILIKE and
Maybe you should give tsearch2 a try and create a GIN index.
Regex searches are sometimes a option.
Robert
c k wrote:
Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL we
have some difficulties. One of them is use of Like and Similar to
operators. We often use LIKE
On Friday 22 August 2008 05:15, Anton Melser wrote:
Hi,
Does anyone know of a script/tool that allows one to export all users
with all privileges? I realise I could construct a query to do it but
google turned up nothing and if someone else has done the good work...
Cheers
Anton
--
echo
Hi,
c k wrote:
Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL we have
some difficulties. One of them is use of Like and Similar to operators.
We often use LIKE to search a string from front-end without case
sensetivity. As postgreSQL's LIKE is case sensitive, we
Thanks to all,
I will try to use tsearch2 with some other index and then reply.
Regards,
CPK
On Fri, Aug 22, 2008 at 5:01 PM, Tino Wildenhain [EMAIL PROTECTED] wrote:
Hi,
c k wrote:
Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL we have
some difficulties. One
On Fri, 22 Aug 2008 16:43:47 +0530
c k [EMAIL PROTECTED] wrote:
Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL
we have some difficulties. One of them is use of Like and Similar
to operators. We often use LIKE to search a string from front-end
without case
Peter Billen wrote:
Hi all,
I have a problem with foreign keys and data-only (no schema) backup. I
have a simple table node (pseudo-SQL):
When I do a data-only backup, the backup file contains following two lines:
INSERT INTO NODE (node_id, parent_node_id) VALUES (2, 1);
INSERT INTO
Hi,
I do not think this will work. As far as I know foreign key checks are
not triggers. Postgres is very strict with things concerning referential
integrity so you cannot turn them off.
Maybe it will help to use --orig-order for creating the dump.
Markus
Richard Huxton schrieb:
Peter Billen
On Thu, Aug 21, 2008 at 09:08:24PM +0200, Peter Billen wrote:
Is it possible to insert a new entry? Will the serial sequence somehow
be able to find the gap (3)?
As others have said, no it's not going to. Sequences will only return
values out of order when explicitly told to. The main reason
Maxim Boguk [EMAIL PROTECTED] writes:
[ ndistinct estimates way off ]
Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Markus Mehrwald wrote:
Hi,
I do not think this will work. As far as I know foreign key checks are
not triggers. Postgres is very strict with things concerning referential
integrity so you cannot turn them off.
Actually you are mistaken -- FKs are triggers, and you can turn them
off.
There
On Aug 21, 2008, at 3:45 AM, Tomasz Ostrowski wrote:
- one byte char (with quotes), but it is a non standard, integral
type, will cause interface problems and I don't know if it will not be
deprecated some time.
It's used in the catalogs, so I'd say the odds of it getting replaced
anytime
Tom Lane wrote:
Gregory Stark [EMAIL PROTECTED] writes:
ISTM this is the one that's wrong. CET is standard time, it, GMT+1.
If you want a timezone which switches between CET and CST automatically you
should use something like Europe/Paris.
Well, actually he *is* using such a zone:
Hello all,
As I know and have seen that innodb engine of MySQL does an auto-recovery
when MySQL server is crashed or due to power failure. What is with
postgreSQL? Does it makes an auto-recovery? and how?
Thanks
CPK
Thanks
CPK
On Fri, Aug 22, 2008 at 11:36 PM, Tomeh, Husam [EMAIL PROTECTED]wrote:
Postgres, like any descent RDBMS, performs an auto instance crash
recovery using its transaction logs.
Regards,
Husam
--
*From:* [EMAIL PROTECTED] [mailto:
[EMAIL
Postgres, like any descent RDBMS, performs an auto instance crash
recovery using its transaction logs.
Regards,
Husam
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of c k
Sent: Friday, August 22, 2008 11:02 AM
To:
Hi all !!
On Windows, we can install the postgre 8.3 with a command, without windows
setup to install it, like on linux?
Anderson dos Santos Donda wrote on 22.08.2008 22:53:
Hi all !!
On Windows, we can install the postgre 8.3 with a command, without
windows setup to install it, like on linux?
http://pginstaller.projects.postgresql.org/silent.html
--
Sent via pgsql-general mailing list
Thanks Man!!!
I'll try and reply if i have any problems!!
On Fri, Aug 22, 2008 at 6:02 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Anderson dos Santos Donda wrote on 22.08.2008 22:53:
Hi all !!
On Windows, we can install the postgre 8.3 with a command, without
windows setup to install
Since there is no current solution to ranking values in pl/pgsql as the
rank() over (partition by... that there is in oracle i am hoping someone
can help me out here.
The table i created contains the following columns:
rank | value
I wrote a cursor that will give me all the
Hi all,
well, it´s just a windows xp professional file permisions problem, but some
other folk had the same problem so...
i´m trying to upgrade my postgresql version ( it was 8.2) in windows , so
i' ve downloaded and installed postgresql 8.3.3.1 When i try to install
postgis 1.3.3
On Aug 20, 3:02 pm, [EMAIL PROTECTED] (Scott Marlowe) wrote:
On Tue, Aug 19, 2008 at 9:51 PM, Dale Harris [EMAIL PROTECTED] wrote:
As per the original message:
UPDATE EntityRelation SET Status = inStatus, Modified =
Session_TimeStamp(), ModifiedBy = UserID() WHERE (RelationID =
Merlin Moncure wrote:
On Wed, Aug 20, 2008 at 12:59 PM, James Neff
[EMAIL PROTECTED] wrote:
Greetings,
Is it possible to have a function with a return type of SETOF that has
variable number of return columns?
On Wed, Aug 20, 2008 at 10:08 PM, Tom Lane [EMAIL PROTECTED] wrote:
On Wed, Aug 20, 2008 at 11:25 PM, Dale [EMAIL PROTECTED] wrote:
This afternoon I'm
starting to notice that pgAdmin III for Windows sometimes gives
erratic error messages when there is no error or the error is actually
different. I know this because when I recompile after moving the
cursor,
On Fri, Aug 22, 2008 at 02:30:46PM -0700, Ruben Gouveia wrote:
Since there is no current solution to ranking values in pl/pgsql as
the rank() over (partition by... that there is in oracle i am hoping
someone can help me out here.
It seems likely that the windowing functions patch will get
32 matches
Mail list logo
