Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 6219

PostgreSQL version 9.1

1
vote
The possible solution depends on exactly which objects you are interested in. Tables The way I see is half suggested by the documentation: Only those tables and views are shown that the current …
answered Oct 7 '15 by dezso
3
votes
I haven't tried it myself, but there are others around who have. Here you can see that even 10,000 databases run without problem on a single instance. You can even find some pratical aspects on Serve …
answered Sep 9 '12 by dezso
5
votes
One idea, without knowing the error you get, is that the operation times out. This sometimes happens when the locks to be taken conflict with other operations or there are too many indexes and constr …
answered Sep 21 '16 by dezso
5
votes
Probably this will help: The Linux operating system normally terminates, or kills, a task by sending it a SIGHUP command. This stands for "Signal Hangup" and terminates a process on the syste …
answered Jul 31 '13 by dezso
4
votes
The problem, I guess, hits everyone starting with PostgreSQL. Fortunately, the solution is rather easy: simply call SELECT * FROM circular_ref(); instead of SELECT circular_ref(); This way it …
answered May 15 '14 by dezso
2
votes
If you don't specify FOR EACH ROW in your CREATE TRIGGER statement, it will default to FOR EACH STATEMENT. In this case, the OLD and NEW records will never be assigned - in the end, which row should …
answered Feb 3 '16 by dezso
2
votes
I think you cannot (easily) do that (at least on your PostgreSQL version, see Daniel's answer). What you definitely can, however, is changing your approach, and do a UNION ALL from all those tables i …
answered Sep 15 '16 by dezso
1
vote
If your data is consistent, so that after a number it always contains a space and then something else, then the following expression will get you the number part: split_part(original_size, ' ', 1) …
answered Sep 18 '13 by dezso
5
votes
Up until 9.4 You can go and ask the system catalogs (pg_type, to be precise): SELECT rolname FROM pg_type t JOIN pg_authid r ON typowner = r.oid WHERE typname = 'bla'; usename ───────── …
answered Jan 14 '16 by dezso
4
votes
The documentation says about INCLUDING CONSTRAINTS (emphasis mine): Not-null constraints are always copied to the new table. CHECK constraints will only be copied if INCLUDING CONSTRAINTS is spec …
answered Apr 20 '15 by dezso
5
votes
There is no option like that. A trigger belongs to a table and that is that. However, if all your triggers use the same procedure, you can easily generate a nice text output with all the CREATE TRIG …
answered Jan 30 '13 by dezso
4
votes
As you haven't defined a different collation for your column in question, it uses the database-wide one, which is en_US.UTF8 - just like on my test box. I observe the exact same behaviour, take it as …
answered Sep 17 '15 by dezso
9
votes
So, from the plans I see one thing: you index is either bloated (then alongside with the underlying table) or simply isn't really good for this sort of query (I tried to address this in my latest comm …
answered May 27 '13 by dezso
4
votes
The documentation of GRANT says the following: CREATE For databases, allows new schemas to be created within the database. For schemas, allows new objects to be created within the schema. To ren …
answered Apr 18 '13 by dezso
4
votes
The CONNECT privilege for PUBLIC looks somewhat special: \l template1 | postgres | UTF8 | Hungarian, Hungary | Hungarian, Hungary | postgres=CTc/postgres That is, user test (which is the memb …
answered May 30 '13 by dezso

15 30 50 per page